SELECT a.*,
b.name as `seller_name`,

concat('Kasse ', a.pos_id) as `pos_name`,

left(a.invoice_date, 10) as `date_1`,
concat(left(a.invoice_date, 13), ':00')  as `date_2`,
concat(left(a.invoice_date, 15), '0') as `date_3`,
left(a.invoice_date, 16) as `date_4`,

replace(cast(a.price as char), '.',',')  as `price_string`,
replace(cast(a.total as char), '.',',')  as `total_string`,

'1' as quantity

FROM `view_invoices` a
LEFT JOIN `sellers` b ON a.seller_id = b.seller_id