SELECT STRAIGHT_JOIN COUNT(*)
FROM `#__content` AS `a`
LEFT JOIN `#__categories` AS `c` ON `c`.`id` = `a`.`catid`
LEFT JOIN `#__categories` AS `parent` ON `parent`.`id` = `c`.`parent_id`
WHERE `a`.`access` IN (:preparedArray1,:preparedArray2) AND `c`.`access` IN (:preparedArray3,:preparedArray4) AND `c`.`published` = 1 AND `a`.`state` = :condition AND (`a`.`catid` = :categoryId OR `a`.`catid` IN (238,194,255,268,281,294,307,320,364,195,256,269,282,295,308,321,365,218,257,270,283,296,309,322,366,219,258,271,284,297,310,323,367,373,374,375,376,377,378,379,380,381,382,383,384,385,386,387,388,389,390,391,392,393,394,395,396,397,398,399,400,401,403,404,405,406,407,402,408,409,410,411,412)) AND (`a`.`publish_up` IS NULL OR `a`.`publish_up` <= :publishUp) AND (`a`.`publish_down` IS NULL OR `a`.`publish_down` >= :publishDown)