15/12/2023 09:09:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3989' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 09:09:30 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3989' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '124.50' , '103.04' , NOW() , NOW() ) 15/12/2023 09:09:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89492' 15/12/2023 09:09:30 am >> DELETE FROM ps_document_detail WHERE id_document = '89492' 15/12/2023 09:09:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89492' , '20004' , 'GESU BAMBINO CM 20 - BJ142-20E' , '1' , '-1' , '1' , '21.00' , '17.213114754098' , '22' , '0' , '21.00' ) 15/12/2023 09:09:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89492' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' , '-1' , '1' , '87.00' , '71.311475409836' , '22' , '0' , '87.00' ) 15/12/2023 09:09:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89492' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 15/12/2023 09:09:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89492' , '15589' , 'ANGELO CON STELLA ARG. - 4215' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 15/12/2023 09:15:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2996' AND id_document != '87532' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-10-03') 15/12/2023 09:15:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2996', document_date = '2023-10-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '87532' 15/12/2023 09:15:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87532' 15/12/2023 09:15:52 am >> DELETE FROM ps_document_detail WHERE id_document = '87532' 15/12/2023 09:15:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87532' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 15/12/2023 09:15:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87532' , '20117' , 'FATIMA CM 55 - 1036' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 15/12/2023 09:15:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87532' , '8166' , 'PORTACALICE - 18X35 - 726' , '1' , '-1' , '1' , '45.0000' , '36.885245901639' , '22' , '0' , '45.00' ) 15/12/2023 09:15:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87532' , '15589' , 'ANGELO CON STELLA ARG. - 4215' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 15/12/2023 09:33:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3990' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 09:33:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3990' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 15/12/2023 09:33:27 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89493' 15/12/2023 09:33:27 am >> DELETE FROM ps_document_detail WHERE id_document = '89493' 15/12/2023 09:33:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89493' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '2' , '-2' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '12.00' ) 15/12/2023 09:33:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89493' , '626' , 'ANGELO CUSTODE BABY 023 GA/9 BB' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/12/2023 09:47:21 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/12/2023 09:47:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21997' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 09:47:21 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21997' , '1' , '1' , '2' , NOW() , NOW() ) 15/12/2023 09:47:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21997' , '0' , '1' , '0' , '0' ) 15/12/2023 09:47:59 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788828210290' AND id_product != '21997' AND ean13 != '' 15/12/2023 09:47:59 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788828210290', date_upd = NOW() WHERE id_product = '21997' 15/12/2023 09:47:59 am >> UPDATE ps_product_lang SET name = 'UNA GIORNATA PARTICOLARE', description = '' WHERE id_product = '21997' 15/12/2023 09:47:59 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.5' WHERE id_product = '21997' 15/12/2023 09:47:59 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.5', id_tax_rules_group = '4', id_category_default = '452', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21997' 15/12/2023 09:47:59 am >> DELETE FROM ps_specific_price WHERE id_product = '21997' 15/12/2023 09:48:00 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21997' 15/12/2023 09:48:00 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21998' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 09:48:00 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21998' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21997' 15/12/2023 09:48:00 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21998' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21997' 15/12/2023 09:48:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788828212898' AND id_product != '21998' AND ean13 != '' 15/12/2023 09:48:33 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788828212898', date_upd = NOW() WHERE id_product = '21998' 15/12/2023 09:48:33 am >> UPDATE ps_product_lang SET name = 'VENTO SOFFIA DOVE VUOLE', description = '' WHERE id_product = '21998' 15/12/2023 09:48:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17' WHERE id_product = '21998' 15/12/2023 09:48:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17', id_tax_rules_group = '4', id_category_default = '452', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21998' 15/12/2023 09:48:33 am >> DELETE FROM ps_specific_price WHERE id_product = '21998' 15/12/2023 09:48:34 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21998' 15/12/2023 09:48:35 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21999' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 09:48:35 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21999' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21998' 15/12/2023 09:48:35 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21999' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21998' 15/12/2023 09:49:44 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807923876' AND id_product != '21999' AND ean13 != '' 15/12/2023 09:49:44 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788807923876', date_upd = NOW() WHERE id_product = '21999' 15/12/2023 09:49:44 am >> UPDATE ps_product_lang SET name = 'PIU BELLA DEL MONDO', description = '' WHERE id_product = '21999' 15/12/2023 09:49:44 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '21999' 15/12/2023 09:49:44 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '359', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21999' 15/12/2023 09:49:44 am >> DELETE FROM ps_specific_price WHERE id_product = '21999' 15/12/2023 09:49:45 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21999' 15/12/2023 09:49:45 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22000' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 09:49:45 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22000' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21999' 15/12/2023 09:49:45 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22000' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21999' 15/12/2023 09:50:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259853172' AND id_product != '22000' AND ean13 != '' 15/12/2023 09:50:19 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791259853172', date_upd = NOW() WHERE id_product = '22000' 15/12/2023 09:50:19 am >> UPDATE ps_product_lang SET name = 'VENDETTA DELLE MUSE', description = '' WHERE id_product = '22000' 15/12/2023 09:50:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22000' 15/12/2023 09:50:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '4', id_category_default = '533', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22000' 15/12/2023 09:50:19 am >> DELETE FROM ps_specific_price WHERE id_product = '22000' 15/12/2023 09:52:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 09:52:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3991' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 15/12/2023 09:52:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89494' 15/12/2023 09:52:44 am >> DELETE FROM ps_document_detail WHERE id_document = '89494' 15/12/2023 09:52:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89494' , '21653' , 'AGENDA DEVOZIONALE 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/12/2023 09:56:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259853172' AND id_product != '22000' AND ean13 != '' 15/12/2023 09:56:52 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791259853172', date_upd = NOW() WHERE id_product = '22000' 15/12/2023 09:56:52 am >> UPDATE ps_product_lang SET name = 'VENDETTA DELLE MUSE', description = '' WHERE id_product = '22000' 15/12/2023 09:56:52 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '22000' 15/12/2023 09:56:52 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '533', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22000' 15/12/2023 09:56:52 am >> DELETE FROM ps_specific_price WHERE id_product = '22000' 15/12/2023 10:18:38 am >> SELECT document_num FROM ps_document WHERE document_num = '3992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 10:18:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3992' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '14.75' , NOW() , NOW() ) 15/12/2023 10:18:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89495' 15/12/2023 10:18:38 am >> DELETE FROM ps_document_detail WHERE id_document = '89495' 15/12/2023 10:18:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89495' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '3' , '-3' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '18.00' ) 15/12/2023 10:31:34 am >> SELECT document_num FROM ps_document WHERE document_num = '143/A' AND id_document != '89441' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-12') 15/12/2023 10:31:34 am >> UPDATE ps_document SET id_document_type = '24', document_num = '143/A', document_date = '2023-12-12', document_letter = 'A', id_customer = '4073', id_supplier = '', id_address = '4679226', address1 = 'PIAZZA B. GERMANO 84029 SICIGNANO DEGLI ALBURNI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1079.10', price_tax_excluded = '1079.10', date_upd = NOW() WHERE id_document = '89441' 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89441' 15/12/2023 10:31:34 am >> DELETE FROM ps_document_detail WHERE id_document = '89441' 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '0' , 'DETERMINA N. 118 DEL 21/11/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '0' , 'FORNITURA LIBRI PER LA BIBLIOTECA COMUNALE A SEGUITO DI ASSEGNAZIONE CONTRIBUTO - DECRETO MINISTERO ' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21978' , 'TUTTE LE POESIE - CAPRONI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21983' , 'ORA DARTE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21977' , 'LE POESIE - ROSSELLI' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21976' , 'PRIMO CAFFE DELLA GIORNATA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21982' , 'COSCIENZA DELLE PAROLE' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21972' , 'AUTO DA FE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21973' , 'HOMO SACER' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21975' , 'ARARAT' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21979' , 'IRIS SELVATICO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21964' , 'NOTTE FEDELE E VIRTUOSA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21980' , 'LA FINE DELLA STORIA E LULTIMO UOMO' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21981' , 'CHE COSE LA FILOSOFIA?' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21967' , 'MODERNITA LIQUIDA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21965' , 'SI STA FACENDO SEMPRE PIU TARDI' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21966' , 'LA CONDIZIONE POSTMODERNA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21970' , 'TRA LE NOSTRE PAROLE' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21962' , 'LE AVANGUARDIE ARTISTICHE DEL NOVECENTO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21963' , 'LOSPITE INQUIETANTE' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21968' , 'LA SOCIETA DELLO SPETTACOLO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:31:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21969' , 'IO NON SONO UN POETA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21971' , 'COME ORDINARE UNA BIBLIOTECA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21960' , 'INTERVISTE IMPOSSIBILI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21961' , 'DIARIO DEGLI ERRORI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21974' , 'FASCISMO ETERNO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21912' , 'POETI ITALIANI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21910' , 'ITALO CALVINO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21911' , 'GEOPOLITICA UMANA' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21913' , 'VITA 3.0' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21914' , 'LIBRO DELLA STORIA LGBTQ+' , '1' , '-1' , '4' , '24.9000' , '24.9' , '0' , '0' , '24.90' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21944' , 'APPUNTI 1942-1993' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21948' , 'BUCHI BIANCHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21946' , 'SALUTZ 1984-1986' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21951' , 'VERSO IL PARADISO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21950' , 'VITA MIA DACIA MARAINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21699' , 'PAOLO - C. AUGIAS' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21957' , 'LUOMO CHE SCAMBIO SUA MOGLIE PER UN CAPPELLO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21943' , 'IL MARE NON BAGNA NAPOLI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21936' , 'KITCHEN' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21935' , 'MARIGOLD E ROSE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21947' , 'IL GIOCO DEGLI OCCHI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21939' , 'HOMO DEUS' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21941' , 'SACRO MINORE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21940' , 'CARO PIER PAOLO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21949' , 'LA GIOIA DI SCRIVERE' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21952' , 'METAFISICA CONCRETA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21942' , 'STORIA DELLA BELLEZZA' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21945' , ' 1 Q 84 LIBRO 3' , '1' , '-1' , '4' , '14.5000' , '14.5' , '0' , '0' , '14.50' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21937' , 'ALLARME ALLARME I PRIORI FANNO CARNE!' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21938' , 'DONNE CHE PENSANO TROPPO' , '1' , '-1' , '4' , '18.9000' , '18.9' , '0' , '0' , '18.90' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21953' , 'FA BENE O FA MALE?' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21956' , 'KAFKA SULLA SPIAGGIA' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '0' , '15.50' ) 15/12/2023 10:31:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21955' , 'LA SPERANZA AFRICANA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:31:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21954' , 'QUANDO ERAVAMO I PADRONI DEL MONDO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:31:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21958' , 'LERA DELLINTELLIGENZA ARTIFICIALE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:31:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21994' , 'DIECI COSE CHE HO IMPARATO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:31:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21995' , 'TUTTE LE POESIE - G. GIUDICI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 15/12/2023 10:31:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21993' , 'CALIFORNIA' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 15/12/2023 10:31:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21992' , 'VITA LIQUIDA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:31:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21997' , 'UNA GIORNATA PARTICOLARE' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '0' , '19.50' ) 15/12/2023 10:31:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21999' , 'PIU BELLA DEL MONDO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:31:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '21998' , 'VENTO SOFFIA DOVE VUOLE' , '1' , '-1' , '4' , '17.00' , '17' , '0' , '0' , '17.00' ) 15/12/2023 10:31:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89441' , '22000' , 'VENDETTA DELLE MUSE' , '1' , '-1' , '4' , '17.9' , '17.9' , '0' , '0' , '17.90' ) 15/12/2023 10:40:13 am >> SELECT document_num FROM ps_document WHERE document_num = '5/PA' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 10:40:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '23' , '5/PA' , '2023-12-15' , 'PA' , '4073' , '0' , '4679226' , 'PIAZZA B. GERMANO 84029 SICIGNANO DEGLI ALBURNI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1079.10' , '1079.10' , NOW() , NOW() ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89496' 15/12/2023 10:40:13 am >> DELETE FROM ps_document_detail WHERE id_document = '89496' 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '0' , 'DETERMINA N. 118 DEL 21/11/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '0' , 'FORNITURA LIBRI PER LA BIBLIOTECA COMUNALE A SEGUITO DI ASSEGNAZIONE CONTRIBUTO - DECRETO MINISTERO DELLA CULTURA - DIREZIONE GENERALE BIBLIOTECHE E DIRITTO D\'AUTORE N. 614 DEL 22.08.2023. PROVVEDIMENTI. CIG: Z903D5E745.' , '0' , '0' , '0' , '0.0000' , '0' , '' , '0' , '0.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21978' , 'TUTTE LE POESIE - CAPRONI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21983' , 'ORA DARTE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21977' , 'LE POESIE - ROSSELLI' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21976' , 'PRIMO CAFFE DELLA GIORNATA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21982' , 'COSCIENZA DELLE PAROLE' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21972' , 'AUTO DA FE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21973' , 'HOMO SACER' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21975' , 'ARARAT' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21979' , 'IRIS SELVATICO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21964' , 'NOTTE FEDELE E VIRTUOSA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21980' , 'LA FINE DELLA STORIA E LULTIMO UOMO' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 15/12/2023 10:40:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21981' , 'CHE COSE LA FILOSOFIA?' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21967' , 'MODERNITA LIQUIDA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21965' , 'SI STA FACENDO SEMPRE PIU TARDI' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21966' , 'LA CONDIZIONE POSTMODERNA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21970' , 'TRA LE NOSTRE PAROLE' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21962' , 'LE AVANGUARDIE ARTISTICHE DEL NOVECENTO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21963' , 'LOSPITE INQUIETANTE' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21968' , 'LA SOCIETA DELLO SPETTACOLO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21969' , 'IO NON SONO UN POETA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21971' , 'COME ORDINARE UNA BIBLIOTECA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21960' , 'INTERVISTE IMPOSSIBILI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21961' , 'DIARIO DEGLI ERRORI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21974' , 'FASCISMO ETERNO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21912' , 'POETI ITALIANI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21910' , 'ITALO CALVINO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21911' , 'GEOPOLITICA UMANA' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21913' , 'VITA 3.0' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21914' , 'LIBRO DELLA STORIA LGBTQ+' , '1' , '-1' , '4' , '24.9000' , '24.9' , '0' , '0' , '24.90' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21944' , 'APPUNTI 1942-1993' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21948' , 'BUCHI BIANCHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21946' , 'SALUTZ 1984-1986' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21951' , 'VERSO IL PARADISO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21950' , 'VITA MIA DACIA MARAINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21699' , 'PAOLO - C. AUGIAS' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21957' , 'LUOMO CHE SCAMBIO SUA MOGLIE PER UN CAPPELLO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21943' , 'IL MARE NON BAGNA NAPOLI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21936' , 'KITCHEN' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21935' , 'MARIGOLD E ROSE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21947' , 'IL GIOCO DEGLI OCCHI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21939' , 'HOMO DEUS' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21941' , 'SACRO MINORE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21940' , 'CARO PIER PAOLO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21949' , 'LA GIOIA DI SCRIVERE' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21952' , 'METAFISICA CONCRETA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21942' , 'STORIA DELLA BELLEZZA' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21945' , ' 1 Q 84 LIBRO 3' , '1' , '-1' , '4' , '14.5000' , '14.5' , '0' , '0' , '14.50' ) 15/12/2023 10:40:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21937' , 'ALLARME ALLARME I PRIORI FANNO CARNE!' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21938' , 'DONNE CHE PENSANO TROPPO' , '1' , '-1' , '4' , '18.9000' , '18.9' , '0' , '0' , '18.90' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21953' , 'FA BENE O FA MALE?' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21956' , 'KAFKA SULLA SPIAGGIA' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '0' , '15.50' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21955' , 'LA SPERANZA AFRICANA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21954' , 'QUANDO ERAVAMO I PADRONI DEL MONDO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21958' , 'LERA DELLINTELLIGENZA ARTIFICIALE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21994' , 'DIECI COSE CHE HO IMPARATO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21995' , 'TUTTE LE POESIE - G. GIUDICI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21993' , 'CALIFORNIA' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21992' , 'VITA LIQUIDA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21997' , 'UNA GIORNATA PARTICOLARE' , '1' , '-1' , '4' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21999' , 'PIU BELLA DEL MONDO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21998' , 'VENTO SOFFIA DOVE VUOLE' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 15/12/2023 10:40:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '22000' , 'VENDETTA DELLE MUSE' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 15/12/2023 10:40:33 am >> SELECT document_num FROM ps_document WHERE document_num = '5/PA' AND id_document != '89496' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 10:40:33 am >> UPDATE ps_document SET id_document_type = '23', document_num = '5/PA', document_date = '2023-12-15', document_letter = 'PA', id_customer = '4073', id_supplier = '', id_address = '4679226', address1 = 'PIAZZA B. GERMANO 84029 SICIGNANO DEGLI ALBURNI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '1079.10', price_tax_excluded = '1079.10', date_upd = NOW() WHERE id_document = '89496' 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89496' 15/12/2023 10:40:33 am >> DELETE FROM ps_document_detail WHERE id_document = '89496' 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '0' , 'DETERMINA N. 118 DEL 21/11/2023' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '0' , 'FORNITURA LIBRI PER LA BIBLIOTECA COMUNALE A SEGUITO DI ASSEGNAZIONE CONTRIBUTO - DECRETO MINISTERO ' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21978' , 'TUTTE LE POESIE - CAPRONI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21983' , 'ORA DARTE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21977' , 'LE POESIE - ROSSELLI' , '1' , '-1' , '4' , '26.0000' , '26' , '0' , '0' , '26.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21976' , 'PRIMO CAFFE DELLA GIORNATA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21982' , 'COSCIENZA DELLE PAROLE' , '1' , '-1' , '4' , '28.0000' , '28' , '0' , '0' , '28.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21972' , 'AUTO DA FE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21973' , 'HOMO SACER' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21975' , 'ARARAT' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21979' , 'IRIS SELVATICO' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21964' , 'NOTTE FEDELE E VIRTUOSA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21980' , 'LA FINE DELLA STORIA E LULTIMO UOMO' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21981' , 'CHE COSE LA FILOSOFIA?' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21967' , 'MODERNITA LIQUIDA' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21965' , 'SI STA FACENDO SEMPRE PIU TARDI' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '0' , '11.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21966' , 'LA CONDIZIONE POSTMODERNA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21970' , 'TRA LE NOSTRE PAROLE' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21962' , 'LE AVANGUARDIE ARTISTICHE DEL NOVECENTO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21963' , 'LOSPITE INQUIETANTE' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21968' , 'LA SOCIETA DELLO SPETTACOLO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21969' , 'IO NON SONO UN POETA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21971' , 'COME ORDINARE UNA BIBLIOTECA' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21960' , 'INTERVISTE IMPOSSIBILI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21961' , 'DIARIO DEGLI ERRORI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21974' , 'FASCISMO ETERNO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '0' , '6.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21912' , 'POETI ITALIANI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:40:33 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21910' , 'ITALO CALVINO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21911' , 'GEOPOLITICA UMANA' , '1' , '-1' , '4' , '14.9000' , '14.9' , '0' , '0' , '14.90' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21913' , 'VITA 3.0' , '1' , '-1' , '4' , '29.0000' , '29' , '0' , '0' , '29.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21914' , 'LIBRO DELLA STORIA LGBTQ+' , '1' , '-1' , '4' , '24.9000' , '24.9' , '0' , '0' , '24.90' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21944' , 'APPUNTI 1942-1993' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21948' , 'BUCHI BIANCHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21946' , 'SALUTZ 1984-1986' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21951' , 'VERSO IL PARADISO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21950' , 'VITA MIA DACIA MARAINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21699' , 'PAOLO - C. AUGIAS' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21957' , 'LUOMO CHE SCAMBIO SUA MOGLIE PER UN CAPPELLO' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21943' , 'IL MARE NON BAGNA NAPOLI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21936' , 'KITCHEN' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21935' , 'MARIGOLD E ROSE' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '0' , '10.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21947' , 'IL GIOCO DEGLI OCCHI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21939' , 'HOMO DEUS' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21941' , 'SACRO MINORE' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21940' , 'CARO PIER PAOLO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21949' , 'LA GIOIA DI SCRIVERE' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21952' , 'METAFISICA CONCRETA' , '1' , '-1' , '4' , '38.0000' , '38' , '0' , '0' , '38.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21942' , 'STORIA DELLA BELLEZZA' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21945' , ' 1 Q 84 LIBRO 3' , '1' , '-1' , '4' , '14.5000' , '14.5' , '0' , '0' , '14.50' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21937' , 'ALLARME ALLARME I PRIORI FANNO CARNE!' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21938' , 'DONNE CHE PENSANO TROPPO' , '1' , '-1' , '4' , '18.9000' , '18.9' , '0' , '0' , '18.90' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21953' , 'FA BENE O FA MALE?' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21956' , 'KAFKA SULLA SPIAGGIA' , '1' , '-1' , '4' , '15.5000' , '15.5' , '0' , '0' , '15.50' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21955' , 'LA SPERANZA AFRICANA' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21954' , 'QUANDO ERAVAMO I PADRONI DEL MONDO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21958' , 'LERA DELLINTELLIGENZA ARTIFICIALE' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '0' , '20.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21994' , 'DIECI COSE CHE HO IMPARATO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21995' , 'TUTTE LE POESIE - G. GIUDICI' , '1' , '-1' , '4' , '30.0000' , '30' , '0' , '0' , '30.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21993' , 'CALIFORNIA' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '0' , '18.50' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21992' , 'VITA LIQUIDA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21997' , 'UNA GIORNATA PARTICOLARE' , '1' , '-1' , '4' , '19.5000' , '19.5' , '0' , '0' , '19.50' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21999' , 'PIU BELLA DEL MONDO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '21998' , 'VENTO SOFFIA DOVE VUOLE' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '0' , '17.00' ) 15/12/2023 10:40:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89496' , '22000' , 'VENDETTA DELLE MUSE' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 15/12/2023 10:45:10 am >> DELETE FROM ps_document WHERE id_document = '89441' 15/12/2023 10:45:10 am >> DELETE FROM ps_document_detail WHERE id_document = '89441' 15/12/2023 10:56:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '651870' , '2023-12-13' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '17.53' , '4' , '0' , '0' , '0' , '' , '14' , '0' , '501.52' , '501.52' , NOW() , NOW() ) 15/12/2023 10:56:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89497' 15/12/2023 10:56:00 am >> DELETE FROM ps_document_detail WHERE id_document = '89497' 15/12/2023 10:56:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89497' , '5451' , 'IO SONO CON VOI - GUIDA 2 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+15' , '6.6300' ) 15/12/2023 10:56:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '5451' AND id_supplier = '7' 15/12/2023 10:56:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5451' , '7' , '1' ) 15/12/2023 10:56:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89497' , '5450' , 'IO SONO CON VOI - GUIDA 1 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+15' , '6.6300' ) 15/12/2023 10:56:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '5450' AND id_supplier = '7' 15/12/2023 10:56:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5450' , '7' , '1' ) 15/12/2023 10:56:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89497' , '9681' , 'SARETE MIEI TESTIMONI - GUIDA 2 - MAGNIFICAT' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35+15' , '6.6300' ) 15/12/2023 10:56:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '9681' AND id_supplier = '7' 15/12/2023 10:56:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9681' , '7' , '1' ) 15/12/2023 10:56:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89497' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '50' , '50' , '4' , '3.00' , '3' , '0' , '35+15' , '82.8750' ) 15/12/2023 10:56:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '8598' AND id_supplier = '7' 15/12/2023 10:56:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8598' , '7' , '1' ) 15/12/2023 10:56:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89497' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '80' , '80' , '4' , '3.00' , '3' , '0' , '35+15' , '132.6000' ) 15/12/2023 10:56:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '8599' AND id_supplier = '7' 15/12/2023 10:56:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8599' , '7' , '1' ) 15/12/2023 10:56:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89497' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '100' , '100' , '4' , '3.00' , '3' , '0' , '35+15' , '165.7500' ) 15/12/2023 10:56:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '8602' AND id_supplier = '7' 15/12/2023 10:56:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8602' , '7' , '1' ) 15/12/2023 10:56:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89497' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '50' , '50' , '4' , '3.00' , '3' , '0' , '35+15' , '82.8750' ) 15/12/2023 10:56:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '8603' AND id_supplier = '7' 15/12/2023 10:56:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8603' , '7' , '1' ) 15/12/2023 11:01:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 11:01:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3993' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.10' , '103.36' , NOW() , NOW() ) 15/12/2023 11:01:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89498' 15/12/2023 11:01:26 am >> DELETE FROM ps_document_detail WHERE id_document = '89498' 15/12/2023 11:01:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89498' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '51' , '-51' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '66.30' ) 15/12/2023 11:01:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89498' , '20158' , 'CASETTA NATIVITA - 23/97NAT04' , '21' , '-21' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '27.30' ) 15/12/2023 11:01:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89498' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '25' , '-25' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '32.50' ) 15/12/2023 11:08:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3984' AND id_document != '89487' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-14') 15/12/2023 11:08:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3984', document_date = '2023-12-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.90', price_tax_excluded = '3.20', date_upd = NOW() WHERE id_document = '89487' 15/12/2023 11:08:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89487' 15/12/2023 11:08:50 am >> DELETE FROM ps_document_detail WHERE id_document = '89487' 15/12/2023 11:08:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89487' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '3' , '-3' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '3.90' ) 15/12/2023 11:10:52 am >> SELECT document_num FROM ps_document WHERE document_num = '3994' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 11:10:52 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3994' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 15/12/2023 11:10:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89499' 15/12/2023 11:10:52 am >> DELETE FROM ps_document_detail WHERE id_document = '89499' 15/12/2023 11:10:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89499' , '15261' , 'MEDAGLIA SAN BENEDETTO' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 15/12/2023 11:11:31 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 15/12/2023 11:11:31 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22001' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 11:11:31 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22001' , '1' , '1' , '2' , NOW() , NOW() ) 15/12/2023 11:11:31 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22001' , '0' , '1' , '0' , '0' ) 15/12/2023 11:12:36 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831556330' AND id_product != '22001' AND ean13 != '' 15/12/2023 11:12:36 am >> UPDATE ps_product SET id_supplier = '', reference = '13/4', ean13 = '9788831556330', date_upd = NOW() WHERE id_product = '22001' 15/12/2023 11:12:36 am >> UPDATE ps_product_lang SET name = 'VERRO\' A TROVARTI TUTTE LE VOLTE CHE VORRAI - S. ZAMPA', description = '' WHERE id_product = '22001' 15/12/2023 11:12:36 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '22001' 15/12/2023 11:12:36 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22001' 15/12/2023 11:12:36 am >> DELETE FROM ps_specific_price WHERE id_product = '22001' 15/12/2023 11:12:37 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22001' 15/12/2023 11:12:37 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22002' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 11:12:37 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22002' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22001' 15/12/2023 11:12:37 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22002' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22001' 15/12/2023 11:13:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243477' AND id_product != '22002' AND ean13 != '' 15/12/2023 11:13:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788892243477', date_upd = NOW() WHERE id_product = '22002' 15/12/2023 11:13:20 am >> UPDATE ps_product_lang SET name = 'DOMENICA DELLA PAROLA 2024', description = '' WHERE id_product = '22002' 15/12/2023 11:13:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2.9' WHERE id_product = '22002' 15/12/2023 11:13:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2.9', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22002' 15/12/2023 11:13:20 am >> DELETE FROM ps_specific_price WHERE id_product = '22002' 15/12/2023 11:13:21 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22002' 15/12/2023 11:13:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22003' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 11:13:21 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22003' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22002' 15/12/2023 11:13:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22003' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22002' 15/12/2023 11:15:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240087' AND id_product != '22003' AND ean13 != '' 15/12/2023 11:15:07 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788892240087', date_upd = NOW() WHERE id_product = '22003' 15/12/2023 11:15:07 am >> UPDATE ps_product_lang SET name = 'IMPARARE A PREGARE - C.M. MARTINI', description = '' WHERE id_product = '22003' 15/12/2023 11:15:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22003' 15/12/2023 11:15:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22003' 15/12/2023 11:15:08 am >> DELETE FROM ps_specific_price WHERE id_product = '22003' 15/12/2023 11:15:08 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22003' 15/12/2023 11:15:08 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22004' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 11:15:08 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22004' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22003' 15/12/2023 11:15:08 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22004' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22003' 15/12/2023 11:15:57 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240094' AND id_product != '22004' AND ean13 != '' 15/12/2023 11:15:57 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788892240094', date_upd = NOW() WHERE id_product = '22004' 15/12/2023 11:15:57 am >> UPDATE ps_product_lang SET name = 'PREGHIERA DEL CRISTIANO - C.M. MARTINI', description = '' WHERE id_product = '22004' 15/12/2023 11:15:57 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22004' 15/12/2023 11:15:57 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22004' 15/12/2023 11:15:57 am >> DELETE FROM ps_specific_price WHERE id_product = '22004' 15/12/2023 11:15:58 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22004' 15/12/2023 11:15:58 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22005' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 11:15:58 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22005' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22004' 15/12/2023 11:15:58 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22005' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22004' 15/12/2023 11:17:28 am >> SELECT document_num FROM ps_document WHERE document_num = '3995' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 11:17:28 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3995' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.95' , '4.87' , NOW() , NOW() ) 15/12/2023 11:17:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89500' 15/12/2023 11:17:28 am >> DELETE FROM ps_document_detail WHERE id_document = '89500' 15/12/2023 11:17:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89500' , '16710' , 'MESSAGGIO DI TENEREZZA - 17' , '3' , '-3' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '0.45' ) 15/12/2023 11:17:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89500' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 15/12/2023 11:17:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89500' , '13840' , 'NONNI SONO UN TESORO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 15/12/2023 11:17:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89500' , '21201' , 'PREGHIERA DEI 14 GRAZIE - PAPA FRANCESCO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 15/12/2023 11:17:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89500' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.6' , '0.6' , '0' , '0' , '0.60' ) 15/12/2023 11:18:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892242807' AND id_product != '22005' AND ean13 != '' 15/12/2023 11:18:38 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788892242807', date_upd = NOW() WHERE id_product = '22005' 15/12/2023 11:18:38 am >> UPDATE ps_product_lang SET name = 'PATTO EDUCATIVO GLOBALE - D. SIMEONE', description = '' WHERE id_product = '22005' 15/12/2023 11:18:38 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22005' 15/12/2023 11:18:38 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22005' 15/12/2023 11:18:38 am >> DELETE FROM ps_specific_price WHERE id_product = '22005' 15/12/2023 11:18:39 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22005' 15/12/2023 11:18:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22006' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 11:18:39 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22006' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22005' 15/12/2023 11:18:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22006' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22005' 15/12/2023 11:19:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243453' AND id_product != '22006' AND ean13 != '' 15/12/2023 11:19:19 am >> UPDATE ps_product SET id_supplier = '', reference = '7/1', ean13 = '9788892243453', date_upd = NOW() WHERE id_product = '22006' 15/12/2023 11:19:19 am >> UPDATE ps_product_lang SET name = 'BENEDETTO E FRANCESCO - R. VIRGILI', description = '' WHERE id_product = '22006' 15/12/2023 11:19:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '22006' 15/12/2023 11:19:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22006' 15/12/2023 11:19:19 am >> DELETE FROM ps_specific_price WHERE id_product = '22006' 15/12/2023 11:19:20 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22006' 15/12/2023 11:19:20 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22007' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 11:19:20 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22007' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22006' 15/12/2023 11:19:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22007' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22006' 15/12/2023 11:20:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788882276126' AND id_product != '22007' AND ean13 != '' 15/12/2023 11:20:41 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788882276126', date_upd = NOW() WHERE id_product = '22007' 15/12/2023 11:20:41 am >> UPDATE ps_product_lang SET name = 'BELLEZZA NASCOSTA IN TE - G. DALYATA', description = '' WHERE id_product = '22007' 15/12/2023 11:20:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '22007' 15/12/2023 11:20:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '248', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22007' 15/12/2023 11:20:42 am >> DELETE FROM ps_specific_price WHERE id_product = '22007' 15/12/2023 11:20:42 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22007' 15/12/2023 11:20:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22008' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 11:20:42 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22008' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22007' 15/12/2023 11:20:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22008' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22007' 15/12/2023 11:23:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895060927' AND id_product != '22008' AND ean13 != '' 15/12/2023 11:23:19 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788895060927', date_upd = NOW() WHERE id_product = '22008' 15/12/2023 11:23:19 am >> UPDATE ps_product_lang SET name = 'DUE PICCOLI PESCI - CALENDARIO 2024', description = '' WHERE id_product = '22008' 15/12/2023 11:23:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '6.9' WHERE id_product = '22008' 15/12/2023 11:23:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '6.9', id_tax_rules_group = '4', id_category_default = '250', id_argoment_default = '107', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22008' 15/12/2023 11:23:19 am >> DELETE FROM ps_specific_price WHERE id_product = '22008' 15/12/2023 11:23:19 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22008' 15/12/2023 11:23:19 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22009' , '1' , '' , 'nuovo-prodotto' ) 15/12/2023 11:23:20 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22009' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22008' 15/12/2023 11:23:20 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22009' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22008' 15/12/2023 11:23:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '651869' , '2023-12-13' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.47' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '156.93' , '156.93' , NOW() , NOW() ) 15/12/2023 11:23:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89501' 15/12/2023 11:23:49 am >> DELETE FROM ps_document_detail WHERE id_document = '89501' 15/12/2023 11:23:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '22001' , 'VERRO A TROVARTI TUTTE LE VOLTE CHE VORRAI - S. ZAMPA' , '1' , '1' , '4' , '6.90' , '6.9' , '0' , '33' , '4.6230' ) 15/12/2023 11:23:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22001' AND id_supplier = '7' 15/12/2023 11:23:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22001' , '7' , '1' ) 15/12/2023 11:23:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '22002' , 'DOMENICA DELLA PAROLA 2024' , '12' , '12' , '4' , '2.90' , '2.9' , '0' , '33' , '23.3160' ) 15/12/2023 11:23:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22002' AND id_supplier = '7' 15/12/2023 11:23:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22002' , '7' , '1' ) 15/12/2023 11:23:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '22002' , 'DOMENICA DELLA PAROLA 2024' , '1' , '1' , '4' , '2.90' , '2.9' , '0' , '100' , '0.0000' ) 15/12/2023 11:23:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22002' AND id_supplier = '7' 15/12/2023 11:23:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22002' , '7' , '1' ) 15/12/2023 11:23:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '22003' , 'IMPARARE A PREGARE - C.M. MARTINI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 15/12/2023 11:23:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22003' AND id_supplier = '7' 15/12/2023 11:23:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22003' , '7' , '1' ) 15/12/2023 11:23:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '22004' , 'PREGHIERA DEL CRISTIANO - C.M. MARTINI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '33' , '8.0400' ) 15/12/2023 11:23:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22004' AND id_supplier = '7' 15/12/2023 11:23:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22004' , '7' , '1' ) 15/12/2023 11:23:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '22005' , 'PATTO EDUCATIVO GLOBALE - D. SIMEONE' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 15/12/2023 11:23:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22005' AND id_supplier = '7' 15/12/2023 11:23:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22005' , '7' , '1' ) 15/12/2023 11:23:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '22006' , 'BENEDETTO E FRANCESCO - R. VIRGILI' , '1' , '1' , '4' , '16.00' , '16' , '0' , '33' , '10.7200' ) 15/12/2023 11:23:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '22006' AND id_supplier = '7' 15/12/2023 11:23:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22006' , '7' , '1' ) 15/12/2023 11:23:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '3604' , 'DOCUMENTI DEL CONCILIO VATICANO II' , '1' , '1' , '4' , '16.50' , '16.5' , '0' , '33' , '11.0550' ) 15/12/2023 11:23:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '3604' AND id_supplier = '7' 15/12/2023 11:23:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3604' , '7' , '1' ) 15/12/2023 11:23:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '4842' , 'HUMANAE VITAE' , '1' , '1' , '4' , '2.00' , '2' , '0' , '33' , '1.3400' ) 15/12/2023 11:23:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '4842' AND id_supplier = '7' 15/12/2023 11:23:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4842' , '7' , '1' ) 15/12/2023 11:23:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '9338' , 'SACROSANCTUM CONCILIUM' , '2' , '2' , '4' , '2.50' , '2.5' , '0' , '33' , '3.3500' ) 15/12/2023 11:23:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '9338' AND id_supplier = '7' 15/12/2023 11:23:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9338' , '7' , '1' ) 15/12/2023 11:23:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '22007' , 'BELLEZZA NASCOSTA IN TE - G. DALYATA' , '4' , '4' , '4' , '22.00' , '22' , '0' , '30' , '61.6000' ) 15/12/2023 11:23:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '22007' AND id_supplier = '7' 15/12/2023 11:23:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22007' , '7' , '1' ) 15/12/2023 11:23:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89501' , '22008' , 'DUE PICCOLI PESCI - CALENDARIO 2024' , '2' , '2' , '4' , '6.90' , '6.9' , '0' , '30' , '9.6600' ) 15/12/2023 11:23:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '22008' AND id_supplier = '7' 15/12/2023 11:23:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22008' , '7' , '1' ) 15/12/2023 11:24:34 am >> SELECT document_num FROM ps_document WHERE document_num = '3996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 11:24:34 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3996' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 15/12/2023 11:24:34 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89502' 15/12/2023 11:24:34 am >> DELETE FROM ps_document_detail WHERE id_document = '89502' 15/12/2023 11:24:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89502' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 15/12/2023 11:29:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 11:29:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3997' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.80' , '17.72' , NOW() , NOW() ) 15/12/2023 11:29:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89503' 15/12/2023 11:29:44 am >> DELETE FROM ps_document_detail WHERE id_document = '89503' 15/12/2023 11:29:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89503' , '21846' , 'AGENDINA VITA CRISTIANA 2024' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 15/12/2023 11:29:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89503' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 15/12/2023 11:29:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89503' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '1' , '-1' , '4' , '1.4' , '1.4' , '0' , '0' , '1.40' ) 15/12/2023 11:29:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89503' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 15/12/2023 11:37:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 11:37:18 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3998' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.50' , '26.64' , NOW() , NOW() ) 15/12/2023 11:37:18 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89504' 15/12/2023 11:37:18 am >> DELETE FROM ps_document_detail WHERE id_document = '89504' 15/12/2023 11:37:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89504' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '25' , '-25' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '32.50' ) 15/12/2023 11:37:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3993' AND id_document != '89498' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 11:37:41 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3993', document_date = '2023-12-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '93.60', price_tax_excluded = '76.72', date_upd = NOW() WHERE id_document = '89498' 15/12/2023 11:37:41 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89498' 15/12/2023 11:37:41 am >> DELETE FROM ps_document_detail WHERE id_document = '89498' 15/12/2023 11:37:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89498' , '20157' , 'ALBERO DI NATALE - 23/92NAT04' , '51' , '-51' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '66.30' ) 15/12/2023 11:37:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89498' , '20158' , 'CASETTA NATIVITA - 23/97NAT04' , '21' , '-21' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '27.30' ) 15/12/2023 11:38:06 am >> DELETE FROM ps_document WHERE id_document = '89406' 15/12/2023 11:38:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89406' 15/12/2023 11:50:21 am >> SELECT document_num FROM ps_document WHERE document_num = '3999' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 11:50:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3999' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 15/12/2023 11:50:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89505' 15/12/2023 11:50:21 am >> DELETE FROM ps_document_detail WHERE id_document = '89505' 15/12/2023 11:50:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89505' , '20147' , 'LAMPADA A SFERA AZZURRA - 049DK' , '1' , '-1' , '1' , '26.00' , '21.311475409836' , '22' , '0' , '26.00' ) 15/12/2023 11:50:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89505' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '30' , '-30' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '9.00' ) 15/12/2023 12:01:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '4000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 12:01:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4000' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 15/12/2023 12:01:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89506' 15/12/2023 12:01:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '89506' 15/12/2023 12:01:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89506' , '15387' , 'VESTINA BATTESIMALE ' , '5' , '-5' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '15.00' ) 15/12/2023 12:01:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89506' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '5' , '-5' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '7.00' ) 15/12/2023 12:10:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '4001' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 12:10:51 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4001' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 15/12/2023 12:10:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89507' 15/12/2023 12:10:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '89507' 15/12/2023 12:10:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89507' , '18131' , 'TAU MEDIO CM3 - T6' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 15/12/2023 12:15:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '4002' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 12:15:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4002' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '32.50' , '26.64' , NOW() , NOW() ) 15/12/2023 12:15:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89508' 15/12/2023 12:15:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '89508' 15/12/2023 12:15:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89508' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '25' , '-25' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '32.50' ) 15/12/2023 12:27:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '4003' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 12:27:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4003' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.65' , NOW() , NOW() ) 15/12/2023 12:27:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89509' 15/12/2023 12:27:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '89509' 15/12/2023 12:27:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89509' , '15395' , 'TELA 18X25 - MARIA CHE SCIOGLIE I NODI' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 15/12/2023 12:27:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89509' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 15/12/2023 12:28:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '4004' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 12:28:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4004' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.00' , '37.70' , NOW() , NOW() ) 15/12/2023 12:28:08 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89510' 15/12/2023 12:28:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '89510' 15/12/2023 12:28:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89510' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 15/12/2023 12:28:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89510' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 15/12/2023 12:28:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89510' , '5229' , 'INCENSO PONTIFICAL' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 15/12/2023 12:45:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '4005' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 12:45:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4005' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '128.50' , '108.95' , NOW() , NOW() ) 15/12/2023 12:45:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89511' 15/12/2023 12:45:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89511' 15/12/2023 12:45:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89511' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 15/12/2023 12:45:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89511' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 15/12/2023 12:45:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89511' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 15/12/2023 12:45:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89511' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 15/12/2023 01:01:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '4006' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 01:01:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4006' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '192.25' , '160.15' , NOW() , NOW() ) 15/12/2023 01:01:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89512' 15/12/2023 01:01:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '89512' 15/12/2023 01:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89512' , '21685' , 'STELLARIO CM 30 - ART.18' , '1' , '-1' , '1' , '94.00' , '77.049180327869' , '22' , '0' , '94.00' ) 15/12/2023 01:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89512' , '21686' , 'STELLARIO CM 30 - ART.19' , '1' , '-1' , '1' , '84.00' , '68.852459016393' , '22' , '0' , '84.00' ) 15/12/2023 01:01:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89512' , '21467' , 'ADOLESCENTI INAFFERRABILI - BOTTA / LONARDO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 15/12/2023 03:03:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '4007' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 03:03:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4007' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 15/12/2023 03:03:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89513' 15/12/2023 03:03:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '89513' 15/12/2023 03:03:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89513' , '21679' , 'LAUDATE DEUM - 8583' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 15/12/2023 03:40:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '139/A' AND id_document != '89347' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-05') 15/12/2023 03:40:22 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '139/A', document_date = '2023-12-05', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '36.20', price_tax_excluded = '36.20', date_upd = NOW() WHERE id_document = '89347' 15/12/2023 03:40:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89347' 15/12/2023 03:40:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '89347' 15/12/2023 03:40:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89347' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '0' , '16.90' ) 15/12/2023 03:40:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89347' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 15/12/2023 03:40:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89347' , '21991' , 'MIO PRESEPE - PAPA FRANCESCO' , '1' , '-1' , '4' , '17.90' , '17.9' , '0' , '0' , '17.90' ) 15/12/2023 04:17:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '319' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 04:17:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '319' , '2023-12-15' , '' , '3432' , '0' , '4670953' , 'VIA SAN GIOVANNI, 18 84019 VIETRI SUL MARE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.38' , '57.38' , NOW() , NOW() ) 15/12/2023 04:17:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89514' 15/12/2023 04:17:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89514' 15/12/2023 04:17:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89514' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '27' , '-27' , '4' , '2.50' , '2.5' , '0' , '15' , '57.38' ) 15/12/2023 04:18:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '4008' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 04:18:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4008' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.95' , '48.07' , NOW() , NOW() ) 15/12/2023 04:18:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89515' 15/12/2023 04:18:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '89515' 15/12/2023 04:18:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89515' , '21679' , 'LAUDATE DEUM - 8583' , '27' , '-27' , '4' , '1.00' , '1' , '0' , '5' , '25.65' ) 15/12/2023 04:18:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89515' , '21810' , 'AMEN - FEB 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 15/12/2023 04:18:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89515' , '21809' , 'AMEN - GEN 2024' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 15/12/2023 04:18:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89515' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 15/12/2023 04:18:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89515' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 15/12/2023 04:18:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '4009' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 04:18:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4009' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.04' , '11.04' , NOW() , NOW() ) 15/12/2023 04:18:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89516' 15/12/2023 04:18:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '89516' 15/12/2023 04:18:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89516' , '21810' , 'AMEN - FEB 2024' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '5' , '5.52' ) 15/12/2023 04:18:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89516' , '21809' , 'AMEN - GEN 2024' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '5' , '5.52' ) 15/12/2023 04:22:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '319' AND id_document != '89514' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 04:22:02 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '319', document_date = '2023-12-15', document_letter = '', id_customer = '3432', id_supplier = '', id_address = '4670953', address1 = 'VIA SAN GIOVANNI, 18 84019 VIETRI SUL MARE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '57.38', price_tax_excluded = '57.38', date_upd = NOW() WHERE id_document = '89514' 15/12/2023 04:22:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89514' 15/12/2023 04:22:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '89514' 15/12/2023 04:22:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89514' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '27' , '-27' , '4' , '2.5000' , '2.5' , '0' , '15' , '57.38' ) 15/12/2023 04:43:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4010' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 04:43:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4010' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '42.87' , NOW() , NOW() ) 15/12/2023 04:43:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89517' 15/12/2023 04:43:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '89517' 15/12/2023 04:43:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89517' , '17571' , 'BAMBINO IN RESINA CM 23 - PB9422' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 15/12/2023 04:43:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89517' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 15/12/2023 04:47:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '4011' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 04:47:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4011' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 15/12/2023 04:47:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89518' 15/12/2023 04:47:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '89518' 15/12/2023 04:47:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89518' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 15/12/2023 04:49:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '4012' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 04:49:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4012' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '7.79' , NOW() , NOW() ) 15/12/2023 04:49:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89519' 15/12/2023 04:49:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '89519' 15/12/2023 04:49:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89519' , '15591' , 'ANGELO CON CAMPANA ARG. - 4216' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 15/12/2023 04:52:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '132/A' AND id_document != '89040' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-20') 15/12/2023 04:52:16 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '132/A', document_date = '2023-11-20', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'SAN LEONARDO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '57.90', price_tax_excluded = '55.17', date_upd = NOW() WHERE id_document = '89040' 15/12/2023 04:52:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89040' 15/12/2023 04:52:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '89040' 15/12/2023 04:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89040' , '21809' , 'AMEN - GEN 2024' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 15/12/2023 04:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89040' , '21810' , 'AMEN - FEB 2024' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 15/12/2023 04:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89040' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 15/12/2023 04:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89040' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '14.00' ) 15/12/2023 04:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89040' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 15/12/2023 04:52:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89040' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '10' , '-10' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '10.00' ) 15/12/2023 05:45:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '4013' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 05:45:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4013' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 15/12/2023 05:45:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89520' 15/12/2023 05:45:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '89520' 15/12/2023 05:45:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89520' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 15/12/2023 05:45:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89520' , '20026' , 'CANDELA VOTIVA 20X30' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 15/12/2023 06:07:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '4014' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 06:07:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4014' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.75' , '34.41' , NOW() , NOW() ) 15/12/2023 06:07:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89521' 15/12/2023 06:07:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '89521' 15/12/2023 06:07:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89521' , '20639' , 'CATECHISMO DELLA VITA SPIRITUALE - R. SARAH' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 15/12/2023 06:07:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89521' , '15206' , 'ANELLO CROCE/MIRACOLOSA' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 15/12/2023 07:25:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '4015' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 07:25:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4015' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 15/12/2023 07:25:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89522' 15/12/2023 07:25:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89522' 15/12/2023 07:25:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89522' , '20156' , 'PALLA CON CARTONCINO - 23/64NAT03' , '20' , '-20' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '26.00' ) 15/12/2023 07:26:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '4016' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-12-15') 15/12/2023 07:26:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4016' , '2023-12-15' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.50' , '20.08' , NOW() , NOW() ) 15/12/2023 07:26:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89523' 15/12/2023 07:26:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '89523' 15/12/2023 07:26:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89523' , '6872' , 'NASCITA DI GESÙ BAMBINO - 189' , '3' , '-3' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '10.50' ) 15/12/2023 07:26:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89523' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '14.00' )