<!-- SQL: 
SELECT
 o.owner_id, o.firstName, o.lastName, o.linkBackURL,
 lt.listing_id, lt.tableName,
 v.viewLink,
 sv.sviewLink,
 t.templateLink
 
 FROM Owner o, Owner_to_MetaListing om, MetaListing lt, View v, SearchView sv, Template t
 
 WHERE
 o.userId = "rab" AND o.owner_id = om.owner_id AND
 om.listing_id = lt.listing_id AND
 om.om_id = v.om_id AND
 om.om_id = sv.om_id AND
 om.template_id = t.template_id;
-->
<!-- SQL: 

			SELECT
			n.navLabel, n.URLParams, n.navTitle, n.navPriority,
			nt.name,
			novp.name,
			p.pageRefName, p.pageLink, pt.type_id, pt.name

			FROM ((((MetaListing lt join Owner_to_MetaListing om ) join Owner o) join Nav n) join NavType nt)


			LEFT JOIN NavOption novp
			ON n.option_id = novp.option_id

			LEFT JOIN AvailablePages ap
			ON n.av_id = ap.av_id

			LEFT JOIN Pages p
			ON ap.page_id = p.page_id

			LEFT JOIN PageType pt
			ON p.type_id = pt.type_id

			WHERE
			lt.tableName = "RAB01" AND
			o.userId = "rab" AND
			o.owner_id = om.owner_id AND
			lt.listing_id = om.listing_id AND
			om.om_id = n.om_id AND
			n.type_id = nt.type_id

			ORDER BY n.navPriority ASC;
-->
<!-- SQL: 

			SELECT p.pageRefName, p.pageLink, pt.type_id
			FROM  Owner o, Owner_to_MetaListing om, AvailablePages ap, Pages p, PageType pt
			WHERE
			o.userId = "rab" AND
			o.owner_id = om.owner_id AND
			om.om_id = ap.om_id AND
			ap.page_id = p.page_id AND
			p.type_id = pt.type_id;
-->
<!-- SQL: 
SELECT mc.columnName, mc.label
			FROM   MetaListing l, MetaColumn mc
			WHERE
			l.tableName = "RAB01" AND
			l.listing_id = mc.listing_id AND 
  ( mc.columnName = 'listing_price' OR mc.columnName = 'subdivision' OR mc.columnName = 'num_bedrooms' OR mc.columnName = 'num_bathrooms' OR mc.columnName = 'finished_sq_ft' ) 
-->
<!-- SQL: 

		SELECT mc.columnName, mc.label, t.type, v.name, v.value, p.name, p.value, v.value_id
		FROM ((MetaListing ml join MetaColumn mc) join ColumnType t)

		LEFT JOIN MetaColumn_to_values mtv
		ON mc.column_id = mtv.column_id
		LEFT JOIN ColumnValues v
		ON mtv.value_id = v.value_id

		LEFT JOIN ColumnParameters p
		ON mc.column_id = p.column_id
	WHERE 
ml.tableName = 'RAB01' AND 
ml.listing_id = mc.listing_id AND 
 ( mc.columnName = 'listing_price' OR mc.columnName = 'address_city' OR mc.columnName = 'unique_id' )  AND 
mc.type_id = t.type_id 

-->
<!-- SQL: 

		SELECT mc.columnName, mc.label, t.type, v.name, v.value, p.name, p.value, v.value_id
		FROM ((MetaListing ml join MetaColumn mc) join ColumnType t)

		LEFT JOIN MetaColumn_to_values mtv
		ON mc.column_id = mtv.column_id
		LEFT JOIN ColumnValues v
		ON mtv.value_id = v.value_id

		LEFT JOIN ColumnParameters p
		ON mc.column_id = p.column_id
	WHERE 
ml.tableName = 'RAB01' AND 
ml.listing_id = mc.listing_id AND 
 ( mc.columnName = 'listing_price' OR mc.columnName = 'address_city' OR mc.columnName = 'subdivision' OR mc.columnName = 'acres_lot' OR mc.columnName = 'style' OR mc.columnName = 'num_bedrooms' OR mc.columnName = 'num_bathrooms' OR mc.columnName = 'num_garage' OR mc.columnName = 'quadrant' OR mc.columnName = 'unique_id' )  AND 
mc.type_id = t.type_id 

-->
<!-- SQL: 

		SELECT mc.columnName, mc.label, t.type, v.name, v.value, p.name, p.value, v.value_id
		FROM ((MetaListing ml join MetaColumn mc) join ColumnType t)

		LEFT JOIN MetaColumn_to_values mtv
		ON mc.column_id = mtv.column_id
		LEFT JOIN ColumnValues v
		ON mtv.value_id = v.value_id

		LEFT JOIN ColumnParameters p
		ON mc.column_id = p.column_id
	WHERE 
ml.tableName = 'RAB01' AND 
ml.listing_id = mc.listing_id AND 
 ( mc.columnName = 'listing_id' OR mc.columnName = 'imageRef01' OR mc.columnName = 'listing_price' OR mc.columnName = 'address_street' OR mc.columnName = 'address_city' OR mc.columnName = 'address_state' OR mc.columnName = 'address_zip' OR mc.columnName = 'address_county' OR mc.columnName = 'subdivision' OR mc.columnName = 'acres_lot' OR mc.columnName = 'style' OR mc.columnName = 'num_bedrooms' OR mc.columnName = 'num_bathrooms' OR mc.columnName = 'finished_sq_ft' OR mc.columnName = 'unique_id' )  AND 
mc.type_id = t.type_id 

-->
<!-- SQL: 
SELECT DISTINCT ll.address_city
				FROM Listing_RAB01 ll 
				WHERE ll.address_city <> '' 
				ORDER BY ll.address_city ASC 
-->
<!-- SQL: 
SELECT listing_id,imageRef01, listing_price, address_street, address_city, address_state, address_zip, address_county, subdivision, acres_lot, style, num_bedrooms, num_bathrooms, finished_sq_ft, unique_id
FROM Listing_RAB01 l, Owner o 
 WHERE o.userId = "rab" AND o.owner_id = l.owner_id 

 ORDER BY `listing_price` ASC
 LIMIT 0,10
-->
Query failed: Unknown column 'unique_id' in 'field list'