|
1146 - Table 'artbox_shop.products_stock' doesn't exist
SELECT DISTINCT p.products_id
FROM products p
LEFT JOIN products_stock ps
ON p.products_id = ps.products_id
LEFT JOIN products_stock_colours sc
ON ps.stock_colours_id = sc.stock_colours_id,
products_description pd,
products_to_categories pc,
manufacturers m
WHERE p.products_id = pd.products_id
AND p.products_status = 1
AND p.products_archive = 1
AND p.products_id = pc.products_id
AND p.manufacturers_id = m.manufacturers_id ORDER BY p.products_date_added DESC
[TEP STOP]
|