SELECT p.* FROM simulator_constraints sku LEFT JOIN simulator s ON (sku.sku_number = s.sku_number) LEFT JOIN parcel p ON (s.grid_x = p.grid_x AND s.grid_y = p.grid_y) LEFT JOIN estate e ON (e.estate_id = s.estate_id) WHERE sku.sku_number = '129' AND e.owner_id = p.owner_id LIMIT 5;


Use governor linden.

useful data parcel_id, region_id, name, description, region_x, region_y, actual_square_meters, snapshot_id, 

SELECT p.parcel_id, s.region_id, s.access, s.estate_id, s.sku_number, p.name, p.description, p.region_x, p.region_y, p.actual_square_meters, p.category, p.snapshot_id FROM simulator_constraints sku LEFT JOIN simulator s ON (sku.sku_number = s.sku_number) LEFT JOIN parcel p ON (s.grid_x = p.grid_x AND s.grid_y = p.grid_y) WHERE sku.sku_number = '129' LIMIT 5;

last owner might be nice.

map_url = url to map tile.

ELECT "victorian" as theme, "http://map.url" AS map_url,  NOW() AS date_added, p.parcel_id, s.region_id, s.access, s.estate_id, s.sku_number, p.name, p.description, p.region_x, p.region_y, p.actual_square_meters, p.category, CONCAT("http://asset.agni.lindenlab.com/", p.snapshot_id, ".texture") AS snapshot_url FROM simulator_constraints sku LEFT JOIN simulator s ON (sku.sku_number = s.sku_number) LEFT JOIN parcel p ON (s.grid_x = p.grid_x AND s.grid_y = p.grid_y) WHERE sku.sku_number = '129' LIMIT 5;

Find out how we send new agents to language-specific areas.

SELECT DATE_SUB(NOW(), INTERVAL 5 MINUTE) AS date_locked, "victorian" as theme, "http://map.url" AS map_url,  NOW() AS date_added, p.parcel_id, s.region_id, s.access, s.estate_id, s.sku_number, p.name, p.description, p.region_x, p.region_y, p.actual_square_meters, p.billable_square_meters, p.category, CONCAT("http://asset.agni.lindenlab.com/", p.snapshot_id, ".texture") AS snapshot_url FROM simulator_constraints sku LEFT JOIN simulator s ON (sku.sku_number = s.sku_number) LEFT JOIN parcel p ON (s.grid_x = p.grid_x AND s.grid_y = p.grid_y) WHERE sku.sku_number = '129' LIMIT 5;

Should there be any zoning information?  Can this be part of the theme?

Investigate category to see if it can be reused as Premium Land.

simulator constraints to prevent changing category by new owner?

colo info might be useful to people because of lag.

SELECT DATE_SUB(NOW(), INTERVAL 5 MINUTE) AS date_locked, "some_agent_id" AS lock_owner, "victorian" as type, "http://map.url" AS map_url,  NOW() AS date_added, p.parcel_id, s.region_id, s.access, s.estate_id, s.sku_number, p.name, p.description, p.region_x, p.region_y, p.actual_square_meters, p.billable_square_meters, p.category, CONCAT("http://asset.agni.lindenlab.com/", p.snapshot_id, ".texture") AS snapshot_url FROM simulator_constraints sku LEFT JOIN simulator s ON (sku.sku_number = s.sku_number) LEFT JOIN parcel p ON (s.grid_x = p.grid_x AND s.grid_y = p.grid_y) WHERE sku.sku_number = '129' LIMIT 5;


Something to manage throttling, timing, and locking?  This database?