SELECT 1 id, COUNT(`flag_is_not_executed`) qty
FROM `photographer_executed_demands`
WHERE `flag_executed` <> 1 AND id_user = '303658' AND `flag_is_not_executed` = 1

UNION ALL

SELECT 2, COUNT(`flag_expired`)
FROM `photographer_executed_demands`
WHERE `flag_executed` <> 1 AND id_user = '303658' AND `flag_expired` = 1

UNION ALL

SELECT 3, COUNT(`flag_in_processing`)
FROM `photographer_executed_demands`
WHERE `flag_executed` <> 1 AND id_user = '303658' AND `flag_in_processing` = 1

ORDER BY id

SELECT 
   SUM(`flag_is_not_executed` = 1) `qty_is_not_executed`,
   SUM(`flag_expired` = 1) `qty_expired`,
   SUM(`flag_in_processing` = 1) `qty_in_processing`,
FROM `photographer_executed_demands`
WHERE `flag_executed` <> 1 AND id_user = '303658' AND 
  (`flag_is_not_executed` = 1 OR `flag_expired` = 1 OR `flag_in_processing` = 1);