object(Zend_Db_Adapter_Mysqli_Exception)#124 (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)#126 (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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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)#125 (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(14) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [2]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [3]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [4]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [11]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" } ["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)#126 (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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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)#125 (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(14) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [2]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [3]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [4]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [11]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" } ["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(8) "lakeland" ["error_handler"]=> object(ArrayObject)#47 (3) { ["exception"]=> object(Zend_Db_Adapter_Mysqli_Exception)#124 (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)#126 (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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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)#125 (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(14) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [2]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [3]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [4]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [11]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" } ["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)#126 (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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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)#125 (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(14) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [2]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [3]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [4]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [11]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" } ["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(8) "lakeland" ["error_handler"]=> object(ArrayObject)#47 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#114 (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(8) "lakeland" } ["_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)#114 (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(8) "lakeland" } ["_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)#124 (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)#126 (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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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)#125 (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(14) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [2]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [3]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [4]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [11]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" } ["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)#126 (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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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)#108 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#112 (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(4) "7205" [1]=> &string(6) "TPULEN" [2]=> &string(10) "CORPLENNAR" [3]=> &string(20) "4232 Birch Pond Loop" [4]=> &NULL [5]=> &string(4) "Polk" [6]=> &string(8) "Lakeland" [7]=> &string(2) "FL" [8]=> &string(5) "33812" [9]=> &string(3) "USA" [10]=> &float(27.969877243) [11]=> &float(-81.8945541382) } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_sqlParam:protected"]=> array(1) { [0]=> string(934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_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)#125 (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(14) { [0]=> string(137) "(Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [1]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [2]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [3]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [4]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [5]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [6]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [7]=> string(140) "OR (Subdivision.SubdivisionNumber = '11870' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [8]=> string(139) "OR (Subdivision.SubdivisionNumber = '15129' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [9]=> string(139) "OR (Subdivision.SubdivisionNumber = '16370' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [10]=> string(140) "OR (Subdivision.SubdivisionNumber = '44,WNH,7HH' AND Subdivision.BuilderNumber = '44WNH' AND Subdivision.CorporateBuilderNumber = 'MARONDA')" [11]=> string(138) "OR (Subdivision.SubdivisionNumber = '7059' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(138) "OR (Subdivision.SubdivisionNumber = '7060' AND Subdivision.BuilderNumber = 'OLHLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [13]=> string(138) "OR (Subdivision.SubdivisionNumber = '7205' AND Subdivision.BuilderNumber = 'TPULEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" } ["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(8) "lakeland" ["error_handler"]=> object(ArrayObject)#47 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#114 (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(8) "lakeland" } ["_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) { } } } }