object(Zend_Db_Adapter_Mysqli_Exception)#258 (7) { ["_chainedException:protected"]=> NULL ["message:protected"]=> string(38) "LIMIT argument offset=-10 is not valid" ["string:private"]=> string(0) "" ["code:protected"]=> int(0) ["file:protected"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Mysqli.php" ["line:protected"]=> int(455) ["trace:private"]=> array(9) { [0]=> array(6) { ["file"]=> string(59) "/home/ucl/public_html/app/zend-framework/Zend/Db/Select.php" ["line"]=> int(1044) ["function"]=> string(5) "limit" ["class"]=> string(22) "Zend_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> string(0) "" [1]=> int(10) [2]=> int(-10) } } [1]=> array(6) { ["file"]=> string(59) "/home/ucl/public_html/app/zend-framework/Zend/Db/Select.php" ["line"]=> int(1116) ["function"]=> string(18) "_renderLimitoffset" ["class"]=> string(14) "Zend_Db_Select" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [2]=> array(6) { ["file"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Abstract.php" ["line"]=> int(394) ["function"]=> string(10) "__toString" ["class"]=> string(14) "Zend_Db_Select" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [3]=> array(6) { ["file"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Abstract.php" ["line"]=> int(617) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Db_Select)#260 (3) { ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#259 (1) { ["_expression:protected"]=> string(87) "COUNT(*), MIN(PlanNumber), MIN(BasePrice), MAX(BasePrice), MIN(BaseSqft), MAX(BaseSqft)" } [2]=> NULL } } ["from"]=> array(4) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } ["SalesOfficeAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(18) "SalesOfficeAddress" ["joinCondition"]=> string(216) "Subdivision.SubdivisionNumber = SalesOfficeAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SalesOfficeAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SalesOfficeAddress.CorporateBuilderNumber" } ["SubAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(10) "SubAddress" ["joinCondition"]=> string(192) "Subdivision.SubdivisionNumber = SubAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SubAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SubAddress.CorporateBuilderNumber" } ["Plan"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(4) "Plan" ["joinCondition"]=> string(174) "Subdivision.SubdivisionNumber = Plan.SubdivisionNumber AND Subdivision.BuilderNumber = Plan.BuilderNumber AND Subdivision.CorporateBuilderNumber = Plan.CorporateBuilderNumber" } } ["where"]=> array(70) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [2]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [3]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [4]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [5]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [6]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [7]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [14]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [15]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [16]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [17]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [18]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [19]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [20]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [21]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [22]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [23]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [24]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [25]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [28]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [29]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [31]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [32]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [33]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [34]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [35]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [36]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [37]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [38]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [39]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [40]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [41]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [45]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [46]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [47]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [48]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [49]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [50]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [51]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [52]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [53]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [54]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [55]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [56]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [57]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [58]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [59]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [60]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [61]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [62]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [63]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [64]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [65]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [66]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [67]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [68]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [69]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" } ["group"]=> array(3) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(15) "SubdivisionName" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(-10) ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } [1]=> array(0) { } } } [4]=> array(6) { ["file"]=> string(70) "/home/ucl/public_html/app/application/controllers/MarketController.php" ["line"]=> int(128) ["function"]=> string(8) "fetchAll" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Select)#260 (3) { ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#259 (1) { ["_expression:protected"]=> string(87) "COUNT(*), MIN(PlanNumber), MIN(BasePrice), MAX(BasePrice), MIN(BaseSqft), MAX(BaseSqft)" } [2]=> NULL } } ["from"]=> array(4) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } ["SalesOfficeAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(18) "SalesOfficeAddress" ["joinCondition"]=> string(216) "Subdivision.SubdivisionNumber = SalesOfficeAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SalesOfficeAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SalesOfficeAddress.CorporateBuilderNumber" } ["SubAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(10) "SubAddress" ["joinCondition"]=> string(192) "Subdivision.SubdivisionNumber = SubAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SubAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SubAddress.CorporateBuilderNumber" } ["Plan"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(4) "Plan" ["joinCondition"]=> string(174) "Subdivision.SubdivisionNumber = Plan.SubdivisionNumber AND Subdivision.BuilderNumber = Plan.BuilderNumber AND Subdivision.CorporateBuilderNumber = Plan.CorporateBuilderNumber" } } ["where"]=> array(70) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [2]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [3]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [4]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [5]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [6]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [7]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [14]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [15]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [16]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [17]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [18]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [19]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [20]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [21]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [22]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [23]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [24]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [25]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [28]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [29]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [31]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [32]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [33]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [34]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [35]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [36]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [37]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [38]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [39]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [40]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [41]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [45]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [46]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [47]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [48]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [49]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [50]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [51]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [52]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [53]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [54]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [55]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [56]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [57]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [58]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [59]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [60]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [61]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [62]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [63]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [64]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [65]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [66]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [67]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [68]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [69]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" } ["group"]=> array(3) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(15) "SubdivisionName" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(-10) ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [5]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Action.php" ["line"]=> int(502) ["function"]=> string(14) "listingsAction" ["class"]=> string(16) "MarketController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [6]=> array(6) { ["file"]=> string(80) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(293) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(14) "listingsAction" } } [7]=> array(6) { ["file"]=> string(66) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Front.php" ["line"]=> int(914) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#20 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(11) "/robots.txt" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(11) "/robots.txt" ["_params:protected"]=> array(6) { ["page"]=> string(10) "robots.txt" ["controller"]=> string(6) "market" ["action"]=> string(8) "listings" ["sort"]=> string(4) "name" ["market"]=> string(7) "orlando" ["error_handler"]=> object(ArrayObject)#289 (3) { ["exception"]=> object(Zend_Db_Adapter_Mysqli_Exception)#258 (7) { ["_chainedException:protected"]=> NULL ["message:protected"]=> string(38) "LIMIT argument offset=-10 is not valid" ["string:private"]=> string(0) "" ["code:protected"]=> int(0) ["file:protected"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Mysqli.php" ["line:protected"]=> int(455) ["trace:private"]=> array(9) { [0]=> array(6) { ["file"]=> string(59) "/home/ucl/public_html/app/zend-framework/Zend/Db/Select.php" ["line"]=> int(1044) ["function"]=> string(5) "limit" ["class"]=> string(22) "Zend_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> string(0) "" [1]=> int(10) [2]=> int(-10) } } [1]=> array(6) { ["file"]=> string(59) "/home/ucl/public_html/app/zend-framework/Zend/Db/Select.php" ["line"]=> int(1116) ["function"]=> string(18) "_renderLimitoffset" ["class"]=> string(14) "Zend_Db_Select" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [2]=> array(6) { ["file"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Abstract.php" ["line"]=> int(394) ["function"]=> string(10) "__toString" ["class"]=> string(14) "Zend_Db_Select" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [3]=> array(6) { ["file"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Abstract.php" ["line"]=> int(617) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Db_Select)#260 (3) { ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#259 (1) { ["_expression:protected"]=> string(87) "COUNT(*), MIN(PlanNumber), MIN(BasePrice), MAX(BasePrice), MIN(BaseSqft), MAX(BaseSqft)" } [2]=> NULL } } ["from"]=> array(4) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } ["SalesOfficeAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(18) "SalesOfficeAddress" ["joinCondition"]=> string(216) "Subdivision.SubdivisionNumber = SalesOfficeAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SalesOfficeAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SalesOfficeAddress.CorporateBuilderNumber" } ["SubAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(10) "SubAddress" ["joinCondition"]=> string(192) "Subdivision.SubdivisionNumber = SubAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SubAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SubAddress.CorporateBuilderNumber" } ["Plan"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(4) "Plan" ["joinCondition"]=> string(174) "Subdivision.SubdivisionNumber = Plan.SubdivisionNumber AND Subdivision.BuilderNumber = Plan.BuilderNumber AND Subdivision.CorporateBuilderNumber = Plan.CorporateBuilderNumber" } } ["where"]=> array(70) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [2]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [3]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [4]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [5]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [6]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [7]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [14]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [15]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [16]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [17]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [18]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [19]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [20]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [21]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [22]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [23]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [24]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [25]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [28]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [29]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [31]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [32]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [33]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [34]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [35]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [36]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [37]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [38]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [39]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [40]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [41]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [45]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [46]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [47]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [48]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [49]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [50]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [51]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [52]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [53]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [54]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [55]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [56]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [57]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [58]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [59]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [60]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [61]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [62]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [63]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [64]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [65]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [66]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [67]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [68]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [69]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" } ["group"]=> array(3) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(15) "SubdivisionName" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(-10) ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } [1]=> array(0) { } } } [4]=> array(6) { ["file"]=> string(70) "/home/ucl/public_html/app/application/controllers/MarketController.php" ["line"]=> int(128) ["function"]=> string(8) "fetchAll" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Select)#260 (3) { ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#259 (1) { ["_expression:protected"]=> string(87) "COUNT(*), MIN(PlanNumber), MIN(BasePrice), MAX(BasePrice), MIN(BaseSqft), MAX(BaseSqft)" } [2]=> NULL } } ["from"]=> array(4) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } ["SalesOfficeAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(18) "SalesOfficeAddress" ["joinCondition"]=> string(216) "Subdivision.SubdivisionNumber = SalesOfficeAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SalesOfficeAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SalesOfficeAddress.CorporateBuilderNumber" } ["SubAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(10) "SubAddress" ["joinCondition"]=> string(192) "Subdivision.SubdivisionNumber = SubAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SubAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SubAddress.CorporateBuilderNumber" } ["Plan"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(4) "Plan" ["joinCondition"]=> string(174) "Subdivision.SubdivisionNumber = Plan.SubdivisionNumber AND Subdivision.BuilderNumber = Plan.BuilderNumber AND Subdivision.CorporateBuilderNumber = Plan.CorporateBuilderNumber" } } ["where"]=> array(70) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [2]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [3]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [4]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [5]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [6]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [7]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [14]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [15]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [16]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [17]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [18]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [19]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [20]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [21]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [22]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [23]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [24]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [25]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [28]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [29]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [31]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [32]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [33]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [34]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [35]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [36]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [37]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [38]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [39]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [40]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [41]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [45]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [46]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [47]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [48]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [49]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [50]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [51]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [52]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [53]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [54]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [55]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [56]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [57]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [58]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [59]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [60]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [61]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [62]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [63]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [64]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [65]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [66]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [67]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [68]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [69]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" } ["group"]=> array(3) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(15) "SubdivisionName" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(-10) ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [5]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Action.php" ["line"]=> int(502) ["function"]=> string(14) "listingsAction" ["class"]=> string(16) "MarketController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [6]=> array(6) { ["file"]=> string(80) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(293) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(14) "listingsAction" } } [7]=> array(6) { ["file"]=> string(66) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Front.php" ["line"]=> int(914) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#20 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(11) "/robots.txt" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(11) "/robots.txt" ["_params:protected"]=> array(6) { ["page"]=> string(10) "robots.txt" ["controller"]=> string(6) "market" ["action"]=> string(8) "listings" ["sort"]=> string(4) "name" ["market"]=> string(7) "orlando" ["error_handler"]=> object(ArrayObject)#289 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#248 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(11) "/robots.txt" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(11) "/robots.txt" ["_params:protected"]=> array(5) { ["page"]=> string(10) "robots.txt" ["controller"]=> string(6) "market" ["action"]=> string(8) "listings" ["sort"]=> string(4) "name" ["market"]=> string(7) "orlando" } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(6) "market" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(8) "listings" ["_actionKey:protected"]=> string(6) "action" } } } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(5) "error" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(5) "error" ["_actionKey:protected"]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#21 (8) { ["_body:protected"]=> array(0) { } ["_exceptions:protected"]=> array(1) { [0]=> *RECURSION* } ["_headers:protected"]=> array(0) { } ["_headersRaw:protected"]=> array(0) { } ["_httpResponseCode:protected"]=> int(200) ["_isRedirect:protected"]=> bool(false) ["_renderExceptions:protected"]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [8]=> array(6) { ["file"]=> string(31) "/home/ucl/public_html/index.php" ["line"]=> int(139) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } } ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#248 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(11) "/robots.txt" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(11) "/robots.txt" ["_params:protected"]=> array(5) { ["page"]=> string(10) "robots.txt" ["controller"]=> string(6) "market" ["action"]=> string(8) "listings" ["sort"]=> string(4) "name" ["market"]=> string(7) "orlando" } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(6) "market" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(8) "listings" ["_actionKey:protected"]=> string(6) "action" } } } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(5) "error" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(5) "error" ["_actionKey:protected"]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#21 (8) { ["_body:protected"]=> array(0) { } ["_exceptions:protected"]=> array(1) { [0]=> object(Zend_Db_Adapter_Mysqli_Exception)#258 (7) { ["_chainedException:protected"]=> NULL ["message:protected"]=> string(38) "LIMIT argument offset=-10 is not valid" ["string:private"]=> string(0) "" ["code:protected"]=> int(0) ["file:protected"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Mysqli.php" ["line:protected"]=> int(455) ["trace:private"]=> array(9) { [0]=> array(6) { ["file"]=> string(59) "/home/ucl/public_html/app/zend-framework/Zend/Db/Select.php" ["line"]=> int(1044) ["function"]=> string(5) "limit" ["class"]=> string(22) "Zend_Db_Adapter_Mysqli" ["type"]=> string(2) "->" ["args"]=> array(3) { [0]=> string(0) "" [1]=> int(10) [2]=> int(-10) } } [1]=> array(6) { ["file"]=> string(59) "/home/ucl/public_html/app/zend-framework/Zend/Db/Select.php" ["line"]=> int(1116) ["function"]=> string(18) "_renderLimitoffset" ["class"]=> string(14) "Zend_Db_Select" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [2]=> array(6) { ["file"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Abstract.php" ["line"]=> int(394) ["function"]=> string(10) "__toString" ["class"]=> string(14) "Zend_Db_Select" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [3]=> array(6) { ["file"]=> string(69) "/home/ucl/public_html/app/zend-framework/Zend/Db/Adapter/Abstract.php" ["line"]=> int(617) ["function"]=> string(5) "query" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Db_Select)#260 (3) { ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#259 (1) { ["_expression:protected"]=> string(87) "COUNT(*), MIN(PlanNumber), MIN(BasePrice), MAX(BasePrice), MIN(BaseSqft), MAX(BaseSqft)" } [2]=> NULL } } ["from"]=> array(4) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } ["SalesOfficeAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(18) "SalesOfficeAddress" ["joinCondition"]=> string(216) "Subdivision.SubdivisionNumber = SalesOfficeAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SalesOfficeAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SalesOfficeAddress.CorporateBuilderNumber" } ["SubAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(10) "SubAddress" ["joinCondition"]=> string(192) "Subdivision.SubdivisionNumber = SubAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SubAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SubAddress.CorporateBuilderNumber" } ["Plan"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(4) "Plan" ["joinCondition"]=> string(174) "Subdivision.SubdivisionNumber = Plan.SubdivisionNumber AND Subdivision.BuilderNumber = Plan.BuilderNumber AND Subdivision.CorporateBuilderNumber = Plan.CorporateBuilderNumber" } } ["where"]=> array(70) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [2]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [3]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [4]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [5]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [6]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [7]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [14]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [15]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [16]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [17]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [18]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [19]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [20]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [21]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [22]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [23]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [24]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [25]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [28]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [29]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [31]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [32]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [33]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [34]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [35]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [36]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [37]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [38]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [39]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [40]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [41]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [45]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [46]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [47]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [48]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [49]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [50]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [51]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [52]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [53]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [54]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [55]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [56]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [57]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [58]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [59]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [60]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [61]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [62]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [63]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [64]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [65]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [66]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [67]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [68]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [69]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" } ["group"]=> array(3) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(15) "SubdivisionName" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(-10) ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } [1]=> array(0) { } } } [4]=> array(6) { ["file"]=> string(70) "/home/ucl/public_html/app/application/controllers/MarketController.php" ["line"]=> int(128) ["function"]=> string(8) "fetchAll" ["class"]=> string(24) "Zend_Db_Adapter_Abstract" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> object(Zend_Db_Select)#260 (3) { ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> object(Zend_Db_Adapter_Mysqli)#37 (9) { ["_numericDataTypes:protected"]=> array(16) { [0]=> int(0) [1]=> int(1) [2]=> int(2) ["INT"]=> int(0) ["INTEGER"]=> int(0) ["MEDIUMINT"]=> int(0) ["SMALLINT"]=> int(0) ["TINYINT"]=> int(0) ["BIGINT"]=> int(1) ["SERIAL"]=> int(1) ["DEC"]=> int(2) ["DECIMAL"]=> int(2) ["DOUBLE"]=> int(2) ["DOUBLE PRECISION"]=> int(2) ["FIXED"]=> int(2) ["FLOAT"]=> int(2) } ["_stmt:protected"]=> object(Zend_Db_Statement_Mysqli)#214 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#250 (0) { } ["_keys:protected"]=> array(12) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" [3]=> string(10) "SubStreet1" [4]=> string(10) "SubStreet2" [5]=> string(9) "SubCounty" [6]=> string(7) "SubCity" [7]=> string(8) "SubState" [8]=> string(6) "SubZIP" [9]=> string(10) "SubCountry" [10]=> string(11) "SubLatitude" [11]=> string(12) "SubLongitude" } ["_values:protected"]=> array(12) { [0]=> &string(30) "The Condominiums at Baldwin Pa" [1]=> &string(4) "1272" [2]=> &string(9) "Corp_1272" [3]=> &string(20) "1532 Common Way Road" [4]=> &string(9) "Suite 110" [5]=> &string(6) "Orange" [6]=> &string(7) "Orlando" [7]=> &string(2) "FL" [8]=> &string(5) "32814" [9]=> &string(3) "USA" [10]=> &float(28.566337585449) [11]=> &float(-81.329772949219) } ["_meta:protected"]=> object(mysqli_result)#46 (0) { } ["_adapter:protected"]=> *RECURSION* ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(2630) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#259 (1) { ["_expression:protected"]=> string(87) "COUNT(*), MIN(PlanNumber), MIN(BasePrice), MAX(BasePrice), MIN(BaseSqft), MAX(BaseSqft)" } [2]=> NULL } } ["from"]=> array(4) { ["Subdivision"]=> array(4) { ["joinType"]=> string(10) "inner join" ["schema"]=> NULL ["tableName"]=> string(11) "Subdivision" ["joinCondition"]=> NULL } ["SalesOfficeAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(18) "SalesOfficeAddress" ["joinCondition"]=> string(216) "Subdivision.SubdivisionNumber = SalesOfficeAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SalesOfficeAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SalesOfficeAddress.CorporateBuilderNumber" } ["SubAddress"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(10) "SubAddress" ["joinCondition"]=> string(192) "Subdivision.SubdivisionNumber = SubAddress.SubdivisionNumber AND Subdivision.BuilderNumber = SubAddress.BuilderNumber AND Subdivision.CorporateBuilderNumber = SubAddress.CorporateBuilderNumber" } ["Plan"]=> array(4) { ["joinType"]=> string(9) "left join" ["schema"]=> NULL ["tableName"]=> string(4) "Plan" ["joinCondition"]=> string(174) "Subdivision.SubdivisionNumber = Plan.SubdivisionNumber AND Subdivision.BuilderNumber = Plan.BuilderNumber AND Subdivision.CorporateBuilderNumber = Plan.CorporateBuilderNumber" } } ["where"]=> array(70) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [2]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [3]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [4]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [5]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [6]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [7]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [14]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [15]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [16]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [17]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [18]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [19]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [20]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [21]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [22]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [23]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [24]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [25]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [28]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [29]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [31]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [32]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [33]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [34]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [35]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300272' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [36]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300273' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [37]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300292' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [38]=> string(137) "OR (Subdivision.SubdivisionNumber = '01300335' AND Subdivision.BuilderNumber = '01300' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [39]=> string(132) "OR (Subdivision.SubdivisionNumber = '110' AND Subdivision.BuilderNumber = '11' AND Subdivision.CorporateBuilderNumber = 'BeazerUSA')" [40]=> string(136) "OR (Subdivision.SubdivisionNumber = '1406' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [41]=> string(140) "OR (Subdivision.SubdivisionNumber = '16023' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '16309' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '16327' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(139) "OR (Subdivision.SubdivisionNumber = '16351' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [45]=> string(139) "OR (Subdivision.SubdivisionNumber = '16355' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [46]=> string(136) "OR (Subdivision.SubdivisionNumber = '1764' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [47]=> string(140) "OR (Subdivision.SubdivisionNumber = '2192' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [48]=> string(149) "OR (Subdivision.SubdivisionNumber = '250711000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [49]=> string(149) "OR (Subdivision.SubdivisionNumber = '250714000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [50]=> string(149) "OR (Subdivision.SubdivisionNumber = '250730000000' AND Subdivision.BuilderNumber = '250000000000' AND Subdivision.CorporateBuilderNumber = 'MIHOMES')" [51]=> string(136) "OR (Subdivision.SubdivisionNumber = '3653' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [52]=> string(136) "OR (Subdivision.SubdivisionNumber = '3669' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [53]=> string(136) "OR (Subdivision.SubdivisionNumber = '40012' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" [54]=> string(137) "OR (Subdivision.SubdivisionNumber = '46204' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [55]=> string(137) "OR (Subdivision.SubdivisionNumber = '46615' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [56]=> string(137) "OR (Subdivision.SubdivisionNumber = '46682' AND Subdivision.BuilderNumber = '1038' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [57]=> string(141) "OR (Subdivision.SubdivisionNumber = '48' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [58]=> string(135) "OR (Subdivision.SubdivisionNumber = '50028' AND Subdivision.BuilderNumber = '40638' AND Subdivision.CorporateBuilderNumber = 'CORP803')" [59]=> string(141) "OR (Subdivision.SubdivisionNumber = '53' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [60]=> string(141) "OR (Subdivision.SubdivisionNumber = '57' AND Subdivision.BuilderNumber = '3' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [61]=> string(141) "OR (Subdivision.SubdivisionNumber = '58916' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [62]=> string(149) "OR (Subdivision.SubdivisionNumber = '6409' AND Subdivision.BuilderNumber = 'Toll Brothers, Inc.' AND Subdivision.CorporateBuilderNumber = 'CORPTOLL')" [63]=> string(140) "OR (Subdivision.SubdivisionNumber = '6503' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [64]=> string(138) "OR (Subdivision.SubdivisionNumber = '6790' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [65]=> string(138) "OR (Subdivision.SubdivisionNumber = '6791' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [66]=> string(135) "OR (Subdivision.SubdivisionNumber = '945' AND Subdivision.BuilderNumber = '25' AND Subdivision.CorporateBuilderNumber = 'Ryland Homes')" [67]=> string(140) "OR (Subdivision.SubdivisionNumber = '9871420090429' AND Subdivision.BuilderNumber = 'R1FLA' AND Subdivision.CorporateBuilderNumber = '5737')" [68]=> string(148) "OR (Subdivision.SubdivisionNumber = 'Harmony' AND Subdivision.BuilderNumber = 'HARMONYFL' AND Subdivision.CorporateBuilderNumber = 'HARMONYDEVELOP')" [69]=> string(161) "OR (Subdivision.SubdivisionNumber = 'The Condominiums at Baldwin Pa' AND Subdivision.BuilderNumber = '1272' AND Subdivision.CorporateBuilderNumber = 'Corp_1272')" } ["group"]=> array(3) { [0]=> string(17) "SubdivisionNumber" [1]=> string(13) "BuilderNumber" [2]=> string(22) "CorporateBuilderNumber" } ["having"]=> array(0) { } ["order"]=> array(1) { [0]=> array(2) { [0]=> string(15) "SubdivisionName" [1]=> string(3) "ASC" } } ["limitcount"]=> int(10) ["limitoffset"]=> int(-10) ["forupdate"]=> bool(false) } ["_tableCols:protected"]=> array(0) { } } } } [5]=> array(6) { ["file"]=> string(67) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Action.php" ["line"]=> int(502) ["function"]=> string(14) "listingsAction" ["class"]=> string(16) "MarketController" ["type"]=> string(2) "->" ["args"]=> array(0) { } } [6]=> array(6) { ["file"]=> string(80) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Dispatcher/Standard.php" ["line"]=> int(293) ["function"]=> string(8) "dispatch" ["class"]=> string(22) "Zend_Controller_Action" ["type"]=> string(2) "->" ["args"]=> array(1) { [0]=> string(14) "listingsAction" } } [7]=> array(6) { ["file"]=> string(66) "/home/ucl/public_html/app/zend-framework/Zend/Controller/Front.php" ["line"]=> int(914) ["function"]=> string(8) "dispatch" ["class"]=> string(35) "Zend_Controller_Dispatcher_Standard" ["type"]=> string(2) "->" ["args"]=> array(2) { [0]=> object(Zend_Controller_Request_Http)#20 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(11) "/robots.txt" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(11) "/robots.txt" ["_params:protected"]=> array(6) { ["page"]=> string(10) "robots.txt" ["controller"]=> string(6) "market" ["action"]=> string(8) "listings" ["sort"]=> string(4) "name" ["market"]=> string(7) "orlando" ["error_handler"]=> object(ArrayObject)#289 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#248 (14) { ["_paramSources:protected"]=> array(2) { [0]=> string(4) "_GET" [1]=> string(5) "_POST" } ["_requestUri:protected"]=> string(11) "/robots.txt" ["_baseUrl:protected"]=> string(0) "" ["_basePath:protected"]=> NULL ["_pathInfo:protected"]=> string(11) "/robots.txt" ["_params:protected"]=> array(5) { ["page"]=> string(10) "robots.txt" ["controller"]=> string(6) "market" ["action"]=> string(8) "listings" ["sort"]=> string(4) "name" ["market"]=> string(7) "orlando" } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(6) "market" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(8) "listings" ["_actionKey:protected"]=> string(6) "action" } } } ["_aliases:protected"]=> array(0) { } ["_dispatched:protected"]=> bool(true) ["_module:protected"]=> string(7) "default" ["_moduleKey:protected"]=> string(6) "module" ["_controller:protected"]=> string(5) "error" ["_controllerKey:protected"]=> string(10) "controller" ["_action:protected"]=> string(5) "error" ["_actionKey:protected"]=> string(6) "action" } [1]=> object(Zend_Controller_Response_Http)#21 (8) { ["_body:protected"]=> array(0) { } ["_exceptions:protected"]=> array(1) { [0]=> *RECURSION* } ["_headers:protected"]=> array(0) { } ["_headersRaw:protected"]=> array(0) { } ["_httpResponseCode:protected"]=> int(200) ["_isRedirect:protected"]=> bool(false) ["_renderExceptions:protected"]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [8]=> array(6) { ["file"]=> string(31) "/home/ucl/public_html/index.php" ["line"]=> int(139) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } } } ["_headers:protected"]=> array(0) { } ["_headersRaw:protected"]=> array(0) { } ["_httpResponseCode:protected"]=> int(200) ["_isRedirect:protected"]=> bool(false) ["_renderExceptions:protected"]=> bool(false) ["headersSentThrowsException"]=> bool(true) } } } [8]=> array(6) { ["file"]=> string(31) "/home/ucl/public_html/index.php" ["line"]=> int(139) ["function"]=> string(8) "dispatch" ["class"]=> string(21) "Zend_Controller_Front" ["type"]=> string(2) "->" ["args"]=> array(0) { } } } }