SELECT * FROM `articles` LEFT OUTER JOIN `category` ON `articles`.`a_cat` = `category`.`cat_id` WHERE `it_visible`= 1