Victorian Plumbing UK : Offers bathroom accessories, toilet flush levers and WC toilet ceramic cistern levers at wholesale prices.
Victorian Plumbing Bathroom Accessories
  Home » Accessories » W.C. Levers » Ceramic Cistern Lever - E370 My Account  |  Cart Contents  |  Checkout
   Browse Categories
Basins
Bath Screens ->
Boilers ->
Door Furniture
Accessories ->
    Baskets
    Bath Racks
    Bathroom Sets
    Cabinets
    Hooks and Hangers
    Mats
    Mirrors
    Scales
    Shelves
    Shower Curtains
    Shower Racks
    Soap Dishes
    Stand Pipes
    Storage
    Thermostatic Taps
    Toilet Brush & Holders
    Toilet Roll Holders
    Toilet Seats
    Towel Rails
    Tumblers
    W.C. Levers
    Waste
    WC Cisterns
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

Ceramic Cistern Lever - E370

[E370]
Description:

A complementary designed WC lever that brings added co ordination to a period bathroom setting

W. C. lever range complements our traditional and contemporary bathroom showers and bathroom taps.


In Stock(Delivery 2 - 3 days)

Price :£11.95
(£10.39 exc Vat)

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=44 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_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!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=103 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=106 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=114 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=120 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=139 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=164 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=239 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=262 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=269 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=303 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=330 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=335 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=337 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=371 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=376 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=391 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=411 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=448 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=454 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=488 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=520 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=555 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=573 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=579 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=590 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=645 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=669 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=677 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=876 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=885 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=957 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1012 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1046 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1089 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1200 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1250 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1323 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1360 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1365 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1371 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1382 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1408 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1505 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1517 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1535 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1575 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1640 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1645 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1648 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1681 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1705 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1735 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1748 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1842 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1867 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=1997 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2031 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2035 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2172 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2182 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2190 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2219 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2353 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2383 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2434 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2465 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2494 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2513 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2545 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2577 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2595 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_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!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2680 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2688 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2696 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2706 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2821 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2822 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2823 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2851 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2889 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2893 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2907 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2916 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2936 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2944 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2950 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=2975 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3002 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3029 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3033 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3043 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3046 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3067 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3097 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3108 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3121 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3124 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3132 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3139 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3192 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_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!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3202 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3220 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3257 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3273 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3289 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3299 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3342 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3352 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3356 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3378 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3394 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3431 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3526 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3562 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3615 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3649 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3653 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3668 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3671 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3674 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3693 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3712 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3731 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3748 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3751 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3752 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3798 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3828 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=3881 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4016 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4041 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4061 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4079 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4080 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4117 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4125 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4158 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4215 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4217 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4279 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4280 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4292 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4300 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4312 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4340 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4362 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4428 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4439 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4461 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4526 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4553 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4574 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4577 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4605 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4622 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4634 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4658 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4777 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4799 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4823 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4830 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4847 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4859 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4891 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4893 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4948 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=4980 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5003 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5011 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5042 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5047 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5095 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5106 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5107 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5119 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5124 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5127 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5138 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5140 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5141 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5165 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5299 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5341 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5392 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5400 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5425 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5427 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5480 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5483 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5574 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5579 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5621 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5624 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5627 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5632 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5641 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5642 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5666 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5725 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5732 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5794 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5822 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5827 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=5950 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_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!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6131 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6163 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6190 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6197 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6201 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6216 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6251 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6275 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6358 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6431 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6447 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6480 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6489 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6511 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6513 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6516 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6528 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6531 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6534 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6552 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6606 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6607 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6664 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6814 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6831 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=6982 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7004 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7100 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7170 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7293 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7354 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7447 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7522 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7535 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7545 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7555 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7560 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_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!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7678 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7689 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7697 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7797 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7861 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7926 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7951 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=7964 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8001 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8007 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8055 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8076 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8084 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8090 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8152 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8166 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8243 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8252 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8287 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8343 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8350 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8362 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8363 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8377 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8380 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8516 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8560 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8563 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8684 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8752 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8769 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8799 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8817 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8825 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8834 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8882 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8895 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8904 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8938 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8948 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8960 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8963 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8969 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8981 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=8999 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9027 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9044 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9059 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9112 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9146 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9155 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9183 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9210 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9220 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9251 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9266 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9345 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9373 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9438 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9445 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9454 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9467 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9468 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9474 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9490 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9574 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9621 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9622 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9640 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9656 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9681 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9686 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9699 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9803 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9817 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9823 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9878 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9902 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=9950 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10027 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10034 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10051 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10109 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10157 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10215 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' UNION SELECT op.orders_id, op.products_id, p.products_image,p.products_quantity,p.products_price, p.products_tax_class_id,pd.products_name,pd.products_description FROM orders_products op LEFT JOIN products p USING (products_id) LEFT JOIN products_description pd USING (products_id) WHERE op.orders_id=10229 and p.products_id=pd.products_id and op.products_id!='192' and p.products_status='1' ORDER BY orders_id desc LIMIT 6

[TEP STOP]