Phalcon How to do SELECT not in with SUB QUERY in query manager?

Question

Phalcon How to do SELECT not in with SUB QUERY in query manager?

Mahen 3D Dec '15

Created Dec '15	Last Reply Dec '15	Replies 2	Views 1166	Votes 0

Mahen 3D 13.4k

Dec '15

like to know how do i use select not in as a subquery in phalcon

for example i know i can use following to do the notIn with a array values.

return User::query() ->where(" gender!=:gender: ", array('gender' => $gender)) ->andWhere(" verify=1 ") ->notInWhere('user_id', "SELECT user_id FROM user_bannned WHERE user_id=:user_id:" ) ->order(" last_visit DESC ") ->limit($limit) ->execute();

Problem is

"SELECT user_id FROM user_bannned WHERE user_id=:user_id:"

how do i do this subquery with model query manager ?

ANY ideas ? or workarounds ?

Izo · Answer 1 · 2015-12-11T00:19:50-07:00

Izo
85.5k

Dec '15

hasOne, hasMany , phql https://docs.phalcon.io/en/latest/reference/phql.html

Wojciech Ślawski · Answer 2 · 2015-12-11T01:23:42-07:00

Wojciech Ślawski
145.0k

Dec '15

Just like in mysql.

Mahen 3D · Answer 3 · 2015-12-13T18:37:31-07:00

Mahen 3D
13.4k

in reply to

Wojciech Ślawski

Dec '15

Just like in mysql.

What you mean by this ? SELECT Subquery dont work in models

Mahen 3D · Answer 4 · 2015-12-13T18:39:55-07:00

hasOne, hasMany , phql https://docs.phalcon.io/en/latest/reference/phql.html

Can you exaplain in details how you can do this ? becaue i want soemthng like below done

User::query() ->andWhere(" gender!=:gender: ", array('gender' => $gender)) ->andWhere(" verified=1 ") ->inWhere('mode', ['active','pending']) ->notInWhere('user_id',"(SELECT user_from AS user_id FROM XYZ\Models\UsersBlock WHERE user_to=:user_id:) UNION (SELECT user_to AS user_id FROM XYZ\Models\UsersBlock WHERE user_from=:user_id:)") ->bind('user_id',$this->user->user_id) ->order(" last_visit DESC ") ->limit($limit)