1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'order by RAND(), p.products_sort_order, pd.products_name
desc limit 10' at line 17
select
p.products_id
, products_tax_class_id
, pd.products_name
, p.products_model
, p.products_image
, p.products_price
from products p
INNER JOIN products_to_stores p2s ON p.products_id = p2s.products_id
, products_to_categories ptc
, products_description pd
where p.products_status = '1'
and pd.products_id = ptc.products_id
and p.products_id = ptc.products_id
and p2s.stores_id = '2'
and ptc.categories_id =
order by RAND(), p.products_sort_order, pd.products_name
desc limit 10
Ricerca avanzata
