Message: |
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'S' in 'where clause', query was: (SELECT pp.portal_page_id,
(SELECT pd.portal_domain_name FROM portal_domains pd WHERE pp.portal_id = pd.portal_id AND pd.portal_domain_master = 1 AND pd.portal_domain_hidden = 0 LIMIT 1) AS portal_domain,
IF(pp.language_id = '1', pp.portal_page_url, CONCAT('/', l.language_code, pp.portal_page_url) ) AS portal_page_url
FROM aliases a, portal_pages pp, languages l
WHERE pp.language_id = l.language_id
AND pp.portal_page_id = a.portal_page_id
AND (SELECT p.page_status FROM pages p WHERE pp.page_id = p.page_id LIMIT 1) = 'ENABLED'
AND ( (a.alias_url = 'http://allthesonnets.co.uk/webapp/templates/main/rs-plugin/js/'+S+'' OR a.alias_url = '/webapp/templates/main/rs-plugin/js/'+S+'') OR (a.alias_url = 'http://allthesonnets.co.uk/webapp/templates/main/rs-plugin/js/'+S+'/' OR a.alias_url = '/webapp/templates/main/rs-plugin/js/'+S+'/') ) LIMIT 1) |