| 0.0002 |
SELECT count(ID) as TOTAL
FROM `message`
WHERE `user_ID` = ''
AND `READ_CONTENT` =0
AND `REMOVE_user` = 'F'
|
| 0.0001 |
SELECT ID, NAME
FROM vehicle_type
WHERE EQUAL_ID = '2'
AND lang_ID = '1'
|
| 0.0001 |
SELECT ID, NAME
FROM vehicle_type
WHERE id <> '2'
AND lang_ID = '1'
|
| 0.0001 |
SELECT (SELECT COUNT(*) FROM vehicle where vehicle.category_ID = category.ID and vehicle.REMOVE = 'F') as TOPLAM, `category`.`ID`, `category`.`category_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `category`
WHERE `category`.`category_ID` = '87'
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT (SELECT COUNT(*) FROM vehicle where vehicle.category_ID = category.ID and vehicle.REMOVE = 'F') as TOPLAM, `category`.`ID`, `category`.`category_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `category`
WHERE `category`.`category_ID` = '88'
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT (SELECT COUNT(*) FROM vehicle where vehicle.category_ID = category.ID and vehicle.REMOVE = 'F') as TOPLAM, `category`.`ID`, `category`.`category_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `category`
WHERE `category`.`category_ID` = '89'
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT (SELECT COUNT(*) FROM vehicle where vehicle.category_ID = category.ID and vehicle.REMOVE = 'F') as TOPLAM, `category`.`ID`, `category`.`category_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `category`
WHERE `category`.`category_ID` = '90'
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT (SELECT COUNT(*) FROM vehicle where vehicle.category_ID = category.ID and vehicle.REMOVE = 'F') as TOPLAM, `category`.`ID`, `category`.`category_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `category`
WHERE `category`.`category_ID` = '91'
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT (SELECT COUNT(*) FROM vehicle where vehicle.category_ID = category.ID and vehicle.REMOVE = 'F') as TOPLAM, `category`.`ID`, `category`.`category_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `category`
WHERE `category`.`category_ID` = '92'
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT (SELECT COUNT(*) FROM vehicle where vehicle.category_ID = category.ID and vehicle.REMOVE = 'F') as TOPLAM, `category`.`ID`, `category`.`category_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `category`
WHERE `category`.`category_ID` = '106'
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT count(distinct vehicle.ID) as TOPLAM, `category`.`ID`, `cat1`.`ID` `cat1_ID`, `cat2`.`ID` `cat2_ID`, `cat3`.`ID` `cat3_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `vehicle`
LEFT JOIN `category` ON `vehicle`.`category_ID` = `category`.`ID`
LEFT JOIN `category` `cat1` ON `category`.`category_ID` = `cat1`.`ID`
LEFT JOIN `category` `cat2` ON `cat1`.`category_ID` = `cat2`.`ID`
LEFT JOIN `category` `cat3` ON `cat2`.`category_ID` = `cat3`.`ID`
WHERE
(
category.category_ID = 88 OR
`cat1`.`category_ID` = 88 OR
`cat2`.`category_ID` = 88 OR
`cat3`.`category_ID` = 88 OR
`category`.`ID` = 88 OR
`cat1`.`ID` = 88 OR
`cat2`.`ID` = 88 OR
cat3.ID = 88
)
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
AND `vehicle`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT count(distinct vehicle.ID) as TOPLAM, `category`.`ID`, `cat1`.`ID` `cat1_ID`, `cat2`.`ID` `cat2_ID`, `cat3`.`ID` `cat3_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `vehicle`
LEFT JOIN `category` ON `vehicle`.`category_ID` = `category`.`ID`
LEFT JOIN `category` `cat1` ON `category`.`category_ID` = `cat1`.`ID`
LEFT JOIN `category` `cat2` ON `cat1`.`category_ID` = `cat2`.`ID`
LEFT JOIN `category` `cat3` ON `cat2`.`category_ID` = `cat3`.`ID`
WHERE
(
category.category_ID = 89 OR
`cat1`.`category_ID` = 89 OR
`cat2`.`category_ID` = 89 OR
`cat3`.`category_ID` = 89 OR
`category`.`ID` = 89 OR
`cat1`.`ID` = 89 OR
`cat2`.`ID` = 89 OR
cat3.ID = 89
)
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
AND `vehicle`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT count(distinct vehicle.ID) as TOPLAM, `category`.`ID`, `cat1`.`ID` `cat1_ID`, `cat2`.`ID` `cat2_ID`, `cat3`.`ID` `cat3_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `vehicle`
LEFT JOIN `category` ON `vehicle`.`category_ID` = `category`.`ID`
LEFT JOIN `category` `cat1` ON `category`.`category_ID` = `cat1`.`ID`
LEFT JOIN `category` `cat2` ON `cat1`.`category_ID` = `cat2`.`ID`
LEFT JOIN `category` `cat3` ON `cat2`.`category_ID` = `cat3`.`ID`
WHERE
(
category.category_ID = 90 OR
`cat1`.`category_ID` = 90 OR
`cat2`.`category_ID` = 90 OR
`cat3`.`category_ID` = 90 OR
`category`.`ID` = 90 OR
`cat1`.`ID` = 90 OR
`cat2`.`ID` = 90 OR
cat3.ID = 90
)
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
AND `vehicle`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT count(distinct vehicle.ID) as TOPLAM, `category`.`ID`, `cat1`.`ID` `cat1_ID`, `cat2`.`ID` `cat2_ID`, `cat3`.`ID` `cat3_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `vehicle`
LEFT JOIN `category` ON `vehicle`.`category_ID` = `category`.`ID`
LEFT JOIN `category` `cat1` ON `category`.`category_ID` = `cat1`.`ID`
LEFT JOIN `category` `cat2` ON `cat1`.`category_ID` = `cat2`.`ID`
LEFT JOIN `category` `cat3` ON `cat2`.`category_ID` = `cat3`.`ID`
WHERE
(
category.category_ID = 91 OR
`cat1`.`category_ID` = 91 OR
`cat2`.`category_ID` = 91 OR
`cat3`.`category_ID` = 91 OR
`category`.`ID` = 91 OR
`cat1`.`ID` = 91 OR
`cat2`.`ID` = 91 OR
cat3.ID = 91
)
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
AND `vehicle`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT count(distinct vehicle.ID) as TOPLAM, `category`.`ID`, `cat1`.`ID` `cat1_ID`, `cat2`.`ID` `cat2_ID`, `cat3`.`ID` `cat3_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `vehicle`
LEFT JOIN `category` ON `vehicle`.`category_ID` = `category`.`ID`
LEFT JOIN `category` `cat1` ON `category`.`category_ID` = `cat1`.`ID`
LEFT JOIN `category` `cat2` ON `cat1`.`category_ID` = `cat2`.`ID`
LEFT JOIN `category` `cat3` ON `cat2`.`category_ID` = `cat3`.`ID`
WHERE
(
category.category_ID = 92 OR
`cat1`.`category_ID` = 92 OR
`cat2`.`category_ID` = 92 OR
`cat3`.`category_ID` = 92 OR
`category`.`ID` = 92 OR
`cat1`.`ID` = 92 OR
`cat2`.`ID` = 92 OR
cat3.ID = 92
)
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
AND `vehicle`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0002 |
SELECT count(distinct vehicle.ID) as TOPLAM, `category`.`ID`, `cat1`.`ID` `cat1_ID`, `cat2`.`ID` `cat2_ID`, `cat3`.`ID` `cat3_ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
FROM `vehicle`
LEFT JOIN `category` ON `vehicle`.`category_ID` = `category`.`ID`
LEFT JOIN `category` `cat1` ON `category`.`category_ID` = `cat1`.`ID`
LEFT JOIN `category` `cat2` ON `cat1`.`category_ID` = `cat2`.`ID`
LEFT JOIN `category` `cat3` ON `cat2`.`category_ID` = `cat3`.`ID`
WHERE
(
category.category_ID = 106 OR
`cat1`.`category_ID` = 106 OR
`cat2`.`category_ID` = 106 OR
`cat3`.`category_ID` = 106 OR
`category`.`ID` = 106 OR
`cat1`.`ID` = 106 OR
`cat2`.`ID` = 106 OR
cat3.ID = 106
)
AND `category`.`vehicle_type_ID` = '2'
AND `category`.`REMOVE` = 'F'
AND `vehicle`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0001 |
SELECT
category.ID,
category.category_ID,
category.NAME,
category.vehicle_type_ID
FROM category
WHERE category.ID = '87' AND
category.vehicle_type_ID = '2' AND REMOVE = 'F'
|
| 0.0001 |
SELECT
category.ID,
category.category_ID,
category.NAME,
category.vehicle_type_ID
FROM category
WHERE category.ID = '0' AND
category.vehicle_type_ID = '2' AND REMOVE = 'F'
|
| 0.0001 |
SELECT *
FROM `city`
WHERE `country_ID` = '-1'
ORDER BY `NAME` ASC
|
| 0.0001 |
SELECT *
FROM `country`
ORDER BY `CODE` ASC
|
| 0.0001 |
SELECT
category.ID
FROM category
WHERE category.category_ID in (87) AND REMOVE = 'F'
|
| 0.0001 |
SELECT
category.ID
FROM category
WHERE category.category_ID in (-1,88,89,90,91,92,106) AND REMOVE = 'F'
|
| 0.0001 |
SELECT `vehicle`.`ID`, `vehicle`.`CAPTION`, `vehicle`.`vehicle_type_ID`, `vehicle`.`PRICE`, `currency`.`NAME` AS `CURRENCY_NAME`, `picture`.`PATH`
FROM `vehicle`
LEFT JOIN `picture` ON `vehicle`.`picture_ID` = `picture`.`ID`
JOIN `currency` ON `vehicle`.`currency_ID` = `currency`.`ID`
WHERE `vehicle`.`category_ID` in (87,88,89,90,91,92,106)
AND `vehicle`.`vehicle_type_ID` = '2'
AND `vehicle`.`REMOVE` = 'F'
ORDER BY `ID` DESC
LIMIT 1
|
| 0.0001 |
SELECT
category.ID
FROM category
WHERE category.category_ID in (87) AND REMOVE = 'F'
|
| 0.0001 |
SELECT
category.ID
FROM category
WHERE category.category_ID in (-1,88,89,90,91,92,106) AND REMOVE = 'F'
|
| 0.0001 |
SELECT count(*) AS TOPLAM_KAYIT
FROM `vehicle`
LEFT JOIN `picture` ON `vehicle`.`picture_ID` = `picture`.`ID`
WHERE `vehicle`.`category_ID` in (87,88,89,90,91,92,106)
AND `vehicle`.`vehicle_type_ID` = '2'
AND `vehicle`.`REMOVE` = 'F'
|
