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:31:59' 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 (412) and class_ads.category_id in (412) 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:31:59' 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 (412) and class_slugs.`type`='listing' GROUP BY class_ads.id order by date_added desc
Error path: tixads.com/search/stroitelnaya-tehnika/kazachinskoe/?marka2=nigata