| 0.0001 |
SELECT ID FROM lang WHERE CODE = 'en'
|
| 0.0001 |
SELECT EQUAL_ID, NAME
FROM vehicle_type
WHERE lang_ID = '1'
|
| 0.0000 |
SELECT `user_notification`.`ID`, `user_notification`.`NAME`, `picture`.`PATH`
FROM `user_notification`
LEFT JOIN `vehicle` ON `user_notification`.`vehicle_ID` = `vehicle`.`ID`
LEFT JOIN `picture` ON `picture`.`ID` = `vehicle`.`picture_ID`
WHERE `user_notification`.`user_ID` = ''
AND `READ_CONTENT` =0
|
| 0.0000 |
SELECT distinct count(favorite_detail.ID) as TOTAL
FROM `favorite`
JOIN `favorite_detail` ON `favorite`.`ID` = `favorite_detail`.`favorite_ID`
WHERE `favorite`.`user_ID` = ''
|
| 0.0000 |
SELECT count(ID) as TOTAL
FROM `message`
WHERE `user_ID` = ''
AND `READ_CONTENT` =0
AND `REMOVE_user` = 'F'
|
| 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` = '2'
AND `category`.`vehicle_type_ID` = '1'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0000 |
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` = '47'
AND `category`.`vehicle_type_ID` = '1'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0000 |
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` = '48'
AND `category`.`vehicle_type_ID` = '1'
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` = '49'
AND `category`.`vehicle_type_ID` = '1'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0000 |
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` = '50'
AND `category`.`vehicle_type_ID` = '1'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0000 |
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` = '51'
AND `category`.`vehicle_type_ID` = '1'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0000 |
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` = '52'
AND `category`.`vehicle_type_ID` = '1'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0000 |
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` = '53'
AND `category`.`vehicle_type_ID` = '1'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0000 |
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` = '93'
AND `category`.`vehicle_type_ID` = '1'
AND `category`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0000 |
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 = 47 OR
`cat1`.`category_ID` = 47 OR
`cat2`.`category_ID` = 47 OR
`cat3`.`category_ID` = 47 OR
`category`.`ID` = 47 OR
`cat1`.`ID` = 47 OR
`cat2`.`ID` = 47 OR
cat3.ID = 47
)
AND `category`.`vehicle_type_ID` = '1'
AND `category`.`REMOVE` = 'F'
AND `vehicle`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0000 |
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 = 48 OR
`cat1`.`category_ID` = 48 OR
`cat2`.`category_ID` = 48 OR
`cat3`.`category_ID` = 48 OR
`category`.`ID` = 48 OR
`cat1`.`ID` = 48 OR
`cat2`.`ID` = 48 OR
cat3.ID = 48
)
AND `category`.`vehicle_type_ID` = '1'
AND `category`.`REMOVE` = 'F'
AND `vehicle`.`REMOVE` = 'F'
GROUP BY `category`.`ID`, `category`.`NAME`, `category`.`vehicle_type_ID`
|
| 0.0000 |
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 = 49 OR
`cat1`.`category_ID` = 49 OR
`cat2`.`category_ID` = 49 OR
`cat3`.`category_ID` = 49 OR
`category`.`ID` = 49 OR
`cat1`.`ID` = 49 OR
`cat2`.`ID` = 49 OR
cat3.ID = 49
)
AND `category`.`vehicle_type_ID` = '1'
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 = 50 OR
`cat1`.`category_ID` = 50 OR
`cat2`.`category_ID` = 50 OR
`cat3`.`category_ID` = 50 OR
`category`.`ID` = 50 OR
`cat1`.`ID` = 50 OR
`cat2`.`ID` = 50 OR
cat3.ID = 50
)
AND `category`.`vehicle_type_ID` = '1'
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 = 51 OR
`cat1`.`category_ID` = 51 OR
`cat2`.`category_ID` = 51 OR
`cat3`.`category_ID` = 51 OR
`category`.`ID` = 51 OR
`cat1`.`ID` = 51 OR
`cat2`.`ID` = 51 OR
cat3.ID = 51
)
AND `category`.`vehicle_type_ID` = '1'
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 = 52 OR
`cat1`.`category_ID` = 52 OR
`cat2`.`category_ID` = 52 OR
`cat3`.`category_ID` = 52 OR
`category`.`ID` = 52 OR
`cat1`.`ID` = 52 OR
`cat2`.`ID` = 52 OR
cat3.ID = 52
)
AND `category`.`vehicle_type_ID` = '1'
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 = 53 OR
`cat1`.`category_ID` = 53 OR
`cat2`.`category_ID` = 53 OR
`cat3`.`category_ID` = 53 OR
`category`.`ID` = 53 OR
`cat1`.`ID` = 53 OR
`cat2`.`ID` = 53 OR
cat3.ID = 53
)
AND `category`.`vehicle_type_ID` = '1'
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 = 93 OR
`cat1`.`category_ID` = 93 OR
`cat2`.`category_ID` = 93 OR
`cat3`.`category_ID` = 93 OR
`category`.`ID` = 93 OR
`cat1`.`ID` = 93 OR
`cat2`.`ID` = 93 OR
cat3.ID = 93
)
AND `category`.`vehicle_type_ID` = '1'
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 = '2' AND
category.vehicle_type_ID = '1' 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 = '1' 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 (2) AND REMOVE = 'F'
|
| 0.0001 |
SELECT
category.ID
FROM category
WHERE category.category_ID in (-1,47,48,49,50,51,52,53,93) 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 (2,47,48,49,50,51,52,53,93)
AND `vehicle`.`vehicle_type_ID` = '1'
AND `vehicle`.`REMOVE` = 'F'
ORDER BY `ID` DESC
LIMIT 1
|
| 0.0000 |
SELECT
category.ID
FROM category
WHERE category.category_ID in (2) AND REMOVE = 'F'
|
| 0.0000 |
SELECT
category.ID
FROM category
WHERE category.category_ID in (-1,47,48,49,50,51,52,53,93) AND REMOVE = 'F'
|
| 0.0000 |
SELECT count(*) AS TOPLAM_KAYIT
FROM `vehicle`
LEFT JOIN `picture` ON `vehicle`.`picture_ID` = `picture`.`ID`
WHERE `vehicle`.`category_ID` in (2,47,48,49,50,51,52,53,93)
AND `vehicle`.`vehicle_type_ID` = '1'
AND `vehicle`.`REMOVE` = 'F'
|
