Changes between Initial Version and Version 1 of Ticket #26634


Ignore:
Timestamp:
May 18, 2016, 11:46:42 AM (9 years ago)
Author:
Simon Charette
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #26634 – Description

    initial v1  
    1010The SQL looks like this:
    1111
     12{{{#!sql
    1213select * from myapp_project where
    1314id in (SELECT id from myapp_project p WHERE p.version = (SELECT max(version) FROM myapp_project p1 WHERE p1.ref = p.ref))
     15}}}
    1416
    15 I had to use extra(where=[maxids]) to achieve this*.
     17I had to use `extra(where=[maxids])` to achieve this*.
    1618
    17 *Where maxids = "id in (SELECT id from myapp_project p WHERE p.version = (SELECT max(version) FROM myapp_project p1 WHERE p1.ref = p.ref))"
     19*Where `maxids = "id in (SELECT id from myapp_project p WHERE p.version = (SELECT max(version) FROM myapp_project p1 WHERE p1.ref = p.ref))"`
    1820
    1921Stackoverflow discussion here:
Back to Top