select a.*,c.*,fs.sum_num from wdb_products a left join (select product_id,sum_num,site_id from wdb_favorites_sum where site_id = '4') fs on a.products_id = fs.product_id, wdb_products_description c ,(select b.products_id,b.sort_order,count(1) cnt from wdb_products_to_categories b,wdb_categories d where b.categories_path like('2331-2353-2355-%') and d.is_enabled = 1 and b.categories_id = d.categories_id group by b.products_id ) x where a.is_enabled=1 and c.languages_id='1' and c.site_id = '4' and c.is_enabled = 1 and a.products_type>=0 and a.start_selling <= '2026-02-11 11:05:39' and locate('2', a.showed_to_customer) and a.products_id = x.products_id and a.products_id = c.products_id and a.products_id in (232213,232193,232183,232003,229701,229891,229911,229881,229691,229921,232203,230841,231983,231993) order by field(a.products_id,232213,232193,232183,232003,229701,229891,229911,229881,229691,229921,232203,230841,231983,231993) limit 0,24