Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- return $this->
- join(array(
- 'business_follower' => 'business_follower.business_id = notification.business_id',
- 'business' => 'business.business_id = notification.business_id'
- ), 'INNER JOIN')->
- selectFields(array(
- 'notification.dateline',
- 'notification.business_id',
- 'notification.message',
- 'business.logo_media_id'
- ))->
- where(array('business_follower.user_id' => $userId))->
- select()->
- run();
- return $this->runSql("
- SELECT
- notification.dateline,
- notification.business_id,
- notification.message,
- business.logo_media_id
- FROM
- notification
- INNER JOIN
- business_follower ON (business_follower.business_id = notification.business_id),
- business ON (business.business_id = notification.business_id)
- WHERE
- business_follower.user_id = " . $userId
- );
- ?>
Add Comment
Please, Sign In to add comment