SELECT Cust.*, t_xpathth1 FROM Cust left outer join thumbstrailer on c_id=th_key Where C_a = 'A' AND C_manu Like 'cherokee%' And C_DC Like 'chism%' And ISDATE(C_sold_date)=0 OR C_a = 'A' AND C_manu Like 'cherokee%' And C_DC Like 'chism%' And C_sold_date > getdate()-30 Order By C_manu Asc;

Photo	Year	Size	Type	Make/Model	Price	Stock#	More Info
	2009	Cattle	B	CHEROKEE SHOW CALF STK	$16,900	2913	More Info
	2007	4	G	cherokee tomahawk	$33,900		More Info
	2009	2	G	Cherokee Invasion	$25,600	2981	More Info