No replies to this topic

[bhbilbao]

http://addons.oscommerce.com/info/1808

Quote

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 '{6}17{8}36{7}26 AND px.xsell_id = p.products_id AND p.products_id > '100' AND xp' at line 1

SELECT p.products_id, pd.products_name, p.products_image, p.products_price, p.products_tax_class_id FROM products AS p, products_description AS pd, products_xsell AS px WHERE px.products_id = 10{6}17{8}36{7}26 AND px.xsell_id = p.products_id AND p.products_id > '100' AND xp.xsell_id > '100' AND px.xsell_id = pd.products_id AND p.products_status = '1' AND pd.language_id = '3' ORDER BY p.products_ordered DESC

[TEP STOP]

i tried to delimiting the query to non-atributed products but nothing.

This contribution needs some fix like "if tep not null --- px.products_id"

some suggest-