|
|
You are here: Home > 1.75" Parts > 1.75" Stainless Steel1 3/4 inch stainless steel pipes1 3/4 inch stainless steel pipes handle high heat and resist corrosion.
Warning: mysqli_query(): (08S01/1053): Server shutdown in progress in /home/pipes/public_html/includes/functions/database.php on line 49
1053 - Server shutdown in progress
SELECT SQL_CALC_FOUND_ROWS DISTINCT products.products_id, seo_cpath , products.seo_keyword_01, products_name, manufacturers_name, manufacturers_id, factory_sku, products_model, IF(products_quantity < 1 AND allow_dropship <> 1,1,0) unavailable, product_new, product_hot, products_quantity, products.sort_order, products_description.products_name, productstats.intelligent_sort_order
,
products_price,
specials_new_products_price,
customers_group_price,
stores_price,
msrp,
IF(
stores_price > 0,stores_price,
IF(specials_new_products_price > 0 AND specials_new_products_price < products_price AND (specials_new_products_price < customers_group_price OR customers_group_price=0 OR customers_group_price IS NULL),specials_new_products_price,
IF(customers_group_price > 0 AND customers_group_price < products_price AND customers_group_price IS NOT NULL,customers_group_price,
products_price
)
)
) final_price
, suppliers_dropship_availability_name, suppliers_dropship_availability_text_style, suppliers_dropship_availability_image
FROM products
LEFT JOIN products_description USING(products_id)
LEFT JOIN products_extra USING(products_id)
LEFT JOIN productstats USING(products_id)
LEFT JOIN manufacturers USING(manufacturers_id)
LEFT JOIN products_to_categories USING(products_id)
LEFT JOIN categories USING(categories_id)
LEFT JOIN suppliers USING(suppliers_id)
LEFT JOIN suppliers_dropship_availability USING(suppliers_dropship_availability_key)
LEFT JOIN stores_price ON stores_price.products_id = products.products_id AND stores_price.store_id = "4"
LEFT JOIN specials ON status = 1 AND specials.products_id = products.products_id
LEFT JOIN products_groups ON products_groups.products_id = products.products_id AND products_groups.customers_group_id = "0"
LEFT JOIN products_seocpath ON products_seocpath.products_id = products.products_id AND products_seocpath.store_id = "4"
WHERE 1=1
AND categories_id IN("476") AND products_status = 1
ORDER BY products.sort_order ASC , products_description.products_name ASC , productstats.intelligent_sort_order ASC
LIMIT 0, 500
[TEP STOP]
| |
