|
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 '%moon%' or m.manufacturers_name like '%moon%' or pd.products_head_keywords_tag like '%moon%' or pd.products_head_keywords_tag2 like '%moon%' or p.products_model like '%moon%' or sc.stock_colours_name like '%moon%') ) AND sc.stock_colours_search_id = '9' ORDER BY p.products_outofstock, pd.products_name ASC
[TEP STOP]
|
