|
1053 - Server shutdown in progress
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 OR ps.stock_quantity > 0)
AND p.products_id = pc.products_id
AND p.manufacturers_id = m.manufacturers_id and ((pd.products_name like '%frilly%' or m.manufacturers_name like '%frilly%' or pd.products_head_keywords_tag like '%frilly%' or pd.products_head_keywords_tag2 like '%frilly%' or p.products_model like '%frilly%' or sc.stock_colours_name like '%frilly%') ) AND sc.stock_colours_search_id = '1' AND ((p.style_id = '2') OR (p.style2_id = '2') OR (p.style3_id = '2') OR (p.style4_id = '2') OR (p.style5_id = '2')) ORDER BY p.products_outofstock, pd.products_name ASC
[TEP STOP]
|