SELECT ba.*, oz.nume_operator, oz.logo_operator, o.nume_oras AS o_plecare , o2.nume_oras AS o_destinatie, s.seo_text AS html_nume_oras, s2.seo_text AS html_nume_tara, t.nume_tara
FROM bilete_avion ba
INNER JOIN operatori_zbor oz ON (ba.compania_aeriana = oz.id)
INNER JOIN orase o ON (ba.plecare = o.id_oras)
INNER JOIN orase o2 ON (ba.destinatie = o2.id_oras)
INNER JOIN tari t ON (t.id_tara = o2.tara_oras)
INNER JOIN seo_modules s ON (s.id_corespondent = destinatie)
INNER JOIN seo_modules s2 ON (s2.id_corespondent = t.id_tara)
WHERE ba.id = 609 AND s.modul = 'oras' AND s2.modul = 'tara'
Eroare: