SELECT * FROM ( (select 'blog' as type, ca.id, ca.old_id, '' as image_2_label, '' as image_3_label, '' as image_4_label, '' as issue, '' as image_label, '' as image_credit, ca.image_id, ca.have_image as image, ca.section_id, ca.date_created, ca.authors_id, ca.author_id, '' as npaper_link, '' as catalog_id, '' as catalog_page, ca.title, ca.subtitle, ca.content as intro_text, ca.content_output as intro_text_output, '' as section_name from users_blogs ca where (ca.authors_id LIKE '%x1492x%' or ca.author_id = '1492') and ca.active='1' and ca.date_created < '2014-04-17' ) UNION (select 'article' as type, ca.id, ca.old_id, ca.image_2_label, ca.image_3_label, ca.image_4_label, ca.issue, ca.image_label, ca.image_credit, ca.image_id, ca.image, ca.section_id, ca.date_created, ca.authors_id, ca.author_id, ca.npaper_link, ca.catalog_id, ca.catalog_page, ca.title, ca.subtitle, ca.intro_text, ca.intro_text_output, cs.section_name from cont_articles ca, cont_sections cs where ca.section_id=cs.id and ca.authors_id LIKE '%x1492x%' and ca.active='1' and ca.date_created < '2014-04-17' ) ) as tmp_table ORDER BY date_created desc
 
 
Home · Articles · By IVY LIN
 

Avenue of the Roses

A documentary filmmaker collects portraits of change along 82nd Avenue.


News Stories
I used to sneer at Chinatowns. I considered them tourist attractions that I wanted nothing to do with. I grew up in Taiwan with Chinese food and Chinese culture—what’s new to see in any ci   More
 
Wednesday, February 20, 2013 IVY LIN
Top Articles from IVY LIN
No articles in this section
 

Web Design for magazines

Close
Close
Close