SESION: select id,cat,subcat1,subcat2,subcat3,subcat4,subcat5,count(*) as count , REMAP(subcat1,26,(158,192,193,194,196,197,198,199,200,202,203,204,163,165,180,181,183,185,188,191,162,170,160,159,161,164),(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) as r from products_search where active=1 AND date_publish >= 1713457469 {{category}} AND dlv_country in(100) {{sortparam}} {{groupby}} ORDER BY r ASC limit 100
CATEGORY MENU: select id,cat,subcat1,subcat2,subcat3,subcat4,subcat5,count(*) as count , REMAP(subcat1,26,(158,192,193,194,196,197,198,199,200,202,203,204,163,165,180,181,183,185,188,191,162,170,160,159,161,164),(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) as r from products_search where active=1 AND date_publish >= 1713457469 AND cat=9 AND dlv_country in(100) AND subcat1 in( 158,192,193,194,196,197,198,199,200,202,203,204,163,165,180,181,183,185,188,191,162,170,160,159,161,164) GROUP BY subcat1 ORDER BY r ASC limit 100
CATEGORY: Business & Industrial
