EllisLab text mark
Advanced Search
     
Long query?
Posted: 25 June 2007 05:10 AM
Joined: 2007-05-28
7 posts
SELECT xxx.id as postid,
        
xxx.title as title,
        
xxx.description as description,
        
xxx.recepient_id as recepient,
        
xxx.vote as vote,
        
yyy.id as userid
        
yyy.sml_picture as smallpix,
        
yyy.username as username
        
zzz.name as category,
        
aaa.name as relationship,
        
yyy2.username as rec_name,
        
yyy2.sml_picture as rec_img,
        
xxx.date as date
        FROM xxx
        LEFT JOIN yyy
        ON yyy
.id xxx.user
        LEFT JOIN zzz
        ON zzz
.id xxx.channel
        LEFT join aaa
        ON aaa
.id xxx.relationship
        LEFT join yyy 
as yyy2
        ON xxx
.recepient_id yyy2.id
        WHERE xxx
.active 1
        ORDER BY xxx
.date desc 

You think my sql is too long? is it okay to have query this long for CI?

 
Posted: 25 June 2007 06:01 AM   [ # 1 ]   [ Rating: 0 ]
Avatar
Joined: 2007-05-27
41 posts

yes its OK i actualy use much longer qery than yours and it runs fine smile see here
http://ellislab.com/forums/viewthread/53131/