SELECT * FROM templates WHERE (name = 'intro') SELECT categ_id, descr, disp_seq_no, img_file, REPLACE(img_file, '.jpg', 'T.jpg') AS thumbnail FROM ec_categ WHERE (parent_id = '') AND (descr != 'new items') ORDER BY disp_seq_no;

- - - - -