SELECT cs.shortname, cs.htmlname, ps1.content AS title, ps2.content AS content, concat( '../company/press/', filename, '.pdf' ) AS pdflink, concat( '../company/press/', filename, '.doc' ) AS wordlink, concat( '../company/press/', filename, '.zip' ) AS imagelink, concat( '../company/press/', filename, '_user_review.pdf' ) AS user_review
FROM customer_stories AS cs, page_sections AS ps1, page_sections AS ps2, products, product_customer_story AS pcs
LEFT JOIN press_releases ON ( press_releases.id = cs.press_release )
WHERE cs.intro = ps1.id
AND cs.full_page = ps2.id
AND products.id = pcs.productid
AND pcs.storyid = cs.id
ORDER BY cs.updated DESC 

#1054 - Unknown column 'cs.press_release' in 'on clause'