Local Ticket Sales You’ll LOVE These Hometown Events

Welcome

Sponsor

    Show Your Ad Here!
Page requested: /
Request Method: GET
Referrer:
User Agent: CCBot/2.0 (http://commoncrawl.org/faq/)
Remote Address: 23.20.225.97
Request Time: 1.13907384872 seconds

Console:

Query Log:

SELECT
	events.id,
	events.pictures_id,
	title,
	event_date,
	end_date,
	sale_date,
	start_time,
	end_time,
	ticket_price,
	venues_id,
	categories_id,
	categories.parent_id as categories_parent_id,
	featured,
	recurrence,
	events.clicks,
	events.description,
	events.special_instructions,
	events.cancelled,
	events.external_link,
	( 3959 * acos( cos( radians(39.03) ) * cos( radians( venues.lat ) ) * cos( radians( venues.`long` ) - radians(-77.5) ) + sin( radians(39.03) ) * sin( radians( venues.lat ) ) ) ) AS distance,
	venues.business_name,
	venues.lat,
	venues.long,
	venues.keywords,
	show_until
FROM
	events
LEFT JOIN
	categories ON events.categories_id=categories.id
            LEFT JOIN categories categories_parents ON categories.parent_id = categories_parents.id
LEFT JOIN
	venues ON events.venues_id=venues.id
	
	HAVING distance < 30
ORDER BY
	categories_parents.priority, categories.parent_id, events.event_date, events.start_time


SELECT
	cities.id,
                city,
	state,
                description,
                keywords,
                pictures_id
FROM
	cities
WHERE
	cities.city="Ashburn" AND cities.state="VA"


SELECT
	categories.id,
	categories.category,
	categories.parent_id,
	categories_tmp.category AS parent_name,
	categories.priority,
	
	categories.pictures_id
FROM
	categories
            LEFT JOIN categories categories_tmp ON categories.parent_id = categories_tmp.id
WHERE
	categories.parent_id IS NULL
ORDER BY
	categories.parent_id, categories.priority


SELECT
	categories.id,
	categories.category,
	categories.parent_id,
	categories_tmp.category AS parent_name,
	categories.priority,
	
	categories.pictures_id
FROM
	categories
            LEFT JOIN categories categories_tmp ON categories.parent_id = categories_tmp.id
WHERE
	categories.parent_id IS NULL
ORDER BY
	categories.parent_id, categories.priority


SELECT
	categories.id,
	categories.category,
	categories.parent_id,
	categories_tmp.category AS parent_name,
	categories.priority,
	
	categories.pictures_id
FROM
	categories
            LEFT JOIN categories categories_tmp ON categories.parent_id = categories_tmp.id
WHERE
	categories.parent_id=1
ORDER BY
	categories.parent_id, categories.priority


SELECT
	categories.id,
	categories.category,
	categories.parent_id,
	categories_tmp.category AS parent_name,
	categories.priority,
	
	categories.pictures_id
FROM
	categories
            LEFT JOIN categories categories_tmp ON categories.parent_id = categories_tmp.id
WHERE
	categories.parent_id=2
ORDER BY
	categories.parent_id, categories.priority


SELECT
	categories.id,
	categories.category,
	categories.parent_id,
	categories_tmp.category AS parent_name,
	categories.priority,
	
	categories.pictures_id
FROM
	categories
            LEFT JOIN categories categories_tmp ON categories.parent_id = categories_tmp.id
WHERE
	categories.parent_id=3
ORDER BY
	categories.parent_id, categories.priority


SELECT
	categories.id,
	categories.category,
	categories.parent_id,
	categories_tmp.category AS parent_name,
	categories.priority,
	
	categories.pictures_id
FROM
	categories
            LEFT JOIN categories categories_tmp ON categories.parent_id = categories_tmp.id
WHERE
	categories.parent_id=4
ORDER BY
	categories.parent_id, categories.priority


SELECT
	categories.id,
	categories.category,
	categories.parent_id,
	categories_tmp.category AS parent_name,
	categories.priority,
	
	categories.pictures_id
FROM
	categories
            LEFT JOIN categories categories_tmp ON categories.parent_id = categories_tmp.id
WHERE
	categories.parent_id=5
ORDER BY
	categories.parent_id, categories.priority


SELECT
	categories.id,
	categories.category,
	categories.parent_id,
	categories_tmp.category AS parent_name,
	categories.priority,
	
	categories.pictures_id
FROM
	categories
            LEFT JOIN categories categories_tmp ON categories.parent_id = categories_tmp.id
WHERE
	categories.parent_id=6
ORDER BY
	categories.parent_id, categories.priority


SELECT
	SQL_CALC_FOUND_ROWS
	ads.id,
                advertisers_id,
	pictures_id,
                impressions,
                clicks,
                size,
	fails,
                destination,
	( 3959 * acos( cos( radians(39.03) ) * cos( radians( advertisers.lat ) ) * cos( radians( advertisers.`long` ) - radians(-77.5) ) + sin( radians(39.03) ) * sin( radians( advertisers.lat ) ) ) ) AS distance,
                photo_location,
	advertisers.name,
	advertisers.lat,
	advertisers.`long`
FROM
	ads
LEFT JOIN
	advertisers ON ads.advertisers_id=advertisers.id
WHERE
	size = 1 
	HAVING distance < 30
ORDER BY
	impressions
LIMIT
	6


SELECT
	FOUND_ROWS()