Advertisement
Guest User

Untitled

a guest
Aug 23rd, 2012
56
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. <?php
  2. $options = array(
  3.     'joins' => array(
  4.         "JOIN (
  5.             SELECT container_guid, MAX(time_updated) AS mtime
  6.             FROM entities
  7.             WHERE owner_guid = $user_guid
  8.             GROUP BY container_guid
  9.         ) AS q1 ON (e.guid = q1.container_guid AND e.type = 'group')"
  10.     ),
  11.     'order_by' => 'q1.mtime DESC',
  12.     'limit' => 10,
  13. );
Advertisement
Advertisement
Advertisement
RAW Paste Data Copied
Advertisement