SELECT * FROM tbl_ibkprojects_projects P LEFT JOIN tbl_ibkprojects_categories C ON P.p_category = C.cat_code WHERE p_deleted = 0 AND p_visible = 1 AND p_code = 'sZp44pTw';