Database query error. The error was: errno : 1052 Column 'category_id' in where clause is ambiguous
SQL query/queries : select class_ads.*, class_ads.id as adid, date_format(class_ads.`date_added`,'%d.%m в %H:%i') as date_nice, date_format(class_ads.`date_expires`,'%d.%m в %H:%i') as date_expires_nice, UNIX_TIMESTAMP(class_ads.`date_added`) as `time_added`, (class_ads.date_expires < '2024-04-23 23:32:02' and class_ads.date_expires!='0000-00-00 00:00:00' and class_ads.active=0) as expired , class_slugs.slug from class_ads inner join class_slugs on class_ads.id=class_slugs.object_id left join class_products on class_ads.id=class_products.product_id where class_ads.featured = 0 and `block_ad` is null and `category_id` in (145,148,149,150,151,152,153,681,682,683,154,674,675,676,677,678,679,680,144,146,171,173,174,175,890,891,892,893,894,898,899,900,901,902,895,903,904,905,906,907,908,909,910,896,897,177,178,181,183,184,888,176,889,911,914,915,916,917,918,912,913,172,594,718,719,720,721,722,723,724,725,726,728,729,730,731,732,733,734,735,736,737,738,739,740,741,727,742,744,745,746,747,748,749,743,751,752,753,754,755,756,750,757,186,593,595,597,605,684,685,686,687,688,689,690,691,692,693,694,695,696,497,601,603,600,592,702,703,596,598,599,604,698,699,700,706,705,704,591,708,709,707,710,711,712,713,714,715,716,717,697,156) and class_ads.category_id in (145,148,149,150,151,152,153,681,682,683,154,674,675,676,677,678,679,680,144,146,171,173,174,175,890,891,892,893,894,898,899,900,901,902,895,903,904,905,906,907,908,909,910,896,897,177,178,181,183,184,888,176,889,911,914,915,916,917,918,912,913,172,594,718,719,720,721,722,723,724,725,726,728,729,730,731,732,733,734,735,736,737,738,739,740,741,727,742,744,745,746,747,748,749,743,751,752,753,754,755,756,750,757,186,593,595,597,605,684,685,686,687,688,689,690,691,692,693,694,695,696,497,601,603,600,592,702,703,596,598,599,604,698,699,700,706,705,704,591,708,709,707,710,711,712,713,714,715,716,717,697,156) and class_slugs.`type`='listing' group by class_ads.id order by date_added desc limit 0, 12
select class_ads.*, class_ads.id as adid, date_format(class_ads.`date_added`,'%d.%m в %H:%i') as date_nice, date_format(class_ads.`date_expires`,'%d.%m в %H:%i') as date_expires_nice, UNIX_TIMESTAMP(class_ads.`date_added`) as `time_added`, (class_ads.date_expires < '2024-04-23 23:32:02' and class_ads.date_expires!='0000-00-00 00:00:00' and class_ads.active=0) as expired , class_slugs.slug from class_ads inner join class_slugs on class_ads.id=class_slugs.object_id left join class_products on class_ads.id=class_products.product_id where class_ads.featured>0 and class_ads.active = 1 and `category_id` in (145,148,149,150,151,152,153,681,682,683,154,674,675,676,677,678,679,680,144,146,171,173,174,175,890,891,892,893,894,898,899,900,901,902,895,903,904,905,906,907,908,909,910,896,897,177,178,181,183,184,888,176,889,911,914,915,916,917,918,912,913,172,594,718,719,720,721,722,723,724,725,726,728,729,730,731,732,733,734,735,736,737,738,739,740,741,727,742,744,745,746,747,748,749,743,751,752,753,754,755,756,750,757,186,593,595,597,605,684,685,686,687,688,689,690,691,692,693,694,695,696,497,601,603,600,592,702,703,596,598,599,604,698,699,700,706,705,704,591,708,709,707,710,711,712,713,714,715,716,717,697,156) and class_slugs.`type`='listing' GROUP BY class_ads.id order by date_added desc
Error path: tixads.com/search/elektronika/kaliningradskaya_oblast/mamonovo/