Here are links to more useful resources. You can view them all or select a type of resource you are interested in.
View By Type:
SELECT l.*,c.* FROM links l LEFT JOIN links_categories c ON l.link_cat_id=c.cat_id ORDER BY c.cat_priority, l.link_title ASC