SELECT `jss_cat_id`, `jsc_name`, `jss_id`, `jss_cost`,`jss_duration`,`jss_onlinename`,`jssa_doc_id`,`jss_description`,jss_name,
(select count(`jssa_id`) from app_my_doc.dm_jour_services_docs t2sd, app_my_doc.dm_jour_services t2sv WHERE t2sd.`jssa_doc_id` in (0) and t2sv.jss_duration  between 600 and 600 and t2sd.`jssa_jss_id`=srv.`jss_id` and t2sd.jssa_jss_id=t2sv.jss_id and t2sv.jss_isonline=1 and t2sv.jss_duration>0 and t2sv.jss_cost>0 and t2sv.jss_status=1 and t2sd.jssa_branche_id='6' and t2sd.jssa_branche_id='6') avl,
(SELECT GROUP_CONCAT(t3sd.jssa_doc_id) from app_my_doc.dm_jour_services_docs t3sd WHERE t3sd.jssa_jss_id=srv.jss_id and t3sd.jssa_doc_id in (0) and t3sd.jssa_branche_id='6' ) docs
,CASE WHEN (srv.jss_iflimittime=1  and (jss_period_from>1765910062 or jss_period_to<1765910062 ) )THEN 1 ELSE 0 END BLOCKED_BY_TIME

,(SELECT GROUP_CONCAT(t4sd.jssa_own_cost ORDER BY t4sd.jssa_own_cost) from app_my_doc.dm_jour_services_docs t4sd WHERE t4sd.jssa_jss_id=srv.jss_id and t4sd.jssa_doc_id in (0) and t4sd.jssa_branche_id=6) ownCosts

,(SELECT ifnull(GROUP_CONCAT(DISTINCT(t5sd.jssa_ssg_time)),0) from app_my_doc.dm_jour_services_docs t5sd WHERE t5sd.jssa_jss_id=srv.jss_id and t5sd.jssa_doc_id in (0) and t5sd.jssa_branche_id=6 AND t5sd.jssa_ssg_time!=srv.jss_duration ) ownDuration
from app_my_doc.dm_jour_services_docs sd 
    left join app_my_doc.dm_jour_services srv on srv.jss_id=sd.jssa_jss_id and srv.jss_branche_id='6'
    left join app_my_doc.dm_jour_services_cat srvcat on srvcat.jsc_id=srv.jss_cat_id 
    


WHERE `jss_isonline`=1 and `jss_cost`>0 and `jss_duration`>0 and jss_status=1 
and sd.jssa_branche_id='6'  

GROUP by `jss_cat_id`, `jsc_name`, `jss_id`, `jss_cost`,`jss_duration`,`jss_onlinename`,`jss_description`
ORDER by srvcat.jsc_sort, srv.jss_sort