westcoastsafes.com - gun safes Map to Showroom Contact us
safes
West Coast Safes Home Contact Us Testimonials Site Map Shopping Cart
safe accessories bar
CALL FOR BEST PRICING!
  HOME » Graffunder Safes My Account  |  Cart Contents  |  Checkout   
Categories
Quick Find
 
Use keywords to find a product.
Advanced Search
Testimonials more

Superior Master safe just delivered and installed. All aspects of purchase to installation were very...

Read More


Mike     
Articles more
New Articles
All Topics
 Gun Safe Accessories (3)
 Gun Safes (2)
 News and Events (1)
Graffunder Gun Safes and Vault Doors When you need to be absolutely certain your valuables are protected, you can count on Graffunder Safes and Graffunder Gun Safes.

• Safes and Gun Safes for Residential & Commercial Use

• Weapon Storage

• Multipurpose Safes

• Vault Doors

Since 1968, Graffunder Safes, Gun Safes and Vault Doors have been hand crafted for commercial and residential use. Guided by the philosophy "quality over quantity", our products exceed industry standards at every level and in every area. With a specialty in custom work; this business has earned its reputation as "the Rolls Royce of Safes". The Graffunder Safes and Gun Safes are built with B rate, C rate, E rate and F rate bodies and doors, giving the Graffunder Gun Safes the most and heaviest steel in the gun safe industry today.

1016 - Can't open file: './westcsafes_os_c/specials.frm' (errno: 24)

SELECT SQL_CALC_FOUND_ROWS pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000319' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000318' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000317' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000316' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000315' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000314' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000313' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000312' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000311' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000310' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000309' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000308' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000307' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000306' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000305' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000304' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000303' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000302' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000301' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000300' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000299' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000298' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000297' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000296' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000295' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000294' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000293' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000292' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000291' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000290' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000289' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000288' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000287' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000286' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000285' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000284' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000283' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000282' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000281' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000280' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000279' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000278' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000277' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000276' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000275' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000274' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000273' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000272' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000271' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000270' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000269' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000268' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000267' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000266' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000265' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000264' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000263' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000262' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000261' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000260' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000259' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000258' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000257' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000256' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000255' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000254' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000253' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000252' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000251' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000250' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000249' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000248' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000247' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000246' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000245' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000244' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000243' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000242' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000241' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000240' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000239' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000238' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000237' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000236' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000235' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000234' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000233' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000232' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000231' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000230' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000229' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000228' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000227' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000226' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000225' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000224' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000223' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000222' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000221' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000220' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000219' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000218' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000217' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000216' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000215' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000214' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000213' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000212' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000211' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000210' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000209' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000207' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000206' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000205' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000204' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000203' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000202' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000201' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000200' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000199' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000198' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000197' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000196' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000195' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000194' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000193' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000184' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000183' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000182' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000181' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000180' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000179' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000178' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000177' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000176' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000175' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000174' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000173' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000172' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000171' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000170' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000169' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000168' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000167' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000164' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000163' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000162' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000161' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000160' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000159' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000158' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000157' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000155' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000154' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000153' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000152' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000148' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000147' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000146' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000145' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000144' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000141' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000138' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000135' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000133' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000132' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000131' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000130' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000129' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000125' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000124' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000123' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000122' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000119' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000117' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000115' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000114' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000113' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000112' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000111' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000110' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000109' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000108' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000102' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000101' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000100' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000098' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000095' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000094' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000093' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000092' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000088' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000087' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000086' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000085' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000084' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000083' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000082' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000081' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000080' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000079' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000078' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000077' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000072' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000071' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000070' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000069' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000068' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000067' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000066' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000065' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000064' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000063' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000062' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000061' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000060' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000059' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000058' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000057' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000056' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000055' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000054' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000053' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000052' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000051' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000050' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000049' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000048' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000039' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000038' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000037' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000035' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000034' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000033' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000032' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000031' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000030' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000029' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1000028' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='211' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='210' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='209' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='208' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='207' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='206' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='205' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='204' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='202' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='201' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='200' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='199' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='198' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='193' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='190' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='189' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='185' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='184' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='183' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='180' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='178' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='177' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='175' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='171' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='168' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='167' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='166' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='165' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='164' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='163' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='162' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='151' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='150' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='149' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='147' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='146' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='145' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='144' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='143' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='142' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='141' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='140' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='139' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='138' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='137' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='136' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='135' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='134' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='132' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='131' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='129' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='128' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='127' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='126' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='125' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='124' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='123' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='122' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='121' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='120' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='119' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='117' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='116' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='115' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='114' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='113' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='112' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='111' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='110' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='109' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='108' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='107' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='106' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='105' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='104' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='103' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='102' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='101' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='100' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='99' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='98' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='97' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='96' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='95' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='91' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='90' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='89' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='88' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='87' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='80' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='79' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='78' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='77' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='76' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='74' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='72' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='71' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='70' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='69' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='68' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='67' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='66' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='64' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='63' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='62' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='61' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='60' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='59' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='58' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='57' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='56' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='55' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='53' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='52' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='51' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='50' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='49' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='48' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='47' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='46' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='45' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='44' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='42' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='41' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='40' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='39' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='38' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='37' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='36' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='35' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='34' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='33' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='30' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='29' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='28' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='27' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='26' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='25' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='23' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='22' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='20' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='19' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='18' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='17' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='16' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='15' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='14' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='13' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='12' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='11' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='10' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='5' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='4' AND p.products_status='1' AND p.manufacturers_id = '1000020' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='1' AND p.products_status='1' AND p.manufacturers_id = '1000020' order by products_ordered desc LIMIT 0, 20

[TEP STOP]