select l.links_status from TABLE_LINKS l left join TABLE_LINKS_DESCRIPTION ld on l.links_id = ld.links_id left join TABLE_LINKS_TO_LINK_CATEGORIES l2c on l2c.links_id = ld.links_id left join TABLE_LINK_CATEGORIES lc on l2c.link_categories_id = lc.link_categories_id where (l.links_status = 2 and ( ld.language_id = 99 or ld.language_id = '2') )