SELECT
`columns`.`id`,
UNIX_TIMESTAMP(`created`) as `created`,
UNIX_TIMESTAMP(`modified`) as `modified`,
`columns`.`name`,
`columns`.`columnscol`,
`columns`.`order`,
`columns`.`comment`
FROM `ccdb`.`columns`
WHERE `typeId` = 1
ORDER BY `columns`.`order`;
