SELECT DISTINCT wi.winery_name, wi.winery_name,wi.winery_address1,wi.varietalsbottled,wi.winery_address2, wi.winery_city, wi.winery_country, wi.winery_state, wi.winery_zipcode,wi.winery_county,wi.pk_id,wi.fk_user_id,wi.fk_parent_company_id,wi.telephone,wi.fax,wi.web,wi.email,wi.is_winery_tasting_room, wi.mail_address1,wi.mail_address2, wi.mail_city, wi.mail_country, wi.mail_state,ct.fk_title_group_id,wi.mail_zipcode, wi.mail_county, wi.is_tr_public_tasting,wi.is_virtual_winery, wi.is_bonded_winery,ps.annual_case_production,ps.avg_bottle_price_range,ps.vineyard_acreage,ps.is_purchase_grapes,ps.is_custom_crush,ct.first_name,ct.last_name,ct.title,ct.phone,ct.email,ct.contact_type 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' and ct.contact_type='primary'   WHERE  fk_parent_company_id!=wi.pk_id