Oh, here is the generated sql. Running this in phpMyAdmin poses a problem too. Oddly enough, if I take out the "order by answers0_.text asc" part, the query works. What could be wrong? :/
Code:
select
answers0_.question_result_id as question1_3_,
answers0_.answer_id as answer2_3_,
questionke1_.answer_id as answer1_4_0_,
questionke1_.question_id as question3_4_0_,
questionke1_.originality as original4_4_0_,
questionke1_.text as text4_0_,
questionke1_.loose_matching as loose6_4_0_,
questionke1_.type as type4_0_,
question2_.question_id as question1_5_1_,
question2_.task_id as task3_5_1_,
question2_.text as text5_1_,
question2_.ordering as ordering5_1_,
question2_.success_message as success6_5_1_,
question2_.engine_type as engine7_5_1_,
question2_.minimum_number_of_keywords as minimum8_5_1_,
question2_.minimum_number_of_words as minimum9_5_1_,
question2_.minimum_number_of_words_for_first_attempt as minimum10_5_1_,
question2_.minimum_number_of_sentences as minimum11_5_1_,
question2_.type as type5_1_,
task3_.task_id as task1_8_2_,
task3_.name as name8_2_,
task3_.ordering as ordering8_2_,
task3_.module_id as module4_8_2_
from
question_result_to_answer answers0_
left outer join
answer questionke1_
on answers0_.answer_id=questionke1_.answer_id
inner join
question question2_
on questionke1_.question_id=question2_.question_id
left outer join
task task3_
on question2_.task_id=task3_.task_id
where
answers0_.question_result_id=1
order by
answers0_.text asc
Login
FAQ
Search
