select f.*, count(fw.id) as watki, fk.nazwa as kat_naz
,(select count(1)
from fora_posty fp
join fora_watki fw on fp.fora_watki_id = fw.id
where fw.fora_id = f.id) as posty
,if((select max(data)
from fora_posty pp
where pp.fora_watki_id in(select aa.fora_watki_id
from fora_user aa
where aa.fora_id = f.id)) >
(select max(fuu.data) from fora_user fuu where fuu.fora_id = f.id),1,0) as nowy
from fora f
join fora_kat fk on fk.id = f.fora_kat_id
left join fora_watki fw on fw.fora_id = f.id
left join fora_user fu on fu.fora_id = f.id
where f.fora_kat_id = 20
group by f.id,f.nazwa
order by (select max(fp.data)
from fora_posty fp
join fora_watki fw on fp.fora_watki_id = fw.id
where fw.fora_id = f.id) desc limit 40
SELECT * from cms_kategorie where active = 1 and id_rodzic is null order by kolejnosc
Forum - Citysquare.pl
