16/11/2023 08:58:14 am >> SELECT document_num FROM ps_document WHERE document_num = '271' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 08:58:15 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 ( '21' , '271' , '2023-11-16' , '' , '353' , '0' , '4677366' , 'C.DA EPITAFFIO 82100 BENEVENTO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '88.50' , '88.50' , NOW() , NOW() ) 16/11/2023 08:58:15 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 = '88983' 16/11/2023 08:58:15 am >> DELETE FROM ps_document_detail WHERE id_document = '88983' 16/11/2023 08:58: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 ( '88983' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.50' , '3.5' , '0' , '15' , '38.68' ) 16/11/2023 08:58: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 ( '88983' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '23' , '-23' , '4' , '2.40' , '2.4' , '0' , '15' , '46.92' ) 16/11/2023 08:58: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 ( '88983' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 16/11/2023 09:09:30 am >> SELECT document_num FROM ps_document WHERE document_num = '3622' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/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' , '3622' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '31.97' , NOW() , NOW() ) 16/11/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 = '88984' 16/11/2023 09:09:30 am >> DELETE FROM ps_document_detail WHERE id_document = '88984' 16/11/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 ( '88984' , '17296' , 'ROSARIO GIROCOLLO NERO ARG ' , '1' , '-1' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '39.00' ) 16/11/2023 09:10:56 am >> SELECT document_num FROM ps_document WHERE document_num = '3623' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 09:10:56 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' , '3623' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 16/11/2023 09:10:56 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 = '88985' 16/11/2023 09:10:56 am >> DELETE FROM ps_document_detail WHERE id_document = '88985' 16/11/2023 09:10:56 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 ( '88985' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 16/11/2023 10:05:38 am >> SELECT document_num FROM ps_document WHERE document_num = '272' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 10:05: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 ( '21' , '272' , '2023-11-16' , '' , '3999' , '0' , '4678275' , 'Via Duomo vicolo Florio 18 84087 Sarno' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '99.28' , '99.28' , NOW() , NOW() ) 16/11/2023 10:05: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 = '88986' 16/11/2023 10:05:38 am >> DELETE FROM ps_document_detail WHERE id_document = '88986' 16/11/2023 10:05: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 ( '88986' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '27' , '-27' , '4' , '3.50' , '3.5' , '0' , '5' , '89.78' ) 16/11/2023 10:05: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 ( '88986' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 16/11/2023 10:07:58 am >> SELECT document_num FROM ps_document WHERE document_num = '271' AND id_document != '88983' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 10:07:58 am >> UPDATE ps_document SET id_document_type = '21', document_num = '271', document_date = '2023-11-16', document_letter = '', id_customer = '353', id_supplier = '', id_address = '4677366', address1 = 'C.DA EPITAFFIO 82100 BENEVENTO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '88.50', price_tax_excluded = '88.50', date_upd = NOW() WHERE id_document = '88983' 16/11/2023 10:07:58 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 = '88983' 16/11/2023 10:07:58 am >> DELETE FROM ps_document_detail WHERE id_document = '88983' 16/11/2023 10:07:58 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 ( '88983' , '2679' , 'CONOSCERE GESU\'' , '13' , '-13' , '4' , '3.5000' , '3.5' , '0' , '15' , '38.68' ) 16/11/2023 10:07:58 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 ( '88983' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '23' , '-23' , '4' , '2.4000' , '2.4' , '0' , '15' , '46.92' ) 16/11/2023 10:07:58 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 ( '88983' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 16/11/2023 10:57:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3624' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 10:57:39 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' , '3624' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 16/11/2023 10:57:39 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 = '88987' 16/11/2023 10:57:39 am >> DELETE FROM ps_document_detail WHERE id_document = '88987' 16/11/2023 10:57:39 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 ( '88987' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 16/11/2023 11:01:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3625' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 11:01:20 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' , '3625' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.00' , '37.70' , NOW() , NOW() ) 16/11/2023 11:01:20 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 = '88988' 16/11/2023 11:01:20 am >> DELETE FROM ps_document_detail WHERE id_document = '88988' 16/11/2023 11:01:20 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 ( '88988' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '4' , '-4' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '40.00' ) 16/11/2023 11:01:20 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 ( '88988' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 16/11/2023 11:01:20 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 ( '88988' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 16/11/2023 11:01:20 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 ( '88988' , '6207' , 'MARCUS 25G - MENTA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 16/11/2023 11:01:20 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 ( '88988' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 16/11/2023 11:31:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3626' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 11:31:51 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' , '3626' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.50' , '30.74' , NOW() , NOW() ) 16/11/2023 11:31: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 = '88989' 16/11/2023 11:31:51 am >> DELETE FROM ps_document_detail WHERE id_document = '88989' 16/11/2023 11:31:51 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 ( '88989' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '50' , '-50' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '17.50' ) 16/11/2023 11:31:51 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 ( '88989' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 16/11/2023 11:38:06 am >> SELECT document_num FROM ps_document WHERE document_num = '197' AND id_document != '88536' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-25') 16/11/2023 11:38:06 am >> UPDATE ps_document SET id_document_type = '21', document_num = '197', document_date = '2023-10-25', document_letter = '', id_customer = '2385', id_supplier = '', id_address = '4678091', address1 = 'PIAZZA REGINA MARGHERITA 84084 LANCUSI BOLANO', address2 = '', note = 'acconto € 200,00 pos + 270,48 16/11/2023', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '470.48', price_tax_excluded = '470.48', date_upd = NOW() WHERE id_document = '88536' 16/11/2023 11:38:06 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 = '88536' 16/11/2023 11:38:06 am >> DELETE FROM ps_document_detail WHERE id_document = '88536' 16/11/2023 11:38:06 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 ( '88536' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '41' , '-41' , '4' , '3.5000' , '3.5' , '0' , '15' , '121.98' ) 16/11/2023 11:38:06 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 ( '88536' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '41' , '-41' , '4' , '10.0000' , '10' , '0' , '15' , '348.50' ) 16/11/2023 11:39:39 am >> SELECT document_num FROM ps_document WHERE document_num = '3627' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 11:39:39 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' , '3627' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '31.17' , NOW() , NOW() ) 16/11/2023 11:39:39 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 = '88990' 16/11/2023 11:39:39 am >> DELETE FROM ps_document_detail WHERE id_document = '88990' 16/11/2023 11:39:39 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 ( '88990' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 16/11/2023 11:39:39 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 ( '88990' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 16/11/2023 11:47:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3628' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 11:47:46 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' , '3628' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.80' , '54.62' , NOW() , NOW() ) 16/11/2023 11:47:46 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 = '88991' 16/11/2023 11:47:46 am >> DELETE FROM ps_document_detail WHERE id_document = '88991' 16/11/2023 11:47:46 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 ( '88991' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '15' , '-15' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '52.50' ) 16/11/2023 11:47:47 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 ( '88991' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 16/11/2023 11:51:16 am >> SELECT document_num FROM ps_document WHERE document_num = '256' AND id_document != '88892' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-10') 16/11/2023 11:51:16 am >> UPDATE ps_document SET id_document_type = '21', document_num = '256', document_date = '2023-11-10', document_letter = '', id_customer = '68', id_supplier = '', id_address = '4676195', address1 = 'PIAZZA BERNARDINO LAMBERTI 84013 CAVA DE\\\' TIRRENI', 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 = '71.40', price_tax_excluded = '71.40', date_upd = NOW() WHERE id_document = '88892' 16/11/2023 11:51:16 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 = '88892' 16/11/2023 11:51:16 am >> DELETE FROM ps_document_detail WHERE id_document = '88892' 16/11/2023 11:51:16 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 ( '88892' , '4154' , 'FESTA DEL PERDONO' , '28' , '-28' , '4' , '3.0000' , '3' , '0' , '15' , '71.40' ) 16/11/2023 11:54:16 am >> SELECT document_num FROM ps_document WHERE document_num = '3629' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 11:54:16 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' , '3629' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.21' , '87.50' , NOW() , NOW() ) 16/11/2023 11:54:16 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 = '88992' 16/11/2023 11:54:16 am >> DELETE FROM ps_document_detail WHERE id_document = '88992' 16/11/2023 11:54:16 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 ( '88992' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '27' , '-27' , '4' , '3.00' , '3' , '0' , '5' , '76.95' ) 16/11/2023 11:54:16 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 ( '88992' , '14955' , 'DARAI ALLA LUCE UN FIGLIO - NOVENA IMMACOLATA - G. FORLAI' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 16/11/2023 11:54:16 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 ( '88992' , '21563' , 'AGENDA SAN PAOLO 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 16/11/2023 11:56:00 am >> SELECT document_num FROM ps_document WHERE document_num = '3630' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 11: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 ( '11' , '3630' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 16/11/2023 11: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 = '88993' 16/11/2023 11:56:00 am >> DELETE FROM ps_document_detail WHERE id_document = '88993' 16/11/2023 11: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 ( '88993' , '21196' , 'CALENDARIO LITURGICO 2024' , '10' , '-10' , '4' , '0.50' , '0.5' , '0' , '0' , '5.00' ) 16/11/2023 12:08:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3560' AND id_document != '88893' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-10') 16/11/2023 12:08:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3560', document_date = '2023-11-10', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '88893' 16/11/2023 12:08:38 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 = '88893' 16/11/2023 12:08:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '88893' 16/11/2023 12:08:38 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 ( '88893' , '21524' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '100' , '0.00' ) 16/11/2023 12:16:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '269' AND id_document != '88966' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-15') 16/11/2023 12:16:55 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '269', document_date = '2023-11-15', document_letter = '', id_customer = '1138', id_supplier = '', id_address = '4672220', address1 = 'P. ZZA AMENDOLA - LANZARA 84083 CASTEL SAN GIORGIO', 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 = '500.99', price_tax_excluded = '500.99', date_upd = NOW() WHERE id_document = '88966' 16/11/2023 12:16: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 = '88966' 16/11/2023 12:16:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '88966' 16/11/2023 12:16: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 ( '88966' , '2679' , 'CONOSCERE GESU\'' , '42' , '-42' , '4' , '3.5000' , '3.5' , '0' , '15' , '124.95' ) 16/11/2023 12:16: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 ( '88966' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '15' , '4.25' ) 16/11/2023 12:16: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 ( '88966' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '38' , '-38' , '4' , '3.5000' , '3.5' , '0' , '15' , '113.05' ) 16/11/2023 12:16: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 ( '88966' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '34' , '-34' , '4' , '3.5000' , '3.5' , '0' , '15' , '101.15' ) 16/11/2023 12:16: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 ( '88966' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '35' , '-35' , '4' , '3.4000' , '3.4' , '0' , '15' , '101.15' ) 16/11/2023 12:16: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 ( '88966' , '5457' , 'IO SONO CON VOI 1 PARTE' , '18' , '-18' , '4' , '2.8000' , '2.8' , '0' , '15' , '42.84' ) 16/11/2023 12:16: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 ( '88966' , '5446' , 'IO SONO CON VOI - GUIDA' , '2' , '-2' , '4' , '8.0000' , '8' , '0' , '15' , '13.60' ) 16/11/2023 12:35:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3631' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 12:35:06 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' , '3631' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '90.16' , NOW() , NOW() ) 16/11/2023 12:35:06 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 = '88994' 16/11/2023 12:35:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '88994' 16/11/2023 12:35:06 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 ( '88994' , '21137' , 'MOCCOLO 70X200' , '4' , '-4' , '1' , '6.5' , '5.327868852459' , '22' , '0' , '26.00' ) 16/11/2023 12:35:06 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 ( '88994' , '16761' , 'LAMPADA MARIANA - 096DP2K' , '2' , '-2' , '1' , '42' , '34.426229508197' , '22' , '0' , '84.00' ) 16/11/2023 12:40:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3632' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 12:40:16 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' , '3632' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '197.33' , '197.33' , NOW() , NOW() ) 16/11/2023 12:40: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 = '88995' 16/11/2023 12:40:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '88995' 16/11/2023 12:40: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 ( '88995' , '5444' , 'IO SONO CON VOI - CAT.' , '12' , '-12' , '4' , '5.23' , '5.23' , '0' , '0' , '62.76' ) 16/11/2023 12:40: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 ( '88995' , '11193' , 'VENITE CON ME CAT.' , '10' , '-10' , '4' , '5.23' , '5.23' , '0' , '0' , '52.30' ) 16/11/2023 12:40: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 ( '88995' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '5' , '28.50' ) 16/11/2023 12:40: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 ( '88995' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '5' , '19.95' ) 16/11/2023 12:40: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 ( '88995' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '5' , '28.50' ) 16/11/2023 12:40: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 ( '88995' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '2' , '-2' , '4' , '2.80' , '2.8' , '0' , '5' , '5.32' ) 16/11/2023 12:41:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3633' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 12:41:35 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' , '3633' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '180.00' , '147.54' , NOW() , NOW() ) 16/11/2023 12:41:35 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 = '88996' 16/11/2023 12:41:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '88996' 16/11/2023 12:41:35 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 ( '88996' , '14401' , 'BALZA CM 19' , '10' , '-10' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '180.00' ) 16/11/2023 12:42:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '3634' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 12:42:35 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' , '3634' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.00' , '20.58' , NOW() , NOW() ) 16/11/2023 12:42:35 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 = '88997' 16/11/2023 12:42:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '88997' 16/11/2023 12:42:35 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 ( '88997' , '17617' , 'IMMAGINI ISONZO X 100' , '6' , '-6' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '21.00' ) 16/11/2023 12:42:35 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 ( '88997' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 16/11/2023 12:42:35 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 ( '88997' , '16834' , 'LITURGICO CARTA 8GG' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 16/11/2023 12:47:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3635' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 12:47:22 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' , '3635' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 16/11/2023 12:47: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 = '88998' 16/11/2023 12:47:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '88998' 16/11/2023 12:47: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 ( '88998' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 16/11/2023 12:49:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '3633' AND id_document != '88996' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 12:49:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3633', document_date = '2023-11-16', 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 = '180.00', price_tax_excluded = '147.54', date_upd = NOW() WHERE id_document = '88996' 16/11/2023 12:49: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 = '88996' 16/11/2023 12:49:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '88996' 16/11/2023 12:49: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 ( '88996' , '14401' , 'BALZA CM 19' , '10' , '-10' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '180.00' ) 16/11/2023 12:49: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 ( '88996' , '14401' , 'BALZA CM 19' , '2' , '-2' , '1' , '18.00' , '14.754098360656' , '22' , '100' , '0.00' ) 16/11/2023 04:13:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '200' AND id_document != '88570' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-10-27') 16/11/2023 04:13:30 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '200', document_date = '2023-10-27', document_letter = '', id_customer = '3781', id_supplier = '', id_address = '4671993', address1 = 'PIAZZA SETTE MARTIRI 11 50054 MASSARELLA', address2 = '', note = 'assegno versato a novembre', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '16', id_causal = '0', price_tax_included = '47.76', price_tax_excluded = '47.76', date_upd = NOW() WHERE id_document = '88570' 16/11/2023 04:13:30 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 = '88570' 16/11/2023 04:13:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '88570' 16/11/2023 04:13:30 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 ( '88570' , '13397' , 'MIO GESU\'' , '5' , '-5' , '4' , '3.5000' , '3.5' , '0' , '5' , '16.63' ) 16/11/2023 04:13:30 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 ( '88570' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 16/11/2023 04:13:30 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 ( '88570' , '4479' , 'GESÙ MIO AMICO - VOL. 1°' , '5' , '-5' , '4' , '2.0000' , '2' , '0' , '5' , '9.50' ) 16/11/2023 04:13:30 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 ( '88570' , '12253' , 'MIO LIBRO DI PREGHIERE' , '5' , '-5' , '4' , '2.8000' , '2.8' , '0' , '5' , '13.30' ) 16/11/2023 04:29:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '3636' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 04:29:16 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' , '3636' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 16/11/2023 04:29: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 = '88999' 16/11/2023 04:29:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '88999' 16/11/2023 04:29: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 ( '88999' , '21838' , 'CARTOLINA CARLO ACUTIS' , '20' , '-20' , '1' , '0.15' , '0.12295081967213' , '22' , '0' , '3.00' ) 16/11/2023 04:46:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3637' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 04:46:02 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' , '3637' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '15.57' , NOW() , NOW() ) 16/11/2023 04:46: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 = '89000' 16/11/2023 04:46:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '89000' 16/11/2023 04:46: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 ( '89000' , '16985' , 'SAN GIUSEPPE DORMIENTE - 4040' , '1' , '-1' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '19.00' ) 16/11/2023 04:54:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3484' AND id_document != '88774' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-07') 16/11/2023 04:54:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3484', document_date = '2023-11-07', 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 = '302.00', price_tax_excluded = '260.96', date_upd = NOW() WHERE id_document = '88774' 16/11/2023 04:54: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 = '88774' 16/11/2023 04:54:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '88774' 16/11/2023 04:54: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 ( '88774' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '21.2' , '21.2' , '0' , '0' , '21.20' ) 16/11/2023 04:54: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 ( '88774' , '7962' , 'PETTINA ROMANA NERO - MISTO - 44' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 16/11/2023 04:54: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 ( '88774' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '79.80' ) 16/11/2023 04:54: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 ( '88774' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 16/11/2023 04:54: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 ( '88774' , '21779' , 'CAMMINO DI UN POPOLO - C.M. MARTINI' , '1' , '-1' , '4' , '40.0000' , '40' , '0' , '5' , '38.00' ) 16/11/2023 04:54: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 ( '88774' , '21439' , 'NATUZZA EVOLO COME BIBBIA - R.I. ZANINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 16/11/2023 04:56:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3626' AND id_document != '88989' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 04:56:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3626', document_date = '2023-11-16', 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 = '37.50', price_tax_excluded = '30.74', date_upd = NOW() WHERE id_document = '88989' 16/11/2023 04:56:29 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 = '88989' 16/11/2023 04:56:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '88989' 16/11/2023 04:56:29 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 ( '88989' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '50' , '-50' , '1' , '0.3500' , '0.28688524590164' , '22' , '0' , '17.50' ) 16/11/2023 04:56:29 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 ( '88989' , '20177' , 'ANGELO SU CUORE CM 6,5 - AR112' , '4' , '-4' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '10.00' ) 16/11/2023 04:56:29 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 ( '88989' , '20178' , 'ANGELI SEDUTI CON CUORE - AR116' , '4' , '-4' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '10.00' ) 16/11/2023 05:15:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2853' AND id_document != '87335' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-18') 16/11/2023 05:15:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2853', document_date = '2023-09-18', 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 = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '87335' 16/11/2023 05:15:56 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 = '87335' 16/11/2023 05:15:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '87335' 16/11/2023 05:15:56 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 ( '87335' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 16/11/2023 05:15:56 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 ( '87335' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 16/11/2023 05:15:56 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 ( '87335' , '5538' , 'LACCIO MARRONE' , '2' , '-2' , '1' , '0.05' , '0.040983606557377' , '22' , '0' , '0.10' ) 16/11/2023 05:18:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '255' AND id_document != '88888' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-10') 16/11/2023 05:18:50 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '255', document_date = '2023-11-10', document_letter = '', id_customer = '3259', id_supplier = '', id_address = '4671434', address1 = 'VIA EX MONASTERO 2 84030 CAGGIANO', 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 = '53.97', price_tax_excluded = '53.97', date_upd = NOW() WHERE id_document = '88888' 16/11/2023 05:18:50 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 = '88888' 16/11/2023 05:18:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '88888' 16/11/2023 05:18:50 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 ( '88888' , '6629' , 'MIA PREGHIERA' , '30' , '-30' , '4' , '0.9000' , '0.9' , '0' , '15' , '22.95' ) 16/11/2023 05:18:50 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 ( '88888' , '21524' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '15' , '15.30' ) 16/11/2023 05:18:50 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 ( '88888' , '9253' , 'SACRA BIBBIA CEI - UELCI' , '1' , '-1' , '4' , '18.5000' , '18.5' , '0' , '15' , '15.72' ) 16/11/2023 05:53:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3638' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 05:53:45 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' , '3638' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '8.50' , NOW() , NOW() ) 16/11/2023 05:53:45 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 = '89001' 16/11/2023 05:53:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '89001' 16/11/2023 05:53:45 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 ( '89001' , '13039' , 'LIBRO DEL BEBE - ROSA' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '0' , '8.50' ) 16/11/2023 06:13:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '3639' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-16') 16/11/2023 06:13:44 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' , '3639' , '2023-11-16' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 16/11/2023 06:13:44 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 = '89002' 16/11/2023 06:13:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89002' 16/11/2023 06:13:44 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 ( '89002' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' )