(SELECT * , 'news' AS article_type FROM `site_news`)
                              UNION 
                              (SELECT * , 'industry' AS article_type FROM `industry_news`)
                              UNION
                              (SELECT * , 'articles' AS article_type FROM `articles`)
                              ORDER BY `date_created` DESC LIMIT 10 : Table 'weaponmx_store.site_news' doesn't exist