Cod: Selectaţi tot
SELECT package.name, geography.name, g2.name, g3.name, g4.name,g5.name, package.id,
geography.id, g2.id, g3.id, g4.id, g5.id
FROM package
left join hotel on package.hotel_id = hotel.id
left join geography on hotel.location = geography.id
left join geography g2 on geography.parent_id = g2.id
left join geography g3 on g2.parent_id = g3.id
left join geography g4 on g3.parent_id = g4.id
left join geography g5 on g4.parent_id = g5.id
Si vreau sa il fac pentru doctrine simfony2 ce am incercat gresit:
Am postat si aici
http://stackoverflow.com/questions/36886441/sql-convert-to-orm-doctrine-simfony2