Perfil de las Escuelas de Samba de Río

Informaciones de las Escuelas de Samba del Carnaval.

SELECT *, (select count(c.wcccid) from wc_costume as c where c.school_id=s.wcssid and c.soldout<>'1' and c.s_site1='1') as cosqte FROM wc_RCO_samba_school as s left join wc_metas as m on m.site=17 AND s.wcssid=m.id and m.category='Samba School' where s_enable_rco='1' and group_name='Access Group' order by day, group_day_esp

Grupo Especial

Grupo Acesso