Error: Query failed. MySQL Says: "Column 'user_id' in where clause is ambiguous"\n
Error: This query is invalid:
Error: This query is invalid:
SELECT COUNT( DISTINCT( data.data_id ) ) AS count FROM data
JOIN dataclassified ON dataclassified.data_id = data.data_id
JOIN datamap ON data.data_id = datamap.data_id
JOIN categoryswitchboard ON datamap.categorypool_id = categoryswitchboard.categorypool_id
LEFT JOIN user ON user.user_id = data.user_id
WHERE data.start_time <= '2008-07-25 15:14:13' AND data.end_time > '2008-07-25 15:14:13' AND data.is_active = 'true' AND user_id = '206911' AND otheradlinks = 'true'
AND categoryswitchboard.lineage LIKE '|%'
AND data.brand_id = '6'Call Stack Table:
file line function /var/www/html/tehachapinews.com/2.9/webroot/core/Database.php 294 debug_table /var/www/html/tehachapinews.com/2.9/webroot/core/Database.php 588 query /var/www/html/tehachapinews.com/2.9/platform/component/core/database/GenericData.php 1314 query /var/www/html/tehachapinews.com/2.9/platform/component/classified/widgets/wdg_UserClassifiedAds/UserClassifiedAds.php 29 getDataCount /var/www/html/tehachapinews.com/2.9/webroot/home 744 post
All ads from this user
