Mais informação

query: SELECT YMS.*, YMS.features_pt as features, B.brand, M.model, C.country_pt 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 = '479' AND YMS.publish = 2 ORDER BY YMS.date_added DESCDe opgegeven query is onjuist!