SELECT Cust.*, t_xpathth1 FROM Cust left outer join thumbstrailer on c_id=th_key Where C_a = 'A' AND C_manu Like '%' And C_DC Like 'chism%' And ISDATE(C_sold_date)=0 OR C_a = 'A' AND C_manu Like '%' 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	Stock/Combo	G	S&H 2H BP	$4,550		More Info
	2009	Cattle	B	CHEROKEE SHOW CALF STK	$18,950	2913	More Info
	2007	4	G	cherokee tomahawk	$33,900		More Info
	2009	2	G	Cherokee Invasion	$28,900	2981	More Info
	2002	3	G	DELTA SLANT	$5,850		More Info
	2008	3	G	ELITE 3H 10FTSWLQ,	$49,900		More Info
	1997	2	G	ELITE 2HORSE GN	$9,950		More Info
	2001	4	G	ELITE 4H LQ	$46,500		More Info
	2002	3	G	HART 3H GN	$13,900		More Info
	2008		G	INTEGRITY 4H HERITAGE w/bus windows	$20,500	NEW	More Info
	2008	3	G	LOGAN LOGAN COACH 811 XTR	$52,500		More Info
	2010	Stock	G	LOGAN COACH STOCK LQ	$43,500		More Info
	2010	4	G	PHOENIX BY S&H 4H 101/2 FT LQ	$49,400	PHO4H	More Info
	2010	3	B	S&H 3H BP ALUMINUM	$13,400		More Info
	2010	4	G	S&H CONTENDER AL GN	$14,950		More Info
	2009	Stock	G	S&H rawhide 16x6x5pig	$4,950		More Info
	2010	Stock	B	S&H rawhide	$4,250		More Info
	1997	3	G	SHELBY COMPETITOR	$23,500		More Info
	1998	3	G	sooner  3h	$10,900	1000284	More Info
	2007	4	G	SUNDOWNER 8018 LQ	$87,500		More Info
	1996	6	G	SUNDOWNER SUNLITE	$11,900		More Info
	2008	2	B	TITAN 2H BP CHALLENGER W/DRESSING ROOM	$5,600	1421	More Info
	2008	3	G	TITAN 3 HORSE CHALLENGER W/2' SW	$7,700	1435	More Info