SELECT data.*, dataclassified.*, categoryswitchboard.*
FROM datamap
JOIN categoryswitchboard ON datamap.categorypool_id = categoryswitchboard.categorypool_id
JOIN data ON data.data_id = datamap.data_id
JOIN dataclassified ON dataclassified.data_id = data.data_id
WHERE data.start_time >= '2007-12-03' AND
data.end_time > '2008-12-02 22:31:47' AND
data.is_active = 'true' AND
data.type = 'classified'
AND (categoryswitchboard.lineage LIKE '|%')
AND categoryswitchboard.brand_id = '1'
AND user.user_id = '3554' AND otheradlinks = 'true'
ORDER BY datamap.data_id DESC
LIMIT 0, 10Call Stack Table:
file line function /var/www/html/bakotopia.com/2.10/webroot/core/Database.php 294 debug_table /var/www/html/bakotopia.com/2.10/webroot/core/Database.php 589 query /var/www/html/bakotopia.com/2.10/platform/component/core/database/GenericData.php 1982 query /var/www/html/bakotopia.com/2.10/platform/component/classified/widgets/wdg_UserClassifiedAds/UserClassifiedAds.php 28 getDataBySearch /var/www/html/bakotopia.com/2.10/webroot/home 730 post