Guest User

Untitled

a guest
Jun 18th, 2018
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.42 KB | None | 0 0
  1. INSERT INTO eve_data.assets
  2. (locatiONID, typeid, quantity, flag, corp, compONentJob, cONtainerID)
  3. SELECT al.Office, bpt.productTypeid, 20, al.DivisiON, 1, -1, a2.itemID
  4. FROM eve_data.activeLocatiONs al
  5.  
  6. LEFT JOIN eve_dump.invBlueprintTypes bpt ON (bpt.blueprinttypeid = 11629)
  7.  
  8. LEFT JOIN eve_data.assets a2 ON (a2.locatiONID = al.Office AND a2.typeid = 27)
  9.  
  10. WHERE al.activityid = 1
  11. GROUP BY al.activityid
Add Comment
Please, Sign In to add comment