DEBUG BLOCK 1: City Slug Detection (Spec-Compliant) URL Slug ($city_slug_from_url): string(6) "oldham" Query: SELECT name FROM uk_towns WHERE slug = 'oldham' Matched Canonical Name: string(6) "Oldham" $city_filter set to: string(6) "Oldham"
DEBUG BLOCK 2: Final Query Conditions
Final WHERE Clause ($where_sql): WHERE p.deleted_at IS NULL AND p.location_city = :city
Final HAVING Clause ($having_sql):
Final Parameters ($params): array(1) {
[":city"]=>
string(6) "Oldham"
}