30/01/2024 09:13:34 am >> SELECT document_num FROM ps_document WHERE document_num = '300' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 09:13: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' , '300' , '2024-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.00' , '55.74' , NOW() , NOW() ) 30/01/2024 09:13: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 = '90148' 30/01/2024 09:13:34 am >> DELETE FROM ps_document_detail WHERE id_document = '90148' 30/01/2024 09:13: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 ( '90148' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 30/01/2024 09:22:26 am >> SELECT document_num FROM ps_document WHERE document_num = '2/E' AND id_document != '90119' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-26') 30/01/2024 09:22:26 am >> UPDATE ps_document SET id_document_type = '23', document_num = '2/E', document_date = '2024-01-26', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', 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 = '816.00', price_tax_excluded = '668.85', date_upd = NOW() WHERE id_document = '90119' 30/01/2024 09:22: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 = '90119' 30/01/2024 09:22:26 am >> DELETE FROM ps_document_detail WHERE id_document = '90119' 30/01/2024 09:22: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 ( '90119' , '12814' , 'LIBRO DEI BATTEZZATI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 30/01/2024 09:22: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 ( '90119' , '12816' , 'LIBRO DEI DEFUNTI' , '12' , '-12' , '1' , '40.0000' , '32.786885245902' , '22' , '40' , '288.00' ) 30/01/2024 09:22: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 ( '90119' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '20' , '-20' , '1' , '20.0000' , '16.393442622951' , '22' , '40' , '240.00' ) 30/01/2024 10:00:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002183' AND id_product != '21680' AND ean13 != '' 30/01/2024 10:00:54 am >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '002183', date_upd = NOW() WHERE id_product = '21680' 30/01/2024 10:00:54 am >> UPDATE ps_product_lang SET name = 'CASULA - 65-019416', description = '' WHERE id_product = '21680' 30/01/2024 10:00:54 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1303.2786885245903' WHERE id_product = '21680' 30/01/2024 10:00:54 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1303.2786885245903', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21680' 30/01/2024 10:00:54 am >> DELETE FROM ps_specific_price WHERE id_product = '21680' 30/01/2024 10:02:36 am >> SELECT document_num FROM ps_document WHERE document_num = '301' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 10:02:36 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' , '301' , '2024-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.25' , NOW() , NOW() ) 30/01/2024 10:02:36 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 = '90149' 30/01/2024 10:02:36 am >> DELETE FROM ps_document_detail WHERE id_document = '90149' 30/01/2024 10:02: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 ( '90149' , '18323' , 'CONSACRAZIONE PERFETTA A GESU CRISTO PER MEZZO DI MARIA - 8170' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 30/01/2024 10:02: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 ( '90149' , '12936' , 'SCATOLA 4X4' , '1' , '-1' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '0.30' ) 30/01/2024 10:19:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002001' AND id_product != '19660' AND ean13 != '' 30/01/2024 10:19:29 am >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '002001', date_upd = NOW() WHERE id_product = '19660' 30/01/2024 10:19:29 am >> UPDATE ps_product_lang SET name = 'CASULA POLIESTERE - 65/11648', description = '' WHERE id_product = '19660' 30/01/2024 10:19:29 am >> UPDATE ps_product SET wholesale_price = '116.40', on_sale = '0', price = '360.65573770491807' WHERE id_product = '19660' 30/01/2024 10:19:29 am >> UPDATE ps_product_shop SET wholesale_price = '116.40', price = '360.65573770491807', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19660' 30/01/2024 10:19:29 am >> DELETE FROM ps_specific_price WHERE id_product = '19660' 30/01/2024 10:22:00 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001587' AND id_product != '17404' AND ean13 != '' 30/01/2024 10:22:00 am >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '001587', date_upd = NOW() WHERE id_product = '17404' 30/01/2024 10:22:00 am >> UPDATE ps_product_lang SET name = 'CASULA RIGATA', description = '' WHERE id_product = '17404' 30/01/2024 10:22:00 am >> UPDATE ps_product SET wholesale_price = '130.00', on_sale = '0', price = '286.0655737704918' WHERE id_product = '17404' 30/01/2024 10:22:00 am >> UPDATE ps_product_shop SET wholesale_price = '130.00', price = '286.0655737704918', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17404' 30/01/2024 10:22:00 am >> DELETE FROM ps_specific_price WHERE id_product = '17404' 30/01/2024 10:23:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000858' AND id_product != '19821' AND ean13 != '' 30/01/2024 10:23:20 am >> UPDATE ps_product SET id_supplier = '143', reference = '', ean13 = '000858', date_upd = NOW() WHERE id_product = '19821' 30/01/2024 10:23:20 am >> UPDATE ps_product_lang SET name = 'CASULA RIGHE - 65/1909', description = '' WHERE id_product = '19821' 30/01/2024 10:23:20 am >> UPDATE ps_product SET wholesale_price = '120.00', on_sale = '0', price = '274.59016393442624' WHERE id_product = '19821' 30/01/2024 10:23:20 am >> UPDATE ps_product_shop SET wholesale_price = '120.00', price = '274.59016393442624', id_tax_rules_group = '1', id_category_default = '468', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19821' 30/01/2024 10:23:20 am >> DELETE FROM ps_specific_price WHERE id_product = '19821' 30/01/2024 10:32:43 am >> SELECT document_num FROM ps_document WHERE document_num = '302' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 10:32:43 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' , '302' , '2024-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.60' , '26.60' , NOW() , NOW() ) 30/01/2024 10:32:43 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 = '90150' 30/01/2024 10:32:43 am >> DELETE FROM ps_document_detail WHERE id_document = '90150' 30/01/2024 10:32:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90150' , '7704' , 'PASSIONE DI NOSTRO SIGNORE GESÙ CRISTO - 8671' , '4' , '-4' , '4' , '7.00' , '7' , '0' , '5' , '26.60' ) 30/01/2024 10:42:12 am >> SELECT document_num FROM ps_document WHERE document_num = '303' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 10:42:12 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' , '303' , '2024-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.90' , '39.84' , NOW() , NOW() ) 30/01/2024 10:42:12 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 = '90151' 30/01/2024 10:42:12 am >> DELETE FROM ps_document_detail WHERE id_document = '90151' 30/01/2024 10:42: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 ( '90151' , '22064' , 'QUARESIMA 2024' , '1' , '-1' , '4' , '3.60' , '3.6' , '0' , '5' , '3.42' ) 30/01/2024 10:42: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 ( '90151' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 30/01/2024 10:42: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 ( '90151' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 30/01/2024 10:42: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 ( '90151' , '15795' , 'CARLO ACUTIS - 8950' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 30/01/2024 10:42: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 ( '90151' , '22089' , 'QUARESIMA 2024 GIORNO PER GIORNO' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 30/01/2024 10:42: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 ( '90151' , '17617' , 'IMMAGINI ISONZO X 100' , '3' , '-3' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '11.40' ) 30/01/2024 10:59:00 am >> SELECT document_num FROM ps_document WHERE document_num = '140/A' AND id_document != '89396' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-12-07') 30/01/2024 10:59:00 am >> UPDATE ps_document SET id_document_type = '24', document_num = '140/A', document_date = '2023-12-07', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '147.95', price_tax_excluded = '133.07', date_upd = NOW() WHERE id_document = '89396' 30/01/2024 10:59: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 = '89396' 30/01/2024 10:59:00 am >> DELETE FROM ps_document_detail WHERE id_document = '89396' 30/01/2024 10:59: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 ( '89396' , '15094' , 'BRACCIALE DECINA CORDA TAU' , '80' , '-80' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '80.00' ) 30/01/2024 10:59: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 ( '89396' , '9257' , 'SACRA FAMIGLIA' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 30/01/2024 10:59: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 ( '89396' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '7' , '-7' , '4' , '3.5000' , '3.5' , '0' , '15' , '20.82' ) 30/01/2024 10:59: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 ( '89396' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '15' , '-15' , '4' , '3.5000' , '3.5' , '0' , '15' , '44.63' ) 30/01/2024 10:59:29 am >> SELECT document_num FROM ps_document WHERE document_num = '304' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 10:59:29 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' , '304' , '2024-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.90' , '140.90' , NOW() , NOW() ) 30/01/2024 10:59:29 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 = '90152' 30/01/2024 10:59:29 am >> DELETE FROM ps_document_detail WHERE id_document = '90152' 30/01/2024 11:00:52 am >> SELECT document_num FROM ps_document WHERE document_num = '304' AND id_document != '90152' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 11:00:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '304', document_date = '2024-01-30', 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 = '171.90', price_tax_excluded = '140.90', date_upd = NOW() WHERE id_document = '90152' 30/01/2024 11:00: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 = '90152' 30/01/2024 11:00:52 am >> DELETE FROM ps_document_detail WHERE id_document = '90152' 30/01/2024 11:00: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 ( '90152' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 30/01/2024 11:00: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 ( '90152' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.00' , '55.737704918033' , '22' , '0' , '68.00' ) 30/01/2024 11:00: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 ( '90152' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '16.00' ) 30/01/2024 11:00: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 ( '90152' , '17617' , 'IMMAGINI ISONZO X 100' , '20' , '-20' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '70.00' ) 30/01/2024 11:13:41 am >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 11:13:41 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 ( '24' , '13/A' , '2024-01-30' , 'A' , '2332' , '0' , '4679092' , 'P.ZZA S. ROCCO 84088 SIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 30/01/2024 11:13: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 = '90153' 30/01/2024 11:13:41 am >> DELETE FROM ps_document_detail WHERE id_document = '90153' 30/01/2024 11:13: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 ( '90153' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 30/01/2024 11:15:21 am >> SELECT document_num FROM ps_document WHERE document_num = '304' AND id_document != '90152' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 11:15:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '304', document_date = '2024-01-30', 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 = '171.90', price_tax_excluded = '140.90', date_upd = NOW() WHERE id_document = '90152' 30/01/2024 11:15: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 = '90152' 30/01/2024 11:15:21 am >> DELETE FROM ps_document_detail WHERE id_document = '90152' 30/01/2024 11:15: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 ( '90152' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.9000' , '14.672131147541' , '22' , '0' , '17.90' ) 30/01/2024 11:15: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 ( '90152' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '68.00' ) 30/01/2024 11:15: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 ( '90152' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '2' , '-2' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '16.00' ) 30/01/2024 11:15: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 ( '90152' , '17617' , 'IMMAGINI ISONZO X 100' , '20' , '-20' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '70.00' ) 30/01/2024 11:17:12 am >> DELETE FROM ps_document WHERE id_document = '89074' 30/01/2024 11:17:12 am >> DELETE FROM ps_document_detail WHERE id_document = '89074' 30/01/2024 03:34:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400271966' AND id_product != '18276' AND ean13 != '' 30/01/2024 03:34:05 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400271966', date_upd = NOW() WHERE id_product = '18276' 30/01/2024 03:34:05 pm >> UPDATE ps_product_lang SET name = 'CINGOLO CON NODI - 3280', description = '' WHERE id_product = '18276' 30/01/2024 03:34:05 pm >> UPDATE ps_product SET wholesale_price = '0.99', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '18276' 30/01/2024 03:34:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.99', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18276' 30/01/2024 03:34:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '18276' 30/01/2024 03:34:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '305' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 03:34: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' , '305' , '2024-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.50' , '2.05' , NOW() , NOW() ) 30/01/2024 03:34: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 = '90154' 30/01/2024 03:34:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '90154' 30/01/2024 03:34: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 ( '90154' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 30/01/2024 03:43:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '306' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 03:43:40 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' , '306' , '2024-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 30/01/2024 03:43:40 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 = '90155' 30/01/2024 03:43:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '90155' 30/01/2024 03:43:40 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 ( '90155' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '20' , '-20' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '6.00' ) 30/01/2024 03:43:40 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 ( '90155' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 30/01/2024 03:49:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '6' AND id_document != '89782' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-03') 30/01/2024 03:49:19 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '6', document_date = '2024-01-03', document_letter = '', id_customer = '467', id_supplier = '', id_address = '4669419', address1 = 'VIA GIOVANNI ANDREA MELONI, 14 09075 SANTU LUSSURGIU', 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 = '119.05', price_tax_excluded = '119.05', date_upd = NOW() WHERE id_document = '89782' 30/01/2024 03:49:19 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 = '89782' 30/01/2024 03:49:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89782' 30/01/2024 03:49:19 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 ( '89782' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '20' , '-20' , '4' , '2.4000' , '2.4' , '0' , '15' , '40.80' ) 30/01/2024 03:49:19 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 ( '89782' , '11193' , 'VENITE CON ME CAT.' , '14' , '-14' , '4' , '5.5000' , '5.5' , '0' , '5' , '73.15' ) 30/01/2024 03:49:19 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 ( '89782' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '5.1' , '5.1' , '0' , '0' , '5.10' ) 30/01/2024 03:50:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '89879' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-09') 30/01/2024 03:50:27 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '9', document_date = '2024-01-09', document_letter = '', id_customer = '4079', id_supplier = '', id_address = '4679251', address1 = 'VIA ZINGONAGLIE 11 87046 MONTALTO UFFUGO', address2 = '', note = '', price_shipping = '5.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 = '15.64', price_tax_excluded = '15.64', date_upd = NOW() WHERE id_document = '89879' 30/01/2024 03:50:27 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 = '89879' 30/01/2024 03:50:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '89879' 30/01/2024 03:50:27 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 ( '89879' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '5.89' , '5.89' , '0' , '0' , '5.89' ) 30/01/2024 03:50:27 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 ( '89879' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 30/01/2024 03:50:27 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 ( '89879' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 30/01/2024 03:57:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '13' AND id_document != '89960' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-16') 30/01/2024 03:57:44 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '13', document_date = '2024-01-16', document_letter = '', id_customer = '949', id_supplier = '', id_address = '4679102', address1 = 'VIA P. PALMIERI 39 10138 TORINO', address2 = '', note = '', price_shipping = '6.40', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '435.00', price_tax_excluded = '435.00', date_upd = NOW() WHERE id_document = '89960' 30/01/2024 03:57: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 = '89960' 30/01/2024 03:57:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '89960' 30/01/2024 03:57: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 ( '89960' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '15' , '47.60' ) 30/01/2024 03:57: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 ( '89960' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '10' , '-10' , '4' , '20' , '20' , '0' , '0' , '200.00' ) 30/01/2024 03:57: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 ( '89960' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '20' , '-20' , '4' , '10.00' , '10' , '0' , '15' , '170.00' ) 30/01/2024 03:57: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 ( '89960' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 30/01/2024 04:00:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '20' AND id_document != '90059' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-22') 30/01/2024 04:00:53 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '20', document_date = '2024-01-22', document_letter = '', id_customer = '2159', id_supplier = '', id_address = '4678463', address1 = 'VIA CAVAROLA, 3 41054 MARANO SUL PANARO', address2 = '', note = 'crocifissione c', 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 = '137.70', price_tax_excluded = '137.70', date_upd = NOW() WHERE id_document = '90059' 30/01/2024 04:00:53 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 = '90059' 30/01/2024 04:00:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '90059' 30/01/2024 04:00:53 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 ( '90059' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '5' , '-5' , '4' , '25.00' , '25' , '0' , '15' , '106.25' ) 30/01/2024 04:00:53 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 ( '90059' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '15' , '25.50' ) 30/01/2024 04:00:54 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 ( '90059' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '5.95' , '5.95' , '0' , '0' , '5.95' ) 30/01/2024 04:01:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '22' AND id_document != '90064' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-24') 30/01/2024 04:01:42 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '22', document_date = '2024-01-24', document_letter = '', id_customer = '4075', id_supplier = '', id_address = '4679231', address1 = 'VIA PARROCO PALI 39020 SLUDERNO', address2 = '', note = '', price_shipping = '5.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 = '17.40', price_tax_excluded = '17.40', date_upd = NOW() WHERE id_document = '90064' 30/01/2024 04:01:42 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 = '90064' 30/01/2024 04:01:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '90064' 30/01/2024 04:01:42 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 ( '90064' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 30/01/2024 04:01:42 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 ( '90064' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 30/01/2024 04:05:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '3700' AND id_document != '89103' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 30/01/2024 04:05:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3700', document_date = '2023-11-23', 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 = '250.00', price_tax_excluded = '204.92', date_upd = NOW() WHERE id_document = '89103' 30/01/2024 04:05:00 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 = '89103' 30/01/2024 04:05:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '89103' 30/01/2024 04:05:00 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 ( '89103' , '20273' , 'CASULA IHS - 220' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 30/01/2024 04:05:00 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 ( '89103' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '102.1' , '83.688524590164' , '22' , '0' , '102.10' ) 30/01/2024 04:05:00 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 ( '89103' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 30/01/2024 04:05:00 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 ( '89103' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '60.00' ) 30/01/2024 04:06:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '123' AND id_document != '89924' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-12') 30/01/2024 04:06:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '123', document_date = '2024-01-12', 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 = '444.93', price_tax_excluded = '377.67', date_upd = NOW() WHERE id_document = '89924' 30/01/2024 04:06:54 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 = '89924' 30/01/2024 04:06:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '89924' 30/01/2024 04:06:54 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 ( '89924' , '13078' , 'LEGGIO IN LEGNO - 043' , '1' , '-1' , '1' , '120.0000' , '98.360655737705' , '22' , '0' , '120.00' ) 30/01/2024 04:06:54 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 ( '89924' , '13079' , 'COPPIA CANDELIERI IN LEGNO - 033' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 30/01/2024 04:06:54 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 ( '89924' , '13256' , 'SINAI: VIAGGIO CON MOSE - GIOCO' , '1' , '-1' , '4' , '19.9000' , '19.9' , '0' , '5' , '18.91' ) 30/01/2024 04:06:54 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 ( '89924' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '5' , '17.01' ) 30/01/2024 04:06:54 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 ( '89924' , '22002' , 'DOMENICA DELLA PAROLA 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 30/01/2024 04:06:54 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 ( '89924' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 30/01/2024 04:06:54 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 ( '89924' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '6' , '-6' , '4' , '5.0000' , '5' , '0' , '5' , '28.50' ) 30/01/2024 04:06:54 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 ( '89924' , '17617' , 'IMMAGINI ISONZO X 100' , '14' , '-14' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '49.00' ) 30/01/2024 04:06:54 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 ( '89924' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 30/01/2024 04:06:54 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 ( '89924' , '22055' , 'CROCE IN PVC -' , '100' , '-100' , '1' , '1.39' , '1.1393442622951' , '22' , '0' , '139.00' ) 30/01/2024 04:07:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '154' AND id_document != '89958' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-16') 30/01/2024 04:07:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '154', document_date = '2024-01-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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '89958' 30/01/2024 04:07: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 = '89958' 30/01/2024 04:07:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89958' 30/01/2024 04:07: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 ( '89958' , '15055' , 'CROCE PADRE NOSTRO' , '15' , '-15' , '1' , '3' , '2.4590163934426' , '22' , '0' , '45.00' ) 30/01/2024 04:08:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '189' AND id_document != '90003' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-18') 30/01/2024 04:08:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '189', document_date = '2024-01-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 = '93.10', price_tax_excluded = '79.58', date_upd = NOW() WHERE id_document = '90003' 30/01/2024 04:08: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 = '90003' 30/01/2024 04:08:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '90003' 30/01/2024 04:08: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 ( '90003' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '10' , '-10' , '4' , '1.9000' , '1.9' , '0' , '5' , '18.10' ) 30/01/2024 04:08: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 ( '90003' , '15055' , 'CROCE PADRE NOSTRO' , '25' , '-25' , '1' , '3' , '2.4590163934426' , '22' , '0' , '75.00' ) 30/01/2024 04:09:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '151' AND id_document != '89954' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-16') 30/01/2024 04:09:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '151', document_date = '2024-01-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.02', price_tax_excluded = '33.41', date_upd = NOW() WHERE id_document = '89954' 30/01/2024 04:09: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 = '89954' 30/01/2024 04:09:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '89954' 30/01/2024 04:09: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 ( '89954' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 30/01/2024 04:09: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 ( '89954' , '22002' , 'DOMENICA DELLA PAROLA 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 30/01/2024 04:09: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 ( '89954' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 30/01/2024 04:09: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 ( '89954' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE - PADRE G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 30/01/2024 04:09: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 ( '89954' , '15055' , 'CROCE PADRE NOSTRO' , '10' , '-10' , '1' , '2' , '1.6393442622951' , '22' , '0' , '20.00' ) 30/01/2024 04:14:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '307' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 04:14:21 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' , '307' , '2024-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.40' , '4.86' , NOW() , NOW() ) 30/01/2024 04:14:21 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 = '90156' 30/01/2024 04:14:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '90156' 30/01/2024 04:14:21 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 ( '90156' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '1.2' , '1.2' , '0' , '0' , '2.40' ) 30/01/2024 04:14:21 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 ( '90156' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 30/01/2024 04:14:21 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 ( '90156' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 30/01/2024 04:50:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '308' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 04:50:56 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' , '308' , '2024-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '55.00' , NOW() , NOW() ) 30/01/2024 04:50: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 = '90157' 30/01/2024 04:50:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '90157' 30/01/2024 04:50: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 ( '90157' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '55' , '55' , '0' , '0' , '55.00' ) 30/01/2024 05:22:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '24' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 05:22:09 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' , '24' , '2024-01-30' , '' , '2755' , '0' , '4677545' , 'VIA PRINCIPE DI PIEMONTE 04026 MINTURNO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '41.97' , '41.97' , NOW() , NOW() ) 30/01/2024 05:22:09 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 = '90158' 30/01/2024 05:22:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '90158' 30/01/2024 05:22:09 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 ( '90158' , '20725' , 'NELLO STUPORE DELLA CROCE - U. DE VANNA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 30/01/2024 05:22:09 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 ( '90158' , '20790' , 'AI PIEDI DEL SUO AMORE ' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 30/01/2024 05:22:09 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 ( '90158' , '20872' , 'CON TE GESU - ' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 30/01/2024 05:22:09 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 ( '90158' , '22085' , 'FATICA DEL CAMMINO - S. DI BENEDETTO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 30/01/2024 05:22:09 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 ( '90158' , '22093' , 'VIA CRUCIS DEI BAMBINI - M. GATTAFONI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 30/01/2024 05:22:09 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 ( '90158' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 30/01/2024 05:22:09 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 ( '90158' , '22092' , 'VIA CRUCIS DI FRATERNITA - A. COMASTRI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 30/01/2024 05:22:09 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 ( '90158' , '22080' , 'LI AMO SINO ALLA FINE - QA. RAMINA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 30/01/2024 05:22:09 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 ( '90158' , '22073' , 'VIA CRUCIS PELLEGRINI DI SPERANZA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 30/01/2024 05:22:09 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 ( '90158' , '22064' , 'QUARESIMA 2024' , '1' , '-1' , '4' , '3.60' , '3.6' , '0' , '5' , '3.42' ) 30/01/2024 05:22:10 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 ( '90158' , '22078' , 'CHICCO DI GRANO - QUARESIMA BAMBINI 2024' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '5' , '4.75' ) 30/01/2024 05:22:10 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 ( '90158' , '22077' , 'QUARESIMA E PASQUA 2024' , '2' , '-2' , '4' , '2.90' , '2.9' , '0' , '5' , '5.51' ) 30/01/2024 05:35:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '309' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 05:35:43 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' , '309' , '2024-01-30' , '' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '94.10' , NOW() , NOW() ) 30/01/2024 05:35:43 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 = '90159' 30/01/2024 05:35:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90159' 30/01/2024 05:35:43 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 ( '90159' , '21809' , 'AMEN - GEN 2024' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 30/01/2024 05:35:43 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 ( '90159' , '21810' , 'AMEN - FEB 2024' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 30/01/2024 05:35:43 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 ( '90159' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3654' , '4' , '0' , '3.50' ) 30/01/2024 05:35:43 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 ( '90159' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9231' , '4' , '0' , '14.00' ) 30/01/2024 05:35:43 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 ( '90159' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '2' , '-2' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '1.00' ) 30/01/2024 05:35:43 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 ( '90159' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '10' , '-10' , '1' , '1.0000' , '0.8197' , '22' , '0' , '10.00' ) 30/01/2024 05:35:43 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 ( '90159' , '2653' , 'CONFEZIONE CARTONCINO CON BAMBINO - P391' , '20' , '-20' , '1' , '0.6000' , '0.4918' , '22' , '0' , '12.00' ) 30/01/2024 05:35:43 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 ( '90159' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '6.0000' , '4.918' , '22' , '0' , '6.00' ) 30/01/2024 05:35:43 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 ( '90159' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 30/01/2024 05:36:00 pm >> DELETE FROM ps_document WHERE id_document = '89040' 30/01/2024 05:36:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '89040' 30/01/2024 05:39:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '309' AND id_document != '90159' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 05:39:38 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '309', document_date = '2024-01-30', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 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 = '100.00', price_tax_excluded = '94.10', date_upd = NOW() WHERE id_document = '90159' 30/01/2024 05:39: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 = '90159' 30/01/2024 05:39:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '90159' 30/01/2024 05:39: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 ( '90159' , '21809' , 'AMEN - GEN 2024' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 30/01/2024 05:39: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 ( '90159' , '21810' , 'AMEN - FEB 2024' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 30/01/2024 05:39: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 ( '90159' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 30/01/2024 05:39: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 ( '90159' , '16689' , 'OSTIA PAN DI CENA mm80' , '7' , '-7' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '14.00' ) 30/01/2024 05:39: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 ( '90159' , '7933' , 'PERGAMENE - CRESIMA MOD. B' , '2' , '-2' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '1.00' ) 30/01/2024 05:39: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 ( '90159' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '10' , '-10' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '10.00' ) 30/01/2024 05:39: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 ( '90159' , '2653' , 'CONFEZIONE CARTONCINO CON BAMBINO - P391' , '20' , '-20' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '12.00' ) 30/01/2024 05:39: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 ( '90159' , '18884' , 'BAMBINELLO CM 10 - PB13627' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 30/01/2024 05:39: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 ( '90159' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 30/01/2024 05:46:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 05:46:10 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 ( '24' , '14/A' , '2024-01-30' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'OSPEDALE SAN LEONARNO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.60' , '41.41' , NOW() , NOW() ) 30/01/2024 05:46:10 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 = '90160' 30/01/2024 05:46:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '90160' 30/01/2024 05:46:10 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 ( '90160' , '21920' , 'AMEN - MAR 24' , '5' , '-5' , '4' , '2.90' , '2.9' , '0' , '0' , '14.50' ) 30/01/2024 05:46:10 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 ( '90160' , '21919' , 'AMEN - APR 24' , '5' , '-5' , '4' , '2.90' , '2.9' , '0' , '0' , '14.50' ) 30/01/2024 05:46:10 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 ( '90160' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 30/01/2024 05:46:10 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 ( '90160' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '6' , '-6' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '6.00' ) 30/01/2024 05:46:10 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 ( '90160' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '1' , '-1' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '0.60' ) 30/01/2024 05:58:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '310' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 05:58:15 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' , '310' , '2024-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.50' , NOW() , NOW() ) 30/01/2024 05:58:15 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 = '90161' 30/01/2024 05:58:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '90161' 30/01/2024 05:58:15 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 ( '90161' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.5' , '4.5' , '0' , '0' , '4.50' ) 30/01/2024 06:09:19 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3858' 30/01/2024 06:09:19 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3858' , '10' , '205' , 'PARROCCHIA DI BIBBIANO' , 'ZANETTI' , 'FIORENZA' , 'VIA G.B.VENTURI 140' , '' , '42021' , 'BIBBIANO' , '' , '' , '338/3175667' , '' , '' , NOW() , NOW() ) 30/01/2024 06:09:20 pm >> UPDATE ps_customer SET email = 'fiorenza.z2004@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3858' 30/01/2024 06:10:30 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3859' 30/01/2024 06:10:30 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3859' , '10' , '205' , 'PARROCCHIA DI BIBBIANO' , 'DARMETKO' , 'don WOJCIECH' , 'VIA G.B.VENTURI , 140' , '' , '42021' , 'BIBBIANO' , '' , '' , '3383175667' , '' , '' , NOW() , NOW() ) 30/01/2024 06:10:30 pm >> UPDATE ps_customer SET email = 'FIORENZA.Z2004@LIBERO.IT', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3859' 30/01/2024 06:11:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 06:11:03 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' , '25' , '2024-01-30' , '' , '3859' , '0' , '4679260' , 'VIA G.B.VENTURI , 140 42021 BIBBIANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '45.38' , '45.38' , NOW() , NOW() ) 30/01/2024 06:11:03 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 = '90162' 30/01/2024 06:11:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '90162' 30/01/2024 06:11:03 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 ( '90162' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '50' , '-50' , '4' , '0.85' , '0.85' , '0' , '5' , '40.38' ) 30/01/2024 06:12:21 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3859' 30/01/2024 06:12:21 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3859' , '10' , '205' , 'PARROCCHIA DI BIBBIANO' , 'DARMETKO' , 'don WOJCIECH' , 'VIA G.B.VENTURI , 140' , '' , '42021' , 'BIBBIANO' , '' , '' , '3383175667' , '' , '' , NOW() , NOW() ) 30/01/2024 06:12:21 pm >> UPDATE ps_customer SET email = 'fiorenza.z2004@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3859' 30/01/2024 06:33:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '14/A' AND id_document != '90160' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 06:33:13 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '14/A', document_date = '2024-01-30', document_letter = 'A', id_customer = '3842', id_supplier = '0', id_address = '4673208', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'OSPEDALE SAN LEONARNO', 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 = '42.60', price_tax_excluded = '41.41', date_upd = NOW() WHERE id_document = '90160' 30/01/2024 06:33: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 = '90160' 30/01/2024 06:33:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '90160' 30/01/2024 06:33: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 ( '90160' , '21920' , 'AMEN - MAR 24' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 30/01/2024 06:33: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 ( '90160' , '21919' , 'AMEN - APR 24' , '5' , '-5' , '4' , '2.9000' , '2.9' , '0' , '0' , '14.50' ) 30/01/2024 06:33: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 ( '90160' , '6283' , 'MASSIME ETERNE - 8362' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 30/01/2024 06:33: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 ( '90160' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 30/01/2024 06:33: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 ( '90160' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '1' , '-1' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '0.60' ) 30/01/2024 06:58:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '311' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-30') 30/01/2024 06:58:00 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' , '311' , '2024-01-30' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.40' , '46.23' , NOW() , NOW() ) 30/01/2024 06:58:00 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 = '90163' 30/01/2024 06:58:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '90163' 30/01/2024 06:58:00 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 ( '90163' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' )