Guest User

Untitled

a guest
Sep 26th, 2011
133
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 1.31 KB | None | 0 0
  1. new wesqlQuery('example', array(
  2.     'union' => array(
  3.         new wesqlQuery('example_sub1', array(
  4.                 'select' => array(
  5.                     array('t1.field1', 't2.field2'),
  6.                     array('distinct' => true),
  7.                 ),
  8.                 'from' => '{db_prefix}table1 AS t1',
  9.                 'inner_join' => '{db_prefix}table2 AS t2 ON (t1.field3 = t2.field4)',
  10.                 'left_join' => '{db_prefix}table3 AS t3 ON (t3.mem = t2.mem)',
  11.                 'where' => 't1.member = {member}',
  12.                 'group_by' => 't1.field1',
  13.                 'having' => 't1.field1 = {field1}',
  14.                 'order_by' => 't1.member ASC',
  15.                 'limit' => '1, 50',
  16.             ), array(
  17.                 'member' => array('int', 5),
  18.                 'field1' => array('string', 'test'),
  19.             )
  20.         ),
  21.         new wesqlQuery('example_sub2', array(
  22.                 'select' => array('IFNULL(m.name, mem.name) AS name',  'mem.id_member'),
  23.                 'from' => '{db_prefix}mems AS m',
  24.                 'inner_join' => '{db_prefix}members AS mem ON (m.id_member = mem.id_member)',
  25.                 'where' => 'mem.id_member IN ({mem_player_query})',
  26.                 'order_by' => 'mem.id_member DESC',
  27.             ), array(
  28.                 'mem_player_query' => array('query', new wesqlQuery('example_sub2_sub', array(
  29.                         'select' => 'p.id_member',
  30.                         'from' => '{db_prefix}players AS p',
  31.                         'where' => 'p.pfield IN ({fields})',
  32.                     ), array(
  33.                         'fields' => array('array_string', array('hockey', 'cricket')),
  34.                     )
  35.                 )),
  36.             )
  37.         )
  38.     ),
  39. ));
Advertisement
Add Comment
Please, Sign In to add comment