SELECT
                        p.place_id, p.place_name, p.logo, p.slug AS place_slug, p.address, p.cross_street,
                        p.postal_code, p.phone, p.area_code, p.lat, p.lng, p.state_id, p.feat, p.short_desc,
                        p.website, c.city_name, c.slug, c.state,
                        s.state_name, s.slug AS state_slug, s.state_abbr,
                        co.country_name, co.country_abbr,
                        cats.cat_icon, cats.name AS cat_name, cats.cat_slug, cats.id AS cat_id,
                        ph.dir, ph.filename,
                        pt.plan_priority,
                        sub1.cat_id AS main_cat_id, sub1.cat_slug AS main_cat_slug, sub1.name AS main_cat_name

SELECT
                        p.place_id, p.place_name, p.logo, p.slug AS place_slug, p.address, p.cross_street,
                        p.postal_code, p.phone, p.area_code, p.lat, p.lng, p.state_id, p.feat, p.short_desc,
                        p.website, c.city_name, c.slug, c.state,
                        s.state_name, s.slug AS state_slug, s.state_abbr,
                        co.country_name, co.country_abbr,
                        cats.cat_icon, cats.name AS cat_name, cats.cat_slug, cats.id AS cat_id,
                        ph.dir, ph.filename,
                        pt.plan_priority,
                        sub1.cat_id AS main_cat_id, sub1.cat_slug AS main_cat_slug, sub1.name AS main_cat_name