select engvi.*,engcomplex.complexid,engcomplex.name as engcomplexname,engcomplex.enable as complexenable,engcomplex.addres as engcomplexaddres,_eng_country.name as engcountryname,_eng_town.name as engtownname, engvitheme.*,engviprovider.*,engtheme.themeid,engtheme.name as engthemename,engprovider.providerID,engprovider.name as engprovidername, engprovider.addres as engprovideraddres,engprovider.phone as engproviderphone,engprovider.email as engprovideremail, engprovider.url as engproviderurl, engprovider.`desc` as engproviderdesc,eng_vilogo.imagename as engvilogoname from `engvi` left join engcomplex on engvi.complex = engcomplex.complexid left join engvitheme on engvitheme.viid = engvi.viid left join engviprovider on engviprovider.viid = engvi.viid left join engtheme on engvitheme.themeid = engtheme.themeid left join engprovider on engviprovider.providerid = engprovider.providerid left join eng_vilogo on engvi.viid = eng_vilogo.viid left join `_eng_country` on engcomplex.country = `_eng_country`.`id` left join _eng_town on engcomplex.town = _eng_town.id

Новости выставки ЛегпромЭкспо - 2023

ЛегпромЭкспо - 2023
Записей нет.