sub-select

<?php
$query = "
select concat(n.chapter, ': ', lower(n.title)) as ata, coalesce(n.subtotal,0) as in_project, coalesce(n.total,0) as ata_total from (
	select
		m.chapter, m.title, m.slug,

		(select count(*) as subtotal from atas a
		inner join parts_listings pl on pl.ata = a.id
		inner join project_parts pp on pp.part_listing_id = pl.id
		where pl.ata = m.chapter and pp.in_project and a.active and pp.project_id = {$id}
		group by a.id order by a.chapter) as subtotal,

		(select count(*) as total from atas a
		inner join parts_listings pl on pl.ata = a.id
		inner join project_parts pp on pp.part_listing_id = pl.id
		where pl.ata = m.chapter and a.active and pp.project_id = {$id}
		group by a.id order by a.chapter) as total
	from
		atas m
	where
		m.active
		and
		(select count(*) as total from atas a
		inner join parts_listings pl on pl.ata = a.id
		inner join project_parts pp on pp.part_listing_id = pl.id
		where pl.ata = m.chapter and a.active and pp.project_id = {$id}
		group by a.id order by a.chapter)  > 0

	order by
		m.chapter
) as n
";