SELECT node.nid AS nid,
   node_node_data_field_product_title.title AS node_node_data_field_product_title_title,
   node_node_data_field_product_title.nid AS node_node_data_field_product_title_nid,
   node_node_data_field_product_title.language AS node_node_data_field_product_title_language,
   node_node_data_field_product_title_node_data_field_price.field_price_value AS node_node_data_field_product_title_node_data_field_price_field_price_value,
   node_node_data_field_product_title.type AS node_node_data_field_product_title_type,
   node_node_data_field_product_title.vid AS node_node_data_field_product_title_vid,
   node_node_data_field_product_title_node_data_field_price.field_retail_price_value AS node_node_data_field_product_title_node_data_field_price_field_retail_price_value,
   node_node_data_field_product_title_node_data_field_price.field_export_price_value AS node_node_data_field_product_title_node_data_field_price_field_export_price_value,
   node_data_field_amount3.field_amount3_value AS node_data_field_amount3_field_amount3_value,
   node.language AS node_language,
   node_data_field_amount3.delta AS node_data_field_amount3_delta,
   node.type AS node_type,
   node.vid AS node_vid,
   node_data_field_status.field_status_value AS node_data_field_status_field_status_value,
   node.title AS node_title,
   node.created AS node_created,
   node_node_data_field_product_title_node_data_field_art_number.field_art_number_value AS node_node_data_field_product_title_node_data_field_art_number_field_art_number_value
 FROM node node 
 LEFT JOIN content_field_product_title node_data_field_product_title ON node.vid = node_data_field_product_title.vid
 INNER JOIN node node_node_data_field_product_title ON node_data_field_product_title.field_product_title_nid = node_node_data_field_product_title.nid
 INNER JOIN users users ON node.uid = users.uid
 LEFT JOIN content_field_amount3 node_data_field_amount3 ON node.vid = node_data_field_amount3.vid AND (node_data_field_product_title.delta = node_data_field_amount3.delta)
 LEFT JOIN content_type_product node_node_data_field_product_title_node_data_field_price ON node_node_data_field_product_title.vid = node_node_data_field_product_title_node_data_field_price.vid
 LEFT JOIN content_type_order node_data_field_status ON node.vid = node_data_field_status.vid
 LEFT JOIN content_type_product node_node_data_field_product_title_node_data_field_art_number ON node_node_data_field_product_title.vid = node_node_data_field_product_title_node_data_field_art_number.vid
 WHERE users.uid = ***CURRENT_USER***
   ORDER BY node_created DESC, node_node_data_field_product_title_node_data_field_art_number_field_art_number_value ASC, node_node_data_field_product_title_title ASC