left join med flere clauses i on
SELECT party.time_cancel, party.time_reg, party.time_start, party.area, party.title, party.flyer, COUNT(user_party.user_id) AS num_user, SUM(party_pics.pic_end-party_pics.pic_start+1) AS num_pic, COUNT(debate.id) AS num_contFROM (($DB.party party
LEFT JOIN $DB.user_party user_party ON user_party.party_id='$value')
LEFT JOIN $DB.party_pics party_pics ON party_pics.party_id='$value')
LEFT JOIN $DB.debate debate ON debate.thread_id=party.thread_id && debate.reply_id!=0
WHERE party.id='$value'
GROUP BY party.id
Der bliver ikke returneret nogle fejl, men 'num_user', 'num_pic' og 'num_cont' bliver ikke talt korrekt!?
'num_user' = 6 // men skal give 1
'num_pic' = 75 // men skal give 25
'num_cont' = 6 // men skal give 3
