SESION: select id,cat,subcat1,subcat2,subcat3,subcat4,subcat5,count(*) as count , REMAP(subcat1,12,(225,224,226,227,228,235,236,229,232,234,233,231),(1,2,3,4,5,6,7,8,9,10,11,12)) as r from products_search where active=1 AND date_publish >= 1728298111 AND domain in(1) {{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,12,(225,224,226,227,228,235,236,229,232,234,233,231),(1,2,3,4,5,6,7,8,9,10,11,12)) as r from products_search where active=1 AND date_publish >= 1728298111 AND domain in(1) AND cat=23 AND dlv_country in(100) AND subcat1 in( 225,224,226,227,228,235,236,229,232,234,233,231) GROUP BY subcat1 ORDER BY r ASC limit 100