Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT DISTINCT ev.id AS event_id, ts.id AS stage_id, (
- SELECT CASE WHEN ts_fr.name IS NULL THEN ts.name ELSE ts_fr.name END) AS stage_name, ev.startdate, pa1.id AS pa1_id, IF ((
- SELECT COUNT(id)
- FROM ep_event_participants
- WHERE ev.id = ep_event_participants.eventFK)=4, (
- SELECT GROUP_CONCAT(IF(paa.name = coo.name, coo_fr.name, IF(paa_fr.name IS NULL, paa.name, paa_fr.name))
- ORDER BY number ASC SEPARATOR ",")
- FROM ep_event_participants
- INNER JOIN ep_participant AS paa ON paa.id=ep_event_participants.participantFK
- LEFT JOIN ep_language AS paa_fr ON paa.id = paa_fr.objectFK AND paa_fr.object="participant" AND paa_fr.language_typeFK=29 AND paa_fr.del <> "yes"
- INNER JOIN ep_country AS coo ON coo.id = paa.countryFK
- LEFT JOIN ep_language AS coo_fr ON coo.id = coo_fr.objectFK AND coo_fr.object="country" AND coo_fr.language_typeFK=29
- WHERE ep_event_participants.eventFK=ev.id AND number IN (1,3)), IF(pa1.name = co1.name, co1_fr.name, IF(pa1_fr.name IS NULL OR pa1_fr.name = "", pa1.name, pa1_fr.name))) AS pa1_name, IF ((
- SELECT COUNT(id)
- FROM ep_event_participants
- WHERE ev.id = ep_event_participants.eventFK)=4, (
- SELECT GROUP_CONCAT(IF(paa.name = coo.name, coo_fr.name, IF(paa_fr.name IS NULL, paa.name, paa_fr.name))
- ORDER BY number ASC SEPARATOR ",")
- FROM ep_event_participants
- INNER JOIN ep_participant AS paa ON paa.id=ep_event_participants.participantFK
- LEFT JOIN ep_language AS paa_fr ON paa.id = paa_fr.objectFK AND paa_fr.object="participant" AND paa_fr.language_typeFK=29 AND paa_fr.del <> "yes"
- INNER JOIN ep_country AS coo ON coo.id = paa.countryFK
- LEFT JOIN ep_language AS coo_fr ON coo.id = coo_fr.objectFK AND coo_fr.object="country" AND coo_fr.language_typeFK=29
- WHERE ep_event_participants.eventFK=ev.id AND number IN (2,4)), IF(pa2.name = co2.name, co2_fr.name, IF(pa2_fr.name IS NULL OR pa2_fr.name = "", pa2.name, pa2_fr.name))) AS pa2_name, pa2.id AS pa2_id , pa1.countryFK as pa1_countryFK, pa2.id AS pa2_id, pa2.countryFK as pa2_countryFK, (
- SELECT CASE WHEN re1tennis.value IS NULL THEN re1.value ELSE re1tennis.value END) pa1resultat_value, (
- SELECT CASE WHEN re2tennis.value IS NULL THEN re2.value ELSE re2tennis.value END) pa2resultat_value
- FROM ep_event_participants AS evp1
- INNER JOIN ep_event AS ev ON ev.id = evp1.eventFK
- INNER JOIN ep_tournament_stage ts ON ts.id = ev.tournament_stageFK
- LEFT JOIN ep_language ts_fr ON ts.id = ts_fr.objectFK AND ts_fr.object="tournament_stage" AND ts_fr.language_typeFK=29
- INNER JOIN ep_event_participants AS evp2 ON ev.id = evp2.eventFK AND evp2.number!=evp1.number
- INNER JOIN ep_participant pa1 ON evp1.participantFK=pa1.id
- INNER JOIN ep_participant pa2 ON evp2.participantFK=pa2.id
- LEFT JOIN ep_language pa1_fr ON pa1.id = pa1_fr.objectFK AND pa1_fr.object="participant" AND pa1_fr.language_typeFK=29 AND pa1_fr.del <> "yes"
- LEFT JOIN ep_language pa2_fr ON pa2.id = pa2_fr.objectFK AND pa2_fr.object="participant" AND pa2_fr.language_typeFK=29 AND pa2_fr.del <> "yes"
- INNER JOIN ep_country co1 ON co1.id = pa1.countryFK
- LEFT JOIN ep_language co1_fr ON co1.id = co1_fr.objectFK AND co1_fr.object="country" AND co1_fr.language_typeFK=29
- INNER JOIN ep_country co2 ON co2.id = pa2.countryFK
- LEFT JOIN ep_language co2_fr ON co2.id = co2_fr.objectFK AND co2_fr.object="country" AND co2_fr.language_typeFK=29
- LEFT JOIN ep_result re1 ON re1.event_participantsFK=evp1.id AND re1.result_code IN ("finalresult")
- LEFT JOIN ep_result re2 ON re2.event_participantsFK=evp2.id AND re2.result_code IN ("finalresult")
- LEFT JOIN ep_result re1tennis ON re1tennis.event_participantsFK=evp1.id AND re1tennis.result_code IN ("setswon")
- LEFT JOIN ep_result re2tennis ON re2tennis.event_participantsFK=evp2.id AND re2tennis.result_code IN ("setswon")
- WHERE (evp1.number=1 OR evp1.number=2) AND pa1.id='.$idteam.' AND ev.status_type="notstarted" AND ev.startdate < DATE_ADD(CURDATE(),INTERVAL 100 DAY) AND ev.startdate > now()
- GROUP BY ev.id
- ORDER BY ev.startdate DESC
- LIMIT '.$limit.'
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement