SELECT content_type, content_order, id, title, subtitle, old_id, image, image_id, intro_text, intro_text_output, date_created, time_created, author_id, author_name, section_name, section_id FROM ( (SELECT ('article') as content_type, (1) as content_order, ar.id as id, ar.title as title, ar.subtitle, ar.old_id, ar.image, ar.image_id, ar.intro_text, ar.intro_text_output, ar.date_created, ar.time_created, ar.author_id as author_id, au.author_name as author_name, ars.section_name, ars.id as section_id FROM cont_articles ar LEFT JOIN cont_authors au ON ar.author_id = au.id LEFT JOIN cont_sections as ars ON ar.section_id = ars.id WHERE ( MATCH(ar.title) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1 )UNION( SELECT ('article') as content_type, (20) as content_order, ar.id as id, ar.title as title, ar.subtitle, ar.old_id, ar.image, ar.image_id, ar.intro_text, ar.intro_text_output, ar.date_created, ar.time_created, ar.author_id as author_id, au.author_name as author_name, ars.section_name, ars.id as section_id FROM cont_articles ar LEFT JOIN cont_authors au ON ar.author_id = au.id LEFT JOIN cont_sections as ars ON ar.section_id = ars.id WHERE ( MATCH(au.author_name) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1 )UNION( SELECT ('article') as content_type, (10) as content_order, ar.id as id, ar.title as title, ar.subtitle, ar.old_id, ar.image, ar.image_id, ar.intro_text, ar.intro_text_output, ar.date_created, ar.time_created, ar.author_id as author_id, au.author_name as author_name, ars.section_name, ars.id as section_id FROM cont_articles ar LEFT JOIN cont_authors au ON ar.author_id = au.id LEFT JOIN cont_sections as ars ON ar.section_id = ars.id WHERE ( MATCH(ar.subtitle) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1 )UNION( SELECT ('blog') as content_type, (2) as content_order, ar.id as id, ar.title as title, ('') as subtitle, ar.old_id, ar.have_image as image, ar.image_id, ar.content as intro_text, ar.content_output as intro_text_output, ar.date_created, ar.time_created, ar.author_id as author_id, au.author_name as author_name, ars.section_name, ars.id as section_id FROM users_blogs ar LEFT JOIN cont_authors au ON ar.author_id = au.id LEFT JOIN blogs_sections as ars ON ar.section_id = ars.id WHERE ( MATCH(ar.title) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1 )UNION( SELECT ('blog') as content_type, (21) as content_order, ar.id as id, ar.title as title, ('') as subtitle, ar.old_id, ar.have_image as image, ar.image_id, ar.content as intro_text, ar.content_output as intro_text_output, ar.date_created, ar.time_created, ar.author_id as author_id, au.author_name as author_name, ars.section_name, ars.id as section_id FROM users_blogs ar LEFT JOIN cont_authors au ON ar.author_id = au.id LEFT JOIN blogs_sections as ars ON ar.section_id = ars.id WHERE ( MATCH(au.author_name) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1 )UNION( SELECT ('article') as content_type, (23) as content_order, ar.id as id, ar.title as title, ar.subtitle, ar.old_id, ar.image, ar.image_id, ar.intro_text, ar.intro_text_output, ar.date_created, ar.time_created, ar.author_id as author_id, au.author_name as author_name, ars.section_name, ars.id as section_id FROM cont_articles ar LEFT JOIN cont_authors au ON ar.author_id = au.id LEFT JOIN cont_sections as ars ON ar.section_id = ars.id WHERE ( MATCH(ar.intro_text_output) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1 )UNION( SELECT ('article') as content_type, (25) as content_order, ar.id as id, ar.title as title, ar.subtitle, ar.old_id, ar.image, ar.image_id, ar.intro_text, ar.intro_text_output, ar.date_created, ar.time_created, ar.author_id as author_id, au.author_name as author_name, ars.section_name, ars.id as section_id FROM cont_articles ar LEFT JOIN cont_authors au ON ar.author_id = au.id LEFT JOIN cont_sections as ars ON ar.section_id = ars.id WHERE ( MATCH(ar.content_output) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1 )UNION( SELECT ('blog') as content_type, (24) as content_order, ar.id as id, ar.title as title, ('') as subtitle, ar.old_id, ar.have_image as image, ar.image_id, ar.content as intro_text, ar.content_output as intro_text_output, ar.date_created, ar.time_created, ar.author_id as author_id, au.author_name as author_name, ars.section_name, ars.id as section_id FROM users_blogs ar LEFT JOIN cont_authors au ON ar.author_id = au.id LEFT JOIN blogs_sections as ars ON ar.section_id = ars.id WHERE ( MATCH(ar.content_output) AGAINST ('>' IN BOOLEAN MODE) ) AND active = 1 )) ToTal GROUP BY id ORDER BY content_order ASC, date_created DESC, time_created DESC, title ASC
 
 
Search: in Authors

Arts & Books

Books (679)
Comedy and Variety (23)
Dance (36)
Performance (3)
Theater (558)
Visual Arts (276)
Updated on Wednesday, November 19, 2014

Features

Cheapskate (76)
Culture Features (101)
Fashion (157)
Featured Stories (588)
Findings (2)
Headout (380)
Headout Picks (103)
Hitched (33)
Joke in a Box (2)
Night Cabbie (176)
Outdoors (28)
Q & A (113)
Queer Window (345)
Scoop (505)
Street (2)
Street (4)
Updated on Wednesday, November 19, 2014

Food & Drink

Bar Reviews (328)
Drank (167)
Food Cart Reviews (85)
Food Reviews & Stories (4641)
Q & A (1)
z-Bite Club (108)
z-Eat Me (21)
z-Miss Dish (84)
Updated on Wednesday, November 19, 2014

Movies

Brew Views (278)
DVD & TV (149)
Movie Reviews & Stories (1373)
Screen (42)
Updated on Wednesday, November 19, 2014
 

Web Design for magazines

Close
Close
Close