selectcount(*) as aggregate from `applications` leftjoin `authors` on `authors`.`id` = `applications`.`author_id` leftjoin `app_translations` on `applications`.`id` = `app_translations`.`app_id` leftjoin `application_category` on `applications`.`id` = `application_category`.`application_id` where `lang_id` =6and `applications`.`visible` =1and `category_id` =4572