Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- INSERT INTO eve_data.assets
- (locatiONID, typeid, quantity, flag, corp, compONentJob, cONtainerID)
- SELECT al.Office, bpt.productTypeid, 20, al.DivisiON, 1, -1, a2.itemID
- FROM eve_data.activeLocatiONs al
- LEFT JOIN eve_dump.invBlueprintTypes bpt ON (bpt.blueprinttypeid = 11629)
- LEFT JOIN eve_data.assets a2 ON (a2.locatiONID = al.Office AND a2.typeid = 27)
- WHERE al.activityid = 1
- GROUP BY al.activityid
Add Comment
Please, Sign In to add comment