SELECT `p`.`name` FROM `products` as `p`
LEFT JOIN `user_looks` as `ul` ON `ul`.`product_id` = `p`.`id`
WHERE `ul`.`product_id` is nullSELECT * FROM user_walls AS uw
JOIN user_uploads AS uu
ON uw.images REGEXP '[[:<:]]' || uu.upload_id || '[[:>:]]'
WHERE uw.id = 1$users = Users::model()->findAll();$user = Users::model()->findByPk($id);class Users extends CActiveRecord
{
…
public function relations()
{
return array(
'messages'=>array(self::HAS_MANY, 'Messages', 'user_id')
);
}
}$user->messages
UPDATE `wp_posts` SET `post_status`='publish' WHERE `id` in (SELECT DISTINCT `post_id` as `id` FROM `wp_postmeta` WHERE `meta_value` LIKE '%letitbit.net%')