The generated query is ===================================== SELECT verhalen_verhaal.body AS verhalen_verhaal_body, verhalen_verhaal.update_date AS verhalen_verhaal_update_date, verhalen_verhaal.user_id AS verhalen_verhaal_user_id, verhalen_verhaal.review_date AS verhalen_verhaal_review_date, verhalen_verhaal.title AS verhalen_verhaal_title, verhalen_verhaal.ip AS verhalen_verhaal_ip, verhalen_verhaal.author AS verhalen_verhaal_author, verhalen_verhaal.enabled AS verhalen_verhaal_enabled, verhalen_verhaal.author_mail AS verhalen_verhaal_author_mail, verhalen_verhaal.slug AS verhalen_verhaal_slug, verhalen_verhaal.status AS verhalen_verhaal_status, verhalen_verhaal.create_date AS verhalen_verhaal_create_date, verhalen_verhaal.inleiding AS verhalen_verhaal_inleiding, verhalen_verhaal.author_slug AS verhalen_verhaal_author_slug, verhalen_verhaal.may_addify AS verhalen_verhaal_may_addify, verhalen_verhaa_4076.score AS verhalen_verhaa_4076_score, verhalen_verhaa_4076.keer_gelezen AS verhalen_verhaa_4076_kee_f168, verhalen_verhaa_4076.id AS verhalen_verhaa_4076_id, verhalen_verhaal.verhaalstats_id AS verhalen_verhaal_verhaal_9484, verhalen_verhaal.id AS verhalen_verhaal_id FROM (
SELECT verhalen_verhaal.id AS verhalen_verhaal_id, verhalen_verhaalstats.score AS verhalen_verhaalstats_score FROM verhalen_verhaal, verhalen_verhaalstats ORDER BY verhalen_verhaalstats.score DESC LIMIT 30 ) AS tbl_row_count, verhalen_verhaal LEFT OUTER JOIN verhalen_verhaalstats AS verhalen_verhaa_4076 ON verhalen_verhaa_4076.id = verhalen_verhaal.verhaalstats_id WHERE verhalen_verhaal.id = tbl_row_count.verhalen_verhaal_id ORDER BY tbl_row_count.verhalen_verhaalstats_score DESC , verhalen_verhaa_4076.id ===================================== For what it's worth it seems the generated subquery is wrong, in that it lacks a where clause, it is: ===================================== SELECT verhalen_verhaal.id AS verhalen_verhaal_id, verhalen_verhaalstats.score AS verhalen_verhaalstats_score FROM verhalen_verhaal, verhalen_verhaalstats ORDER BY verhalen_verhaalstats.score DESC LIMIT 30 ===================================== But when i change it to: ===================================== SELECT verhalen_verhaal.id AS verhalen_verhaal_id, verhalen_verhaalstats.score AS verhalen_verhaalstats_score FROM verhalen_verhaal, verhalen_verhaalstats WHERE verhalen_verhaalstats.id = verhalen_verhaal.verhaalstats_id ORDER BY verhalen_verhaalstats.score DESC LIMIT 30 ===================================== It looks much better ;). Of course I'm clueless as to what to change to my model to generate that query :/ --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en -~----------~----~----~----~------~----~------~--~---