Advertisement
Guest User

Untitled

a guest
Sep 8th, 2015
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.54 KB | None | 0 0
  1. SELECT
  2.     `OrderItem`.`entry_id`,
  3.     `OrderItem`.`relation_id`,
  4.     `type`.`entry_id` AS `type.entry_id`,
  5.     `type`.`value` AS `type.value`,
  6.     `order_number`.`entry_id` AS `order_number.entry_id`,
  7.     `order_number`.`value` AS `order_number.value`
  8. FROM
  9.     `sym_entries_data_349` AS `OrderItem`
  10.         LEFT OUTER JOIN
  11.     `sym_entries_data_596` AS `type` ON `OrderItem`.`entry_id` = `type`.`entry_id`
  12.         LEFT OUTER JOIN
  13.     `sym_entries_data_651` AS `order_number` ON `OrderItem`.`entry_id` = `order_number`.`entry_id`
  14. LIMIT 20;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement