I just realized that my namings sound so wrong in English. sex_candidati reffers to the gender of the candidates, I'm not making anything naughty here :D

Member Avatar
diafol

How are your ordering this? $p1/$p2 (whetever that is) or none at all? You can put

 ORDER BY 1

inside the GROUP_CONCAT:

GROUP_CONCAT(DISTINCT(lb.limba) ORDER BY 1 SEPARATOR ', ')

Do check if you actually need the distinct in every case.

Sweet that did the trick ^_^ . $p1 and $p2 are to ordering filters I set for various nefarious purposes :D Thanks a bunch, my lil' data base is starting to get an awesome shape!

Too many sub queries - Performance may get affected!!

Check it out!!