USA TODAY Airfare Specials and Deals from Sherman's Travel

FLIGHT DEALS: USA/ Canada Europe Carribean/ Mexico
Asia More
HOTEL DEALS: Las Vegas Florida New York California Hawaii Other USA/ Canada
Caribbean/ Mexico Europe Luxury Villas More
VACATION DEALS: Hawaii Las Vegas Florida New York California Other USA/ Canada
Caribbean/ Mexico Europe Luxury More
CRUISE DEALS: Caribbean/ Bermuda Alaska Hawaii Mexico New England
Pacific Coast Europe More

32 queries took 58 ms
Nr	Query	Affected	Num. rows	Took (ms)
1	SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a71tumbdpdmrkju4gvl1u5bl16'	0	0	1
2	DESCRIBE `deals`	30	30	1
3	DESCRIBE `geotags`	5	5	1
4	DESCRIBE `places`	15	15	1
5	DESCRIBE `tag_types`	2	2	1
6	DESCRIBE `tags`	3	3	1
7	DESCRIBE `site_pages`	10	10	1
8	DESCRIBE `article_pages`	5	5	1
9	DESCRIBE `articles`	19	19	1
10	DESCRIBE `article_types`	2	2	1
11	DESCRIBE `authors`	5	5	1
12	DESCRIBE `images`	12	12	1
13	DESCRIBE `tag_records`	4	4	1
14	DESCRIBE `article_elements`	9	9	1
15	SELECT * FROM site_pages WHERE url='/deals/index/luxe15/'	1	1	1
16	DESCRIBE `visitors`	3	3	1
17	INSERT INTO visitors SET created = NOW(), refer_id = 0	1		0
18	SELECT * FROM visitors WHERE id = LAST_INSERT_ID()	1	1	0
19	DESCRIBE `visits`	6	6	1
20	DESCRIBE `refers`	9	9	1
21	INSERT INTO visits SET created = NOW(), visitor_id = 110813781, refer_id = 0, ip_address = '38.103.63.18', is_usatoday = 1	1		0
22	SELECT LAST_INSERT_ID() AS id	1	1	0
23	select min(place_type_id) as place_type_id from places where geotag_short='Luxe15'	1	1	0
24	(select tags1.name as tag_name, data.* from (select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'Air' order by rand()) union (select tags1.name as tag_name, data.* from (select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'Hotel' order by rand()) union (select tags1.name as tag_name, data.* from (select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'Package' order by rand()) union (select tags1.name as tag_name, data.* from (select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'Cruise' order by rand()) union (select tags1.name as tag_name, data.* from (select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'Car' order by rand())	0	0	33
25	SELECT p.geotag_short, p.geotag_full, p.lineage, p.lineage_display FROM deals d INNER JOIN geotags g ON g.association_id = d.id AND g.association_type IN('Deal', 'EditorReview') AND g.tag_type_id NOT IN (4,11) INNER JOIN places p ON g.place_id = p.id WHERE d.is_published = 1 AND d.show_in_search_results = 1 AND d.sponsor_listing <> 1 AND d.date_to_show < NOW() AND d.date_to_remove > NOW() AND p.geotag_short = 'luxe15' GROUP BY p.id ORDER BY p.geotag_full	0	0	1
26	DESCRIBE `travel_guides`	17	17	1
27	SELECT TravelGuide., ArticlePage., ArticleElement.*, Place.lineage_display, Place.place_type_id FROM travel_guides AS TravelGuide LEFT JOIN article_pages ArticlePage ON ArticlePage.article_id = TravelGuide.id LEFT JOIN article_elements ArticleElement ON ArticleElement.article_page_id = ArticlePage.id AND ArticlePage.name IN ('Intro.','Hotels','Restaurants') LEFT JOIN geotags Geotag ON Geotag.association_id = TravelGuide.id AND Geotag.association_type = 'TravelGuide' LEFT JOIN places Place ON Geotag.place_id = Place.id WHERE TravelGuide.title = 'Luxe15' ORDER BY ArticlePage.position ASC	0	0	1
28	DESCRIBE `slideshows`	19	19	1
29	DESCRIBE `slides`	12	12	1
30	select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4)	0	0	1
31	SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a71tumbdpdmrkju4gvl1u5bl16'	1	1	0
32	INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config\|a:3:{s:9:\"userAgent\";s:32:\"b260d25dcd9c138e5e653c28eaa88044\";s:4:\"time\";i:1210421593;s:4:\"rand\";i:508131920;}userAgent\|s:7:\"Unknown\";refer_id\|i:0;refer_id_visitor_id\|i:0;visit_id\|s:8:\"14492939\";refer_id_visit_id\|i:0;', 1210421593, 'a71tumbdpdmrkju4gvl1u5bl16')	1		1

32 queries took 58 ms

Query

Error

Affected

Num. rows

Took (ms)

SELECT `cake_sessions`.`data` FROM `cake_sessions` WHERE `cake_sessions`.`id` = 'a71tumbdpdmrkju4gvl1u5bl16'

DESCRIBE `deals`

DESCRIBE `geotags`

DESCRIBE `places`

DESCRIBE `tag_types`

DESCRIBE `tags`

DESCRIBE `site_pages`

DESCRIBE `article_pages`

DESCRIBE `articles`

DESCRIBE `article_types`

DESCRIBE `authors`

DESCRIBE `images`

DESCRIBE `tag_records`

DESCRIBE `article_elements`

SELECT * FROM site_pages WHERE url='/deals/index/luxe15/'

DESCRIBE `visitors`

INSERT INTO visitors SET created = NOW(), refer_id = 0

SELECT * FROM visitors WHERE id = LAST_INSERT_ID()

DESCRIBE `visits`

DESCRIBE `refers`

INSERT INTO visits SET created = NOW(), visitor_id = 110813781, refer_id = 0, ip_address = '38.103.63.18', is_usatoday = 1

SELECT LAST_INSERT_ID() AS id

select min(place_type_id) as place_type_id from places where geotag_short='Luxe15'

(select tags1.name as tag_name, data.* from (select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'Air' order by rand()) union (select tags1.name as tag_name, data.* from (select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'Hotel' order by rand()) union (select tags1.name as tag_name, data.* from (select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'Package' order by rand()) union (select tags1.name as tag_name, data.* from (select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'Cruise' order by rand()) union (select tags1.name as tag_name, data.* from (select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join deals data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Deal' and now() between data.date_to_show and data.date_to_remove and data.is_published='1' and data.is_published = 1 AND data.show_in_search_results = 1 AND data.sponsor_listing <> 1 AND data.date_to_show < NOW() AND data.date_to_remove > NOW() and g.tag_type_id not in (11, 4)) data inner join tag_records tr1 on tr1.association_id=data.id inner join tags tags1 on tags1.id=tr1.tag_id where tr1.association_type='Deal' and tags1.name = 'Car' order by rand())

SELECT p.geotag_short, p.geotag_full, p.lineage, p.lineage_display FROM deals d INNER JOIN geotags g ON g.association_id = d.id AND g.association_type IN('Deal', 'EditorReview') AND g.tag_type_id NOT IN (4,11) INNER JOIN places p ON g.place_id = p.id WHERE d.is_published = 1 AND d.show_in_search_results = 1 AND d.sponsor_listing <> 1 AND d.date_to_show < NOW() AND d.date_to_remove > NOW() AND p.geotag_short = 'luxe15' GROUP BY p.id ORDER BY p.geotag_full

DESCRIBE `travel_guides`

SELECT TravelGuide.*, ArticlePage.*, ArticleElement.*, Place.lineage_display, Place.place_type_id FROM travel_guides AS TravelGuide LEFT JOIN article_pages ArticlePage ON ArticlePage.article_id = TravelGuide.id LEFT JOIN article_elements ArticleElement ON ArticleElement.article_page_id = ArticlePage.id AND ArticlePage.name IN ('Intro.','Hotels','Restaurants') LEFT JOIN geotags Geotag ON Geotag.association_id = TravelGuide.id AND Geotag.association_type = 'TravelGuide' LEFT JOIN places Place ON Geotag.place_id = Place.id WHERE TravelGuide.title = 'Luxe15' ORDER BY ArticlePage.position ASC

DESCRIBE `slideshows`

DESCRIBE `slides`

select data.* from places p0 inner join geotags g on p0.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join geotags g on p1.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join geotags g on p2.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join geotags g on p3.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join geotags g on p4.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join geotags g on p5.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join geotags g on p6.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join geotags g on p7.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4) union select data.* from places p0 inner join places p1 on p0.id=p1.parent_id inner join places p2 on p1.id=p2.parent_id inner join places p3 on p2.id=p3.parent_id inner join places p4 on p3.id=p4.parent_id inner join places p5 on p4.id=p5.parent_id inner join places p6 on p5.id=p6.parent_id inner join places p7 on p6.id=p7.parent_id inner join places p8 on p7.id=p8.parent_id inner join geotags g on p8.id=g.place_id inner join slideshows data on g.association_id=data.id where p0.geotag_short='Luxe15' and g.association_type='Slideshow' and g.tag_type_id not in (11, 4)

SELECT COUNT(id) AS count FROM `cake_sessions` WHERE `id` = 'a71tumbdpdmrkju4gvl1u5bl16'

INSERT INTO `cake_sessions` (`data`,`expires`,`id`) VALUES ('Config|a:3:{s:9:\"userAgent\";s:32:\"b260d25dcd9c138e5e653c28eaa88044\";s:4:\"time\";i:1210421593;s:4:\"rand\";i:508131920;}userAgent|s:7:\"Unknown\";refer_id|i:0;refer_id_visitor_id|i:0;visit_id|s:8:\"14492939\";refer_id_visit_id|i:0;', 1210421593, 'a71tumbdpdmrkju4gvl1u5bl16')

USA TODAY Cruise Log with Gene Sloan