selectcount(*) as aggregate from `applications` leftjoin `authors` on `authors`.`id` = `applications`.`author_id` leftjoin `application_category` on `applications`.`id` = `application_category`.`application_id` where `applications`.`visible` =1and `category_id` =1209