Bicester and District table Tennis Club

SELECT ID, head, IF(LENGTH(item)> 50, CONCAT(SUBSTRING(item,1,50)," ..."),item) AS item, concat('Read item') as ReadItem, DATE_FORMAT(modified,'%D %b %y') AS modified, forcetop, forceverytop, modified as sortdate FROM newsitems WHERE deleted = 0 and inOldItems = 1 ORDER BY sortdate DESC ;

All News Items Older items