object(Zend_Db_Adapter_Mysqli_Exception)#104 (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)#106 (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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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)#105 (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(36) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [2]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [3]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [4]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [8]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [9]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [10]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [11]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [14]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [15]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [16]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [17]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [21]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [22]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [23]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [24]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [26]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [28]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [29]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [31]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [32]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [33]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [34]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [35]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" } ["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)#106 (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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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)#105 (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(36) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [2]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [3]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [4]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [8]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [9]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [10]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [11]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [14]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [15]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [16]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [17]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [21]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [22]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [23]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [24]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [26]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [28]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [29]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [31]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [32]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [33]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [34]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [35]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" } ["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(6) "naples" ["error_handler"]=> object(ArrayObject)#118 (3) { ["exception"]=> object(Zend_Db_Adapter_Mysqli_Exception)#104 (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)#106 (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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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)#105 (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(36) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [2]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [3]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [4]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [8]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [9]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [10]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [11]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [14]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [15]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [16]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [17]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [21]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [22]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [23]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [24]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [26]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [28]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [29]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [31]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [32]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [33]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [34]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [35]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" } ["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)#106 (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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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)#105 (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(36) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [2]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [3]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [4]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [8]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [9]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [10]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [11]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [14]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [15]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [16]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [17]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [21]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [22]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [23]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [24]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [26]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [28]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [29]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [31]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [32]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [33]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [34]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [35]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" } ["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(6) "naples" ["error_handler"]=> object(ArrayObject)#118 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#94 (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(6) "naples" } ["_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)#94 (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(6) "naples" } ["_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)#104 (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)#106 (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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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)#105 (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(36) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [2]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [3]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [4]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [8]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [9]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [10]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [11]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [14]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [15]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [16]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [17]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [21]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [22]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [23]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [24]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [26]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [28]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [29]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [31]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [32]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [33]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [34]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [35]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" } ["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)#106 (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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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)#77 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#96 (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(29) "Amberton Isles/Amberton Point" [1]=> &string(5) "19629" [2]=> &string(7) "CORP348" [3]=> &string(32) "8070 Dream Catcher Circle #2201" [4]=> &NULL [5]=> &string(7) "Collier" [6]=> &string(6) "Naples" [7]=> &string(2) "FL" [8]=> &string(5) "34119" [9]=> &string(3) "USA" [10]=> &float(26.2733287811) [11]=> &float(-81.6940765381) } ["_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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(438) "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 )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(438) "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 )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(7) "dbu_ucl" ["password"]=> string(9) "Guxz06peh" ["dbname"]=> string(7) "ucl_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)#105 (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(36) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [2]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [3]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [4]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [8]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [9]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [10]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [11]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [14]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [15]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [16]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [17]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '11885' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '15986' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '16003' AND Subdivision.BuilderNumber = 'DIVOSTA000' AND Subdivision.CorporateBuilderNumber = 'DiVosta')" [21]=> string(139) "OR (Subdivision.SubdivisionNumber = '16081' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [22]=> string(139) "OR (Subdivision.SubdivisionNumber = '16119' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [23]=> string(139) "OR (Subdivision.SubdivisionNumber = '16120' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [24]=> string(139) "OR (Subdivision.SubdivisionNumber = '16121' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '1633' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [26]=> string(140) "OR (Subdivision.SubdivisionNumber = '2025' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [27]=> string(140) "OR (Subdivision.SubdivisionNumber = '2221' AND Subdivision.BuilderNumber = 'Pulte110' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [28]=> string(142) "OR (Subdivision.SubdivisionNumber = '324' AND Subdivision.BuilderNumber = '5' AND Subdivision.CorporateBuilderNumber = 'TaylorMorrisonUSCorp')" [29]=> string(142) "OR (Subdivision.SubdivisionNumber = '50260' AND Subdivision.BuilderNumber = 'Div Sd239' AND Subdivision.CorporateBuilderNumber = 'Corp Sd239')" [30]=> string(138) "OR (Subdivision.SubdivisionNumber = '50496' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [31]=> string(138) "OR (Subdivision.SubdivisionNumber = '51222' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [32]=> string(138) "OR (Subdivision.SubdivisionNumber = '51333' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [33]=> string(138) "OR (Subdivision.SubdivisionNumber = '51814' AND Subdivision.BuilderNumber = 'Centex110' AND Subdivision.CorporateBuilderNumber = 'Centex')" [34]=> string(138) "OR (Subdivision.SubdivisionNumber = '6429' AND Subdivision.BuilderNumber = 'LEHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [35]=> string(159) "OR (Subdivision.SubdivisionNumber = 'Amberton Isles/Amberton Point' AND Subdivision.BuilderNumber = '19629' AND Subdivision.CorporateBuilderNumber = 'CORP348')" } ["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(6) "naples" ["error_handler"]=> object(ArrayObject)#118 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#94 (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(6) "naples" } ["_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) { } } } }