SELECT w.*, wb.*, wcm.*, wf.*, wfi.*, wfh.*, wps.*, wvd.*, wi.*, w.wines_id FROM wines AS w LEFT JOIN wines_assoc AS wa USING(wines_id) LEFT JOIN winery_info AS wi ON(wi.user_login_id=w.user_login_id) LEFT JOIN wine_bottling AS wb ON (wb.wines_id=w.wines_id) LEFT JOIN wine_cooperage_maturation AS wcm ON (wcm.wines_id=w.wines_id) LEFT JOIN wine_fermentation AS wf ON (wf.wines_id=w.wines_id) LEFT JOIN wine_finished_info AS wfi ON (wfi.wines_id=w.wines_id) LEFT JOIN wine_fruit_handling AS wfh ON (wfh.wines_id=w.wines_id) LEFT JOIN wine_pressing_soaking AS wps ON (wps.wines_id=w.wines_id) LEFT JOIN wine_vineyard_data AS wvd ON (wvd.wines_id=w.wines_id) WHERE w.wines_id='371' AND w.published='Y'No database selected