SELECT DISTINCT wi.winery_name,wi.pk_id,wi.fk_user_id, wi.winery_name, wi.fk_parent_company_id, wi.telephone, wi.fax, wi.web, wi.email, wi.facebook_url, wi.twitter_url, wi.googleplus_url, wi.year_founded, wi.is_multiplebrand,wi.winery_address1, wi.winery_address2, wi.winery_city, wi.winery_country, wi.winery_state, wi.winery_zipcode,wi.winery_county, wi.is_winery_tasting_room, wi.mail_address1, wi.mail_address2, wi.mail_city, wi.mail_country, wi.mail_state, wi.mail_zipcode, wi.mail_county, wi.tasting_room_address1, wi.tasting_room_address2, wi.tasting_room_city, wi.tasting_room_state, wi.tasting_room_zipcode, wi.is_tr_public_tasting, wi.is_tr_picnic_area, wi.is_tr_kid_friendly, wi.is_tr_dog_friendly, wi.is_tr_wedding_venue, wi.is_tr2_public_tasting, wi.is_tr2_picnic_area, wi.is_tr2_kid_friendly, wi.is_tr2_dog_friendly, wi.is_tr2_wedding_venue, wi.is_ecommerce, wi.is_virtual_winery, wi.is_bonded_winery,ps.* FROM wv_winery_info wi left outer join wv_production_stats ps on wi.pk_id = ps.fk_winery_info_id left outer join wv_contacts ct on wi.pk_id = ct.fk_winery_info_id and ps.production_type='primary' WHERE fk_parent_company_id >=0 ORDER BY wi.winery_name ASC