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]--> Link to comment https://forums.phpfreaks.com/topic/172470-left-join-with-mysql-5-and-tpl-parsing/ 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 Link to comment https://forums.phpfreaks.com/topic/172470-left-join-with-mysql-5-and-tpl-parsing/#findComment-909634 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.