Victorian Plumbing UK : Offers bathroom accessories, chrome oval curtain rails and shower curtain rails at wholesale prices.
Victorian Plumbing Bathroom Accessories
  Home » Curtain Rails » Chrome Oval Curtain Rail My Account  |  Cart Contents  |  Checkout
   Browse Categories
Basins
Bath Screens ->
Boilers ->
Door Furniture
Accessories ->
Baths
Bathroom Mirrors
Bathroom Suites ->
Curtain Rails
Taps - Bathroom ->
Taps - Kitchen ->
Triton Showers ->
Radiators & Towel Rails ->
Showers ->
Wastes ->

Victorian Originals ->
   Information
Shipping & Returns
Privacy Notice
Conditions of Use
Contact Us
Site Map
Other sites
Showroom
   Customer Service
Victorian Plumbing, welcomes your questions and comments.

Please phone or email us if you have any queries or issues with the website.

Telephone no : (+44)
(0) 870 850 6708
   Brands
Aqualux
Delonghi
Home of Ultra
Hudson Reed
Jax Bathrooms
Lucy
Phoenix
Triton Showers
Victorian Originals
Victorian Plumbing
Watermill
safe buy victorian plumbing
verified by Geotrust
HEADING_TITLE

Technical Spec

Chrome Oval Curtain Rail

[LA385]
Description:

Chrome oval ceiling mounted shower curtain rail. Supplied with two ceiling support legs.

Specifications

  • Diameter of tube 31mm
  • Length 1100mm
  • Width 655mm
  • Length of ceiling supports 350mm

Specialist bathroom accessories including shower rings,shower curtain rails and decorative bathroom water feed pipes.

Please note returns are not permitted on this product unless this item is faulty. Please double check the dimensions before ordering


In Stock(Delivery 2 - 3 days)

Price :£169.95
(£147.78 exc Vat)

Optional related products - Chrome Oval Curtain Rail

Shower Curtain - White Polyester - 200cm Length

Our Price: £17.95
(£15.61 exc Vat)

Buy Now
Shower Curtain - White Polyester - 200cm Length

Shower Curtain - White Polyester - 210cm Length

Our Price: £17.95
(£15.61 exc Vat)

Buy Now
Shower Curtain - White Polyester - 210cm Length

Shower Curtain - White Polyester - 220cm Length

Our Price: £17.95
(£15.61 exc Vat)

Buy Now
Shower Curtain - White Polyester - 220cm Length
1017 - Can't find file: './victoriandb/products_description.frm' (errno: 24)

SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=20 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=16 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=21 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=25 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=27 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=31 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=32 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=36 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=39 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=45 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=47 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=50 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=51 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=56 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=58 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=62 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=65 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=67 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=74 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=84 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=95 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=96 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=100 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=113 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=116 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=118 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=121 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=132 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=145 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=152 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=157 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=160 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=162 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=169 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=170 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=174 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=178 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=189 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=205 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=208 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=212 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=216 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=221 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=242 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=255 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=281 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=282 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=289 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=295 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=304 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=321 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=344 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=365 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=383 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=393 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=395 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=400 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=415 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=416 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=430 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=433 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=447 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=462 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=468 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=490 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=499 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=537 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=543 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=556 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=565 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=568 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=587 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=589 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=591 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=596 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=602 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=606 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=618 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=624 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=625 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=629 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=638 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=660 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=665 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=673 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=675 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=698 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=701 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=702 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=710 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=720 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=728 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=737 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=766 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=768 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=774 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=781 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=784 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=785 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=786 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=821 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=803 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=806 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=822 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=827 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=831 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=836 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=853 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=866 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=872 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=882 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=896 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=909 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=911 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=924 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=944 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=985 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=990 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=991 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1004 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1006 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1037 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1058 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1065 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1086 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1134 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1142 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1149 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1187 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1217 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1272 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1275 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1366 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1387 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1407 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1411 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1446 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1489 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1493 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1504 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1540 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1592 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1605 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1625 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1630 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1647 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1695 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1706 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1717 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1729 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1753 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1789 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1817 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1826 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1880 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1894 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1911 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1944 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1965 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1991 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2002 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2005 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2027 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2037 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2038 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2090 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2109 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2127 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2158 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2225 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2229 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2234 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2244 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2272 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2273 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2287 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2312 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2338 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2358 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2365 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2372 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2374 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2390 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2393 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2399 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2407 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2408 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2410 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2420 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2426 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2472 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2551 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2592 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2598 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2600 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2608 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2632 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2644 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2687 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2705 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2709 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2716 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2732 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2740 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2749 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2761 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2779 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2784 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2809 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2815 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2852 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2872 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2875 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2919 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2982 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2996 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3004 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3044 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3094 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3103 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3110 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3117 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3118 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3119 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3120 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3199 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3208 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3218 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3255 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3267 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3297 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3309 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3311 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3344 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3389 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3411 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3413 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3435 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3485 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3487 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3491 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3560 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3592 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3603 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3606 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3610 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3734 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3741 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3745 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3769 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3778 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3792 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3813 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3814 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3926 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3950 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3999 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4007 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4008 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4032 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4036 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4069 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4084 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4096 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4154 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4251 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4420 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4473 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4488 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4500 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4524 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4539 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4651 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4749 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4793 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4895 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4950 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5063 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5285 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5326 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5584 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5710 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5726 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5750 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5789 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5900 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5923 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5933 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5944 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5953 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5982 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5989 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6041 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6045 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6050 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6053 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6087 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6135 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6151 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6175 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6178 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6212 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6243 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6249 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6271 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6285 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6294 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6307 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6325 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6333 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6336 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6360 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6384 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6390 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6409 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6410 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6456 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6461 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6506 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6518 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6522 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6523 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6615 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6644 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6649 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6665 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6668 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6675 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6679 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6685 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6723 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6775 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6785 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6797 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6802 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6809 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6860 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6862 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6903 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6926 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6939 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6943 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6961 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6981 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7070 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7073 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7076 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7077 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7116 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7130 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7148 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7183 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7192 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7193 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7238 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7249 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7258 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7259 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7272 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7273 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7299 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7345 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7368 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7394 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7414 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7426 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7446 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7449 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7458 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7473 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7479 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7587 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7594 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7596 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7626 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7651 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7655 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7695 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7699 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7702 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7706 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7805 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7863 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7875 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7884 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7953 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7954 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7969 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7971 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7973 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8068 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8069 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8086 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8112 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8127 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8131 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8135 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8136 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8191 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8220 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8225 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8231 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8247 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8270 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8271 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8300 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8309 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8456 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8459 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8489 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8490 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8510 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8598 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8675 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8703 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8705 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8719 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8740 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8747 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8833 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8835 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8840 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8850 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8855 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8856 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8890 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8892 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8946 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8958 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8962 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8967 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9005 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9010 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9018 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9028 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9030 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9050 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9065 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9100 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9103 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9137 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9138 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9154 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9201 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9224 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9225 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9255 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9268 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9274 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9340 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9408 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9432 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9469 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9500 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9508 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9513 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9535 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9584 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9588 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9605 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9668 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9684 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9695 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9715 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9752 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9756 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9812 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9827 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9946 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9991 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9996 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10003 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10020 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10039 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10046 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10047 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10057 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10140 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10155 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10174 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10177 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10186 and p.products_id=pd.products_id and op.products_id!='186' and p.products_status='1' ORDER BY orders_id desc LIMIT 6

[TEP STOP]