Q&A about the site for Joomla! administrators, users, developers and designers
select top 100 creationdate AS created_at,creationdate AS modified_at,ROUND(RAND(),0) AS channel,title,tags AS lead,body AS text ,ABS(CHECKSUM(NewId())) % 1 from Posts WHERE LEN(Title)>0