sabren.net archives
back to sabren.net...
back to the
archive...
Database error: Invalid SQL: select user, topic, mas_content.*,
DATE_FORMAT(mas_content.creationdate, '%Y/%c/%d') as shDate
from mas_content, hive_content
left join msdc_user on mas_content.userID = msdc_user.ID
left join hive_topic on hive_content.topicID = hive_topic.ID
where (mas_content.ID = hive_content.contentID) and (isactive)
and DATE_FORMAT(mas_content.creationdate, '%Y/%c/%d') = '2002/8/24'
order by mas_content.ID desc limit 20
MySQL Error: 1054 (Unknown column 'mas_content.userID' in 'on clause')
Session halted.