object(Zend_Db_Adapter_Mysqli_Exception)#274 (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)#276 (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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#275 (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(64) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [2]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [3]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [4]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [5]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [6]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [7]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [8]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [9]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [14]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [15]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [16]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [17]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [21]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [22]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [23]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [24]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [27]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [28]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [29]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [30]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [31]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [32]=> string(137) "OR (Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [33]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [34]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [35]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [36]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [37]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [38]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [39]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [40]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [41]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [45]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [46]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [47]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [48]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [49]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [50]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [51]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [52]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [53]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [54]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [55]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [56]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [57]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [58]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [59]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [60]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [61]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [62]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [63]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" } ["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)#276 (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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#275 (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(64) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [2]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [3]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [4]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [5]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [6]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [7]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [8]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [9]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [14]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [15]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [16]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [17]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [21]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [22]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [23]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [24]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [27]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [28]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [29]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [30]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [31]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [32]=> string(137) "OR (Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [33]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [34]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [35]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [36]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [37]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [38]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [39]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [40]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [41]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [45]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [46]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [47]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [48]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [49]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [50]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [51]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [52]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [53]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [54]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [55]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [56]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [57]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [58]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [59]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [60]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [61]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [62]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [63]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" } ["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(9) "charlotte" ["error_handler"]=> object(ArrayObject)#302 (3) { ["exception"]=> object(Zend_Db_Adapter_Mysqli_Exception)#274 (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)#276 (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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#275 (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(64) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [2]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [3]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [4]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [5]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [6]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [7]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [8]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [9]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [14]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [15]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [16]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [17]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [21]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [22]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [23]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [24]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [27]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [28]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [29]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [30]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [31]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [32]=> string(137) "OR (Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [33]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [34]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [35]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [36]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [37]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [38]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [39]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [40]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [41]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [45]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [46]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [47]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [48]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [49]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [50]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [51]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [52]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [53]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [54]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [55]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [56]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [57]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [58]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [59]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [60]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [61]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [62]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [63]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" } ["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)#276 (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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#275 (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(64) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [2]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [3]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [4]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [5]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [6]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [7]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [8]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [9]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [14]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [15]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [16]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [17]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [21]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [22]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [23]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [24]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [27]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [28]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [29]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [30]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [31]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [32]=> string(137) "OR (Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [33]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [34]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [35]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [36]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [37]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [38]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [39]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [40]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [41]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [45]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [46]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [47]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [48]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [49]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [50]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [51]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [52]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [53]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [54]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [55]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [56]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [57]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [58]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [59]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [60]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [61]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [62]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [63]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" } ["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(9) "charlotte" ["error_handler"]=> object(ArrayObject)#302 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#264 (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(9) "charlotte" } ["_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)#264 (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(9) "charlotte" } ["_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)#274 (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)#276 (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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#275 (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(64) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [2]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [3]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [4]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [5]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [6]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [7]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [8]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [9]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [14]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [15]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [16]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [17]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [21]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [22]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [23]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [24]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [27]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [28]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [29]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [30]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [31]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [32]=> string(137) "OR (Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [33]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [34]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [35]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [36]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [37]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [38]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [39]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [40]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [41]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [45]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [46]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [47]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [48]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [49]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [50]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [51]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [52]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [53]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [54]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [55]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [56]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [57]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [58]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [59]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [60]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [61]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [62]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [63]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" } ["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)#276 (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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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)#233 (12) { ["_stmt:protected"]=> object(mysqli_stmt)#266 (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(13) "Steel Gardens" [1]=> &string(4) "2094" [2]=> &string(9) "Corp_2094" [3]=> &NULL [4]=> &NULL [5]=> &string(11) "Mecklenburg" [6]=> &string(9) "Charlotte" [7]=> &string(2) "NC" [8]=> &string(5) "28205" [9]=> &string(3) "USA" [10]=> &NULL [11]=> &NULL } ["_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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_fetchMode:protected"]=> int(2) ["_attribute:protected"]=> array(0) { } ["_bindColumn:protected"]=> array(0) { } ["_bindParam:protected"]=> array(0) { } ["_sqlSplit:protected"]=> array(1) { [0]=> string(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE 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(2934) "SELECT .* FROM WHERE ( SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE OR SubZip LIKE )" } ["_queryId:protected"]=> NULL } ["_config:protected"]=> array(6) { ["host"]=> string(9) "localhost" ["username"]=> string(6) "ucl_db" ["password"]=> string(9) "ju803WsqZ" ["dbname"]=> string(3) "ucl" ["options"]=> array(2) { ["caseFolding"]=> int(0) ["autoQuoteIdentifiers"]=> bool(true) } ["driver_options"]=> array(0) { } } ["_fetchMode:protected"]=> int(2) ["_profiler:protected"]=> object(Zend_Db_Profiler)#41 (4) { ["_queryProfiles:protected"]=> array(0) { } ["_enabled:protected"]=> bool(false) ["_filterElapsedSecs:protected"]=> NULL ["_filterTypes:protected"]=> NULL } ["_defaultProfilerClass:protected"]=> string(16) "Zend_Db_Profiler" ["_connection:protected"]=> object(mysqli)#43 (0) { } ["_caseFolding:protected"]=> int(0) ["_autoQuoteIdentifiers:protected"]=> bool(true) } ["_parts:protected"]=> array(10) { ["distinct"]=> bool(false) ["columns"]=> array(4) { [0]=> array(3) { [0]=> string(11) "Subdivision" [1]=> string(1) "*" [2]=> NULL } [1]=> array(3) { [0]=> string(18) "SalesOfficeAddress" [1]=> string(4) "City" [2]=> NULL } [2]=> array(3) { [0]=> string(10) "SubAddress" [1]=> string(7) "SubCity" [2]=> NULL } [3]=> array(3) { [0]=> string(4) "Plan" [1]=> object(Zend_Db_Expr)#275 (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(64) { [0]=> string(134) "(Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [1]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [2]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [3]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [4]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [5]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [6]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [7]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [8]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [9]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [10]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [11]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [12]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [13]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [14]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [15]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [16]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [17]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [18]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [19]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [20]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [21]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [22]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [23]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [24]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [25]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [26]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [27]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [28]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [29]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [30]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [31]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [32]=> string(137) "OR (Subdivision.SubdivisionNumber = '01400158' AND Subdivision.BuilderNumber = '01400' AND Subdivision.CorporateBuilderNumber = 'CORPKB')" [33]=> string(140) "OR (Subdivision.SubdivisionNumber = '11993' AND Subdivision.BuilderNumber = 'DELWEBB000' AND Subdivision.CorporateBuilderNumber = 'DelWebb')" [34]=> string(127) "OR (Subdivision.SubdivisionNumber = '125' AND Subdivision.BuilderNumber = '2' AND Subdivision.CorporateBuilderNumber = 'CORP1')" [35]=> string(126) "OR (Subdivision.SubdivisionNumber = '1351' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [36]=> string(126) "OR (Subdivision.SubdivisionNumber = '1476' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [37]=> string(126) "OR (Subdivision.SubdivisionNumber = '1489' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [38]=> string(126) "OR (Subdivision.SubdivisionNumber = '1551' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [39]=> string(126) "OR (Subdivision.SubdivisionNumber = '1575' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [40]=> string(126) "OR (Subdivision.SubdivisionNumber = '1580' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [41]=> string(126) "OR (Subdivision.SubdivisionNumber = '1623' AND Subdivision.BuilderNumber = '28' AND Subdivision.CorporateBuilderNumber = '31')" [42]=> string(139) "OR (Subdivision.SubdivisionNumber = '18136' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [43]=> string(139) "OR (Subdivision.SubdivisionNumber = '18166' AND Subdivision.BuilderNumber = 'GALLEN' AND Subdivision.CorporateBuilderNumber = 'CORPLENNAR')" [44]=> string(140) "OR (Subdivision.SubdivisionNumber = '2298' AND Subdivision.BuilderNumber = 'Pulte145' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [45]=> string(140) "OR (Subdivision.SubdivisionNumber = '2849' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [46]=> string(140) "OR (Subdivision.SubdivisionNumber = '2854' AND Subdivision.BuilderNumber = 'Pulte130' AND Subdivision.CorporateBuilderNumber = 'PulteHomes')" [47]=> string(136) "OR (Subdivision.SubdivisionNumber = '42720' AND Subdivision.BuilderNumber = '5101' AND Subdivision.CorporateBuilderNumber = 'Corp_5101')" [48]=> string(126) "OR (Subdivision.SubdivisionNumber = '447' AND Subdivision.BuilderNumber = '9' AND Subdivision.CorporateBuilderNumber = '0123')" [49]=> string(137) "OR (Subdivision.SubdivisionNumber = '45960' AND Subdivision.BuilderNumber = '1000' AND Subdivision.CorporateBuilderNumber = 'CORPCENTEX')" [50]=> string(140) "OR (Subdivision.SubdivisionNumber = '9664720051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [51]=> string(140) "OR (Subdivision.SubdivisionNumber = '9665020051209' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [52]=> string(140) "OR (Subdivision.SubdivisionNumber = '9802220080513' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [53]=> string(140) "OR (Subdivision.SubdivisionNumber = '9824720080703' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [54]=> string(140) "OR (Subdivision.SubdivisionNumber = '9834120081215' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [55]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869020090317' AND Subdivision.BuilderNumber = 'R1CTN' AND Subdivision.CorporateBuilderNumber = '5737')" [56]=> string(140) "OR (Subdivision.SubdivisionNumber = '9869620090326' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [57]=> string(140) "OR (Subdivision.SubdivisionNumber = '9872520090508' AND Subdivision.BuilderNumber = 'R1CTS' AND Subdivision.CorporateBuilderNumber = '5737')" [58]=> string(141) "OR (Subdivision.SubdivisionNumber = 'Antiquity1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [59]=> string(161) "OR (Subdivision.SubdivisionNumber = 'Ardrey Commons' AND Subdivision.BuilderNumber = 'CUNNANEGROUPDIV1' AND Subdivision.CorporateBuilderNumber = 'CUNNANEGROUP1')" [60]=> string(147) "OR (Subdivision.SubdivisionNumber = 'Bonterra Village' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" [61]=> string(143) "OR (Subdivision.SubdivisionNumber = 'Cedar Walk 1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [62]=> string(142) "OR (Subdivision.SubdivisionNumber = 'Eagle Park1' AND Subdivision.BuilderNumber = '88723' AND Subdivision.CorporateBuilderNumber = '02032009')" [63]=> string(144) "OR (Subdivision.SubdivisionNumber = 'Steel Gardens' AND Subdivision.BuilderNumber = '2094' AND Subdivision.CorporateBuilderNumber = 'Corp_2094')" } ["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(9) "charlotte" ["error_handler"]=> object(ArrayObject)#302 (3) { ["exception"]=> *RECURSION* ["type"]=> string(15) "EXCEPTION_OTHER" ["request"]=> object(Zend_Controller_Request_Http)#264 (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(9) "charlotte" } ["_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) { } } } }