sql - MYSQL UNION and ORDER BY not working -

After

I have a mysql query which is

  (order_product.op_id, selection of order_product Order_product.op_partyubber, order_product.op_name, order_product.op_date, order_stock available.aosa_id, order_stock available.off_id, order_stock available.aosa_stock order, order_grad.order_product leftjoint ordercounta on order_product.cart_id = order_grad.cat from order_product _ID Left Join Order_stock is available on order_product.op_id = order_stockavailable.op_id) UNION (select order_product.op_id, order_product.ocat_id, order_product.op_partnunber, order_product.op_name, order_product.op_upc, order_product.op_desc, order_stockavailable_attributes.id, order_stockavailable_attributes.of_id Order_stockavailable_attributes.opap_stock, order_cart. Order_product join ocat_name from left, order_product.ocat_id = order_category.ocat_id on order_category join order_product.op_id = order_stockavailable on the left order_stockavailable.op_id order_product.op_id = order_stockavailable_attributes.op_id order_stockavailable_attributes on the left join order_product. The query error givng by op_name is   
 , T  
  table selects from 'order_product' in the global order section   
 can not be checked by the MYSQL manual , But no clue is found, any help would really be very good.  
 
 
 SELECT * FROM (SELECT order_product.op_id, order_product.ocat_id, order_product.op_partnunber, order_product.op_name, Order_product.op_upc, order_product.op_desc, order_stockavailable.osa_id, order_stockavailable.osa_id, order_stockavailable.of_id, order_stockavailable.osa_stocka, order_category.ocat_name order_product LEFT JOIN order_category ON order_product.ocat_id = order_category.ocat_id LEFT JOIN order_stock order_product.op_id = order_stock available.op_id Available at order_product.op_id, order_product.opcat_id, order_product.oP_partnunber, order_product.op_name, order_product.op_upc, order_product.op_dcc, order_stockavailable_attributes.id, order_stockavailable_attributes.of_id, order_stockavailable_attributes.opap_stock, order_category.ocat_name order_product LEFT JOIN order_ca Tegory ON command_product.cat_id = order_category.ocat_id LEFT JOIN order_stock available order_product.op_id = order_stockavailable.op_id order_product.op_id = order_stockavailable_attributes.op_id on the left-order_stockavailable_attributes] by op_name  
 Btw. There is no need to put a selection of a union in parentheses