Query: | SELECT `T1`.*, `T2`.`Value` AS `name`
FROM `fl_multi_formats` AS `T1`
LEFT JOIN `fl_multi_formats_lang_en` AS `T2` ON `T2`.`Key` = `T1`.`Key`
WHERE `T1`.`Status` = 'active' AND (
`Path` = 'aziende/macchine_da_caffe_professionali_produzione_aziende/dalla-corte-srl' ) LIMIT 1 |