Changes between Initial Version and Version 1 of Ticket #414


Ignore:
Timestamp:
Oct 27, 2006, 11:54:01 AM (18 years ago)
Author:
Nicklas Nordborg
Comment:

Legend:

Unmodified
Added
Removed
Modified

  • Ticket #414

    • Property Status new → assigned

  • Ticket #414 – Description

    initial v1  
    1010SQL that was generated:
    1111{{{
    12 SELECT DISTINCT "rpt"."id" AS "id" FROM "base2"."dynamic"."D40363Spot" "spt" INNER JOIN "base2"."dynamic"."D40363Pos" AS "pos" ON "pos"."cube" = "spt"."cube" AND "pos"."position" = "spt"."position"  INNER JOIN "Reporters" AS rpt ON rpt.id = pos."reporter_id"  WHERE "spt"."cube" = 2 AND "spt"."layer" = 1 ORDER BY "rpt"."external_id" ASC limit ?
     12SELECT DISTINCT "rpt"."id" AS "id"
     13FROM "base2"."dynamic"."D40363Spot" "spt"
     14INNER JOIN "base2"."dynamic"."D40363Pos" AS "pos"
     15ON "pos"."cube" = "spt"."cube"
     16AND "pos"."position" = "spt"."position" 
     17INNER JOIN "Reporters" AS rpt
     18ON rpt.id = pos."reporter_id" 
     19WHERE "spt"."cube" = 2 AND "spt"."layer" = 1
     20ORDER BY "rpt"."external_id" ASC limit ?
    1321}}}
    1422