Advertisement
nocturnalmk

[BP] detali za lista

Apr 17th, 2013
48
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
SQL 0.24 KB | None | 0 0
  1. SELECT list_id, list_naslov, list_opis, (SELECT (k_ime || ' ' || k_prezime) FROM korisnici WHERE k_id = listi.k_id) AS kreirana_od, k_id, (SELECT COUNT(*) FROM listi_lokacii WHERE list_id = listi.list_id) AS br_lokacii FROM listi WHERE list_id = 2
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement