CMS Dialer Lightning database query help

OS Commerce Query
$static_query = "select CONCAT(customers_firstname,customers_lastname) as 'post_title', 12 as 'design_layout_id', customers_telephone as 'post_content',0  as content_type_id ,0 as content_type_value,'' as image_url,'no' as close_after, '#ffffff' as backcolor, '15,bold,#000000' as fldtext,'15,bold,#000000' as valtext,'#ffffff' as bccolor, ''as post_excerpt  from customers";
Opencart Query
select CONCAT(firstname,lastname) as 'post_title', 12 as 'design_layout_id', telephone as 'post_content',0  as content_type_id ,0 as content_type_value,'' as image_url,'no' as close_after, '#ffffff' as backcolor, '15,bold,#000000' as fldtext,'15,bold,#000000' as valtext,'#ffffff' as bccolor, ''as post_excerpt  from ocb4_customer