Art Galleries in Salida Colorado and Buena Vista Colorado

	SELECT *
		FROM subcat s INNER JOIN category c ON s.catid=c.catid
	 WHERE s.subcatid = 35 

	SELECT distinct city
		FROM biz_contacts 
	 WHERE subcatid like '%35%'
	 	 AND active = 1
ORDER BY city

	SELECT *
		FROM biz_contacts 
	 WHERE active = 0
		 AND subcatid = 35
ORDER BY bizname

	SELECT *
		FROM lodge_amens 
ORDER BY amen

			SELECT sc.*, c.*
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid 
			 WHERE sc.subcatid = 35 

					SELECT *
						FROM subcat
					 WHERE catid = 5
				ORDER BY subcat
				

						SELECT * 
							FROM biz_contacts
						 WHERE subcatid = 35 

						SELECT * 
							FROM biz_contacts
						 WHERE subcatid = 16 

						SELECT * 
							FROM biz_contacts
						 WHERE subcatid = 17 

						SELECT * 
							FROM biz_contacts
						 WHERE subcatid = 41 

						SELECT * 
							FROM biz_contacts
						 WHERE subcatid = 37 

										SELECT listingnumber, subcatid
											FROM biz_contacts
										 WHERE subcatid like '%35%'
											 AND active = 1
											 AND city = 'Buena Vista'
											 AND paytype = 'premium'
									ORDER BY bizname
									

										SELECT listingnumber, subcatid
											FROM biz_contacts
										 WHERE subcatid like '%35%'
											 AND active = 1
											 AND city = 'Buena Vista'
											 AND paytype = 'basic'
									ORDER BY bizname
									

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 425 

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 229 

										SELECT listingnumber, subcatid
											FROM biz_contacts
										 WHERE subcatid like '%35%'
											 AND active = 1
											 AND city = 'Salida'
											 AND paytype = 'premium'
									ORDER BY bizname
									

										SELECT listingnumber, subcatid
											FROM biz_contacts
										 WHERE subcatid like '%35%'
											 AND active = 1
											 AND city = 'Salida'
											 AND paytype = 'basic'
									ORDER BY bizname
									

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 530 

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 230 

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 497 

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 357 

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 545 

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 526 

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 401 

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 495 

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 736 

										SELECT listingnumber, subcatid
											FROM biz_contacts
										 WHERE subcatid like '%35%'
											 AND active = 1
											 AND city = 'Buena Vista'
											 AND paytype = 'premium'
									ORDER BY bizname
									

										SELECT listingnumber, subcatid
											FROM biz_contacts
										 WHERE subcatid like '%35%'
											 AND active = 1
											 AND city = 'Buena Vista'
											 AND paytype = 'basic'
									ORDER BY bizname
									

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 229 

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber = 425 

										SELECT listingnumber, subcatid
											FROM biz_contacts
										 WHERE subcatid like '%35%'
											 AND active = 1
											 AND paytype = 'free'
											 ORDER BY listingnumber
									

										SELECT *
											FROM biz_contacts
										 WHERE listingnumber in (371,487,488,532,533,534,535,536,537,538,539,640,721)
									ORDER BY bizname
									

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 1 AND activity_type <> 'Mountain'
				
		ORDER BY activity_type DESC, subcat
		

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 1 AND activity_type = 'Mountain'
				
		ORDER BY activity_type DESC, subcat
		

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 2
				
		ORDER BY activity_type DESC, subcat
		

			SELECT *
				FROM subcat sc INNER JOIN category c ON sc.catid=c.catid
			 WHERE c.catid = 6
				
		ORDER BY activity_type DESC, subcat
		

CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/home/ccvbuser/public_html/arts_entertainment/showdetails2.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=Accept: application/xhtml+xml,text/html;q=0.9,text/plain;
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=close
HTTP_COOKIE=
HTTP_HOST=www.headwatersofadventure.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=
PATH_TRANSLATED=/home/ccvbuser/public_html/arts_entertainment/showdetails2.cfm
QUERY_STRING=subcat=35
REMOTE_ADDR=38.103.63.56
REMOTE_HOST=38.103.63.56
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/arts_entertainment/showdetails2.cfm
SERVER_NAME=www.headwatersofadventure.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.1
SERVER_SOFTWARE=Apache/1.3.41 (Unix) JRun/4.0 PHP/4.4.6 mod_log_bytes/1.2 mod_bwlimited/1.4 mod_auth_passthrough/1.8 FrontPage/5.0.2.2635 mod_ssl/2.8.31 OpenSSL/0.9.7a
WEB_SERVER_API=

Client Variables:
cfid=8616871
cftoken=37255888
hitcount=1
lastvisit={ts '2008-12-03 20:17:34'}
timecreated={ts '2008-12-03 20:17:34'}
urltoken=CFID=8616871&CFTOKEN=37255888

Cookie Variables:
CFID=8616871
CFTOKEN=37255888
LANGUAGE=english

Session Variables:
cfid=8616871
cftoken=37255888
sessionid=COLORADOHEADWATERS_8616871_37255888
urltoken=CFID=8616871&CFTOKEN=37255888

URL Parameters:
SUBCAT=35