| - | |where=char2.detail = 'Fame' AND characters.Status = 'Active' OR char2.detail = 'Contacts' AND characters.Status = 'Active' OR char2.detail = 'Allies' AND char2.value > 2 AND char2.option IN ('Academia','Arms Dealers','Charities','City Hall','Clubs','Criminals','Culture','Digital Networks','Emergency Services','Entertainment','Fashion','Finance','Judicial','Medical','Status','News Media','Public Works','Religious Groups','Street','Unions') AND characters.Status = 'Active' OR char2.detail = 'Status' AND char2.value > 1 AND char2.option IN ('Academia','Arms Dealers','Charities','City Hall','Clubs','Criminals','Culture','Digital Networks','Emergency Services','Entertainment','Fashion','Finance','Judicial','Medical','Status','News Media','Public Works','Religious Groups','Street','Unions') AND characters.Status = 'Active'
| + | |
| - | |data=threadid=characters.threadid, name=char_name, detail=detail, spheres=GROUP_CONCAT(DISTINCT char2.option ORDER BY char2.option ASC SEPARATOR ', '), userid=characters.userid
| + | |
