SELECT g.*, k.type FROM grupper AS g JOIN aktive_grupper AS ag ON ag.gruppe_id=g.id JOIN artikler AS a ON ag.artikkel_id=a.id JOIN kategorier AS k ON k.id=a.kategori_id WHERE a.status='aktiv' AND ( k.id='702' OR k.foreldre_id='702' ) AND k.site_id=21 AND k.status='synlig' AND g.type=216 AND g.id!=484 AND g.id!=1128 GROUP BY g.id ORDER BY g.navn SELECT g.*, k.type FROM grupper AS g JOIN aktive_grupper AS ag ON ag.gruppe_id=g.id JOIN artikler AS a ON ag.artikkel_id=a.id JOIN kategorier AS k ON k.id=a.kategori_id WHERE a.status='aktiv' AND ( k.id='702' OR k.foreldre_id='702' ) AND k.site_id=21 AND k.status='synlig' AND g.type=215 AND g.id!=484 AND g.id!=1128 GROUP BY g.id ORDER BY g.navn SELECT g.*, k.type FROM grupper AS g JOIN aktive_grupper AS ag ON ag.gruppe_id=g.id JOIN artikler AS a ON ag.artikkel_id=a.id JOIN kategorier AS k ON k.id=a.kategori_id WHERE a.status='aktiv' AND ( k.id='702' OR k.foreldre_id='702' ) AND k.site_id=21 AND k.status='synlig' AND g.type=212 AND g.id!=484 AND g.id!=1128 GROUP BY g.id ORDER BY g.navn *1
Cymbaler - Istanbul Agop, Pergamon, Dream