Più informazioni

query: SELECT YMS.*, YMS.features_it as features, B.brand, M.model, C.country_it as yacht_country, CUR.name_short as yacht_currency FROM ((((yachtpub_yms.yachts YMS LEFT JOIN websitea_currency.currency CUR on YMS.currency = CUR.id) LEFT JOIN websitea_countries.countries C on YMS.location_country = C.country_id) LEFT JOIN yachtpub_yms.yachts_brands B on YMS.brand = B.id) LEFT JOIN yachtpub_yms.yachts_models M on YMS.model = M.id) WHERE YMS.id = '478' AND YMS.publish = 2 ORDER BY YMS.date_added DESCDe opgegeven query is onjuist!