Advertisement
Guest User

Untitled

a guest
Jan 30th, 2015
367
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 1.99 KB | None | 0 0
  1. SELECT x2.x3, x2.x3, x4.x5 FROM (SELECT x6.x7 AS x8, x6.x9 AS x10, x6.x11 AS x12, x6.x13 AS x14, x6.x15 AS x3, x6.x16 AS x17, x6.x18 AS x19, x20.x21 AS x22, x20.x23 AS x24, x20.x25 AS x26 FROM (SELECT x27.`Plt` AS x7, x27.`God` AS x9, x27.`Pre` AS x11, x27.`Sef` AS x13, x27.`Mbr` AS x15, x27.`Prz` AS x16, x27.`Ime` AS x18 FROM `radnik` x27) x6 LEFT OUTER JOIN (SELECT x28.`Spr` AS x21, x28.`Mbr` AS x23, x28.`Brc` AS x25 FROM `radproj` x28) x20 ON 1=1) x2 LEFT OUTER JOIN (SELECT x29.`Spr` AS x30, x29.`Ruk` AS x31, x29.`Nap` AS x5, x29.`Nar` AS x32 FROM `projekat` x29) x4 ON (x2.x3 = x2.x24) AND (x2.x22 = x4.x30) WHERE ((x2.x19 = 'Ana') AND (NOT (x2.x17 = ''))) OR (x2.x22 = 60)
  2.  
  3.  
  4. SELECT x2.x3, x2.x4, x5.x6 FROM (SELECT x7.x8 AS x9, x7.x10 AS x11, x7.x12 AS x13, x7.x14 AS x15, x7.x16 AS x17, x7.x18 AS x4, x7.x19 AS x3, x20.x21 AS x22, x20.x23 AS x24, x20.x25 AS x26 FROM (SELECT x27.`Plt` AS x8, x27.`God` AS x10, x27.`Pre` AS x12, x27.`Sef` AS x14, x27.`Mbr` AS x16, x27.`Prz` AS x18, x27.`Ime` AS x19 FROM `radnik` x27) x7 LEFT OUTER JOIN (SELECT x28.`Spr` AS x21, x28.`Mbr` AS x23, x28.`Brc` AS x25 FROM `radproj` x28) x20 ON x7.x16 = x20.x23) x2 LEFT OUTER JOIN (SELECT x29.`Spr` AS x30, x29.`Ruk` AS x31, x29.`Nap` AS x6, x29.`Nar` AS x32 FROM `projekat` x29) x5 ON x2.x22 = x5.x30 WHERE ((x2.x3 = 'Ana') AND (NOT (x2.x4 = ''))) OR (x2.x22 = 60)
  5.  
  6.  
  7. SELECT x2.x3, x2.x4, x5.x6 FROM (SELECT x7.x8 AS x9, x7.x10 AS x11, x7.x12 AS x13, x7.x14 AS x15, x7.x16 AS x17, x7.x18 AS x4, x7.x19 AS x3, x20.x21 AS x22, x20.x23 AS x24, x20.x25 AS x26 FROM (SELECT x27.`Plt` AS x8, x27.`God` AS x10, x27.`Pre` AS x12, x27.`Sef` AS x14, x27.`Mbr` AS x16, x27.`Prz` AS x18, x27.`Ime` AS x19 FROM `radnik` x27) x7 LEFT OUTER JOIN (SELECT x28.`Spr` AS x21, x28.`Mbr` AS x23, x28.`Brc` AS x25 FROM `radproj` x28) x20 ON x7.x16 = x20.x23) x2 LEFT OUTER JOIN (SELECT x29.`Spr` AS x30, x29.`Ruk` AS x31, x29.`Nap` AS x6, x29.`Nar` AS x32 FROM `projekat` x29) x5 ON x2.x22 = x5.x30 WHERE ((x2.x3 = 'Ana') AND (NOT (x2.x4 = ''))) OR (x2.x22 = 60)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement