SELECT craigs.id AS postid, craigs.priority, title, cities.city,
states.statecode, date, area, subarea, craigs.state AS poststate,
craigs.city AS postcity, SUBSTRING(body,  1 ,  200 ) AS body
FROM craigs
LEFT JOIN states ON craigs.state=states.statecode
LEFT JOIN cities ON craigs.city=cities.id WHERE craigs.category='rfs' AND states.abbreviation='dc' 
ORDER BY priority DESC, date DESC

-- 
-- Table structure for table `cities`
-- 

CREATE TABLE `cities` (
  `id` int( 11 ) NOT NULL default '0',
  `city` varchar( 100 ) NOT NULL default '',
  `statecode` int( 11 ) NOT NULL default '0',
  PRIMARY KEY  (`id`)
) TYPE=MyISAM;

-- --------------------------------------------------------

-- 
-- Table structure for table `craigs`
-- 

CREATE TABLE `craigs` (
  `id` int( 11 ) NOT NULL auto_increment,
  `craigid` int( 11 ) NOT NULL default '0',
  `url` varchar( 100 ) NOT NULL default '',
  `area` varchar( 20 ) NOT NULL default '',
  `category` varchar( 20 ) NOT NULL default '',
  `title` varchar( 255 ) NOT NULL default '',
  `body` text NOT NULL,
  `subarea` varchar( 200 ) NOT NULL default '',
  `state` int( 11 ) NOT NULL default '0',
  `city` int( 11 ) NOT NULL default '0',
  `email` varchar( 100 ) NOT NULL default '',
  `price` int( 11 ) NOT NULL default '0',
  `date` int( 11 ) NOT NULL default '0',
  `priority` tinyint( 4 ) NOT NULL default '0',
  `arid` int( 11 ) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `craigid` (`craigid`),
  KEY `category` (`category`),
  FULLTEXT KEY `body` (`body`),
  FULLTEXT KEY `subarea` (`subarea`),
  FULLTEXT KEY `title` (`title`)
) TYPE=MyISAM AUTO_INCREMENT= 565035  ;

-- --------------------------------------------------------

-- 
-- Table structure for table `states`
-- 

CREATE TABLE `states` (
  `statecode` smallint( 6 ) NOT NULL default '0',
  `abbreviation` char( 2 ) NOT NULL default '',
  `state` varchar( 100 ) NOT NULL default '',
  PRIMARY KEY  (`statecode`),
  UNIQUE KEY `abbreviation` (`abbreviation`)
) TYPE=MyISAM;

SELECT * FROM t1 
    ORDER BY key_part1 DESC, key_part2 DESC;