SELECT asd_user.name, IFNULL(gp_1.score, 0) AS gp_1_score, IFNULL(gp_2.score, 0) AS gp_2_score, IFNULL(gp_3.score, 0) AS gp_3_score, IFNULL(gp_4.score, 0) AS gp_4_score, IFNULL(gp_5.score, 0) AS gp_5_score, IFNULL(gp_6.score, 0) AS gp_6_score, IFNULL(gp_7.score, 0) AS gp_7_score, IFNULL(gp_8.score, 0) AS gp_8_score, IFNULL(gp_9.score, 0) AS gp_9_score, IFNULL(gp_10.score, 0) AS gp_10_score, IFNULL(gp_11.score, 0) AS gp_11_score, IFNULL(gp_12.score, 0) AS gp_12_score, IFNULL(gp_13.score, 0) AS gp_13_score, IFNULL(gp_14.score, 0) AS gp_14_score, IFNULL(gp_15.score, 0) AS gp_15_score, IFNULL(gp_16.score, 0) AS gp_16_score, IFNULL(gp_17.score, 0) AS gp_17_score, IFNULL(gp_18.score, 0) AS gp_18_score, IFNULL(gp_19.score, 0) AS gp_19_score, IFNULL(gp_20.score, 0) AS gp_20_score, IFNULL(gp_1.score, 0) + IFNULL(gp_2.score, 0) + IFNULL(gp_3.score, 0) + IFNULL(gp_4.score, 0) + IFNULL(gp_5.score, 0) + IFNULL(gp_6.score, 0) + IFNULL(gp_7.score, 0) + IFNULL(gp_8.score, 0) + IFNULL(gp_9.score, 0) + IFNULL(gp_10.score, 0) + IFNULL(gp_11.score, 0) + IFNULL(gp_12.score, 0) + IFNULL(gp_13.score, 0) + IFNULL(gp_14.score, 0) + IFNULL(gp_15.score, 0) + IFNULL(gp_16.score, 0) + IFNULL(gp_17.score, 0) + IFNULL(gp_18.score, 0) + IFNULL(gp_19.score, 0) + IFNULL(gp_20.score, 0) AS total_score, IFNULL(gp_1.tt0, 0) + IFNULL(gp_2.tt0, 0) + IFNULL(gp_3.tt0, 0) + IFNULL(gp_4.tt0, 0) + IFNULL(gp_5.tt0, 0) + IFNULL(gp_6.tt0, 0) + IFNULL(gp_7.tt0, 0) + IFNULL(gp_8.tt0, 0) + IFNULL(gp_9.tt0, 0) + IFNULL(gp_10.tt0, 0) + IFNULL(gp_11.tt0, 0) + IFNULL(gp_12.tt0, 0) + IFNULL(gp_13.tt0, 0) + IFNULL(gp_14.tt0, 0) + IFNULL(gp_15.tt0, 0) + IFNULL(gp_16.tt0, 0) + IFNULL(gp_17.tt0, 0) + IFNULL(gp_18.tt0, 0) + IFNULL(gp_19.tt0, 0) + IFNULL(gp_20.tt0, 0) AS tt0, IFNULL(gp_1.tt1, 0) + IFNULL(gp_2.tt1, 0) + IFNULL(gp_3.tt1, 0) + IFNULL(gp_4.tt1, 0) + IFNULL(gp_5.tt1, 0) + IFNULL(gp_6.tt1, 0) + IFNULL(gp_7.tt1, 0) + IFNULL(gp_8.tt1, 0) + IFNULL(gp_9.tt1, 0) + IFNULL(gp_10.tt1, 0) + IFNULL(gp_11.tt1, 0) + IFNULL(gp_12.tt1, 0) + IFNULL(gp_13.tt1, 0) + IFNULL(gp_14.tt1, 0) + IFNULL(gp_15.tt1, 0) + IFNULL(gp_16.tt1, 0) + IFNULL(gp_17.tt1, 0) + IFNULL(gp_18.tt1, 0) + IFNULL(gp_19.tt1, 0) + IFNULL(gp_20.tt1, 0) AS tt1, IFNULL(gp_1.tt2, 0) + IFNULL(gp_2.tt2, 0) + IFNULL(gp_3.tt2, 0) + IFNULL(gp_4.tt2, 0) + IFNULL(gp_5.tt2, 0) + IFNULL(gp_6.tt2, 0) + IFNULL(gp_7.tt2, 0) + IFNULL(gp_8.tt2, 0) + IFNULL(gp_9.tt2, 0) + IFNULL(gp_10.tt2, 0) + IFNULL(gp_11.tt2, 0) + IFNULL(gp_12.tt2, 0) + IFNULL(gp_13.tt2, 0) + IFNULL(gp_14.tt2, 0) + IFNULL(gp_15.tt2, 0) + IFNULL(gp_16.tt2, 0) + IFNULL(gp_17.tt2, 0) + IFNULL(gp_18.tt2, 0) + IFNULL(gp_19.tt2, 0) + IFNULL(gp_20.tt2, 0) AS tt2, IFNULL(gp_1.tt3, 0) + IFNULL(gp_2.tt3, 0) + IFNULL(gp_3.tt3, 0) + IFNULL(gp_4.tt3, 0) + IFNULL(gp_5.tt3, 0) + IFNULL(gp_6.tt3, 0) + IFNULL(gp_7.tt3, 0) + IFNULL(gp_8.tt3, 0) + IFNULL(gp_9.tt3, 0) + IFNULL(gp_10.tt3, 0) + IFNULL(gp_11.tt3, 0) + IFNULL(gp_12.tt3, 0) + IFNULL(gp_13.tt3, 0) + IFNULL(gp_14.tt3, 0) + IFNULL(gp_15.tt3, 0) + IFNULL(gp_16.tt3, 0) + IFNULL(gp_17.tt3, 0) + IFNULL(gp_18.tt3, 0) + IFNULL(gp_19.tt3, 0) + IFNULL(gp_20.tt3, 0) AS tt3, IFNULL(gp_1.tt4, 0) + IFNULL(gp_2.tt4, 0) + IFNULL(gp_3.tt4, 0) + IFNULL(gp_4.tt4, 0) + IFNULL(gp_5.tt4, 0) + IFNULL(gp_6.tt4, 0) + IFNULL(gp_7.tt4, 0) + IFNULL(gp_8.tt4, 0) + IFNULL(gp_9.tt4, 0) + IFNULL(gp_10.tt4, 0) + IFNULL(gp_11.tt4, 0) + IFNULL(gp_12.tt4, 0) + IFNULL(gp_13.tt4, 0) + IFNULL(gp_14.tt4, 0) + IFNULL(gp_15.tt4, 0) + IFNULL(gp_16.tt4, 0) + IFNULL(gp_17.tt4, 0) + IFNULL(gp_18.tt4, 0) + IFNULL(gp_19.tt4, 0) + IFNULL(gp_20.tt4, 0) AS tt4, IFNULL(gp_1.tt5, 0) + IFNULL(gp_2.tt5, 0) + IFNULL(gp_3.tt5, 0) + IFNULL(gp_4.tt5, 0) + IFNULL(gp_5.tt5, 0) + IFNULL(gp_6.tt5, 0) + IFNULL(gp_7.tt5, 0) + IFNULL(gp_8.tt5, 0) + IFNULL(gp_9.tt5, 0) + IFNULL(gp_10.tt5, 0) + IFNULL(gp_11.tt5, 0) + IFNULL(gp_12.tt5, 0) + IFNULL(gp_13.tt5, 0) + IFNULL(gp_14.tt5, 0) + IFNULL(gp_15.tt5, 0) + IFNULL(gp_16.tt5, 0) + IFNULL(gp_17.tt5, 0) + IFNULL(gp_18.tt5, 0) + IFNULL(gp_19.tt5, 0) + IFNULL(gp_20.tt5, 0) AS tt5, IFNULL(gp_1.tt6, 0) + IFNULL(gp_2.tt6, 0) + IFNULL(gp_3.tt6, 0) + IFNULL(gp_4.tt6, 0) + IFNULL(gp_5.tt6, 0) + IFNULL(gp_6.tt6, 0) + IFNULL(gp_7.tt6, 0) + IFNULL(gp_8.tt6, 0) + IFNULL(gp_9.tt6, 0) + IFNULL(gp_10.tt6, 0) + IFNULL(gp_11.tt6, 0) + IFNULL(gp_12.tt6, 0) + IFNULL(gp_13.tt6, 0) + IFNULL(gp_14.tt6, 0) + IFNULL(gp_15.tt6, 0) + IFNULL(gp_16.tt6, 0) + IFNULL(gp_17.tt6, 0) + IFNULL(gp_18.tt6, 0) + IFNULL(gp_19.tt6, 0) + IFNULL(gp_20.tt6, 0) AS tt6, IFNULL(gp_1.tt7, 0) + IFNULL(gp_2.tt7, 0) + IFNULL(gp_3.tt7, 0) + IFNULL(gp_4.tt7, 0) + IFNULL(gp_5.tt7, 0) + IFNULL(gp_6.tt7, 0) + IFNULL(gp_7.tt7, 0) + IFNULL(gp_8.tt7, 0) + IFNULL(gp_9.tt7, 0) + IFNULL(gp_10.tt7, 0) + IFNULL(gp_11.tt7, 0) + IFNULL(gp_12.tt7, 0) + IFNULL(gp_13.tt7, 0) + IFNULL(gp_14.tt7, 0) + IFNULL(gp_15.tt7, 0) + IFNULL(gp_16.tt7, 0) + IFNULL(gp_17.tt7, 0) + IFNULL(gp_18.tt7, 0) + IFNULL(gp_19.tt7, 0) + IFNULL(gp_20.tt7, 0) AS tt7, IFNULL(gp_1.tt8, 0) + IFNULL(gp_2.tt8, 0) + IFNULL(gp_3.tt8, 0) + IFNULL(gp_4.tt8, 0) + IFNULL(gp_5.tt8, 0) + IFNULL(gp_6.tt8, 0) + IFNULL(gp_7.tt8, 0) + IFNULL(gp_8.tt8, 0) + IFNULL(gp_9.tt8, 0) + IFNULL(gp_10.tt8, 0) + IFNULL(gp_11.tt8, 0) + IFNULL(gp_12.tt8, 0) + IFNULL(gp_13.tt8, 0) + IFNULL(gp_14.tt8, 0) + IFNULL(gp_15.tt8, 0) + IFNULL(gp_16.tt8, 0) + IFNULL(gp_17.tt8, 0) + IFNULL(gp_18.tt8, 0) + IFNULL(gp_19.tt8, 0) + IFNULL(gp_20.tt8, 0) AS tt8, IFNULL(gp_1.tt9, 0) + IFNULL(gp_2.tt9, 0) + IFNULL(gp_3.tt9, 0) + IFNULL(gp_4.tt9, 0) + IFNULL(gp_5.tt9, 0) + IFNULL(gp_6.tt9, 0) + IFNULL(gp_7.tt9, 0) + IFNULL(gp_8.tt9, 0) + IFNULL(gp_9.tt9, 0) + IFNULL(gp_10.tt9, 0) + IFNULL(gp_11.tt9, 0) + IFNULL(gp_12.tt9, 0) + IFNULL(gp_13.tt9, 0) + IFNULL(gp_14.tt9, 0) + IFNULL(gp_15.tt9, 0) + IFNULL(gp_16.tt9, 0) + IFNULL(gp_17.tt9, 0) + IFNULL(gp_18.tt9, 0) + IFNULL(gp_19.tt9, 0) + IFNULL(gp_20.tt9, 0) AS tt9 FROM asd_user LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 1 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 1 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 1 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 1 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 1 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 1 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 1 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 1 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 1 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 1 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 1 AND p2.gp_id = 1 AND p3.gp_id = 1 AND p4.gp_id = 1 AND p5.gp_id = 1 AND p6.gp_id = 1 AND p7.gp_id = 1 AND p8.gp_id = 1 AND p9.gp_id = 1 AND p10.gp_id = 1 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_1 ON gp_1.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 2 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 2 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 2 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 2 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 2 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 2 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 2 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 2 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 2 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 2 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 2 AND p2.gp_id = 2 AND p3.gp_id = 2 AND p4.gp_id = 2 AND p5.gp_id = 2 AND p6.gp_id = 2 AND p7.gp_id = 2 AND p8.gp_id = 2 AND p9.gp_id = 2 AND p10.gp_id = 2 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_2 ON gp_2.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 3 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 3 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 3 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 3 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 3 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 3 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 3 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 3 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 3 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 3 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 3 AND p2.gp_id = 3 AND p3.gp_id = 3 AND p4.gp_id = 3 AND p5.gp_id = 3 AND p6.gp_id = 3 AND p7.gp_id = 3 AND p8.gp_id = 3 AND p9.gp_id = 3 AND p10.gp_id = 3 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_3 ON gp_3.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 4 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 4 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 4 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 4 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 4 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 4 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 4 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 4 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 4 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 4 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 4 AND p2.gp_id = 4 AND p3.gp_id = 4 AND p4.gp_id = 4 AND p5.gp_id = 4 AND p6.gp_id = 4 AND p7.gp_id = 4 AND p8.gp_id = 4 AND p9.gp_id = 4 AND p10.gp_id = 4 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_4 ON gp_4.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 5 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 5 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 5 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 5 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 5 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 5 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 5 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 5 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 5 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 5 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 5 AND p2.gp_id = 5 AND p3.gp_id = 5 AND p4.gp_id = 5 AND p5.gp_id = 5 AND p6.gp_id = 5 AND p7.gp_id = 5 AND p8.gp_id = 5 AND p9.gp_id = 5 AND p10.gp_id = 5 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_5 ON gp_5.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 6 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 6 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 6 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 6 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 6 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 6 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 6 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 6 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 6 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 6 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 6 AND p2.gp_id = 6 AND p3.gp_id = 6 AND p4.gp_id = 6 AND p5.gp_id = 6 AND p6.gp_id = 6 AND p7.gp_id = 6 AND p8.gp_id = 6 AND p9.gp_id = 6 AND p10.gp_id = 6 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_6 ON gp_6.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 7 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 7 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 7 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 7 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 7 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 7 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 7 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 7 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 7 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 7 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 7 AND p2.gp_id = 7 AND p3.gp_id = 7 AND p4.gp_id = 7 AND p5.gp_id = 7 AND p6.gp_id = 7 AND p7.gp_id = 7 AND p8.gp_id = 7 AND p9.gp_id = 7 AND p10.gp_id = 7 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_7 ON gp_7.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 8 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 8 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 8 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 8 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 8 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 8 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 8 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 8 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 8 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 8 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 8 AND p2.gp_id = 8 AND p3.gp_id = 8 AND p4.gp_id = 8 AND p5.gp_id = 8 AND p6.gp_id = 8 AND p7.gp_id = 8 AND p8.gp_id = 8 AND p9.gp_id = 8 AND p10.gp_id = 8 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_8 ON gp_8.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 9 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 9 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 9 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 9 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 9 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 9 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 9 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 9 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 9 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 9 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 9 AND p2.gp_id = 9 AND p3.gp_id = 9 AND p4.gp_id = 9 AND p5.gp_id = 9 AND p6.gp_id = 9 AND p7.gp_id = 9 AND p8.gp_id = 9 AND p9.gp_id = 9 AND p10.gp_id = 9 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_9 ON gp_9.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 10 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 10 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 10 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 10 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 10 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 10 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 10 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 10 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 10 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 10 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 10 AND p2.gp_id = 10 AND p3.gp_id = 10 AND p4.gp_id = 10 AND p5.gp_id = 10 AND p6.gp_id = 10 AND p7.gp_id = 10 AND p8.gp_id = 10 AND p9.gp_id = 10 AND p10.gp_id = 10 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_10 ON gp_10.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 11 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 11 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 11 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 11 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 11 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 11 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 11 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 11 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 11 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 11 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 11 AND p2.gp_id = 11 AND p3.gp_id = 11 AND p4.gp_id = 11 AND p5.gp_id = 11 AND p6.gp_id = 11 AND p7.gp_id = 11 AND p8.gp_id = 11 AND p9.gp_id = 11 AND p10.gp_id = 11 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_11 ON gp_11.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 12 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 12 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 12 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 12 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 12 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 12 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 12 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 12 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 12 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 12 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 12 AND p2.gp_id = 12 AND p3.gp_id = 12 AND p4.gp_id = 12 AND p5.gp_id = 12 AND p6.gp_id = 12 AND p7.gp_id = 12 AND p8.gp_id = 12 AND p9.gp_id = 12 AND p10.gp_id = 12 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_12 ON gp_12.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 13 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 13 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 13 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 13 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 13 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 13 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 13 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 13 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 13 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 13 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 13 AND p2.gp_id = 13 AND p3.gp_id = 13 AND p4.gp_id = 13 AND p5.gp_id = 13 AND p6.gp_id = 13 AND p7.gp_id = 13 AND p8.gp_id = 13 AND p9.gp_id = 13 AND p10.gp_id = 13 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_13 ON gp_13.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 14 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 14 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 14 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 14 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 14 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 14 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 14 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 14 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 14 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 14 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 14 AND p2.gp_id = 14 AND p3.gp_id = 14 AND p4.gp_id = 14 AND p5.gp_id = 14 AND p6.gp_id = 14 AND p7.gp_id = 14 AND p8.gp_id = 14 AND p9.gp_id = 14 AND p10.gp_id = 14 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_14 ON gp_14.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 15 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 15 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 15 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 15 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 15 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 15 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 15 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 15 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 15 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 15 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 15 AND p2.gp_id = 15 AND p3.gp_id = 15 AND p4.gp_id = 15 AND p5.gp_id = 15 AND p6.gp_id = 15 AND p7.gp_id = 15 AND p8.gp_id = 15 AND p9.gp_id = 15 AND p10.gp_id = 15 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_15 ON gp_15.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 16 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 16 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 16 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 16 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 16 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 16 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 16 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 16 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 16 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 16 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 16 AND p2.gp_id = 16 AND p3.gp_id = 16 AND p4.gp_id = 16 AND p5.gp_id = 16 AND p6.gp_id = 16 AND p7.gp_id = 16 AND p8.gp_id = 16 AND p9.gp_id = 16 AND p10.gp_id = 16 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_16 ON gp_16.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 17 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 17 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 17 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 17 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 17 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 17 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 17 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 17 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 17 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 17 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 17 AND p2.gp_id = 17 AND p3.gp_id = 17 AND p4.gp_id = 17 AND p5.gp_id = 17 AND p6.gp_id = 17 AND p7.gp_id = 17 AND p8.gp_id = 17 AND p9.gp_id = 17 AND p10.gp_id = 17 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_17 ON gp_17.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 18 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 18 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 18 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 18 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 18 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 18 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 18 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 18 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 18 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 18 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 18 AND p2.gp_id = 18 AND p3.gp_id = 18 AND p4.gp_id = 18 AND p5.gp_id = 18 AND p6.gp_id = 18 AND p7.gp_id = 18 AND p8.gp_id = 18 AND p9.gp_id = 18 AND p10.gp_id = 18 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_18 ON gp_18.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 19 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 19 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 19 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 19 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 19 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 19 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 19 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 19 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 19 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 19 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 19 AND p2.gp_id = 19 AND p3.gp_id = 19 AND p4.gp_id = 19 AND p5.gp_id = 19 AND p6.gp_id = 19 AND p7.gp_id = 19 AND p8.gp_id = 19 AND p9.gp_id = 19 AND p10.gp_id = 19 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_19 ON gp_19.id = asd_user.id LEFT JOIN (SELECT t1.id, t1.name, t1.abv1, IFNULL(c1.score, 0) AS score1, t1.abv2, IFNULL(c2.score, 0) AS score2, t1.abv3, IFNULL(c3.score, 0) AS score3, t1.abv4, IFNULL(c4.score, 0) AS score4, t1.abv5, IFNULL(c5.score, 0) AS score5, t1.abv6, IFNULL(c6.score, 0) AS score6, t1.abv7, IFNULL(c7.score, 0) AS score7, t1.abv8, IFNULL(c8.score, 0) AS score8, t1.abv9, IFNULL(c9.score, 0) AS score9, t1.abv10, IFNULL(c10.score, 0) AS score10, IF(t1.diff1=0,1,0) + IF(t1.diff2=0,1,0) + IF(t1.diff3=0,1,0) + IF(t1.diff4=0,1,0) + IF(t1.diff5=0,1,0) + IF(t1.diff6=0,1,0) + IF(t1.diff7=0,1,0) + IF(t1.diff8=0,1,0) + IF(t1.diff9=0,1,0) + IF(t1.diff10=0,1,0) tt0, IF(t1.diff1=1,1,0) + IF(t1.diff2=1,1,0) + IF(t1.diff3=1,1,0) + IF(t1.diff4=1,1,0) + IF(t1.diff5=1,1,0) + IF(t1.diff6=1,1,0) + IF(t1.diff7=1,1,0) + IF(t1.diff8=1,1,0) + IF(t1.diff9=1,1,0) + IF(t1.diff10=1,1,0) tt1, IF(t1.diff1=2,1,0) + IF(t1.diff2=2,1,0) + IF(t1.diff3=2,1,0) + IF(t1.diff4=2,1,0) + IF(t1.diff5=2,1,0) + IF(t1.diff6=2,1,0) + IF(t1.diff7=2,1,0) + IF(t1.diff8=2,1,0) + IF(t1.diff9=2,1,0) + IF(t1.diff10=2,1,0) tt2, IF(t1.diff1=3,1,0) + IF(t1.diff2=3,1,0) + IF(t1.diff3=3,1,0) + IF(t1.diff4=3,1,0) + IF(t1.diff5=3,1,0) + IF(t1.diff6=3,1,0) + IF(t1.diff7=3,1,0) + IF(t1.diff8=3,1,0) + IF(t1.diff9=3,1,0) + IF(t1.diff10=3,1,0) tt3, IF(t1.diff1=4,1,0) + IF(t1.diff2=4,1,0) + IF(t1.diff3=4,1,0) + IF(t1.diff4=4,1,0) + IF(t1.diff5=4,1,0) + IF(t1.diff6=4,1,0) + IF(t1.diff7=4,1,0) + IF(t1.diff8=4,1,0) + IF(t1.diff9=4,1,0) + IF(t1.diff10=4,1,0) tt4, IF(t1.diff1=5,1,0) + IF(t1.diff2=5,1,0) + IF(t1.diff3=5,1,0) + IF(t1.diff4=5,1,0) + IF(t1.diff5=5,1,0) + IF(t1.diff6=5,1,0) + IF(t1.diff7=5,1,0) + IF(t1.diff8=5,1,0) + IF(t1.diff9=5,1,0) + IF(t1.diff10=5,1,0) tt5, IF(t1.diff1=6,1,0) + IF(t1.diff2=6,1,0) + IF(t1.diff3=6,1,0) + IF(t1.diff4=6,1,0) + IF(t1.diff5=6,1,0) + IF(t1.diff6=6,1,0) + IF(t1.diff7=6,1,0) + IF(t1.diff8=6,1,0) + IF(t1.diff9=6,1,0) + IF(t1.diff10=6,1,0) tt6, IF(t1.diff1=7,1,0) + IF(t1.diff2=7,1,0) + IF(t1.diff3=7,1,0) + IF(t1.diff4=7,1,0) + IF(t1.diff5=7,1,0) + IF(t1.diff6=7,1,0) + IF(t1.diff7=7,1,0) + IF(t1.diff8=7,1,0) + IF(t1.diff9=7,1,0) + IF(t1.diff10=7,1,0) tt7, IF(t1.diff1=8,1,0) + IF(t1.diff2=8,1,0) + IF(t1.diff3=8,1,0) + IF(t1.diff4=8,1,0) + IF(t1.diff5=8,1,0) + IF(t1.diff6=8,1,0) + IF(t1.diff7=8,1,0) + IF(t1.diff8=8,1,0) + IF(t1.diff9=8,1,0) + IF(t1.diff10=8,1,0) tt8, IF(t1.diff1=9,1,0) + IF(t1.diff2=9,1,0) + IF(t1.diff3=9,1,0) + IF(t1.diff4=9,1,0) + IF(t1.diff5=9,1,0) + IF(t1.diff6=9,1,0) + IF(t1.diff7=9,1,0) + IF(t1.diff8=9,1,0) + IF(t1.diff9=9,1,0) + IF(t1.diff10=9,1,0) tt9, IFNULL(c1.score, 0) + IFNULL(c2.score, 0) + IFNULL(c3.score, 0) + IFNULL(c4.score, 0) + IFNULL(c5.score, 0) + IFNULL(c6.score, 0) + IFNULL(c7.score, 0) + IFNULL(c8.score, 0) + IFNULL(c9.score, 0) + IFNULL(c10.score, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25, 30, 0) + IF(c1.score = 25 AND c2.score = 25 AND c3.score = 25 AND c4.score = 25 AND c5.score = 25 AND c6.score = 25 AND c7.score = 25 AND c8.score = 25 AND c9.score = 25 AND c10.score = 25, 120, 0) score FROM ( SELECT asd_user.id, asd_user.name, p1.driver_id driver_id1, d1.abv AS abv1, r1.result result1, ABS(1 - r1.result) AS diff1, p2.driver_id driver_id2, d2.abv AS abv2, r2.result result2, ABS(2 - r2.result) AS diff2, p3.driver_id driver_id3, d3.abv AS abv3, r3.result result3, ABS(3 - r3.result) AS diff3, p4.driver_id driver_id4, d4.abv AS abv4, r4.result result4, ABS(4 - r4.result) AS diff4, p5.driver_id driver_id5, d5.abv AS abv5, r5.result result5, ABS(5 - r5.result) AS diff5, p6.driver_id driver_id6, d6.abv AS abv6, r6.result result6, ABS(6 - r6.result) AS diff6, p7.driver_id driver_id7, d7.abv AS abv7, r7.result result7, ABS(7 - r7.result) AS diff7, p8.driver_id driver_id8, d8.abv AS abv8, r8.result result8, ABS(8 - r8.result) AS diff8, p9.driver_id driver_id9, d9.abv AS abv9, r9.result result9, ABS(9 - r9.result) AS diff9, p10.driver_id driver_id10, d10.abv AS abv10, r10.result result10, ABS(10 - r10.result) AS diff10 FROM asd_user LEFT JOIN asd_prediction p1 ON p1.result = 1 AND p1.user_id = asd_user.id LEFT JOIN asd_result r1 ON p1.driver_id = r1.driver_id AND r1.gp_id = 20 LEFT JOIN asd_driver d1 ON d1.id = p1.driver_id LEFT JOIN asd_prediction p2 ON p2.result = 2 AND p2.user_id = asd_user.id LEFT JOIN asd_result r2 ON p2.driver_id = r2.driver_id AND r2.gp_id = 20 LEFT JOIN asd_driver d2 ON d2.id = p2.driver_id LEFT JOIN asd_prediction p3 ON p3.result = 3 AND p3.user_id = asd_user.id LEFT JOIN asd_result r3 ON p3.driver_id = r3.driver_id AND r3.gp_id = 20 LEFT JOIN asd_driver d3 ON d3.id = p3.driver_id LEFT JOIN asd_prediction p4 ON p4.result = 4 AND p4.user_id = asd_user.id LEFT JOIN asd_result r4 ON p4.driver_id = r4.driver_id AND r4.gp_id = 20 LEFT JOIN asd_driver d4 ON d4.id = p4.driver_id LEFT JOIN asd_prediction p5 ON p5.result = 5 AND p5.user_id = asd_user.id LEFT JOIN asd_result r5 ON p5.driver_id = r5.driver_id AND r5.gp_id = 20 LEFT JOIN asd_driver d5 ON d5.id = p5.driver_id LEFT JOIN asd_prediction p6 ON p6.result = 6 AND p6.user_id = asd_user.id LEFT JOIN asd_result r6 ON p6.driver_id = r6.driver_id AND r6.gp_id = 20 LEFT JOIN asd_driver d6 ON d6.id = p6.driver_id LEFT JOIN asd_prediction p7 ON p7.result = 7 AND p7.user_id = asd_user.id LEFT JOIN asd_result r7 ON p7.driver_id = r7.driver_id AND r7.gp_id = 20 LEFT JOIN asd_driver d7 ON d7.id = p7.driver_id LEFT JOIN asd_prediction p8 ON p8.result = 8 AND p8.user_id = asd_user.id LEFT JOIN asd_result r8 ON p8.driver_id = r8.driver_id AND r8.gp_id = 20 LEFT JOIN asd_driver d8 ON d8.id = p8.driver_id LEFT JOIN asd_prediction p9 ON p9.result = 9 AND p9.user_id = asd_user.id LEFT JOIN asd_result r9 ON p9.driver_id = r9.driver_id AND r9.gp_id = 20 LEFT JOIN asd_driver d9 ON d9.id = p9.driver_id LEFT JOIN asd_prediction p10 ON p10.result = 10 AND p10.user_id = asd_user.id LEFT JOIN asd_result r10 ON p10.driver_id = r10.driver_id AND r10.gp_id = 20 LEFT JOIN asd_driver d10 ON d10.id = p10.driver_id WHERE p1.gp_id = 20 AND p2.gp_id = 20 AND p3.gp_id = 20 AND p4.gp_id = 20 AND p5.gp_id = 20 AND p6.gp_id = 20 AND p7.gp_id = 20 AND p8.gp_id = 20 AND p9.gp_id = 20 AND p10.gp_id = 20 ) t1 LEFT JOIN asd_calc c1 ON c1.diff = t1.diff1 LEFT JOIN asd_calc c2 ON c2.diff = t1.diff2 LEFT JOIN asd_calc c3 ON c3.diff = t1.diff3 LEFT JOIN asd_calc c4 ON c4.diff = t1.diff4 LEFT JOIN asd_calc c5 ON c5.diff = t1.diff5 LEFT JOIN asd_calc c6 ON c6.diff = t1.diff6 LEFT JOIN asd_calc c7 ON c7.diff = t1.diff7 LEFT JOIN asd_calc c8 ON c8.diff = t1.diff8 LEFT JOIN asd_calc c9 ON c9.diff = t1.diff9 LEFT JOIN asd_calc c10 ON c10.diff = t1.diff10 ORDER BY score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC ) gp_20 ON gp_20.id = asd_user.id ORDER BY total_score DESC, tt0 DESC, tt1 DESC, tt2 DESC, tt3 DESC, tt4 DESC, tt5 DESC, tt6 DESC, tt7 DESC, tt8 DESC, tt9 DESC