SELECT DATE_FORMAT(`publish_date`,'%m-%d-%Y') date2,title,tags,author,article,blog_posts.id blog_post_id, IF(users.show='u',`username`,CONCAT(`firstname`,' ',`lastname`)) disp_name FROM `blog_posts`,`users` WHERE `users`.`id`=`blog_posts`.`author` AND blog_id='10' AND short_address='home_hair_care:_hair_treatments_with_household_items' AND `blog_posts`.`active`=1 AND `publish_date` 

Table 'brettl_hipster-hair.users' doesn't exist