Hi all, I have problems to run SQL query using findBySQL, I tried also to run the query using Yii::app()->createCommand() but it did not work…
SET @rownum := 0;
SELECT fb_user_id, rank
FROM (
SELECT @rownum := @rownum +1 AS rank, fb_user_id
FROM users
ORDER BY points DESC
) AS result
WHERE fb_user_id = 12345678
If I run this in PHPMyAdmin, it return an result, what I thik it may be a problem because I have two queries?!