select  CAST(CONCAT(''
, 'ls  /home/comptonpeslonline.com/public_html/comptonPractice/mediaFiles/audio/spxFiles/'
, LPAD(categoryNbr,2,'0')
, '/'
, LPAD(subCategoryNbr,2,'0')
, '/'
, subCategoryType
, '/'
, LPAD(subCategoryLabelOrder,2,'0')
, '/'
, LPAD(subCategoryDataOrder,2,'0')
, '.spx;'
) AS CHAR)

from  audioLabSubCategoryData
limit 10000
