|
 |
|
Home » CLIP ON / SILICON » ST55 |
|
|
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 'AND
categories.parent_id > 0
' at line 11
SELECT DISTINCT products.products_id, products_description.products_name, products_price AS original_price, products.products_quantity, specials.specials_new_products_price AS products_price
FROM products LEFT JOIN products_description ON products_description.products_id = products.products_id
LEFT JOIN products_to_categories ON products_to_categories.products_id = products.products_id
LEFT JOIN products_image ON products_image.products_id = products.products_id
LEFT JOIN categories ON products_to_categories.categories_id = categories.categories_id
LEFT JOIN categories_description ON categories.categories_id = categories_description.categories_id
LEFT JOIN specials ON specials.products_id = products.products_id
WHERE categories_description.categories_name LIKE '%%'
AND
categories.categories_id !=
AND
categories.parent_id > 0
AND
products.products_quantity > 0
ORDER BY specials.specials_new_products_price DESC
LIMIT 12
[TEP STOP]
| |
Batteries and Doors
