#afh_sources
select 
`s`.`source_id` AS `source_id`,`s`.`status` AS `status`,`s`.`import` AS `import`,`s`.`source_campaign` AS `source_campaign`,`s`.`source_slug` AS `source_slug`,
`s`.`source_cart_freeshipping` AS `source_cart_freeshipping`,`s`.`source_commission` AS `source_commission`,
max(if((`sd`.`key` = 'minauthonline'),`sd`.`value`,NULL)) AS `data_minauthonline`
from `sources` `s` 
left join `rel_site_source` `r` on(`r`.`source_id` = `s`.`source_id`)
left join `sources_data` `sd` on(`sd`.`source_id` = `s`.`source_id`)
where (`r`.`site_id` = 2) 
group by `s`.`source_id`

#afh_sources_data
SELECT `sd`.*
FROM `sources` `s` 
LEFT JOIN `rel_site_source` `r` ON(`r`.`source_id` = `s`.`source_id`)
LEFT JOIN `sources_data` `sd` ON(`sd`.`source_id` = `s`.`source_id`)
WHERE (`r`.`site_id` = 2) AND `sd`.`source_id` IS NOT NULL
ORDER BY `sd`.`source_id` ASC

#afh_vouchers
CREATE VIEW aps_vouchers AS
select v.voucher_id, v.source_id, v.voucher_reference_id, v.voucher_code,
IF(v.voucher_date_from<=CURDATE() AND voucher_date_to >= CURDATE(), 1, 0) as is_active,
v.voucher_date_from, v.voucher_date_to,v.voucher_name,v.voucher_description,v.voucher_url,v.voucher_condition,
v.voucher_discount_fixed,v.voucher_discount_variable
from vouchers v
left join rel_site_source r on r.source_id=v.source_id
where r.site_id = 2;