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:01' 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 (223,218,219,220,581,582,583,584,585,222,498,210,214,215,216,221,499,501,502,503,504,500,212,506,507,508,509,505,199,239,241,242,243,245,246,248,249,201,232,233,238,225,226,227,228,229,231,234,235,236,237,353,142,224,510,799,800,801,814,815,816,817,818,819,820,821,822,823,824,802,825,826,827,803,828,829,830,804,831,832,833,834,835,805,836,837,838,839,840,841,842,843,806,844,845,846,847,848,849,807,850,851,852,853,854,855,856,857,858,859,860,808,809,861,862,863,864,865,866,867,810,868,869,870,871,872,873,874,875,876,811,877,878,879,880,881,882,883,884,885,886,887,812,813,630,200) and class_ads.category_id in (223,218,219,220,581,582,583,584,585,222,498,210,214,215,216,221,499,501,502,503,504,500,212,506,507,508,509,505,199,239,241,242,243,245,246,248,249,201,232,233,238,225,226,227,228,229,231,234,235,236,237,353,142,224,510,799,800,801,814,815,816,817,818,819,820,821,822,823,824,802,825,826,827,803,828,829,830,804,831,832,833,834,835,805,836,837,838,839,840,841,842,843,806,844,845,846,847,848,849,807,850,851,852,853,854,855,856,857,858,859,860,808,809,861,862,863,864,865,866,867,810,868,869,870,871,872,873,874,875,876,811,877,878,879,880,881,882,883,884,885,886,887,812,813,630,200) 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:01' 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 (223,218,219,220,581,582,583,584,585,222,498,210,214,215,216,221,499,501,502,503,504,500,212,506,507,508,509,505,199,239,241,242,243,245,246,248,249,201,232,233,238,225,226,227,228,229,231,234,235,236,237,353,142,224,510,799,800,801,814,815,816,817,818,819,820,821,822,823,824,802,825,826,827,803,828,829,830,804,831,832,833,834,835,805,836,837,838,839,840,841,842,843,806,844,845,846,847,848,849,807,850,851,852,853,854,855,856,857,858,859,860,808,809,861,862,863,864,865,866,867,810,868,869,870,871,872,873,874,875,876,811,877,878,879,880,881,882,883,884,885,886,887,812,813,630,200) and class_slugs.`type`='listing' GROUP BY class_ads.id order by date_added desc
Error path: tixads.com/search/dlya-doma-i-dachi/tverskaya_oblast/kimry/