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
	2004	3	G	4 STAR 3H GN STK/COMBO	$13,850	24070	More Info
	1982	Stock	G	barrett 7x20	$6,450	720barr	More Info
	2007	4	G	cherokee tomahawk	$33,900		More Info
	2009	Cattle	B	CHEROKEE SHOW CALF STK	$18,950	2913	More Info
	2009	Stock	B	Cherokee Warrior	$14,800	2914	More Info
	2009	2	G	Cherokee Invasion	$29,250	2981	More Info
		3	G	CIMARRON NORSTAR	$14,750		More Info
	2004	4	G	CIMARRON gn weekender	$18,450		More Info
	2001	3	G	CM Drover	$5,900		More Info
	2008		G	INTEGRITY 4H HERITAGE w/bus windows	$20,500	NEW	More Info
	2010	3	G	MERHOW alumastar	$44,300	369	More Info
	2007	4	G	platinum coach	$64,950		More Info
	2010	Stock	B	s and h rawhide	$4,250		More Info
	2010	3	G	S&H PHOENIX	$49,900		More Info
	2010	3	B	S&H DUSTER	$5,250		More Info
	1997	3	G	SHELBY COMPETITOR	$23,500		More Info
	2007	4	G	SUNDOWNER 8018 KITCHEN SLIDE	$134,500		More Info
	2001	3	G	SUNDOWNER SUNLITE SIERRA BUNK BED	$45,500	3107	More Info
	2008	Stock	B	TITAN 12' BP STOCK CHALLENGER	$4,400	1430	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
	2007		G	Trail Master Flatbed	$5,000	FLT	More Info