SELECT p.id, p.inn_desc, 
			p.amen_fireplace, p.amen_jacuzzi, p.amen_internet, p.amen_wifi, p.amen_eventhosting,
			p.amen_entrance, p.amen_coffee, p.amen_minibar, p.amen_handicap, p.amen_kids, p.amen_pets,
			p.inspection_ratings, p.inn_summary, p.inquiry_email, p.tollfree_phone, 
			p.site_url, p.availability_url, p.rates_url, p.specials_url,  
			l.acct_id, l.bus_name, l.city, l.stcode, l.zipcode, l.phone,
			l.heading, l.teaser, l.ltype, l.latitude, l.longitude, l.map_level
			FROM vtl_pages p, vtl_listings l, sys_accounts a
			WHERE p.acct_id=a.id
			and l.acct_id=a.id
			and l.ltype=1
			and l.bus_name='guest house log cottages'<br>Unknown column 'p.amen_fireplace' in 'field list'