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
 
 
WHAT SHOULD I BE DOING INSTEAD OF THIS?
 
Search: in Authors

Arts & Culture

Articulations (25)
Big Pig Gig (19)
Books (24)
CEA Theater (20)
CEA Theater (21)
Channel Surfing (18)
Cincitecture (20)
Classical Music (10)
Critics Picks (15)
Culture (83)
Curtain Call (361)
Dance (57)
Events (33)
Fine Tuning (20)
Focalpoint (20)
Fringe (257)
Gallery Hop (12)
Get Lit! (17)
Groove Tube (20)
Lit (168)
Look Here! (20)
Onstage (679)
Out There (5)
Quick Draw (4)
Shake It (20)
Television and Radio (20)
The Big Picture (195)
The Fine Print (14)
Visual Art (424)
Web Onstage (28)
Updated on Wednesday, November 19, 2014

Best Of Cincinnati

Arts & Entertainment (12)
Best Of Cincinnati (16)
Eats (12)
Jocks (13)
Public Eye (12)
Shops & Services (12)
Urban Life (12)
Updated on Wednesday, March 26, 2014

Cover Story

Cover Story (1157)
Updated on Wednesday, November 19, 2014

Food

Bite Me (85)
Cooks in the Kitchen (4)
Cravings (21)
Diner (779)
Dining (24)
Drink (31)
eatinglife (9)
Fermentations (43)
Look Who's Eating (67)
Lookwhos (23)
Lost in the Supermarket (48)
Lunchline (25)
Sidedish (5)
The Dish (189)
The Nook (11)
The Nosh Pit (16)
Uncorked! (20)
Updated on Wednesday, November 19, 2014

Multimedia

Live Chats (8)
Multimedia (78)
Updated on Wednesday, January 25, 2012

Promotions

Bengals Fan (32)
Live Nation (9)
More by Staff (1)
Promotions (2)
Updated on Monday, August 2, 2010

Screens

Close Up (7)
Couch Potato (218)
Film (346)
Movie Previews (412)
Movies (907)
Reel Answer (19)
Television (149)
Updated on Wednesday, November 19, 2014
 
Close
Close
Close