29/04/2023 09:06:03 am >> SELECT document_num FROM ps_document WHERE document_num = '46/A' AND id_document != '82651' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-04') 29/04/2023 09:06:03 am >> UPDATE ps_document SET id_document_type = '24', document_num = '46/A', document_date = '2023-04-04', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 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 = '0', id_causal = '0', price_tax_included = '210.50', price_tax_excluded = '179.03', date_upd = NOW() WHERE id_document = '82651' 29/04/2023 09:06:03 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 = '82651' 29/04/2023 09:06:03 am >> DELETE FROM ps_document_detail WHERE id_document = '82651' 29/04/2023 09:06:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '4418' , 'GESÙ CROCIFISSO - 200 ' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 29/04/2023 09:06:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '8928' , 'RESURREZIONE - 353 ' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 29/04/2023 09:06:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '4' , '-4' , '0' , '9.0000' , '9' , '0' , '0' , '36.00' ) 29/04/2023 09:06:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '12337' , 'LUMINI ART. ECO 2 ROSSO' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 29/04/2023 09:06:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '16068' , 'CAMICE PIEGONI 2 INSERTI - AECM17B05' , '1' , '-1' , '1' , '120.00' , '98.360655737705' , '22' , '0' , '120.00' ) 29/04/2023 09:06:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 29/04/2023 09:15:54 am >> SELECT document_num FROM ps_document WHERE document_num = '56/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 09:15:54 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' , '56/A' , '2023-04-29' , 'A' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '84.00' , '68.85' , NOW() , NOW() ) 29/04/2023 09:15:54 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 = '83029' 29/04/2023 09:15:54 am >> DELETE FROM ps_document_detail WHERE id_document = '83029' 29/04/2023 09:15:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83029' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '6' , '-6' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '84.00' ) 29/04/2023 09:22:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1426' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 09:22:31 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' , '1426' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 29/04/2023 09:22:31 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 = '83030' 29/04/2023 09:22:31 am >> DELETE FROM ps_document_detail WHERE id_document = '83030' 29/04/2023 09:22:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83030' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/04/2023 09:31:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1427' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 09:31:42 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' , '1427' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '134.00' , '109.84' , NOW() , NOW() ) 29/04/2023 09:31:42 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 = '83031' 29/04/2023 09:31:42 am >> DELETE FROM ps_document_detail WHERE id_document = '83031' 29/04/2023 09:31:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83031' , '16068' , 'CAMICE PIEGONI 2 INSERTI - AECM17B05' , '1' , '-1' , '1' , '120.00' , '98.360655737705' , '22' , '0' , '120.00' ) 29/04/2023 09:31:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83031' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 29/04/2023 09:32:31 am >> SELECT document_num FROM ps_document WHERE document_num = '46/A' AND id_document != '82651' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-04') 29/04/2023 09:32:31 am >> UPDATE ps_document SET id_document_type = '24', document_num = '46/A', document_date = '2023-04-04', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4670910', address1 = 'VIA PIAVE, 4 84080 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 = '0', id_causal = '0', price_tax_included = '76.50', price_tax_excluded = '69.20', date_upd = NOW() WHERE id_document = '82651' 29/04/2023 09:32:31 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 = '82651' 29/04/2023 09:32:31 am >> DELETE FROM ps_document_detail WHERE id_document = '82651' 29/04/2023 09:32:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '4418' , 'GESÙ CROCIFISSO - 200 ' , '1' , '-1' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '3.50' ) 29/04/2023 09:32:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '8928' , 'RESURREZIONE - 353 ' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 29/04/2023 09:32:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '4' , '-4' , '0' , '9.0000' , '9' , '0' , '0' , '36.00' ) 29/04/2023 09:32:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82651' , '12337' , 'LUMINI ART. ECO 2 ROSSO' , '4' , '-4' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '30.00' ) 29/04/2023 09:49:59 am >> SELECT document_num FROM ps_document WHERE document_num = '1428' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 09:49:59 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' , '1428' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.50' , '54.51' , NOW() , NOW() ) 29/04/2023 09:49:59 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 = '83032' 29/04/2023 09:49:59 am >> DELETE FROM ps_document_detail WHERE id_document = '83032' 29/04/2023 09:49:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83032' , '16311' , 'DECINA MISSIONARIA' , '133' , '-133' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '66.50' ) 29/04/2023 10:10:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1429' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 10:10:05 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' , '1429' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '46.00' , '37.70' , NOW() , NOW() ) 29/04/2023 10:10:05 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 = '83033' 29/04/2023 10:10:05 am >> DELETE FROM ps_document_detail WHERE id_document = '83033' 29/04/2023 10:10:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83033' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 29/04/2023 10:10:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83033' , '1331' , 'BRACCIALE LEGNO BICOLORE - 034CYB499' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 29/04/2023 10:20:59 am >> SELECT document_num FROM ps_document WHERE document_num = '16' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 10:20:59 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' , '16' , '2023-04-29' , '' , '7016' , '0' , '102683561' , 'PIAZZA SANTA MARIA 2 60027 OSIMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '85.00' , '85.00' , NOW() , NOW() ) 29/04/2023 10:20:59 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 = '11066' 29/04/2023 10:20:59 am >> DELETE FROM ps_document_detail WHERE id_document = '11066' 29/04/2023 10:20:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11066' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '20' , '-20' , '4' , '2.00' , '2' , '0' , '15' , '34.00' ) 29/04/2023 10:20:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11066' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '2' , '-2' , '4' , '30.00' , '30' , '0' , '15' , '51.00' ) 29/04/2023 10:36:19 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788825032277' AND id_product != '20105' AND ean13 != '' 29/04/2023 10:36:19 am >> UPDATE ps_product SET id_supplier = '7', reference = '11/5', ean13 = '9788825032277', date_upd = NOW() WHERE id_product = '20105' 29/04/2023 10:36:19 am >> UPDATE ps_product_lang SET name = 'DALLA MELA DI EVA ALLE ZANZARE DI NOE\' - S. PAGANINI', description = '' WHERE id_product = '20105' 29/04/2023 10:36:19 am >> UPDATE ps_product SET wholesale_price = '10.50', on_sale = '0', price = '15.0000' WHERE id_product = '20105' 29/04/2023 10:36:19 am >> UPDATE ps_product_shop SET wholesale_price = '10.50', price = '15.0000', id_tax_rules_group = '4', id_category_default = '17', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20105' 29/04/2023 10:36:19 am >> DELETE FROM ps_specific_price WHERE id_product = '20105' 29/04/2023 10:49:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1430' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 10:49:19 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' , '1430' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 29/04/2023 10:49:19 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 = '83034' 29/04/2023 10:49:19 am >> DELETE FROM ps_document_detail WHERE id_document = '83034' 29/04/2023 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83034' , '20245' , 'FORMELLA CROCIFISSO 25X30' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 29/04/2023 11:24:39 am >> SELECT document_num FROM ps_document WHERE document_num = '1431' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 11:24: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' , '1431' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '47.70' , '45.36' , NOW() , NOW() ) 29/04/2023 11:24: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 = '83035' 29/04/2023 11:24:39 am >> DELETE FROM ps_document_detail WHERE id_document = '83035' 29/04/2023 11:24: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 ( '83035' , '20843' , 'MESSA MEDITAZIONE - MAG/GIU 2023' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 29/04/2023 11:24: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 ( '83035' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 29/04/2023 11:24:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83035' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 29/04/2023 11:24:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83035' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 29/04/2023 11:35:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1432' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 11:35: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' , '1432' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.60' , '48.03' , NOW() , NOW() ) 29/04/2023 11:35: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 = '83036' 29/04/2023 11:35:29 am >> DELETE FROM ps_document_detail WHERE id_document = '83036' 29/04/2023 11:35:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83036' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 29/04/2023 11:35:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83036' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.4' , '2.7868852459016' , '22' , '0' , '3.40' ) 29/04/2023 11:35:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83036' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 29/04/2023 11:35:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83036' , '16398' , 'MADONNA DELLE GRAZIE - 143' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 29/04/2023 11:35:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83036' , '12490' , 'CROCE SAN BENEDETTO ULIVO - CZ6NIK' , '1' , '-1' , '1' , '17.00' , '13.934426229508' , '22' , '0' , '17.00' ) 29/04/2023 11:37:34 am >> SELECT document_num FROM ps_document WHERE document_num = '1433' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 11:37: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' , '1433' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.90' , '3.72' , NOW() , NOW() ) 29/04/2023 11:37: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 = '83037' 29/04/2023 11:37:34 am >> DELETE FROM ps_document_detail WHERE id_document = '83037' 29/04/2023 11:37: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 ( '83037' , '19292' , 'PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 29/04/2023 11:37: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 ( '83037' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 29/04/2023 11:40:59 am >> SELECT document_num FROM ps_document WHERE document_num = '1434' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 11:40:59 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' , '1434' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 29/04/2023 11:40:59 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 = '83038' 29/04/2023 11:40:59 am >> DELETE FROM ps_document_detail WHERE id_document = '83038' 29/04/2023 11:40:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83038' , '20792' , 'CAMICE MARIANO - 70/001035 MARIANO' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 29/04/2023 11:54:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1435' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 11:54:19 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' , '1435' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '151.00' , '123.77' , NOW() , NOW() ) 29/04/2023 11:54:19 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 = '83039' 29/04/2023 11:54:19 am >> DELETE FROM ps_document_detail WHERE id_document = '83039' 29/04/2023 11:54:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83039' , '11389' , 'VINO ROSSO DOLCE - 103' , '18' , '-18' , '1' , '8' , '6.5573770491803' , '22' , '0' , '144.00' ) 29/04/2023 11:54:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83039' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 29/04/2023 11:55:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1436' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 11:55: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' , '1436' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.25' , '1.84' , NOW() , NOW() ) 29/04/2023 11:55: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 = '83040' 29/04/2023 11:55:29 am >> DELETE FROM ps_document_detail WHERE id_document = '83040' 29/04/2023 11:55:29 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83040' , '9797' , 'SEGNALIBRO CRESIMA - 95-26 ' , '9' , '-9' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '2.25' ) 29/04/2023 11:56:12 am >> SELECT document_num FROM ps_document WHERE document_num = '1437' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 11:56: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' , '1437' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 29/04/2023 11:56: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 = '83041' 29/04/2023 11:56:12 am >> DELETE FROM ps_document_detail WHERE id_document = '83041' 29/04/2023 11:56:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '83041' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '6' , '-6' , '4' , '5.00' , '5' , '0' , '5' , '28.50' ) 29/04/2023 12:02:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1438' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 12:02:20 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' , '1438' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 29/04/2023 12:02:20 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 = '83042' 29/04/2023 12:02:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '83042' 29/04/2023 12:02:20 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 ( '83042' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 29/04/2023 12:03:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1439' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 12:03:36 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' , '1439' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.99' , '9.99' , NOW() , NOW() ) 29/04/2023 12:03:36 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 = '83043' 29/04/2023 12:03:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '83043' 29/04/2023 12:03:36 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 ( '83043' , '13397' , 'MIO GESU' , '3' , '-3' , '4' , '3.50' , '3.5' , '0' , '5' , '9.99' ) 29/04/2023 12:06:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '1440' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 12:06:53 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' , '1440' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.60' , '95.90' , NOW() , NOW() ) 29/04/2023 12:06: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 = '83044' 29/04/2023 12:06:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '83044' 29/04/2023 12:06: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 ( '83044' , '20795' , 'SULLA TUA PAROLA MAG/GIU 2023 - 516' , '17' , '-17' , '4' , '5.00' , '5' , '0' , '5' , '80.75' ) 29/04/2023 12:06: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 ( '83044' , '18194' , 'UN MESE CON MARIA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 29/04/2023 12:06: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 ( '83044' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 29/04/2023 12:15:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1436' AND id_document != '83040' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 12:15:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1436', document_date = '2023-04-29', 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 = '2.25', price_tax_excluded = '1.84', date_upd = NOW() WHERE id_document = '83040' 29/04/2023 12:15: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 = '83040' 29/04/2023 12:15:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '83040' 29/04/2023 12:15: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 ( '83040' , '7936' , 'PERGAMENE - CRESIMA MOD. C' , '4' , '-4' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.00' ) 29/04/2023 12:15: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 ( '83040' , '7935' , 'PERGAMENE - CRESIMA MOD. B' , '1' , '-1' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '0.25' ) 29/04/2023 12:28:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801028454' AND id_product != '9603' AND ean13 != '' 29/04/2023 12:28:50 pm >> UPDATE ps_product SET id_supplier = '17', reference = '6/4', ean13 = '9788801028454', date_upd = NOW() WHERE id_product = '9603' 29/04/2023 12:28:50 pm >> UPDATE ps_product_lang SET name = 'SANTA RITA DA CASCIA - V. PERI', description = '' WHERE id_product = '9603' 29/04/2023 12:28:50 pm >> UPDATE ps_product SET wholesale_price = '2.50', on_sale = '0', price = '5.0000' WHERE id_product = '9603' 29/04/2023 12:28:50 pm >> UPDATE ps_product_shop SET wholesale_price = '2.50', price = '5.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9603' 29/04/2023 12:28:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '9603' 29/04/2023 12:34:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1441' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 12:34: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' , '1441' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 29/04/2023 12:34: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 = '83045' 29/04/2023 12:34:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '83045' 29/04/2023 12:34: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 ( '83045' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 29/04/2023 12:43:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '1442' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 12:43:28 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' , '1442' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.25' , '14.26' , NOW() , NOW() ) 29/04/2023 12:43:28 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 = '83046' 29/04/2023 12:43:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '83046' 29/04/2023 12:43:28 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 ( '83046' , '13363' , 'CORONA MM 6 ' , '1' , '-1' , '1' , '3' , '2.4590163934426' , '22' , '0' , '3.00' ) 29/04/2023 12:43:28 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 ( '83046' , '12936' , 'SCATOLA 4X4' , '1' , '-1' , '1' , '0.3' , '0.24590163934426' , '22' , '0' , '0.30' ) 29/04/2023 12:43:28 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 ( '83046' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '20' , '-20' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '12.00' ) 29/04/2023 12:43:28 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 ( '83046' , '8254' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.65' , '0.65' , '0' , '0' , '0.65' ) 29/04/2023 12:43:28 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 ( '83046' , '13506' , 'SANTO ROSARIO' , '1' , '-1' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '0.30' ) 29/04/2023 12:43:28 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 ( '83046' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 29/04/2023 12:44:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '57/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 12:44:37 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' , '57/A' , '2023-04-29' , 'A' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 29/04/2023 12:44:37 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 = '83047' 29/04/2023 12:44:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '83047' 29/04/2023 12:44:37 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 ( '83047' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 29/04/2023 12:44:37 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 ( '83047' , '17702' , 'BENEDETTO XVI - P. SEEWALD' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 29/04/2023 12:45:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1443' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 12:45:52 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' , '1443' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '65.00' , '53.28' , NOW() , NOW() ) 29/04/2023 12:45:52 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 = '83048' 29/04/2023 12:45:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '83048' 29/04/2023 12:45: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 ( '83048' , '15537' , 'AMITTO PURO LINO RICAMO A MANO' , '1' , '-1' , '1' , '65' , '53.27868852459' , '22' , '0' , '65.00' ) 29/04/2023 12:47:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1444' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 12:47:32 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' , '1444' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '64.55' , '53.77' , NOW() , NOW() ) 29/04/2023 12:47:32 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 = '83049' 29/04/2023 12:47:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '83049' 29/04/2023 12:47:32 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 ( '83049' , '20707' , 'LUME LEGNO' , '2' , '-2' , '1' , '29.90' , '24.508196721311' , '22' , '0' , '59.80' ) 29/04/2023 12:47:32 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 ( '83049' , '9603' , 'SANTA RITA DA CASCIA - V.PERI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/04/2023 01:27:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1445' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-29') 29/04/2023 01:27:25 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' , '1445' , '2023-04-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '453.00' , '392.50' , NOW() , NOW() ) 29/04/2023 01:27:25 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 = '83050' 29/04/2023 01:27:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '83050' 29/04/2023 01:27:25 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 ( '83050' , '17034' , 'SACRAMENTO DEL PERDONO' , '6' , '-6' , '4' , '2.00' , '2' , '0' , '5' , '11.40' ) 29/04/2023 01:27:25 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 ( '83050' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 29/04/2023 01:27:25 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 ( '83050' , '19956' , 'VITA DI CRISTO - F. SHEEN' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 29/04/2023 01:27:25 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 ( '83050' , '20864' , 'MESSALINO QUOTIDIANO - MAG/GIU/LUG 23' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 29/04/2023 01:27:25 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 ( '83050' , '18496' , 'MAZZO DI ROSE A SANTA RITA - 8029' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 29/04/2023 01:27:25 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 ( '83050' , '16882' , 'S. RITA DA CASCIA VITA BREVIS' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 29/04/2023 01:27:25 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 ( '83050' , '15805' , 'TREDICINA A SANTANTONIO DI PADOVA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 29/04/2023 01:27:25 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 ( '83050' , '8398' , 'PREGHIERE PRIMA E DOPO LA COMUNIONE - 8276' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 29/04/2023 01:27:25 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 ( '83050' , '7436' , 'PANE DI SANTANTONIO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 29/04/2023 01:27:25 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 ( '83050' , '10726' , 'TREDICINA A SANTANTONIO DI PADOVA' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 29/04/2023 01:27:25 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 ( '83050' , '19155' , 'TREDICINA A SANTANTONIO - 8042' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 29/04/2023 01:27:25 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 ( '83050' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 29/04/2023 01:27:25 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 ( '83050' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 29/04/2023 01:27:25 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 ( '83050' , '5190' , 'IN ONORE DI SAN GIUSEPPE - 8190' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 29/04/2023 01:27:25 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 ( '83050' , '8254' , 'PREGHIAMO CON MARIA' , '2' , '-2' , '4' , '0.65' , '0.65' , '0' , '0' , '1.30' ) 29/04/2023 01:27:25 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 ( '83050' , '8365' , 'PREGHIERE DI BENEDIZIONE E DI LIBERAZIONE...' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 29/04/2023 01:27:25 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 ( '83050' , '20932' , 'SOSTARE CON DIO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 29/04/2023 01:27:25 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 ( '83050' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 29/04/2023 01:27:26 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 ( '83050' , '15020' , 'PREGARE OGNI GIORNO' , '2' , '-2' , '4' , '1.00' , '1' , '0' , '0' , '2.00' ) 29/04/2023 01:27:26 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 ( '83050' , '13886' , 'CANDELABRO BAROCCO ROCCOCO CM 30 OTTONE- DM185R' , '2' , '-2' , '1' , '145' , '118.85245901639' , '22' , '0' , '290.00' ) 29/04/2023 01:27:26 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 ( '83050' , '1937' , 'CERETTI DIAM. 40X400 - ART.500 - 4040' , '2' , '-2' , '1' , '4.40' , '3.6065573770492' , '22' , '100' , '0.00' ) 29/04/2023 01:27:26 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 ( '83050' , '11626' , 'PURIFICATOIO 28X48 - SERV 1' , '2' , '-2' , '1' , '7.40' , '6.0655737704918' , '22' , '0' , '14.80' ) 29/04/2023 01:27:26 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 ( '83050' , '11625' , 'CORPORALE - 47X47 - SERV 4' , '1' , '-1' , '1' , '11.80' , '9.672131147541' , '22' , '0' , '11.80' ) 29/04/2023 01:27:26 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 ( '83050' , '11624' , 'PALLA 16X16 - SERV 3 ' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 29/04/2023 01:27:26 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 ( '83050' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 29/04/2023 01:27:26 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 ( '83050' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '29.85' , '29.85' , '0' , '0' , '29.85' )