Publicar anuncio
0 Agregar
Cerrar
SESION: select id,cat,subcat1,subcat2,subcat3,subcat4,subcat5,count(*) as count , REMAP(subcat1,18,(119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,178,135),(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18)) as r from products_search where active=1 AND date_publish >= 1721688180 AND domain in(3) {{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,18,(119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,178,135),(1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18)) as r from products_search where active=1 AND date_publish >= 1721688180 AND domain in(3) AND cat=5 AND dlv_country in(100) AND subcat1 in( 119,120,121,122,123,124,125,126,127,128,129,130,131,132,133,134,178,135) GROUP BY subcat1 ORDER BY r ASC limit 100
CATEGORÍA: Deporte y Ocio