SELECT p.id AS pid, pw.id AS wid, p.wine_1 AS wine_1, p.grower_id AS grower_id, p.country_1 AS country_1, p.regions_id AS regions_id, p.appellation_id AS appellation_id, p.cat_id AS cat_id, p.classification AS classification, p.vintage AS vintage, pw.size_id AS size_id, pw.price_1 AS price_1, pw.price_2 AS price_2, pw.in_stock AS in_stock, pw.nostock AS nostock, pw.onorder AS onorder, gw.name_1 AS grower_name, tn_score_1, tn_score_2, tn_score_3, tn_score_4, tn_score_5, tn_score_6, tn_score_7, tn_score_8, tn_score_9, tn_score_10, tn_score_11, tn_score_12, tn_score_13, tn_score_14, tn_score_15, p.en_primeur AS en_primeur FROM tbl_product p, tbl_product_grower gw, tbl_product_wine pw WHERE pw.pid=p.id and gw.id=p.grower_id and p.regions_id=18 and p.deleted=0 and p.active=1 and pw.deleted=0 and pw.active=1 ORDER BY gw.name_1, p.wine_1 asc, p.sort_no DESC, pw.sort_no DESC