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

Just wanted to let everyone know this is the most beautiful piece of furniture we own. The platinum ...

Read More


JFK     
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/specials.frm' (errno: 24)

SELECT SQL_CALC_FOUND_ROWS pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='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='1000096' AND p.products_status='1' AND p.manufacturers_id = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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='1000036' AND p.products_status='1' AND p.manufacturers_id = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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='169' AND p.products_status='1' AND p.manufacturers_id = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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='32' AND p.products_status='1' AND p.manufacturers_id = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = s.products_id) LEFT JOIN products_description pd ON ( p.products_id=pd.products_id AND pd.language_id='1' ) WHERE p.products_id='31' AND p.products_status='1' AND p.manufacturers_id = '1000021' UNION SELECT pd.products_dimension, pd.products_volume, pd.products_fire_rating, p.products_id, p.products_quantity, p.products_model, p.products_image, p.products_price, p.products_map, p.products_msrp, p.products_weight, p.manufacturers_id, p.products_ordered, pd.products_name, pd.products_description, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price FROM products p LEFT JOIN specials s on (p.products_id = 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]