SELECT tc.intID AS id, tcl.strTitle AS title, tco.strColor AS color, "category" AS type, tc.intTypeID AS catType, tcl.strDetailTitle AS strDetailTitle, tcl.txtDetailDescription AS txtDetailDescription, tc.strMapOverlay FROM tbl_map_categories AS tc, tbl_map_categories_lang AS tcl, tbl_map_colors AS tco WHERE tc.intID = tcl.intCategoryID AND tcl.intLanguageID = 1 AND tc.intColorID = tco.intID AND tc.intID = partners ORDER BY tc.intID ASC