new wesqlQuery('example', array(
    'union' => array(
        new wesqlQuery('example_sub1', array(
                'select' => array(
                    array('t1.field1', 't2.field2'),
                    array('distinct' => true),
                ),
                'from' => '{db_prefix}table1 AS t1',
                'inner_join' => array(
                    '{db_prefix}table2 AS t2 ON (t1.field3 = t2.field4)',
                    '{db_prefix}table4 AS t4 ON (t4.field7 = t2.field7)',
                ),
                'left_join' => '{db_prefix}table3 AS t3 ON (t3.mem = t2.mem)',
                'where' => array(
                    't1.member = {member}',
                    '(t2.field6 = 0 OR t3.field6 = 0)',
                ),
                'group_by' => 't1.field1',
                'having' => 't1.field1 = {field1}',
                'order_by' => 't1.member ASC',
                'limit' => '1, 50',
            ), array(
                'member' => array('int', 5),
                'field1' => array('string', 'test'),
            )
        ),
        new wesqlQuery('example_sub2', array(
                'select' => array('IFNULL(m.name, mem.name) AS name',  'mem.id_member'),
                'from' => '{db_prefix}mems AS m',
                'inner_join' => '{db_prefix}members AS mem ON (m.id_member = mem.id_member)',
                'where' => 'mem.id_member IN ({mem_player_query})',
                'order_by' => 'mem.id_member DESC',
            ), array(
                'mem_player_query' => array('query', new wesqlQuery('example_sub2_sub', array(
                        'select' => 'p.id_member',
                        'from' => '{db_prefix}players AS p',
                        'where' => 'p.pfield IN ({fields})',
                    ), array(
                        'fields' => array('array_string', array('hockey', 'cricket')),
                    )
                )),
            )
        )
    ),
));