SELECT C.CountryName, SUM(ABS(IR1.RelevantRank - CA.Amplitude)) AS DifferenceRankFROM questions_CountriesAmplitudes AS CA JOIN (SELECT SUM(QA.Amplitude * ANS.AnswerMultiplier) AS RelevantRank, QA.CategoryID AS CategoryID FROM questions_UserAnswers AS UA JOIN questions_Answers AS ANS JOIN questions_QuestionAmplitudes AS QA ON QA.QuestionID=ANS.QuestionID AND ANS.QuestionID=UA.QuestionID AND UA.AnswerID=ANS.AnswerID WHERE UA.UserUUID=1 GROUP BY CategoryID) AS IR1 JOIN questions_Countries AS CON CA.CategoryID=IR1.CategoryID AND CA.CountryID=C.CountryIDGROUP BY CA.CountryIDORDER BY DifferenceRank;"(SELECT QuestionID, QuestionBody, EffectiveAmp FROM "+" (SELECT Q.QuestionID, Q.QuestionBody, 1-ABS(A.Amplitude) AS EffectiveAmp "+" FROM questions_Questions AS Q LEFT JOIN questions_QuestionAmplitudes as A "+" ON Q.QuestionID=A.QuestionID "+" WHERE A.CategoryID=_CatID_ "+" ORDER BY EffectiveAmp DESC) AS T1) "+"UNION "+"(SELECT QuestionID, QuestionBody, EffectiveAmp FROM "+" (SELECT Q.QuestionID, Q.QuestionBody, 1 AS EffectiveAmp "+" FROM questions_Questions AS Q "+" WHERE NOT EXISTS "+" (SELECT Aq.QuestionID, Aq.Amplitude "+" FROM questions_QuestionAmplitudes as Aq "+" WHERE Aq.QuestionID=Q.QuestionID && Aq.CategoryID=_CatID_) "+" ORDER BY rand()) AS T2) "+"LIMIT _Limit_; ";