acctman Posted August 30, 2009 Share Posted August 30, 2009 how would i correct this left join with mysql 5? <!--[Loop Start QUERY:SELECT rm.m_rating, rm.m_user, rm.m_id, rm.m_date, rp.i_id, rp.i_rating FROM `rate_members` AS rm LEFT JOIN rate_pictures AS rp ON rm.m_id = rp.i_user WHERE rm.m_type = '1' AND rp.i_private = 0 AND rm.m_del != 1 AND rp.i_status=2 AND rm.m_rating > 0 AND rm.m_ratingcnt >= <%min_ratings%> ORDER BY RAND() LIMIT 8]--> Quote Link to comment Share on other sites More sharing options...
kickstart Posted August 31, 2009 Share Posted August 31, 2009 Hi Can't see anything that looks out of place (although you do not need to use AS when giving a table name an alias). Possibly an issue with the templating engine. All the best Keith Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.