Miscellany

		$this->ipsclass->DB->simple_construct(array('select' => 'ad.*',
						'from'   => array('post4ads_ads' => 'ad'),
						'where' => "`approved` = '1'",
						'order'  => 'RAND()',
						'add_join' => array(
							0 => array( 'select' => 'me.*',
								'from'   => array( 'members' => 'me' ),
								'where'  => "me.id=ad.mid AND me.post4ads_adviews > '0'",
								'type'   => 'left' ),
						), 'limit'  => array(0, 1)));