You are not logged in.
 



 

Cover 01

Cover 02


Query Failure: SELECT c.Id, c.propsetId, c.ParentId, c.propsetId, c.Title, c.NavName, c.SortName, REPLACE(c.TextAlternative,' ', '
') AS TextAlternative, c.Short, 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, IF ( c.FileName = '', 'javascript:alert(\'Sorry, file not available\');', CONCAT('tools/software/original/public/filedownload.php?code=', SUBSTRING_INDEX(c.FileName, ':::', -1)) ) 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 , 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/', 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 , UNIX_TIMESTAMP(c.StartLive) AS StartLive, 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, pr.Id AS ProductId, pr.ItemId, pr.Price, pr.PriceNote, pr.Weight, pr.Taxable, pr.Shipping, pr.Availability, pr.QuantityAvailable, pr.ProductType, pr.DiscountedPrice, pr.DiscountQuantity, pr.NonTaxableAmount, pr.Options, pr.RecurringPrice, pr.RecurringPeriod FROM (content c, propset ps , product pr, crossreference cr) WHERE (c.propsetId = ps.id AND ( 1 = 0 OR ( ( ( cr.ParentId IN () AND cr.ChildId = c.Id ) OR ( cr.ChildId IN () AND cr.ParentId = c.Id AND cr.Reversible = 'yes' ) ) ) ) AND c.ProductId = pr.Id 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 cr.ChildId = c.Id ) OR ( cr.ChildId IN () AND cr.ParentId = c.I' at line 44