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 for 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!!

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.