mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [code:protected] => 1146
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)
mysqli_sql_exception Object
(
    [message:protected] => Table 'areavi5_2k19.TZestimate' doesn't exist
    [string:Exception:private] => 
    [code:protected] => 1146
    [file:protected] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
    [line:protected] => 74
    [trace:Exception:private] => Array
        (
            [0] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 74
                    [function] => prepare
                    [class] => mysqli
                    [type] => ->
                    [args] => Array
                        (
                            [0] => 
SELECT
TH.CityID,TH.HoodID,StateAbbr,City,Hood,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM THood TH
LEFT JOIN THousing THS USING (CityID,HoodID)
LEFT JOIN TEconomy TE USING (CityID,HoodID)
LEFT JOIN TZestimate TZ USING (StateAbbr,City,Hood)
UNION ALL

SELECT
TC.CityID,NULL,TC.StateAbbr,TC.City,NULL,
MedHouseholdIncomeOwnerOccupied,MedHouseholdIncomeRenterOccupied,MedValueOwnerOccupied,MedRent,
PctOwnerOccupied,PctRenterOccupied,
5Year
FROM TCity TC
LEFT JOIN THousing THS ON THS.CityID=TC.CityID AND THS.HoodID IS NULL
LEFT JOIN TEconomy TE ON TE.CityID=TC.CityID AND TE.HoodID IS NULL
LEFT JOIN TZestimate TZ ON TZ.StateAbbr=TC.StateAbbr AND TZ.City=TC.City AND TZ.Hood IS NULL

                        )

                )

            [1] => Array
                (
                    [file] => /home/areavi5/public_html/_DELETE_scores/new/hox.php
                    [line] => 293
                    [function] => fetch
                    [class] => housing_score
                    [type] => ->
                    [args] => Array
                        (
                        )

                )

        )

    [previous:Exception:private] => 
    [sqlstate:protected] => 42S02
)