Query:

SELECT deactive_id FROM deactive WHERE pid = 1052477

Error:

Query:

SELECT media.mid AS mid, media.name AS name, media.created AS created, properties.pid AS pid FROM media LEFT JOIN properties ON media.pid = properties.pid WHERE (media.type = 'still' OR media.type = 'tpstill' OR media.type = 'lumatix' OR media.type = 'hammond_still') AND media.flag = 'approved' AND media.s_show_disp = 1 AND properties.pid = 1052477 AND LOWER(name) NOT LIKE '%floor plan%' AND LOWER(NAME) NOT LIKE '%floorplan%' ORDER BY media.s_show_order ASC

Error:

Query:

SELECT media.mid AS mid, media.name AS name, media.created AS created, properties.pid AS pid FROM media LEFT JOIN properties ON media.pid = properties.pid WHERE media.type = 'tpstill' AND media.format = 'jpeg' AND media.flag = 'approved' AND properties.pid = 1052477 AND height < 4000 AND (LOWER(name) LIKE '%floor plan%' OR LOWER(NAME) LIKE '%floorplan%') ORDER BY media.s_show_order, media.disporder ASC

Error:

Query:

SELECT properties.uid, properties.oid, properties.cid, properties.prop_show,
		CONCAT(
			properties.streetnum,' ',properties.address,
			IF(properties.unitnum,CONCAT(' Unit: ',properties.unitnum),'')
		) AS title,
		CONCAT(r1.firstname,' ',r1.lastname) AS r1name,
		CONCAT(r2.firstname,' ',r2.lastname) AS r2name,
		IF(DATE_ADD(properties.created, INTERVAL 5 DAY) < NOW(), 1, 0) AS demo,
		states.abbr AS sabbr,
		cities.name AS city,
		properties.streetnum AS streetnum,
		properties.address AS address,
		properties.zip AS zip,
		properties.price AS price,
		properties.type AS type,
		properties_mls.taxes AS taxes,
		properties_mls.gross_living_area AS sqft,
		properties_mls.bedrooms AS bedrooms,
		properties_mls.full_baths AS fullbaths,
		properties_mls.half_baths AS halfbaths,
		properties_mls.parking_spaces AS parking,
		properties_mls.garage_spaces AS garage,
		properties.w_domain AS w_domain,
		properties.mlsno AS mlsno,
		r1.uid AS r1uid,
		r2.uid AS r2uid,
		r1.oid AS r1oid,
		r2.oid AS r2oid,
		r1.cid AS r1cid,
		r2.cid AS r2cid,
		r1.email AS r1email,
		r2.email AS r2email,
		r1.phone AS r1phone,
		r1.phone_cell AS r1phone_cell,
		r2.phone_cell AS r2phone_cell,
		r2.phone AS r2phone,
		r1o.name AS r1oname,
		r1o.phone AS r1ophone,
		r1c.name_long AS r1cname,
		r1c.phone AS r1cphone,
		r2o.name AS r2oname,
		r1.website AS r1website,
		r2.website AS r2website,
		r1.about AS r1about,
		r2.about AS r2about,
		int_fp.url AS int_fp
	FROM properties
	LEFT JOIN cities ON (properties.city = cities.cid)
	LEFT JOIN regions ON (properties.region = regions.rid)
	LEFT JOIN states ON (properties.state = states.sid)
	LEFT JOIN users as r1 ON (properties.realtor1 = r1.uid)
	LEFT JOIN offices as r1o ON (properties.realty_office1 = r1o.oid)
	LEFT JOIN companies as r1c ON (properties.realty_company1 = r1c.cid)
	LEFT JOIN users as r2 ON (properties.realtor2 = r2.uid)
	LEFT JOIN offices as r2o ON (properties.realty_office2 = r2o.oid)
	LEFT JOIN properties_mls ON (properties.pid = properties_mls.pid)
	LEFT JOIN int_fp ON (properties.pid = int_fp.pid)
	WHERE properties.pid = '1052477' LIMIT 1

Error:

Query:

SELECT * FROM prop_show WHERE pid = '1052477' LIMIT 1

Error:

Query:

SELECT * FROM prop_show_features WHERE pid = 1052477 ORDER BY feature_id ASC

Error:

Query:

SELECT * FROM prop_show_disclaimers WHERE pid = 1052477 ORDER BY disclaimer_id ASC

Error:

Query:

SELECT * FROM prop_show_links WHERE pid = 1052477 ORDER BY link_id ASC

Error:

Query:

SELECT * FROM prop_show_features WHERE pid = 1052477 ORDER BY feature_id ASC

Error:

| ,

Details

  • Price: