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_stock Asc;

Photo	Year	Size	Type	Make/Model	Price	Stock#	More Info
	2008	Stock/Combo	G	INTEGRITY 7X24 STK COMBO	$17,800		More Info
	2006	6	G	4 STAR 6H TRAINER	$34,250		More Info
	2006	Stock/Combo	G	EXISS 7X20 STOCK COMBO WKDR	$14,250		More Info
	2002	4	G	PLATINUM SILVER 4H	$36,500		More Info
	2002	4	G	C&C REVERSE LOAD	$43,500		More Info
	1996	6	G	SUNDOWNER SUNLITE	$11,900		More Info
	2001	4	G	ELITE 4H LQ	$46,500		More Info
	2007	4	G	SUNDOWNER 8018 LQ	$87,000		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
	2008	3	G	ELITE 3H 10FTSWLQ,	$47,600		More Info
	1997	2	G	ELITE 2HORSE GN	$9,150		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
	2002	3	G	DELTA SLANT	$5,500		More Info
	2010	3	B	S&H 3H BP ALUMINUM	$12,900		More Info
	2005	3	G	PLATINUM 3H SLANT	$21,600		More Info
	2003	4	G	KEIFER BUILT 4H W/ AC	$14,400		More Info
	1997	3	G	SHELBY COMPETITOR	$18,900		More Info
	2007	4	G	cherokee tomahawk	$33,900		More Info
	2010	Stock	B	S&H rawhide	$4,250		More Info
	1998	3	G	sooner  3h	$9,900	1000284	More Info
	2008	2	B	TITAN 2H BP CHALLENGER W/DRESSING ROOM	$4,990	1421	More Info
	2008	3	G	TITAN 3 HORSE CHALLENGER W/2' SW	$7,200	1435	More Info
	2009	Cattle	B	CHEROKEE SHOW CALF STK	$16,900	2913	More Info
	2009	2	G	Cherokee Invasion	$25,600	2981	More Info
	2010	4	G	PHOENIX BY S&H 4H 101/2 FT LQ	$49,400	PHO4H	More Info