sub consulta mysql

mysql.sub

            SELECT             
            maa.idmarca,
            maa.nombremarca,
            (SELECT COUNT(*) FROM npc_detallebusqueda db
            INNER JOIN npc_versionAutoEnte vae ON db.idauto = vae.idauto
            INNER JOIN npc_version ve ON vae.idversion = ve.idversion
            INNER JOIN npc_marca AS ma ON db.IdMarcaDetalleBusqueda = ma.idmarca
            INNER JOIN npc_tipoauto AS t ON t.idtipoauto = db.IdTipoAutoDetalleBusqueda
            WHERE (t.idTipoVehiculo  = 1)
	     AND (ve.flagActivo = 1) 
	     AND (vae.flagActivo = 1) 
	     AND ma.idmarca = maa.idmarca
            ) AS conteo
            FROM npc_marca maa
            ORDER BY conteo DESC