SELECT Cust.*, t_xpathth1 FROM Cust left outer join thumbstrailer on c_id=th_key Where C_a = 'A' AND C_manu Like 's%' And C_DC Like 'chism%' And ISDATE(C_sold_date)=0 OR C_a = 'A' AND C_manu Like 's%' 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
	2010	4	G	S&H CONTENDER AL GN	$14,450		More Info
	2009	Stock	G	S&H rawhide 16x6x5pig	$4,750		More Info
	2010	3	B	S&H 3H BP ALUMINUM	$12,300		More Info
	2010	Stock	B	S&H rawhide	$4,250		More Info
	1997	3	G	SHELBY COMPETITOR	$18,900		More Info
	1998	3	G	sooner  3h	$9,900	1000284	More Info
	1996	6	G	SUNDOWNER SUNLITE	$11,900		More Info
	2007	4	G	SUNDOWNER 8018 LQ	$87,000		More Info