Kód: Vybrať všetko

SELECT id, name, fname, (male) as male
FROM (

SELECT s.id as id, s.name, fname,
   (
     SELECT COUNT(*)

     FROM(
     SELECT orders_view.logid AS `id`, orders_view.`date_created` AS `date_created`,orders_view.`state` AS `state`, 
     orders_view.`author_id` AS `author_id`,orders_view.`fname` as `fname`, `u`.`id` AS `user_id`,`u`.`gender` AS `gender`,
     `s`.`name` AS `store_name`, s.id as store_id,
     COUNT(u.gender) as count_gender 
     FROM (((orders_view 
              LEFT JOIN `users` `u` ON ((`u`.`id` = orders_view.user_id))) 
              LEFT JOIN `users` `a` ON ((`a`.`id` = orders_view.author_id))) 
              LEFT JOIN `stores` `s` ON ((`s`.`id` = orders_view.store_id))) 
    WHERE s.franchise_id = 1 AND (orders_view.state = 1) AND orders_view.date_created BETWEEN '2016-02-24' AND '2016-03-24' 
    GROUP BY user_id) AS sg
    WHERE s.franchise_id = 1 AND gender='male' AND store_id=s.id) as male
    
    FROM stores s
    WHERE s.franchise_id = 1 AND s.id IN (
                                SELECT DISTINCT store_id 
                                FROM orders_view) 

) as sub