SELECT * 
				  FROM jos_content AS c
				  INNER JOIN jos_content_topics AS t
				  ON c.id = t.content_id
				  AND topic_id = 12
				  WHERE state = 1 
				  AND catid = 14
				  AND (publish_up = '0000-00-00 00:00:00' OR publish_up <= '2009-08-24 23:13')
				  AND (publish_down = '0000-00-00 00:00:00' OR publish_down >= '2009-08-24 23:13') 
				  ORDER BY ordering