| 1234567891011121314151617 |
- 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
|
