(mysql): INSERT INTO `audits` (ts_start,ts_end,audit_text,mls_system) VALUES (1501080737,0,'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration ','gjara');
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT DISTINCT(t1.MST_MLS_NUMBER) AS ID, t1.* from rets_to_gjara_property_resd t1 LEFT JOIN listing_headers t2 ON (t1.MST_MLS_NUMBER = t2.mls_no AND t2.mls_system = 'gjara') WHERE DATEDIFF(t1.sys_Last_Modified, FROM_UNIXTIME(t2.doa_ts)) > 1;
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT * from rets_to_gjara_property_resd where MST_MLS_NUMBER NOT IN (SELECT mls_no from listing_headers WHERE mls_system = 'gjara' AND class = 'RESIDENTIAL');
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT DISTINCT(t1.MST_MLS_NUMBER) AS ID, t1.* from rets_to_gjara_property_land t1 LEFT JOIN listing_headers t2 ON (t1.MST_MLS_NUMBER = t2.mls_no AND t2.mls_system = 'gjara') WHERE DATEDIFF(t1.sys_Last_Modified, FROM_UNIXTIME(t2.doa_ts)) > 1;
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT * from rets_to_gjara_property_land where MST_MLS_NUMBER NOT IN (SELECT mls_no from listing_headers WHERE mls_system = 'gjara' AND class = 'LAND');
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT DISTINCT(t1.MST_MLS_NUMBER) AS ID, t1.* from rets_to_gjara_property_cmml t1 LEFT JOIN listing_headers t2 ON (t1.MST_MLS_NUMBER = t2.mls_no AND t2.mls_system = 'gjara') WHERE DATEDIFF(t1.sys_Last_Modified, FROM_UNIXTIME(t2.doa_ts)) > 1;
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT * from rets_to_gjara_property_cmml where MST_MLS_NUMBER NOT IN (SELECT mls_no from listing_headers WHERE mls_system = 'gjara' AND class = 'COMMERCIAL');
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT DISTINCT(t1.MST_MLS_NUMBER) AS ID, t1.* from rets_to_gjara_property_mfam t1 LEFT JOIN listing_headers t2 ON (t1.MST_MLS_NUMBER = t2.mls_no AND t2.mls_system = 'gjara') WHERE DATEDIFF(t1.sys_Last_Modified, FROM_UNIXTIME(t2.doa_ts)) > 1;
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT * from rets_to_gjara_property_mfam where MST_MLS_NUMBER NOT IN (SELECT mls_no from listing_headers WHERE mls_system = 'gjara' AND class = 'MULTIFAMILY');
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_busoppt' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT DISTINCT(t1.MST_MLS_NUMBER) AS ID, t1.* from rets_to_gjara_property_busoppt t1 LEFT JOIN listing_headers t2 ON (t1.MST_MLS_NUMBER = t2.mls_no AND t2.mls_system = 'gjara') WHERE DATEDIFF(t1.sys_Last_Modified, FROM_UNIXTIME(t2.doa_ts)) > 1;
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - New Record Checks RETS/GJARA - Class property_busoppt' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT * from rets_to_gjara_property_busoppt where MST_MLS_NUMBER NOT IN (SELECT mls_no from listing_headers WHERE mls_system = 'gjara' AND class = 'MULTIFAMILY');
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - New Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_commlse' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT DISTINCT(t1.MST_MLS_NUMBER) AS ID, t1.* from rets_to_gjara_property_commlse t1 LEFT JOIN listing_headers t2 ON (t1.MST_MLS_NUMBER = t2.mls_no AND t2.mls_system = 'gjara') WHERE DATEDIFF(t1.sys_Last_Modified, FROM_UNIXTIME(t2.doa_ts)) > 1;
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - New Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_commlse 07:52:17 - New Record Checks RETS/GJARA - Class property_commlse' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT * from rets_to_gjara_property_commlse where MST_MLS_NUMBER NOT IN (SELECT mls_no from listing_headers WHERE mls_system = 'gjara' AND class = 'LEASE');
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - New Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_commlse 07:52:17 - New Record Checks RETS/GJARA - Class property_commlse 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class agent' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT DISTINCT(t1.rets_agt_id) AS ID, t1.* from rets_to_gjara_agent t1 LEFT JOIN listing_agents t2 ON (t1.rets_agt_id = t2.listing_agent_id AND t2.mls_system = 'gjara') WHERE DATEDIFF(t1.DA_MODIFIED, FROM_UNIXTIME(t2.update_ts)) > 1;
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - New Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_commlse 07:52:17 - New Record Checks RETS/GJARA - Class property_commlse 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class agent 07:52:18 - New Record Checks RETS/GJARA - Class agent' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT * from rets_to_gjara_agent where rets_agt_id NOT IN (SELECT listing_agent_id from listing_agents WHERE mls_system = 'gjara');
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - New Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_commlse 07:52:17 - New Record Checks RETS/GJARA - Class property_commlse 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class agent 07:52:18 - New Record Checks RETS/GJARA - Class agent 07:52:18 - Out Of Date Record Checks RETS/GJARA - Class office' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT DISTINCT(t1.DO_OFFICE_ID) AS ID, t1.* from rets_to_gjara_office t1 LEFT JOIN listing_agents t2 ON (t1.DO_OFFICE_ID = t2.listing_office_id AND t2.mls_system = 'gjara') WHERE DATEDIFF(t1.DO_MODIFIED, FROM_UNIXTIME(t2.update_ts)) > 1;
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1002' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1002,org_short_name = 'APPRAISAL ASSOCIATES OF COLORADO',org_name = 'APPRAISAL ASSOCIATES OF COLORADO',org_address = '134 N 6TH ST',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '134 N 6TH ST',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702567019,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424393568,board_name = 'gjara' WHERE listing_office_id = '1002' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1021' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1021,org_short_name = 'E B REALTY LLC',org_name = 'E B REALTY LLC',org_address = 'PO BOX 1472',org_city = 'PALISADE',org_state = 'CO',org_zip = 81526,org_mail_address = 'PO BOX 1472',org_mail_city = 'PALISADE',org_mail_state = 'CO',org_mail_zip = 81526,org_phone1 = 9704641000,org_phone2 = 0,org_email = 'EB@EB-Realty.com',org_url = 'www.AskforElizabeth.com',update_ts = 1424397564,board_name = 'gjara' WHERE listing_office_id = '1021' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1027' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1027,org_short_name = 'PLATINUM PARTNERS REALTY, LLC',org_name = 'PLATINUM PARTNERS REALTY, LLC',org_address = '660 ROOD AVE STE 100',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '660 ROOD AVE STE 100',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702570500,org_phone2 = 9702549814,org_email = 'info@platinumgj.com',org_url = 'www.PlatinumGJ.com',update_ts = 1424418162,board_name = 'gjara' WHERE listing_office_id = '1027' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '104' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 104,org_short_name = 'HEATH & CO REALTORS/MB',org_name = 'HEATH & CO REALTORS/MB',org_address = '605 25 RD #100',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '605 25 RD #100',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702433376,org_phone2 = 9702456495,org_email = '',org_url = 'Heathrealtors.com',update_ts = 1424399532,board_name = 'gjara' WHERE listing_office_id = '104' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '105' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 105,org_short_name = 'PURE COUNTRY',org_name = 'PURE COUNTRY',org_address = '1048 INDEPENDENT AVE #A107',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '1048 INDEPENDENT AVE #A107',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702442920,org_phone2 = 9702567135,org_email = 'purecountryrealestate@gmail.com',org_url = '',update_ts = 1427247961,board_name = 'gjara' WHERE listing_office_id = '105' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '107' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 107,org_short_name = 'UNITED COUNTRY REALQUEST REALTY',org_name = 'UNITED COUNTRY REALQUEST REALTY',org_address = '2518 MONUMENT RD UNIT B',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81507,org_mail_address = '2518 MONUMENT RD UNIT B',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81507,org_phone1 = 9702569700,org_phone2 = 9702561766,org_email = 'realquest@unitedcountry.com',org_url = 'www.realquestrealty.net',update_ts = 1424481897,board_name = 'gjara' WHERE listing_office_id = '107' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1087' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1087,org_short_name = 'STEVENS REAL ESTATE SERVICES',org_name = 'STEVENS REAL ESTATE SERVICES',org_address = '115 N 5TH STREET STE 240',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '115 N 5TH STREET STE 240',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702434888,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424481263,board_name = 'gjara' WHERE listing_office_id = '1087' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '108' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 108,org_short_name = 'WAKEFIELD REAL ESTATE, LLC',org_name = 'WAKEFIELD REAL ESTATE, LLC',org_address = 'PO BOX 2206',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81502,org_mail_address = 'PO BOX 2206',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81502,org_phone1 = 9702505724,org_phone2 = 0,org_email = 'SMASCARE@BRESNAN.NET',org_url = '',update_ts = 1424482202,board_name = 'gjara' WHERE listing_office_id = '108' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1092' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1092,org_short_name = 'CHESNICK REALTY, LLC',org_name = 'CHESNICK REALTY, LLC',org_address = '137 N PEACH ST',org_city = 'FRUITA',org_state = 'CO',org_zip = 81521,org_mail_address = '137 N PEACH ST',org_mail_city = 'FRUITA',org_mail_state = 'CO',org_mail_zip = 81521,org_phone1 = 9708588238,org_phone2 = 9708588266,org_email = 'lori@chesnickrealtyllc.com',org_url = 'www.chesnickrealtyllc.com',update_ts = 1424395003,board_name = 'gjara' WHERE listing_office_id = '1092' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1116' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1116,org_short_name = 'CROSS COUNTRY REALTY, LLC',org_name = 'CROSS COUNTRY REALTY, LLC',org_address = '497 VALLEJO DRIVE',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81507,org_mail_address = '497 VALLEJO DRIVE',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81507,org_phone1 = 9702013094,org_phone2 = 0,org_email = 'cacross@hotmail.com',org_url = '',update_ts = 1452589758,board_name = 'gjara' WHERE listing_office_id = '1116' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1129' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1129,org_short_name = 'DKT REALTY,INC/MB',org_name = 'DKT REALTY,INC/MB',org_address = '605 25 RD #100',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '605 25 RD #100',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702433376,org_phone2 = 9702456495,org_email = '',org_url = '',update_ts = 1424397071,board_name = 'gjara' WHERE listing_office_id = '1129' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1132' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1132,org_short_name = 'INDEPENDENCE REALTY',org_name = 'INDEPENDENCE REALTY',org_address = '2518 MONUMENT ROAD #B',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81507,org_mail_address = '2518 MONUMENT ROAD #B',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81507,org_phone1 = 9702419200,org_phone2 = 0,org_email = 'info.independencegj@gmail.com',org_url = 'Independencegj.com',update_ts = 1424400131,board_name = 'gjara' WHERE listing_office_id = '1132' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '117' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 117,org_short_name = 'COLORADO WEST HOMES, LLC',org_name = 'COLORADO WEST HOMES, LLC',org_address = '',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702412559,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1352334277,board_name = 'gjara' WHERE listing_office_id = '117' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '121' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 121,org_short_name = 'GEORGE DUNHAM REAL ESTATE,INC',org_name = 'GEORGE DUNHAM REAL ESTATE,INC',org_address = '608 26.5 RD',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '608 26.5 RD',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9702489812,org_phone2 = 9702483555,org_email = 'george@georgedunham.com',org_url = 'www.georgedunham.com',update_ts = 1424398464,board_name = 'gjara' WHERE listing_office_id = '121' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '124' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 124,org_short_name = 'HANSEN & ASSOC/MB',org_name = 'HANSEN & ASSOC/MB',org_address = '605 25 RD #100',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '605 25 RD #100',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702433376,org_phone2 = 9702456495,org_email = '',org_url = '',update_ts = 1464133672,board_name = 'gjara' WHERE listing_office_id = '124' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '125' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 125,org_short_name = 'DOYLE & ASSOC',org_name = 'DOYLE & ASSOC',org_address = '2472 PATTERSON RD #4',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '2472 PATTERSON RD #4',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702571622,org_phone2 = 9702571423,org_email = 'erika@erikadoyle.com',org_url = 'www.ErikaDoyle.com',update_ts = 1424397343,board_name = 'gjara' WHERE listing_office_id = '125' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '133' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 133,org_short_name = 'COLE & COMPANY REALTY, INC',org_name = 'COLE & COMPANY REALTY, INC',org_address = '235 N 7TH ST',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '235 N 7TH ST',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702437711,org_phone2 = 9702484605,org_email = '',org_url = '',update_ts = 1424395470,board_name = 'gjara' WHERE listing_office_id = '133' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '138' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 138,org_short_name = 'BRAY/COMMERCIAL',org_name = 'BRAY/COMMERCIAL',org_address = '244 N 7TH ST',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '244 N 7TH ST',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702412909,org_phone2 = 9702416223,org_email = 'braycommercial@gjcommercial.com',org_url = '',update_ts = 1450832341,board_name = 'gjara' WHERE listing_office_id = '138' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '13' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 13,org_short_name = 'HILL & HOMES, LLC',org_name = 'HILL & HOMES, LLC',org_address = '1204 N 7TH ST STE 200',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '1204 N 7TH ST STE 200',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702417653,org_phone2 = 9702427304,org_email = 'ben@hillandhomes.com',org_url = 'http://www.hillandhomes.com',update_ts = 1424399927,board_name = 'gjara' WHERE listing_office_id = '13' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1424' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1424,org_short_name = 'COLDWELL BANKER COMMERCIAL PRIME PROPERTIES',org_name = 'COLDWELL BANKER COMMERCIAL PRIME PROPERTIES',org_address = '2499 HWY 6&50 STE B',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '2499 HWY 6&50 STE B',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702437375,org_phone2 = 9702452901,org_email = '',org_url = '',update_ts = 1451622229,board_name = 'gjara' WHERE listing_office_id = '1424' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1432' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1432,org_short_name = 'DURANGO COUNTRY R.E. SERVICE',org_name = 'DURANGO COUNTRY R.E. SERVICE',org_address = 'PO BOX 4168',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81502,org_mail_address = 'PO BOX 4168',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81502,org_phone1 = 9707598458,org_phone2 = 9703147536,org_email = '',org_url = '',update_ts = 1424397504,board_name = 'gjara' WHERE listing_office_id = '1432' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '154' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 154,org_short_name = 'RE/MAX OF BOULDER INC',org_name = 'RE/MAX OF BOULDER INC',org_address = '2425 CANYON #200',org_city = 'BOULDER',org_state = 'CO',org_zip = 80302,org_mail_address = '2425 CANYON #200',org_mail_city = 'BOULDER',org_mail_state = 'CO',org_mail_zip = 80302,org_phone1 = 3034497000,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1438638539,board_name = 'gjara' WHERE listing_office_id = '154' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '158' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 158,org_short_name = 'HOME BUYERS MARKETING,II',org_name = 'HOME BUYERS MARKETING,II',org_address = '59 LAKECREST DR',org_city = 'BRECKENRIDGE',org_state = 'CO',org_zip = 80424,org_mail_address = '59 LAKECREST DR',org_mail_city = 'BRECKENRIDGE',org_mail_state = 'CO',org_mail_zip = 80424,org_phone1 = 9704859973,org_phone2 = 0,org_email = 'george@georgemolloy.com',org_url = 'www.georgemolloy.com',update_ts = 1424484627,board_name = 'gjara' WHERE listing_office_id = '158' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '162' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 162,org_short_name = 'COUNTRY REALTY',org_name = 'COUNTRY REALTY',org_address = 'P O BOX 214',org_city = 'MESA',org_state = 'CO',org_zip = 81643,org_mail_address = 'P O BOX 214',org_mail_city = 'MESA',org_mail_state = 'CO',org_mail_zip = 81643,org_phone1 = 9702501000,org_phone2 = '',org_email = '',org_url = '',update_ts = 1260968400,board_name = 'gjara' WHERE listing_office_id = '162' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '16' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 16,org_short_name = 'PROMARK REALTY/MB',org_name = 'PROMARK REALTY/MB',org_address = '605 25 RD #100',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '605 25 RD #100',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702433376,org_phone2 = 9702456495,org_email = 'mm@mbgj.com',org_url = 'MikeMcGinnisRealtor.com',update_ts = 1455152902,board_name = 'gjara' WHERE listing_office_id = '16' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '172' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 172,org_short_name = 'HIGH DESERT APPRAISAL',org_name = 'HIGH DESERT APPRAISAL',org_address = '607 STAN DR',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81504,org_mail_address = '607 STAN DR',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81504,org_phone1 = 9702107883,org_phone2 = 9704343994,org_email = '',org_url = '',update_ts = 1464040888,board_name = 'gjara' WHERE listing_office_id = '172' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '173' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 173,org_short_name = 'B & B APPRAISAL INC.',org_name = 'B & B APPRAISAL INC.',org_address = '743 HORIZON COURT #372',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '743 HORIZON COURT #372',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9702430250,org_phone2 = 9702431721,org_email = '',org_url = '',update_ts = 1449033873,board_name = 'gjara' WHERE listing_office_id = '173' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '175' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 175,org_short_name = 'ADM APPRAISALS',org_name = 'ADM APPRAISALS',org_address = '855 LANAI DR',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '855 LANAI DR',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9702416905,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424393358,board_name = 'gjara' WHERE listing_office_id = '175' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1781' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1781,org_short_name = 'STUDT REALTY, LLC/MB',org_name = 'STUDT REALTY, LLC/MB',org_address = '2518 MONUMENT RD',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81507,org_mail_address = '2518 MONUMENT RD',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81507,org_phone1 = 9704245000,org_phone2 = 9704245001,org_email = '',org_url = '',update_ts = 1424481313,board_name = 'gjara' WHERE listing_office_id = '1781' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '17' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 17,org_short_name = 'RE/MAX TWO RIVERS REALTY,INC.',org_name = 'RE/MAX TWO RIVERS REALTY,INC.',org_address = '125 GRAND AVE',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '125 GRAND AVE',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702413939,org_phone2 = 9702420955,org_email = 'frontdesk@tworiversrealtyinc.com',org_url = 'www.rtrrealestate.com',update_ts = 1424418492,board_name = 'gjara' WHERE listing_office_id = '17' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '187' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 187,org_short_name = 'SHUMAN PETERSON APPRAISALS,LLC',org_name = 'SHUMAN PETERSON APPRAISALS,LLC',org_address = '1000 E 9TH ST STE 2',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '1000 E 9TH ST STE 2',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702429190,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424480940,board_name = 'gjara' WHERE listing_office_id = '187' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1911' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1911,org_short_name = 'GRAYSTONE GROUP',org_name = 'GRAYSTONE GROUP',org_address = '751 HORIZON CT #115',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '751 HORIZON CT #115',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9708124051,org_phone2 = 3035838404,org_email = 'lwood@ggre.us',org_url = 'www.ggre.us',update_ts = 1464758149,board_name = 'gjara' WHERE listing_office_id = '1911' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1912' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1912,org_short_name = 'MARILYN HAMMAR ALL ABOUT REAL EST',org_name = 'MARILYN HAMMAR ALL ABOUT REAL EST',org_address = '616 VIEW POINT DRIVE',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '616 VIEW POINT DRIVE',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9702607988,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424416853,board_name = 'gjara' WHERE listing_office_id = '1912' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '191' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 191,org_short_name = 'ANB BANK',org_name = 'ANB BANK',org_address = '3033 E. FIRST AVENUE',org_city = 'DENVER',org_state = 'CO',org_zip = 80206,org_mail_address = '3033 E. FIRST AVENUE',org_mail_city = 'DENVER',org_mail_state = 'CO',org_mail_zip = 80206,org_phone1 = 3033945066,org_phone2 = 3033945397,org_email = '',org_url = '',update_ts = 1424484474,board_name = 'gjara' WHERE listing_office_id = '191' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1935' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1935,org_short_name = 'THE HOME TEAM REALTY',org_name = 'THE HOME TEAM REALTY',org_address = '751 HORIZON CT STE 106',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '751 HORIZON CT STE 106',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9706390036,org_phone2 = 0,org_email = 'tammytway@gmail.com',org_url = '',update_ts = 1471488505,board_name = 'gjara' WHERE listing_office_id = '1935' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1961' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1961,org_short_name = 'GRAND JUNCTION REAL ESTATE SERVICES',org_name = 'GRAND JUNCTION REAL ESTATE SERVICES',org_address = '263 W PARKVIEW DR',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81503,org_mail_address = '263 W PARKVIEW DR',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81503,org_phone1 = 9702458006,org_phone2 = 9702419476,org_email = '',org_url = '',update_ts = 1424398721,board_name = 'gjara' WHERE listing_office_id = '1961' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1973' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1973,org_short_name = 'MOUNTAIN WEST APPRAISAL INC.',org_name = 'MOUNTAIN WEST APPRAISAL INC.',org_address = '562 HWY 133',org_city = 'CARBONDALE',org_state = 'CO',org_zip = 81623,org_mail_address = '562 HWY 133',org_mail_city = 'CARBONDALE',org_mail_state = 'CO',org_mail_zip = 81623,org_phone1 = 7193954842,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424485396,board_name = 'gjara' WHERE listing_office_id = '1973' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1983' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1983,org_short_name = 'PRESTIGE REALTY, LLC',org_name = 'PRESTIGE REALTY, LLC',org_address = '2533 W PINYON AVE',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '2533 W PINYON AVE',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702501675,org_phone2 = 0,org_email = 'sherigriego247@gmail.com',org_url = 'www.prestigerealtygj.com',update_ts = 1459392771,board_name = 'gjara' WHERE listing_office_id = '1983' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1993' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1993,org_short_name = 'ZIONS BANK',org_name = 'ZIONS BANK',org_address = '2394 PATTERSON RD',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '2394 PATTERSON RD',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 8013161636,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424486444,board_name = 'gjara' WHERE listing_office_id = '1993' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '1996' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 1996,org_short_name = 'MASON REAL ESTATE INC',org_name = 'MASON REAL ESTATE INC',org_address = '263 MAIN ST',org_city = 'DELTA',org_state = 'CO',org_zip = 81416,org_mail_address = '263 MAIN ST',org_mail_city = 'DELTA',org_mail_state = 'CO',org_mail_zip = 81416,org_phone1 = 9708749968,org_phone2 = 9708749976,org_email = 'brianmason@qwestoffice.net',org_url = 'www.masonrecolorado.com',update_ts = 1424485322,board_name = 'gjara' WHERE listing_office_id = '1996' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2003' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2003,org_short_name = 'KEY REALTY GJ LLC',org_name = 'KEY REALTY GJ LLC',org_address = '607 S 7TH STREET',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '607 S 7TH STREET',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702423747,org_phone2 = 9702423750,org_email = '',org_url = '',update_ts = 1467350065,board_name = 'gjara' WHERE listing_office_id = '2003' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2024' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2024,org_short_name = 'ROBERTS & MICHAELS',org_name = 'ROBERTS & MICHAELS',org_address = '151 CLUBHOUSE DR',org_city = 'NEW CASTLE',org_state = 'CO',org_zip = 81647,org_mail_address = '151 CLUBHOUSE DR',org_mail_city = 'NEW CASTLE',org_mail_state = 'CO',org_mail_zip = 81647,org_phone1 = 9709840404,org_phone2 = 8552074499,org_email = '',org_url = 'www.robertsandmichaels.com',update_ts = 1424485729,board_name = 'gjara' WHERE listing_office_id = '2024' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2029' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2029,org_short_name = 'NEW IMAGE REALTY, LLC',org_name = 'NEW IMAGE REALTY, LLC',org_address = '1000 N 9TH ST STE 40',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '1000 N 9TH ST STE 40',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702342179,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1426722279,board_name = 'gjara' WHERE listing_office_id = '2029' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2030' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2030,org_short_name = 'REDLANDS HOME REALTY',org_name = 'REDLANDS HOME REALTY',org_address = '1208 MAIN ST',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '1208 MAIN ST',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702108281,org_phone2 = 0,org_email = 'loricurtis19@gmail.com',org_url = '',update_ts = 1456054369,board_name = 'gjara' WHERE listing_office_id = '2030' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2039' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2039,org_short_name = 'COLDWELL BANKER DEVONSHIRE',org_name = 'COLDWELL BANKER DEVONSHIRE',org_address = '2020 LOWE STREET STE 201',org_city = 'FORT COLLINS',org_state = 'CO',org_zip = 80525,org_mail_address = '2020 LOWE STREET STE 201',org_mail_city = 'FORT COLLINS',org_mail_state = 'CO',org_mail_zip = 80525,org_phone1 = 9702232300,org_phone2 = 9702677360,org_email = '',org_url = '',update_ts = 1424483366,board_name = 'gjara' WHERE listing_office_id = '2039' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2040' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2040,org_short_name = 'FORSTERS PROPERTY MANAGEMENT, LLC',org_name = 'FORSTERS PROPERTY MANAGEMENT, LLC',org_address = '1225 N 23RD STREET STE 206',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '1225 N 23RD STREET STE 206',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702343300,org_phone2 = 9704337224,org_email = '',org_url = '',update_ts = 1471414929,board_name = 'gjara' WHERE listing_office_id = '2040' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2043' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2043,org_short_name = 'JESSICA E & ASSOCIATES',org_name = 'JESSICA E & ASSOCIATES',org_address = '599 RAMBLING ROAD',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81507,org_mail_address = '599 RAMBLING ROAD',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81507,org_phone1 = 9702019567,org_phone2 = 0,org_email = 'JessicaE4u@gmail.com',org_url = 'http://www.JessicaE.com',update_ts = 1453769830,board_name = 'gjara' WHERE listing_office_id = '2043' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2045' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2045,org_short_name = 'STELLAR REALTY',org_name = 'STELLAR REALTY',org_address = '1119 N 1ST STREET STE I',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '1119 N 1ST STREET STE I',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 8007469464,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1444968235,board_name = 'gjara' WHERE listing_office_id = '2045' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2046' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2046,org_short_name = 'RED COMPASS REALTY',org_name = 'RED COMPASS REALTY',org_address = '636 WALNUT',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '636 WALNUT',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702457237,org_phone2 = 0,org_email = 'jackson@callredcompass.com',org_url = 'www.callredcompass.com',update_ts = 1462409625,board_name = 'gjara' WHERE listing_office_id = '2046' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2048' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2048,org_short_name = 'COLLATERAL ANALYTICS',org_name = 'COLLATERAL ANALYTICS',org_address = '2905 WESTCORP BLVD STE 119',org_city = 'HUNTSVILLE',org_state = 'AL',org_zip = 35805,org_mail_address = '2905 WESTCORP BLVD STE 119',org_mail_city = 'HUNTSVILLE',org_mail_state = 'AL',org_mail_zip = 35805,org_phone1 = 2564284545,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424483283,board_name = 'gjara' WHERE listing_office_id = '2048' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2049' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2049,org_short_name = 'MERCURY ALLIANCE MOUNTAIN PROPERTIES',org_name = 'MERCURY ALLIANCE MOUNTAIN PROPERTIES',org_address = '0371 SOUTHSIDE DRIVE STE 102',org_city = 'BASALT',org_state = 'CO',org_zip = 81621,org_mail_address = '0371 SOUTHSIDE DRIVE STE 102',org_mail_city = 'BASALT',org_mail_state = 'CO',org_mail_zip = 81621,org_phone1 = 9709273794,org_phone2 = 9709273816,org_email = 'tom.dimercurio@themercuryalliance.com',org_url = '',update_ts = 1436916463,board_name = 'gjara' WHERE listing_office_id = '2049' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '204' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 204,org_short_name = 'CORELOGIC',org_name = 'CORELOGIC',org_address = '1736 K 3/4 RD',org_city = 'FRUITA',org_state = 'CO',org_zip = 81521,org_mail_address = '1736 K 3/4 RD',org_mail_city = 'FRUITA',org_mail_state = 'CO',org_mail_zip = 81521,org_phone1 = 9708582315,org_phone2 = 9708587514,org_email = 'jake1179@acsol.net',org_url = '',update_ts = 1469679907,board_name = 'gjara' WHERE listing_office_id = '204' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2051' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2051,org_short_name = 'HOMETOWN REALTY OF GRAND JUNCTION',org_name = 'HOMETOWN REALTY OF GRAND JUNCTION',org_address = '1141 N 25TH ST UNIT C STE 3',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '1141 N 25TH ST UNIT C STE 3',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702703573,org_phone2 = 8665937853,org_email = '',org_url = '',update_ts = 1452576622,board_name = 'gjara' WHERE listing_office_id = '2051' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2053' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2053,org_short_name = 'COMMERCIAL VALUATION CONSULTANTS,INC',org_name = 'COMMERCIAL VALUATION CONSULTANTS,INC',org_address = '5395 W 25TH AVENUE',org_city = 'EDGEWATER',org_state = 'CO',org_zip = 80214,org_mail_address = '5395 W 25TH AVENUE',org_mail_city = 'EDGEWATER',org_mail_state = 'CO',org_mail_zip = 80214,org_phone1 = 3034201052,org_phone2 = 0,org_email = 'jean@cvcappraisal.com',org_url = '',update_ts = 1424484040,board_name = 'gjara' WHERE listing_office_id = '2053' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2065' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2065,org_short_name = 'TELLURIDE SOTHEBY'S INTL REALTY',org_name = 'TELLURIDE SOTHEBY'S INTL REALTY',org_address = '565 MOUNTAIN VILLAGE BLVD #101',org_city = 'MOUNTAIN VILLAGE',org_state = 'CO',org_zip = 81435,org_mail_address = '565 MOUNTAIN VILLAGE BLVD #101',org_mail_city = 'MOUNTAIN VILLAGE',org_mail_state = 'CO',org_mail_zip = 81435,org_phone1 = 9707291404,org_phone2 = 0,org_email = 'peggy.raible@sothebysrealty.com',org_url = 'www.telluridesothebysrealty.com',update_ts = 1424485954,board_name = 'gjara' WHERE listing_office_id = '2065' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2067' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2067,org_short_name = 'ACTIVE REALTY',org_name = 'ACTIVE REALTY',org_address = '612 1/2 E INDIAN CREEK DR',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '612 1/2 E INDIAN CREEK DR',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9707124129,org_phone2 = 0,org_email = 'obrien.realty@yahoo.com',org_url = 'www.obriensiterealty.com',update_ts = 1472107155,board_name = 'gjara' WHERE listing_office_id = '2067' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2075' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2075,org_short_name = 'SHOREWOOD REAL ESTATE',org_name = 'SHOREWOOD REAL ESTATE',org_address = '201 COLUMBINE STREET #301',org_city = 'DENVER',org_state = 'CO',org_zip = 80206,org_mail_address = '201 COLUMBINE STREET #301',org_mail_city = 'DENVER',org_mail_state = 'CO',org_mail_zip = 80206,org_phone1 = 3037804974,org_phone2 = 3037565967,org_email = '',org_url = '',update_ts = 1461986731,board_name = 'gjara' WHERE listing_office_id = '2075' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2080' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2080,org_short_name = 'TRI-STAR REALTY',org_name = 'TRI-STAR REALTY',org_address = '33832 DIANA DRIVE',org_city = 'DANA POINT',org_state = 'CA',org_zip = 92629,org_mail_address = '33832 DIANA DRIVE',org_mail_city = 'DANA POINT',org_mail_state = 'CA',org_mail_zip = 92629,org_phone1 = 9492767325,org_phone2 = 8007217314,org_email = '',org_url = '',update_ts = 1424486353,board_name = 'gjara' WHERE listing_office_id = '2080' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2093' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2093,org_short_name = 'MOSSY OAK PROPERTIES COLO MOUNTAIN REALTY',org_name = 'MOSSY OAK PROPERTIES COLO MOUNTAIN REALTY',org_address = '18151 KISER CREEK ROAD',org_city = 'CEDAREDGE',org_state = 'CO',org_zip = 81413,org_mail_address = '18151 KISER CREEK ROAD',org_mail_city = 'CEDAREDGE',org_mail_state = 'CO',org_mail_zip = 81413,org_phone1 = 9709862955,org_phone2 = 0,org_email = 'rob@coloradocountrybroker.com',org_url = 'www.coloradocountrybroker.com',update_ts = 1456818668,board_name = 'gjara' WHERE listing_office_id = '2093' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2096' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2096,org_short_name = 'Owners.com',org_name = 'Owners.com',org_address = '1225 W WASHINGTON ST #300',org_city = 'TEMPE',org_state = 'AZ',org_zip = 85281,org_mail_address = '1225 W WASHINGTON ST #300',org_mail_city = 'TEMPE',org_mail_state = 'AZ',org_mail_zip = 85281,org_phone1 = 4805863136,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1437688361,board_name = 'gjara' WHERE listing_office_id = '2096' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2098' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2098,org_short_name = 'Owners.com',org_name = 'Owners.com',org_address = '5323 MILLENIA LAKES BLVD STE 300',org_city = 'ORLANDO',org_state = 'FL',org_zip = 32839,org_mail_address = '5323 MILLENIA LAKES BLVD STE 300',org_mail_city = 'ORLANDO',org_mail_state = 'FL',org_mail_zip = 32839,org_phone1 = 8888763372,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1437688471,board_name = 'gjara' WHERE listing_office_id = '2098' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2099' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2099,org_short_name = 'DIAMOND REALTY & PROPERTY, LLC',org_name = 'DIAMOND REALTY & PROPERTY, LLC',org_address = '751 HORIZON COURT #121',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '751 HORIZON COURT #121',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9707788714,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1471680047,board_name = 'gjara' WHERE listing_office_id = '2099' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2100' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2100,org_short_name = 'YOUR CASTLE REAL ESTATE',org_name = 'YOUR CASTLE REAL ESTATE',org_address = '1777 S HARRISON ST #1100',org_city = 'DENVER',org_state = 'CO',org_zip = 80210,org_mail_address = '1777 S HARRISON ST #1100',org_mail_city = 'DENVER',org_mail_state = 'CO',org_mail_zip = 80210,org_phone1 = 3039624272,org_phone2 = 3039624278,org_email = '',org_url = '',update_ts = 1471680100,board_name = 'gjara' WHERE listing_office_id = '2100' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2110' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2110,org_short_name = 'CONNECT PROPERTIES INC DBA HEALTH CONNECT PROPERTI',org_name = 'CONNECT PROPERTIES INC DBA HEALTH CONNECT PROPERTI',org_address = '3400 E BAYAUD AVENUE STE 240',org_city = 'DENVER',org_state = 'CO',org_zip = 80209,org_mail_address = '3400 E BAYAUD AVENUE STE 240',org_mail_city = 'DENVER',org_mail_state = 'CO',org_mail_zip = 80209,org_phone1 = 3038301444,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1469502431,board_name = 'gjara' WHERE listing_office_id = '2110' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2115' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2115,org_short_name = 'LEGACY APPRAISALS',org_name = 'LEGACY APPRAISALS',org_address = '660 BRADFORD AVE',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81504,org_mail_address = '660 BRADFORD AVE',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81504,org_phone1 = 9706284230,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1471680138,board_name = 'gjara' WHERE listing_office_id = '2115' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2120' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2120,org_short_name = 'ROCKSTAR REAL ESTATE, LLC',org_name = 'ROCKSTAR REAL ESTATE, LLC',org_address = '574 NORTHGATE DR UNIT#1',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '574 NORTHGATE DR UNIT#1',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9706284777,org_phone2 = 9706284779,org_email = 'rockstar.infonow@gmail.com',org_url = 'www.gjrockstar.com',update_ts = 1452237944,board_name = 'gjara' WHERE listing_office_id = '2120' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2122' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2122,org_short_name = 'HOMESTEAD REALTY, LLC',org_name = 'HOMESTEAD REALTY, LLC',org_address = '2710 PATTERSON RD STE B',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '2710 PATTERSON RD STE B',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9706281948,org_phone2 = 9706281953,org_email = 'homesteadgj@gmail.com',org_url = 'HomesteadRealtyGJ.com',update_ts = 1461220576,board_name = 'gjara' WHERE listing_office_id = '2122' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2131' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2131,org_short_name = 'RIVER CITY REAL ESTATE, LLC',org_name = 'RIVER CITY REAL ESTATE, LLC',org_address = '362 MAIN ST STE B',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '362 MAIN ST STE B',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702488501,org_phone2 = 0,org_email = '',org_url = 'www.rivercitygj.com',update_ts = 1462422430,board_name = 'gjara' WHERE listing_office_id = '2131' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2132' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2132,org_short_name = 'AMORE' REALTY, LLC',org_name = 'AMORE' REALTY, LLC',org_address = '711 MAIN ST',org_city = 'CARBONDALE',org_state = 'CO',org_zip = 81623,org_mail_address = '711 MAIN ST',org_mail_city = 'CARBONDALE',org_mail_state = 'CO',org_mail_zip = 81623,org_phone1 = 9709635177,org_phone2 = 9709635178,org_email = '',org_url = '',update_ts = 1454399230,board_name = 'gjara' WHERE listing_office_id = '2132' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2134' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2134,org_short_name = 'MT. GARFIELD REALTY, LLC',org_name = 'MT. GARFIELD REALTY, LLC',org_address = '2493 HWY 6&50 #20',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '2493 HWY 6&50 #20',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9706445959,org_phone2 = 9706445832,org_email = 'www.mtgarfieldrealty.com',org_url = 'www.mtgarfieldrealty.com',update_ts = 1457584571,board_name = 'gjara' WHERE listing_office_id = '2134' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2143' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2143,org_short_name = 'AMERICAN LAND REALTY, LLC',org_name = 'AMERICAN LAND REALTY, LLC',org_address = '370 S GRAND MESA DRIVE',org_city = 'CEDAREDGE',org_state = 'CO',org_zip = 81413,org_mail_address = '370 S GRAND MESA DRIVE',org_mail_city = 'CEDAREDGE',org_mail_state = 'CO',org_mail_zip = 81413,org_phone1 = 9708567000,org_phone2 = 9708567002,org_email = 'ninaedge@kaycee.net',org_url = 'www.americanlandrealty.com',update_ts = 1456902250,board_name = 'gjara' WHERE listing_office_id = '2143' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2145' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2145,org_short_name = 'WESTERN SLOPE REALTY/MB',org_name = 'WESTERN SLOPE REALTY/MB',org_address = '605 25 RD #100',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '605 25 RD #100',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702433376,org_phone2 = 0,org_email = 'MindySellsGJ@Gmail.com',org_url = 'MetroBrokersGJ.com',update_ts = 1461982582,board_name = 'gjara' WHERE listing_office_id = '2145' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2149' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2149,org_short_name = 'PALLADIUM PROPERTIES',org_name = 'PALLADIUM PROPERTIES',org_address = '620 E HYMAN AVENUE STE 103',org_city = 'ASPEN',org_state = 'CO',org_zip = 81611,org_mail_address = '620 E HYMAN AVENUE STE 103',org_mail_city = 'ASPEN',org_mail_state = 'CO',org_mail_zip = 81611,org_phone1 = 9709258088,org_phone2 = 9709252648,org_email = 'carly@palladiumaspen.com',org_url = '',update_ts = 1469078484,board_name = 'gjara' WHERE listing_office_id = '2149' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '2190' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 2190,org_short_name = 'CTMe CONTRACTS',org_name = 'CTMe CONTRACTS',org_address = '2743 CROSSORADS BLVD',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '2743 CROSSORADS BLVD',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 3032331918,org_phone2 = 7202080663,org_email = '',org_url = '',update_ts = 1469663904,board_name = 'gjara' WHERE listing_office_id = '2190' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '235' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 235,org_short_name = 'PROPERTY INTERLINK, LLC',org_name = 'PROPERTY INTERLINK, LLC',org_address = 'PO BOX 4484',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81502,org_mail_address = 'PO BOX 4484',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81502,org_phone1 = 9702436808,org_phone2 = 9707971040,org_email = '',org_url = '',update_ts = 1433811325,board_name = 'gjara' WHERE listing_office_id = '235' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '25' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 25,org_short_name = 'REAL ESTATE WEST',org_name = 'REAL ESTATE WEST',org_address = '2699 PATTERSON RD',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '2699 PATTERSON RD',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702437100,org_phone2 = 9702434332,org_email = 'realestatewestcolorado@gmail.com',org_url = 'www.realestatewestonline.com',update_ts = 1435880286,board_name = 'gjara' WHERE listing_office_id = '25' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '263' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 263,org_short_name = 'LISA ROBERTS',org_name = 'LISA ROBERTS',org_address = '2392 MARIPOSA DR',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81507,org_mail_address = '2392 MARIPOSA DR',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81507,org_phone1 = 9702432040,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424485818,board_name = 'gjara' WHERE listing_office_id = '263' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '273' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 273,org_short_name = 'AMERICAN AgCREDIT, FLCA',org_name = 'AMERICAN AgCREDIT, FLCA',org_address = 'AMERICAN AgCREDIT, FLCA',org_city = 'SANTA ROSA',org_state = 'CA',org_zip = 95402,org_mail_address = 'AMERICAN AgCREDIT, FLCA',org_mail_city = 'SANTA ROSA',org_mail_state = 'CA',org_mail_zip = 95402,org_phone1 = 9702495274,org_phone2 = 9702493456,org_email = '',org_url = '',update_ts = 1424482891,board_name = 'gjara' WHERE listing_office_id = '273' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '287' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 287,org_short_name = 'MESA COUNTY ASSESSOR',org_name = 'MESA COUNTY ASSESSOR',org_address = 'MESA COUNTY COURT HOUSE',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81502,org_mail_address = 'MESA COUNTY COURT HOUSE',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81502,org_phone1 = 9702441713,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1427430285,board_name = 'gjara' WHERE listing_office_id = '287' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '289' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 289,org_short_name = 'GRAND JUNCTION AREA REALTOR ASSOC',org_name = 'GRAND JUNCTION AREA REALTOR ASSOC',org_address = '2743 CROSSROADS BLVD',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '2743 CROSSROADS BLVD',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9702433322,org_phone2 = 9702419324,org_email = 'pat@gjrealtors.org',org_url = '',update_ts = 1432353791,board_name = 'gjara' WHERE listing_office_id = '289' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '32' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 32,org_short_name = 'VALLEY BROKERS',org_name = 'VALLEY BROKERS',org_address = '751 HORIZON CT STE 247',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '751 HORIZON CT STE 247',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9702410664,org_phone2 = 9702454833,org_email = 'homes@caroltompkins.com',org_url = 'www.caroltompkins.com',update_ts = 1469494960,board_name = 'gjara' WHERE listing_office_id = '32' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '36' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 36,org_short_name = 'KELLER WILLIAMS COLORADO WEST REALTY',org_name = 'KELLER WILLIAMS COLORADO WEST REALTY',org_address = '2474 PATTERSON RD STE 100',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '2474 PATTERSON RD STE 100',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702569100,org_phone2 = 9702569101,org_email = 'klrw765@kw.com',org_url = 'www.kwgrandjunction.com',update_ts = 1465268841,board_name = 'gjara' WHERE listing_office_id = '36' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '373' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 373,org_short_name = 'THE NESHEIM GROUP GJ',org_name = 'THE NESHEIM GROUP GJ',org_address = '469 BISMARCK ST',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81504,org_mail_address = '469 BISMARCK ST',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81504,org_phone1 = 9706400149,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424481593,board_name = 'gjara' WHERE listing_office_id = '373' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '378' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 378,org_short_name = 'CRAVEN REALTY/MB',org_name = 'CRAVEN REALTY/MB',org_address = '507 SOUTH BROADWAY #B',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81507,org_mail_address = '507 SOUTH BROADWAY #B',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81507,org_phone1 = 9702433376,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1441860084,board_name = 'gjara' WHERE listing_office_id = '378' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '37' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 37,org_short_name = 'INVEST IN COLO WEST, INC',org_name = 'INVEST IN COLO WEST, INC',org_address = 'PO BOX 1889',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81502,org_mail_address = 'PO BOX 1889',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81502,org_phone1 = 9702438843,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424400177,board_name = 'gjara' WHERE listing_office_id = '37' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '382' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 382,org_short_name = 'FRUIT & WINE REAL ESTATE',org_name = 'FRUIT & WINE REAL ESTATE',org_address = 'PO BOX 1330',org_city = 'PALISADE',org_state = 'CO',org_zip = 81526,org_mail_address = 'PO BOX 1330',org_mail_city = 'PALISADE',org_mail_state = 'CO',org_mail_zip = 81526,org_phone1 = 9704645100,org_phone2 = 9704644699,org_email = 'tlcraig@fruitandwine.net',org_url = 'www.fruitandwine.net',update_ts = 1455083676,board_name = 'gjara' WHERE listing_office_id = '382' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '389' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 389,org_short_name = 'HUMMEL REAL ESTATE',org_name = 'HUMMEL REAL ESTATE',org_address = '316 MAIN ST',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '316 MAIN ST',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9703147490,org_phone2 = 0,org_email = 'ronda@hummelrealestate.com',org_url = 'www.HummelRealEstate.com',update_ts = 1453364525,board_name = 'gjara' WHERE listing_office_id = '389' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '390' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 390,org_short_name = 'CHERRY CREEK PROPERTIES',org_name = 'CHERRY CREEK PROPERTIES',org_address = '804 GRAND AVE',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '804 GRAND AVE',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9706445002,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424394956,board_name = 'gjara' WHERE listing_office_id = '390' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '397' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 397,org_short_name = 'SANDSTONE REAL EST, LLC',org_name = 'SANDSTONE REAL EST, LLC',org_address = '2145 VISTA CASCADA CT',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81507,org_mail_address = '2145 VISTA CASCADA CT',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81507,org_phone1 = 9702417222,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424480558,board_name = 'gjara' WHERE listing_office_id = '397' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '403' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 403,org_short_name = 'WESTERN EXPOSURES REALTY LLC',org_name = 'WESTERN EXPOSURES REALTY LLC',org_address = '1033 W MARKET ST',org_city = 'MEEKER',org_state = 'CO',org_zip = 81641,org_mail_address = '1033 W MARKET ST',org_mail_city = 'MEEKER',org_mail_state = 'CO',org_mail_zip = 81641,org_phone1 = 9708785877,org_phone2 = 9708785955,org_email = '',org_url = '',update_ts = 1424482321,board_name = 'gjara' WHERE listing_office_id = '403' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '40' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 40,org_short_name = 'JAN GARBER & ASSOC/MB',org_name = 'JAN GARBER & ASSOC/MB',org_address = '605 25 RD #100',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '605 25 RD #100',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702433376,org_phone2 = 9702456495,org_email = '',org_url = '',update_ts = 1424400230,board_name = 'gjara' WHERE listing_office_id = '40' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '419' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 419,org_short_name = 'KARIE HILL O'CONNOR & CO LLC./MB',org_name = 'KARIE HILL O'CONNOR & CO LLC./MB',org_address = '605 25 RD #100',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '605 25 RD #100',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702433376,org_phone2 = 9702456495,org_email = '',org_url = 'Kariehilloconnor.com',update_ts = 1426807353,board_name = 'gjara' WHERE listing_office_id = '419' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '423' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 423,org_short_name = 'BACK TO BASICS REALTY',org_name = 'BACK TO BASICS REALTY',org_address = '624 PEACE DR',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81504,org_mail_address = '624 PEACE DR',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81504,org_phone1 = 9702610280,org_phone2 = 0,org_email = 'homesbythecase@yahoo.com',org_url = 'www.backtobasicsrealtygj.com',update_ts = 1458354150,board_name = 'gjara' WHERE listing_office_id = '423' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '42' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 42,org_short_name = 'RE/MAX 4000, INC',org_name = 'RE/MAX 4000, INC',org_address = '120 W PARK DR STE 200',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '120 W PARK DR STE 200',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702414000,org_phone2 = 9702414015,org_email = '',org_url = '',update_ts = 1424418430,board_name = 'gjara' WHERE listing_office_id = '42' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '44' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 44,org_short_name = 'APEX REALTY,LLC/MB',org_name = 'APEX REALTY,LLC/MB',org_address = '605 25 RD #100',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '605 25 RD #100',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702433376,org_phone2 = 9702456495,org_email = '',org_url = '',update_ts = 1424393504,board_name = 'gjara' WHERE listing_office_id = '44' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '46' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 46,org_short_name = 'KISSNER REAL ESTATE/ INVESTMENT BROKERAGE, INC',org_name = 'KISSNER REAL ESTATE/ INVESTMENT BROKERAGE, INC',org_address = 'PO BOX 3957',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81502,org_mail_address = 'PO BOX 3957',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81502,org_phone1 = 9702412801,org_phone2 = 9702418312,org_email = 'n.kissner7@gmail.com',org_url = '',update_ts = 1433052682,board_name = 'gjara' WHERE listing_office_id = '46' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '4' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 4,org_short_name = 'DOLE & ASSOCIATES',org_name = 'DOLE & ASSOCIATES',org_address = '1097 HWY 65',org_city = 'MESA',org_state = 'CO',org_zip = 81643,org_mail_address = '1097 HWY 65',org_mail_city = 'MESA',org_mail_state = 'CO',org_mail_zip = 81643,org_phone1 = 9702602536,org_phone2 = 9702685400,org_email = 'recolorado@aol.com',org_url = '',update_ts = 1424397217,board_name = 'gjara' WHERE listing_office_id = '4' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '50' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 50,org_short_name = 'BW FINE PROPERTIES',org_name = 'BW FINE PROPERTIES',org_address = 'PO BOX 4366',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81502,org_mail_address = 'PO BOX 4366',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81502,org_phone1 = 9709861839,org_phone2 = 9702551371,org_email = '',org_url = '',update_ts = 1424394798,board_name = 'gjara' WHERE listing_office_id = '50' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '54' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 54,org_short_name = 'ASSOCIATED BROKERS & CONSULTANTS',org_name = 'ASSOCIATED BROKERS & CONSULTANTS',org_address = '759 HORIZON DR #B',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '759 HORIZON DR #B',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9702637250,org_phone2 = 9702637350,org_email = 'Buz@BuyGrandJunction.com',org_url = 'www.BuyGrandJunction.com',update_ts = 1424394122,board_name = 'gjara' WHERE listing_office_id = '54' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '55' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 55,org_short_name = '1ST CHOICE REAL ESTATE CO, INC',org_name = '1ST CHOICE REAL ESTATE CO, INC',org_address = '220 RED SAND RD',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81507,org_mail_address = '220 RED SAND RD',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81507,org_phone1 = 9702458181,org_phone2 = 9702458383,org_email = '',org_url = '',update_ts = 1445648223,board_name = 'gjara' WHERE listing_office_id = '55' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '5' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 5,org_short_name = 'BRAY REAL ESTATE',org_name = 'BRAY REAL ESTATE',org_address = '1015 N 7TH ST',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '1015 N 7TH ST',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702423647,org_phone2 = 9702420436,org_email = 'info@brayandco.com',org_url = 'www.brayandco.com',update_ts = 1427768206,board_name = 'gjara' WHERE listing_office_id = '5' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '60' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 60,org_short_name = 'EVENSON INC',org_name = 'EVENSON INC',org_address = '2935 F 1/4 RD',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81504,org_mail_address = '2935 F 1/4 RD',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81504,org_phone1 = 9704341940,org_phone2 = 9702550336,org_email = 'sonofeven@bresnan.net',org_url = '',update_ts = 1424397688,board_name = 'gjara' WHERE listing_office_id = '60' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '64' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 64,org_short_name = 'JOE HICKS REAL ESTATE',org_name = 'JOE HICKS REAL ESTATE',org_address = '1203 COLORADO AVE',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '1203 COLORADO AVE',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702422075,org_phone2 = 9702425757,org_email = 'joehicks@acsol.net',org_url = '',update_ts = 1431139969,board_name = 'gjara' WHERE listing_office_id = '64' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '77' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 77,org_short_name = 'THE REAL ESTATE SHOPPE, INC.',org_name = 'THE REAL ESTATE SHOPPE, INC.',org_address = 'PO BOX 235',org_city = 'FRUITA',org_state = 'CO',org_zip = 81521,org_mail_address = 'PO BOX 235',org_mail_city = 'FRUITA',org_mail_state = 'CO',org_mail_zip = 81521,org_phone1 = 9708583994,org_phone2 = 9708124328,org_email = 'nancylharrington@gmail.com',org_url = 'www.therealestateshoppe.com',update_ts = 1463025498,board_name = 'gjara' WHERE listing_office_id = '77' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '78' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 78,org_short_name = 'SIERRA REALTY, LLC',org_name = 'SIERRA REALTY, LLC',org_address = '1487 N 1/2 ROAD',org_city = 'LOMA',org_state = 'CO',org_zip = 81524,org_mail_address = '1487 N 1/2 ROAD',org_mail_city = 'LOMA',org_mail_state = 'CO',org_mail_zip = 81524,org_phone1 = 9702561353,org_phone2 = 0,org_email = 'bjfuoco@yahoo.com',org_url = 'www.sierrarealtygj.com',update_ts = 1432112663,board_name = 'gjara' WHERE listing_office_id = '78' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '79' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 79,org_short_name = 'SILVER TRUMPET REALTY INC',org_name = 'SILVER TRUMPET REALTY INC',org_address = '1465 17 1/2 RD',org_city = 'FRUITA',org_state = 'CO',org_zip = 81521,org_mail_address = '1465 17 1/2 RD',org_mail_city = 'FRUITA',org_mail_state = 'CO',org_mail_zip = 81521,org_phone1 = 9708581848,org_phone2 = 9708581842,org_email = 'cricketdonoho15@gmail.com',org_url = 'silvertrumpetrealty.com',update_ts = 1451369175,board_name = 'gjara' WHERE listing_office_id = '79' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '7' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 7,org_short_name = 'MONUMENT REALTY, LLC',org_name = 'MONUMENT REALTY, LLC',org_address = '2648 H 3/4 ROAD',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81506,org_mail_address = '2648 H 3/4 ROAD',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81506,org_phone1 = 9702434890,org_phone2 = 0,org_email = '',org_url = 'www.MonumentCountry.com',update_ts = 1424417267,board_name = 'gjara' WHERE listing_office_id = '7' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '80' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 80,org_short_name = 'FORD REALTY/MB',org_name = 'FORD REALTY/MB',org_address = '605 25 RD #100',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '605 25 RD #100',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702433376,org_phone2 = 9702456495,org_email = '',org_url = '',update_ts = 1424397892,board_name = 'gjara' WHERE listing_office_id = '80' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '81' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 81,org_short_name = 'WEICHERT, REALTORS - HEIDEN HOMES',org_name = 'WEICHERT, REALTORS - HEIDEN HOMES',org_address = '735 ROOD AVE',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '735 ROOD AVE',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9702457777,org_phone2 = 9702457790,org_email = 'homes@heidenhomes.com',org_url = 'www.heidenhomes.com',update_ts = 1470197866,board_name = 'gjara' WHERE listing_office_id = '81' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '83' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 83,org_short_name = 'OMEGA REALTY & ASSOC, INC.',org_name = 'OMEGA REALTY & ASSOC, INC.',org_address = '1048 INDEPENDENT AVE STE A201',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '1048 INDEPENDENT AVE STE A201',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702457571,org_phone2 = 9702457555,org_email = '',org_url = '',update_ts = 1470695496,board_name = 'gjara' WHERE listing_office_id = '83' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '85' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 85,org_short_name = 'DOT REALTY CO, BARRETT & ASSOCIATES LTD',org_name = 'DOT REALTY CO, BARRETT & ASSOCIATES LTD',org_address = '319 25 1/2 RD',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81507,org_mail_address = '319 25 1/2 RD',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81507,org_phone1 = 9702603616,org_phone2 = 9702433608,org_email = 'pattibarrett@dot-re.com',org_url = 'www.dotrecolorado.com',update_ts = 1439462536,board_name = 'gjara' WHERE listing_office_id = '85' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '87' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 87,org_short_name = 'DALE REALTY, INC',org_name = 'DALE REALTY, INC',org_address = '220 S 13TH ST',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81501,org_mail_address = '220 S 13TH ST',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81501,org_phone1 = 9705230303,org_phone2 = 9705237613,org_email = '',org_url = '',update_ts = 1424396898,board_name = 'gjara' WHERE listing_office_id = '87' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '909' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 909,org_short_name = 'CHERYL & CO REAL ESTATE, LLC',org_name = 'CHERYL & CO REAL ESTATE, LLC',org_address = '125 W FIFTH ST',org_city = 'RIFLE',org_state = 'CO',org_zip = 81650,org_mail_address = '125 W FIFTH ST',org_mail_city = 'RIFLE',org_mail_state = 'CO',org_mail_zip = 81650,org_phone1 = 9706254441,org_phone2 = 9706254447,org_email = 'dallas@cherylchandler.com',org_url = 'www.CherylCoRealEstate.com',update_ts = 1459984233,board_name = 'gjara' WHERE listing_office_id = '909' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '928' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 928,org_short_name = 'WEAVER HOMES & LAND',org_name = 'WEAVER HOMES & LAND',org_address = '2975 KICKAPOO CT',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81503,org_mail_address = '2975 KICKAPOO CT',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81503,org_phone1 = 9702345133,org_phone2 = 9702541205,org_email = 'bobweaver@bresnan.net',org_url = '',update_ts = 1424482249,board_name = 'gjara' WHERE listing_office_id = '928' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '931' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 931,org_short_name = 'OUT WEST REALTY Gj',org_name = 'OUT WEST REALTY Gj',org_address = '777 R RD',org_city = 'MACK',org_state = 'CO',org_zip = 81525,org_mail_address = '777 R RD',org_mail_city = 'MACK',org_mail_state = 'CO',org_mail_zip = 81525,org_phone1 = 9702501652,org_phone2 = 0,org_email = 'Pj@PattijoPollard.com',org_url = 'http://OutWestRealtyGj.com',update_ts = 1424417829,board_name = 'gjara' WHERE listing_office_id = '931' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '969' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 969,org_short_name = 'LANDSAFE APPRAISALS',org_name = 'LANDSAFE APPRAISALS',org_address = '11343 W 28TH AVENUE',org_city = 'LAKEWOOD',org_state = 'CO',org_zip = 80215,org_mail_address = '11343 W 28TH AVENUE',org_mail_city = 'LAKEWOOD',org_mail_state = 'CO',org_mail_zip = 80215,org_phone1 = 3034958375,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1457574002,board_name = 'gjara' WHERE listing_office_id = '969' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '97' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 97,org_short_name = 'BENCHMARK REAL ESTATE',org_name = 'BENCHMARK REAL ESTATE',org_address = 'PO BOX 2557',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81502,org_mail_address = 'PO BOX 2557',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81502,org_phone1 = 9702412076,org_phone2 = 0,org_email = '',org_url = '',update_ts = 1424394388,board_name = 'gjara' WHERE listing_office_id = '97' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT update_ts FROM organizations WHERE listing_office_id = '9' AND mls_system = 'gjara';
Error (0):

(mysql): UPDATE organizations SET branch_id = 9,org_short_name = 'COLDWELL BANKER DISTINCTIVE PROPERTIES',org_name = 'COLDWELL BANKER DISTINCTIVE PROPERTIES',org_address = '2499 HWY 6&50',org_city = 'GRAND JUNCTION',org_state = 'CO',org_zip = 81505,org_mail_address = '2499 HWY 6&50',org_mail_city = 'GRAND JUNCTION',org_mail_state = 'CO',org_mail_zip = 81505,org_phone1 = 9702430456,org_phone2 = 9702432896,org_email = 'info@gjhomes.com',org_url = 'www.gjhomes.com',update_ts = 1424395395,board_name = 'gjara' WHERE listing_office_id = '9' AND mls_system = 'gjara';
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - New Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_commlse 07:52:17 - New Record Checks RETS/GJARA - Class property_commlse 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class agent 07:52:18 - New Record Checks RETS/GJARA - Class agent 07:52:18 - Out Of Date Record Checks RETS/GJARA - Class office 07:52:42 - New Record Checks RETS/GJARA - Class office' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT * from rets_to_gjara_office where DO_OFFICE_ID NOT IN (SELECT listing_office_id from organizations WHERE mls_system = 'gjara');
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - New Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_commlse 07:52:17 - New Record Checks RETS/GJARA - Class property_commlse 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class agent 07:52:18 - New Record Checks RETS/GJARA - Class agent 07:52:18 - Out Of Date Record Checks RETS/GJARA - Class office 07:52:42 - New Record Checks RETS/GJARA - Class office 07:52:42 - Cleaning up RETS/GJARA Data' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT t1.listing_header_id AS id FROM listing_headers t1, rets_to_gjara_property_resd t2 WHERE t1.rets_class = 'RESD' AND t1.mls_system = 'gjara' AND t1.mls_no NOT LIKE 'oe%' AND t1.flexiss_status != 'oe' AND t1.mls_no = t2.MST_MLS_NUMBER
Error (0):

(mysql): SELECT listing_header_id AS id FROM listing_headers WHERE listing_header_id NOT IN () AND rets_class = 'RESD' AND mls_system = 'gjara' AND mls_no NOT LIKE 'oe%' AND flexiss_status != 'oe'
Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND rets_class = 'RESD' AND mls_system = 'gjara'' at line 4

(mysql): SELECT t1.listing_header_id AS id FROM listing_headers t1, rets_to_gjara_property_land t2 WHERE t1.rets_class = 'LAND' AND t1.mls_system = 'gjara' AND t1.mls_no NOT LIKE 'oe%' AND t1.flexiss_status != 'oe' AND t1.mls_no = t2.MST_MLS_NUMBER
Error (0):

(mysql): SELECT listing_header_id AS id FROM listing_headers WHERE listing_header_id NOT IN () AND rets_class = 'LAND' AND mls_system = 'gjara' AND mls_no NOT LIKE 'oe%' AND flexiss_status != 'oe'
Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND rets_class = 'LAND' AND mls_system = 'gjara'' at line 4

(mysql): SELECT t1.listing_header_id AS id FROM listing_headers t1, rets_to_gjara_property_cmml t2 WHERE t1.rets_class = 'CMML' AND t1.mls_system = 'gjara' AND t1.mls_no NOT LIKE 'oe%' AND t1.flexiss_status != 'oe' AND t1.mls_no = t2.MST_MLS_NUMBER
Error (0):

(mysql): SELECT listing_header_id AS id FROM listing_headers WHERE listing_header_id NOT IN () AND rets_class = 'CMML' AND mls_system = 'gjara' AND mls_no NOT LIKE 'oe%' AND flexiss_status != 'oe'
Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND rets_class = 'CMML' AND mls_system = 'gjara'' at line 4

(mysql): SELECT t1.listing_header_id AS id FROM listing_headers t1, rets_to_gjara_property_mfam t2 WHERE t1.rets_class = 'MFAM' AND t1.mls_system = 'gjara' AND t1.mls_no NOT LIKE 'oe%' AND t1.flexiss_status != 'oe' AND t1.mls_no = t2.MST_MLS_NUMBER
Error (0):

(mysql): SELECT listing_header_id AS id FROM listing_headers WHERE listing_header_id NOT IN () AND rets_class = 'MFAM' AND mls_system = 'gjara' AND mls_no NOT LIKE 'oe%' AND flexiss_status != 'oe'
Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND rets_class = 'MFAM' AND mls_system = 'gjara'' at line 4

(mysql): SELECT t1.listing_header_id AS id FROM listing_headers t1, rets_to_gjara_property_busoppt t2 WHERE t1.rets_class = 'BUSOPPT' AND t1.mls_system = 'gjara' AND t1.mls_no NOT LIKE 'oe%' AND t1.flexiss_status != 'oe' AND t1.mls_no = t2.MST_MLS_NUMBER
Error (0):

(mysql): SELECT listing_header_id AS id FROM listing_headers WHERE listing_header_id NOT IN () AND rets_class = 'BUSOPPT' AND mls_system = 'gjara' AND mls_no NOT LIKE 'oe%' AND flexiss_status != 'oe'
Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND rets_class = 'BUSOPPT' AND mls_system = 'gja' at line 4

(mysql): SELECT t1.listing_header_id AS id FROM listing_headers t1, rets_to_gjara_property_commlse t2 WHERE t1.rets_class = 'COMMLSE' AND t1.mls_system = 'gjara' AND t1.mls_no NOT LIKE 'oe%' AND t1.flexiss_status != 'oe' AND t1.mls_no = t2.MST_MLS_NUMBER
Error (0):

(mysql): SELECT listing_header_id AS id FROM listing_headers WHERE listing_header_id NOT IN () AND rets_class = 'COMMLSE' AND mls_system = 'gjara' AND mls_no NOT LIKE 'oe%' AND flexiss_status != 'oe'
Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND rets_class = 'COMMLSE' AND mls_system = 'gja' at line 4

(mysql): SELECT t1.listing_header_id AS id FROM listing_headers t1, rets_to_gjara_agent t2 WHERE t1.rets_class = 'Agent' AND t1.mls_system = 'gjara' AND t1.mls_no NOT LIKE 'oe%' AND t1.flexiss_status != 'oe' AND t1.mls_no = t2.MST_MLS_NUMBER
Error (1054): Unknown column 't2.MST_MLS_NUMBER' in 'where clause'

(mysql): SELECT listing_header_id AS id FROM listing_headers WHERE listing_header_id NOT IN () AND rets_class = 'Agent' AND mls_system = 'gjara' AND mls_no NOT LIKE 'oe%' AND flexiss_status != 'oe'
Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND rets_class = 'Agent' AND mls_system = 'gjara' at line 4

(mysql): SELECT t1.listing_header_id AS id FROM listing_headers t1, rets_to_gjara_office t2 WHERE t1.rets_class = 'Office' AND t1.mls_system = 'gjara' AND t1.mls_no NOT LIKE 'oe%' AND t1.flexiss_status != 'oe' AND t1.mls_no = t2.MST_MLS_NUMBER
Error (1054): Unknown column 't2.MST_MLS_NUMBER' in 'where clause'

(mysql): SELECT listing_header_id AS id FROM listing_headers WHERE listing_header_id NOT IN () AND rets_class = 'Office' AND mls_system = 'gjara' AND mls_no NOT LIKE 'oe%' AND flexiss_status != 'oe'
Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND rets_class = 'Office' AND mls_system = 'gjar' at line 4

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - New Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_commlse 07:52:17 - New Record Checks RETS/GJARA - Class property_commlse 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class agent 07:52:18 - New Record Checks RETS/GJARA - Class agent 07:52:18 - Out Of Date Record Checks RETS/GJARA - Class office 07:52:42 - New Record Checks RETS/GJARA - Class office 07:52:42 - Cleaning up RETS/GJARA Data 07:52:42 - Updating RETS/GJARA Geo-Coding' WHERE `audit_id` = 29540;
Error (0):

(mysql): SELECT listing_header_id,street_number,street_direction,street_name,city,state,zip FROM listing_headers WHERE (geocoding_status = 'N' OR geocoding_status = 'R') AND mls_system = 'gjara' LIMIT 1000;
Error (0):

(mysql): SELECT audit_text FROM `audits` WHERE `audit_id` = 29540;
Error (0):

(mysql): UPDATE `audits` SET ts_end = 1501080762, audit_text = 'Jul 26, 2017 07:52:17 - Starting RETS/GJARA Migration 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_resd 07:52:17 - New Record Checks RETS/GJARA - Class property_resd 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_land 07:52:17 - New Record Checks RETS/GJARA - Class property_land 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_cmml 07:52:17 - New Record Checks RETS/GJARA - Class property_cmml 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_mfam 07:52:17 - New Record Checks RETS/GJARA - Class property_mfam 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - New Record Checks RETS/GJARA - Class property_busoppt 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class property_commlse 07:52:17 - New Record Checks RETS/GJARA - Class property_commlse 07:52:17 - Out Of Date Record Checks RETS/GJARA - Class agent 07:52:18 - New Record Checks RETS/GJARA - Class agent 07:52:18 - Out Of Date Record Checks RETS/GJARA - Class office 07:52:42 - New Record Checks RETS/GJARA - Class office 07:52:42 - Cleaning up RETS/GJARA Data 07:52:42 - Updating RETS/GJARA Geo-Coding Jul 26, 2017 07:52:42 - Ending RETS/GJARA Migration' WHERE `audit_id` = 29540;
Error (0):