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

Archived Features

Cheapskate (76)
Hitched (33)
Joke in a Box (2)
Night Cabbie (176)
Queer Window (345)
Updated on Wednesday, March 20, 2013

Arts & Books

Books (694)
Comedy and Variety (35)
Dance (41)
Fashion (159)
Performance (6)
Theater (587)
Visual Arts (282)
Updated on Wednesday, April 1, 2015

Features

Culture Features (94)
Featured Stories (597)
Findings (21)
Headout (399)
Headout Picks (121)
Outdoors (28)
Q & A (118)
Scoop (524)
Snow Report (5)
Street (25)
Willie Weed (33)
Updated on Wednesday, April 1, 2015

Food & Drink

Bar Reviews (361)
Drank (193)
Food Cart Reviews (93)
Food Reviews & Stories (4685)
Q & A (1)
z-Bite Club (108)
z-Eat Me (21)
z-Miss Dish (84)
Updated on Wednesday, April 1, 2015

Misc

Updated on Tuesday, November 30, 1999
 

Web Design for magazines

Close
Close
Close