Changeset 4331 for trunk/admin/rating.php

Timestamp:

Nov 21, 2009, 1:15:22 PM (14 years ago)

Author:

nikrou

Message:

Feature 1255 : improve sql
Replace in queries LIMIT N,M by LIMIT N OFFSET M

File:

• trunk/admin/rating.php (modified) (1 diff)

trunk/admin/rating.php

@@ -177 +177 @@
   GROUP BY r.element_id
   ORDER BY ' . $available_order_by[$order_by_index][1] .'
-  LIMIT '.$start.','.$elements_per_page.'
+  LIMIT '.$start.' OFFSET '.$elements_per_page.'
 ;';