Add offer
0 Add
Close
SESION: select id,cat,subcat1,subcat2,subcat3,subcat4,subcat5,count(*) as count , REMAP(subcat1,3,(166,167,168),(1,2,3)) as r from products_search where active=1 AND date_publish >= 1714063500 {{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,3,(166,167,168),(1,2,3)) as r from products_search where active=1 AND date_publish >= 1714063500 AND cat=10 AND dlv_country in(100) AND subcat1 in( 166,167,168) GROUP BY subcat1 ORDER BY r ASC limit 100
CATEGORY: Collectibles & Art