ó i4Vdc@sddlmZdejfd„ƒYZdejefd„ƒYZdejefd„ƒYZdejefd „ƒYZd ejefd „ƒYZd S( iÿÿÿÿ(tcompilert SQLCompilercBseZeeed„ZRS(cCsØ|o!|jjdk p!|jj}|sZtt|ƒjdtd|d|ƒ\}}nttt|ƒjdtdtd|ƒ\}}d}|jjdk rµd|jjf}nd|||jjf}||fS(s[ Creates the SQL for this query. Returns the SQL string and list of parameters. This is overridden from the original Query class to handle the additional SQL Oracle requires to emulate LIMIT and OFFSET. If 'with_limits' is False, any limit/offset information is not included in the query. t with_limitstwith_col_aliasestsubquerytsWHERE ROWNUM <= %dsUSELECT * FROM (SELECT "_SUB".*, ROWNUM AS "_RN" FROM (%s) "_SUB" %s) WHERE "_RN" > %dN( tqueryt high_marktNonetlow_marktsuperRtas_sqltFalsetTrue(tselfRRRt do_offsettsqltparamst high_where((sp/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/compiler.pyR s"  (t__name__t __module__R R R (((sp/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/compiler.pyRstSQLInsertCompilercBseZRS((RR(((sp/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/compiler.pyR-stSQLDeleteCompilercBseZRS((RR(((sp/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/compiler.pyR1stSQLUpdateCompilercBseZRS((RR(((sp/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/compiler.pyR5stSQLAggregateCompilercBseZRS((RR(((sp/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/compiler.pyR9sN(tdjango.db.models.sqlRRRRRR(((sp/var/www/html/phendo-backend/phendo_python/env/lib/python2.7/site-packages/django/db/backends/oracle/compiler.pyts )