Productos encontrados en la búsqueda

1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 's.weight,s.weight_partial)) desc,pd.products_name ) AS q' at line 1

select count(*) as total FROM ( select s.manufacturers_id, s.products_id, pd.products_name, p.products_tax_class_id, p.products_image, s.products_model, p.products_quantity, pd.products_description_short, pd.products_description from search_index s left join products p USING(products_id) left join products_description pd USING(products_id) left join products_tarifas pt on p.products_id = pt.products_id and tarifas_id = 0 where pd.language_id = '1' and p.products_status = 1 group by p.products_model order by sum(IF( ,s.weight,s.weight_partial)) desc,pd.products_name ) AS q

[TEP STOP]