Guest User

invsql example with new column

a guest
Aug 28th, 2012
47
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.58 KB | None | 0 0
  1. SELECT `inventories`.`id` AS `id`,
  2. `inventories`.`item` AS `item`,
  3. `inventories`.`data` AS `data`,
  4. `inventories`.`damage` AS `damage`,
  5. `inventories`.`count` AS `count`,
  6. `inventories`.`slot` AS `slot`,
  7. `inventories`.`date` AS `date`,
  8. `enchantments`.`ench_index` AS `ench_index`,
  9. `enchantments`.`ench` AS `ench`,
  10. `enchantments`.`level` AS `level`
  11. FROM `invsql_inventories` as `inventories`
  12. LEFT JOIN `invsql_enchantments` AS `enchantments` ON `inventories`.`id` = `enchantments`.`id`
  13. WHERE (`inventories`.`owner` = 1 AND `inventories`.`world` = 'world' AND `inventories`.`is_backup` = 0)
Advertisement
Add Comment
Please, Sign In to add comment