#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