SELECT c.Id, c.rootId, c.propsetId, c.functiongroup, c.rootId, c.OwnerId, c.ParentId, c.propsetId, c.Title, c.NavName, c.SortName, REPLACE(c.TextAlternative,'
', '
') AS TextAlternative, c.Short, c.Short AS Short1 , c.Short2, c.Short3, c.Short4, c.Short5, c.Url, c.ParagraphBreaks, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content,'
', '
'), c.Content) AS Content, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content,'
', '
'), c.Content) AS Content1, 'javascript:alert(\'FileLink is deprecated in version 3, use GetFile instead\');' AS FileLink,
IF (
c.FileName = '',
'javascript:alert(\'Sorry, file not available\');',
CONCAT('./tools/local/secureupload/content/FileName/', SUBSTRING_INDEX(c.FileName, ':::', -1))
) AS FileDirect,
IF (
c.FileName = '',
'[none]',
SUBSTRING_INDEX(c.FileName, ':::', 1)
) AS FileDisplay,
IF (
c.FileName = '',
'javascript:alert(\'Sorry, file not available\');',
CONCAT('./tools/software/3.0/go.php?toolscontext.publicstep=FileDownload&toolscontext.stepinput.entity=content&toolscontext.stepinput.property=FileName&toolscontext.stepinput.id=', c.Id)
) AS GetFile
, c.Thumbnail, CONCAT(c.Id, 't_', c.Thumbnail) AS Thumb, CONCAT(
'./tools/local/imageupload/',
IF (
c.Thumbnail = '',
'spacer.gif',
CONCAT('content/Thumbnail/size1/', SUBSTRING_INDEX(c.Thumbnail, ':::', -1))
)
) AS AutoThumb, CONCAT(
'./tools/local/imageupload/',
IF (
c.MainImage = '',
'spacer.gif',
CONCAT('content/MainImage/size1/', SUBSTRING_INDEX(c.MainImage, ':::', -1))
)
) AS AutoImage,
IF (
c.MainImage = '',
'../../../spacer.gif',
SUBSTRING_INDEX(c.MainImage, ':::', -1)
) AS AutoImageFile,
IF (
c.MainImage = '',
'[none]',
SUBSTRING_INDEX(c.MainImage, ':::', 1)
) AS AutoImageDisplay
, c.MainImage, CONCAT(c.Id, '_', c.FileName) AS Src, IF (c.FileName <> '', CONCAT('./tools/local/imageupload/', c.Id, '_', c.FileName), 'images/spacer.gif') AS AutoSrc, IF (c.Url <> '', c.Url, CONCAT('./pages/', IF (c.NavName <> '', c.NavName, c.Id), '/', REPLACE(c.Title,' ', '_'), '.htm')) AS AutoLink, c.Heading, c.Summary, IF (c.DisplayDate = '0000-00-00 00:00:00', '', DATE_FORMAT(c.DisplayDate, '%c/%e/%Y')) AS DisplayDate , UNIX_TIMESTAMP(c.DisplayDate) AS DisplayDateRaw , IF (c.DisplayDate = '0000-00-00 00:00:00', '', DATE_FORMAT(c.DisplayEnd, '%c/%e/%Y')) AS DisplayEnd, UNIX_TIMESTAMP(c.DisplayEnd) AS DisplayEndRaw , IF (c.DateCreated = '0000-00-00 00:00:00', '', DATE_FORMAT(c.DateCreated, '%c/%e/%Y')) AS DateCreated , UNIX_TIMESTAMP(c.DateCreated) AS DateCreatedRaw , IF (c.DateModified = '0000-00-00 00:00:00', '', DATE_FORMAT(c.DateModified, '%c/%e/%Y')) AS DateModified , UNIX_TIMESTAMP(c.DateModified) AS DateModifiedRaw , UNIX_TIMESTAMP(c.StartLive) AS StartLive, UNIX_TIMESTAMP(c.EndLive) AS EndLive, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content2,'
', '
'), c.Content2) AS Content2, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content3,'
', '
'), c.Content3) AS Content3, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content4,'
', '
'), c.Content4) AS Content4, IF (c.ParagraphBreaks <> 'html', REPLACE(c.Content5,'
', '
'), c.Content5) AS Content5, c.Short6, c.ProductId FROM (content c, propset ps , crossreference cr) WHERE (c.propsetId = ps.id AND ( 1 = 0 OR (
(
(
cr.ParentId IN (3805) AND cr.ChildId = c.Id
) OR (
cr.ChildId IN (3805) AND cr.ParentId = c.Id AND cr.Reversible = 'yes'
)
)
AND cr.Relationship IN('Subcategories')
)
)
AND c.propsetId IN (30016)
AND c.controlAccess IN ('', 'no')
AND c.Id IN() AND ( c.LiveOverride = 'always' OR
(c.LiveOverride = 'by date' AND
(c.StartLive <= NOW() AND
(c.EndLive >= NOW() OR c.EndLive = '0000-00-00 00:00:00')
)
)
)) GROUP BY c.Id ORDER BY c.SortName, c.Title
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND ( c.LiveOverride = 'always' OR
' at line 55
array (
1 =>
array (
'file' => '/home/banderas/public_html/tools/software/3.0/include/cms/api.inc.php',
'line' => 447,
'function' => 'rawQuery',
'class' => 'TOOLSCONTEXT_Storage_Sql',
'type' => '->',
'args' => ', SELECT c.Id, c.rootId, c.propsetId, c.functiongroup, c.rootId, c.OwnerId, c.ParentId, c.propsetId, c.Title, c.NavName, c.SortName, REPLACE(c.TextAlternative,\'
\', \'
\') AS TextAlternative, c.Short, c.Short AS Short1 , c.Short2, c.Short3, c.Short4, c.Short5, c.Url, c.ParagraphBreaks, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content,\'
\', \'
\'), c.Content) AS Content, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content,\'
\', \'
\'), c.Content) AS Content1, \'javascript:alert(\\\'FileLink is deprecated in version 3, use GetFile instead\\\');\' AS FileLink,
IF (
c.FileName = \'\',
\'javascript:alert(\\\'Sorry, file not available\\\');\',
CONCAT(\'./tools/local/secureupload/content/FileName/\', SUBSTRING_INDEX(c.FileName, \':::\', -1))
) AS FileDirect,
IF (
c.FileName = \'\',
\'[none]\',
SUBSTRING_INDEX(c.FileName, \':::\', 1)
) AS FileDisplay,
IF (
c.FileName = \'\',
\'javascript:alert(\\\'Sorry, file not available\\\');\',
CONCAT(\'./tools/software/3.0/go.php?toolscontext.publicstep=FileDownload&toolscontext.stepinput.entity=content&toolscontext.stepinput.property=FileName&toolscontext.stepinput.id=\', c.Id)
) AS GetFile
, c.Thumbnail, CONCAT(c.Id, \'t_\', c.Thumbnail) AS Thumb, CONCAT(
\'./tools/local/imageupload/\',
IF (
c.Thumbnail = \'\',
\'spacer.gif\',
CONCAT(\'content/Thumbnail/size1/\', SUBSTRING_INDEX(c.Thumbnail, \':::\', -1))
)
) AS AutoThumb, CONCAT(
\'./tools/local/imageupload/\',
IF (
c.MainImage = \'\',
\'spacer.gif\',
CONCAT(\'content/MainImage/size1/\', SUBSTRING_INDEX(c.MainImage, \':::\', -1))
)
) AS AutoImage,
IF (
c.MainImage = \'\',
\'../../../spacer.gif\',
SUBSTRING_INDEX(c.MainImage, \':::\', -1)
) AS AutoImageFile,
IF (
c.MainImage = \'\',
\'[none]\',
SUBSTRING_INDEX(c.MainImage, \':::\', 1)
) AS AutoImageDisplay
, c.MainImage, CONCAT(c.Id, \'_\', c.FileName) AS Src, IF (c.FileName <> \'\', CONCAT(\'./tools/local/imageupload/\', c.Id, \'_\', c.FileName), \'images/spacer.gif\') AS AutoSrc, IF (c.Url <> \'\', c.Url, CONCAT(\'./pages/\', IF (c.NavName <> \'\', c.NavName, c.Id), \'/\', REPLACE(c.Title,\' \', \'_\'), \'.htm\')) AS AutoLink, c.Heading, c.Summary, IF (c.DisplayDate = \'0000-00-00 00:00:00\', \'\', DATE_FORMAT(c.DisplayDate, \'%c/%e/%Y\')) AS DisplayDate , UNIX_TIMESTAMP(c.DisplayDate) AS DisplayDateRaw , IF (c.DisplayDate = \'0000-00-00 00:00:00\', \'\', DATE_FORMAT(c.DisplayEnd, \'%c/%e/%Y\')) AS DisplayEnd, UNIX_TIMESTAMP(c.DisplayEnd) AS DisplayEndRaw , IF (c.DateCreated = \'0000-00-00 00:00:00\', \'\', DATE_FORMAT(c.DateCreated, \'%c/%e/%Y\')) AS DateCreated , UNIX_TIMESTAMP(c.DateCreated) AS DateCreatedRaw , IF (c.DateModified = \'0000-00-00 00:00:00\', \'\', DATE_FORMAT(c.DateModified, \'%c/%e/%Y\')) AS DateModified , UNIX_TIMESTAMP(c.DateModified) AS DateModifiedRaw , UNIX_TIMESTAMP(c.StartLive) AS StartLive, UNIX_TIMESTAMP(c.EndLive) AS EndLive, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content2,\'
\', \'
\'), c.Content2) AS Content2, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content3,\'
\', \'
\'), c.Content3) AS Content3, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content4,\'
\', \'
\'), c.Content4) AS Content4, IF (c.ParagraphBreaks <> \'html\', REPLACE(c.Content5,\'
\', \'
\'), c.Content5) AS Content5, c.Short6, c.ProductId FROM (content c, propset ps , crossreference cr) WHERE (c.propsetId = ps.id AND ( 1 = 0 OR (
(
(
cr.ParentId IN (3805) AND cr.ChildId = c.Id
) OR (
cr.ChildId IN (3805) AND cr.ParentId = c.Id AND cr.Reversible = \'yes\'
)
)
AND cr.Relationship IN(\'Subcategories\')
)
)
AND c.propsetId IN (30016)
AND c.controlAccess IN (\'\', \'no\')
AND c.Id IN() AND ( c.LiveOverride = \'always\' OR
(c.LiveOverride = \'by date\' AND
(c.StartLive <= NOW() AND
(c.EndLive >= NOW() OR c.EndLive = \'0000-00-00 00:00:00\')
)
)
)) GROUP BY c.Id ORDER BY c.SortName, c.Title ',
),
2 =>
array (
'file' => '/home/banderas/public_html/tools/software/3.0/include/cms/api.inc.php',
'line' => 493,
'function' => 'getList',
'class' => 'TOOLSCONTEXT_CMS_API',
'type' => '->',
'args' => ', 3805, Array',
),
3 =>
array (
'file' => '/home/banderas/public_html/tools/compile/3/category_sub.php',
'line' => 78,
'function' => 'beginList',
'class' => 'TOOLSCONTEXT_CMS_API',
'type' => '->',
'args' => ', 3805, Array',
),
4 =>
array (
'file' => '/home/banderas/public_html/tools/software/3.0/include/cms/page.inc.php',
'line' => 59,
'args' => ', /home/banderas/public_html/tools/compile/3/category_sub.php',
'function' => 'require',
),
5 =>
array (
'file' => '/home/banderas/public_html/tools/software/3.0/include/master.inc.php',
'line' => 333,
'function' => 'getDisplay',
'class' => 'TOOLSCONTEXT_CMS_Page',
'type' => '->',
'args' => '',
),
6 =>
array (
'file' => '/home/banderas/public_html/pages',
'line' => 130,
'function' => 'getCMSDisplay',
'class' => 'TOOLSCONTEXT_Master',
'type' => '->',
'args' => ', diving-snorkeling, Array',
),
)