|
|
|
|
Warning: mysql_query(): MySQL server has gone away in /var/www/html/Inc/cabecalho.php on line 286
Warning: mysql_query(): Error reading result set's header in /var/www/html/Inc/cabecalho.php on line 286
SELECT count(1) as total,G.codigo_area as codigo,G.codigo_area as codigo_pai,A.nome as nome, 1 as Pai FROM gifs G inner join area_gifs A on A.codigo = G.codigo_area group by codigo,nome union all SELECT count(1) as total,codigo_subarea as codigo,G.codigo_area as codigo_pai,S.nome as nome , 0 as Pai FROM gifs G inner join subarea_area_gifs S on G.codigo_subarea = S.codigo group by codigo_subarea,codigo_pai,nome order by codigo_pai asc,Pai desc, Nome asc | |
