D
--
SELECT loc.id, loc.nume, loc.urlid, judete.nume jnume, judete.cod jcod, tari.name tnume, max(trase.rezervari) rezervari, orar.ora24,
max(curse.d1) d1, max(curse.d2) d2, max(curse.d3) d3, max(curse.d4) d4, max(curse.d5) d5, max(curse.d6) d6, max(curse.d7) d7
FROM legaturi lg
join localitati loc ON loc.id=lg.loc_sosire_id
join tari ON tari.country_id=loc.country_id
join trase ON lg.traseu_id = trase.id
left join judete ON judete.id=loc.jud_id
JOIN orar ON orar.id=lg.ora_plecare_id and orar.dtEnd > NOW()
JOIN curse ON orar.cursa_id=curse.id
WHERE lg.loc_plecare_id=47667
AND loc.country_id <>6
GROUP BY loc.id, loc.nume, judete.cod, tari.name, orar.ora24
ORDER BY loc.country_id, loc.nume, orar.ora24
