Advertisement
Guest User

Untitled

a guest
Jun 30th, 2016
63
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.83 KB | None | 0 0
  1. SELECT * FROM utenti u
  2. LEFT JOIN accessi_buoni b1 ON b1.id_utente = u.id AND b1.buono = 1 AND b1.id_mese = 6
  3. LEFT JOIN accessi_buoni b2 ON b2.id_utente = u.id AND b2.buono = 2 AND b2.id_mese = 6
  4. LEFT JOIN risposte_utenti r1 ON r1.id_utente = u.id AND r1.id_domanda = (
  5.     SELECT id FROM domande WHERE id_mese = 6 LIMIT 0,1
  6. )
  7. LEFT JOIN risposte_utenti r2 ON r2.id_utente = u.id AND r2.id_domanda = (
  8.     SELECT id FROM domande WHERE id_mese = 6 LIMIT 1,1
  9. )
  10. LEFT JOIN risposte_utenti r3 ON r3.id_utente = u.id AND r3.id_domanda = (
  11.     SELECT id FROM domande WHERE id_mese = 6 LIMIT 2,1
  12. )
  13. LEFT JOIN risposte_utenti r4 ON r4.id_utente = u.id AND r4.id_domanda = (
  14.     SELECT id FROM domande WHERE id_mese = 6 LIMIT 3,1
  15. )
  16. LEFT JOIN domande d ON d.id = r.id_domanda
  17. LEFT JOIN punti p ON p.codice_ce = u.codice AND p.id_mese = 6
  18. WHERE 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement