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 My Account  |  Cart Contents  |  Checkout   
Categories
Quick Find
 
Use keywords to find a product.
Advanced Search
Testimonials more

Steve, I just wanted to thank you for the outstanding job your two installers did today: moving my ...

Read More


Keith     
Articles more
New Articles
All Topics
 Gun Safe Accessories (3)
 Gun Safes (2)
 News and Events (1)
1016 - Can't open file: './westcsafes_os_c/products.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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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 = '1000021' order by products_ordered desc LIMIT 0, 20

[TEP STOP]