27/12/2022 09:32:46 am >> SELECT document_num FROM ps_document WHERE document_num = '4085' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 09:32:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4085' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.40' , '1.40' , NOW() , NOW() ) 27/12/2022 09:32:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77535' 27/12/2022 09:32:46 am >> DELETE FROM ps_document_detail WHERE id_document = '77535' 27/12/2022 09:32:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77535' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 27/12/2022 09:34:20 am >> SELECT document_num FROM ps_document WHERE document_num = '4086' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 09:34:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4086' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.70' , '0.70' , NOW() , NOW() ) 27/12/2022 09:34:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77536' 27/12/2022 09:34:20 am >> DELETE FROM ps_document_detail WHERE id_document = '77536' 27/12/2022 09:34:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77536' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 27/12/2022 09:47:21 am >> SELECT document_num FROM ps_document WHERE document_num = '4061' AND id_document != '77506' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-23') 27/12/2022 09:47:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4061', document_date = '2022-12-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 = '52.80', price_tax_excluded = '43.78', date_upd = NOW() WHERE id_document = '77506' 27/12/2022 09:47: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 = '77506' 27/12/2022 09:47:21 am >> DELETE FROM ps_document_detail WHERE id_document = '77506' 27/12/2022 09:47: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 ( '77506' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '1' , '-1' , '1' , '1.3' , '1.0655737704918' , '22' , '0' , '1.30' ) 27/12/2022 09:47: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 ( '77506' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '4' , '-4' , '4' , '0.7000' , '0.7' , '0' , '0' , '2.80' ) 27/12/2022 09:47: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 ( '77506' , '16461' , 'CLERGY NIDO DAPE ML - C 22' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 27/12/2022 09:47: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 ( '77506' , '15077' , 'PRESEPE ALABASTRO - 223' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/12/2022 09:47: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 ( '77506' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 27/12/2022 09:47: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 ( '77506' , '19468' , 'CORONA DELLE ROSE BIGLIETTO - 31111' , '1' , '-1' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '0.20' ) 27/12/2022 10:13:19 am >> SELECT document_num FROM ps_document WHERE document_num = '4087' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 10:13: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' , '4087' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.90' , '4.84' , NOW() , NOW() ) 27/12/2022 10:13: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 = '77537' 27/12/2022 10:13:19 am >> DELETE FROM ps_document_detail WHERE id_document = '77537' 27/12/2022 10:13: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 ( '77537' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.9' , '4.8360655737705' , '22' , '0' , '5.90' ) 27/12/2022 10:14:22 am >> SELECT document_num FROM ps_document WHERE document_num = '4088' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 10:14:22 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' , '4088' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 27/12/2022 10:14:22 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 = '77538' 27/12/2022 10:14:22 am >> DELETE FROM ps_document_detail WHERE id_document = '77538' 27/12/2022 10:14:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77538' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '9' , '7.3770491803279' , '22' , '0' , '9.00' ) 27/12/2022 10:18:51 am >> SELECT document_num FROM ps_document WHERE document_num = '4089' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 10:18:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4089' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.11' , NOW() , NOW() ) 27/12/2022 10:18:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77539' 27/12/2022 10:18:51 am >> DELETE FROM ps_document_detail WHERE id_document = '77539' 27/12/2022 10:18:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77539' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.8' , '3.1147540983607' , '22' , '0' , '3.80' ) 27/12/2022 10:47:20 am >> SELECT document_num FROM ps_document WHERE document_num = '4090' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 10:47:20 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4090' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '76.00' , '76.00' , NOW() , NOW() ) 27/12/2022 10:47:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77540' 27/12/2022 10:47:20 am >> DELETE FROM ps_document_detail WHERE id_document = '77540' 27/12/2022 10:47:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77540' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '16' , '-16' , '4' , '5.00' , '5' , '0' , '5' , '76.00' ) 27/12/2022 10:53:16 am >> SELECT document_num FROM ps_document WHERE document_num = '4091' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 10:53:16 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4091' , '2022-12-27' , '' , '3029' , '0' , '4669124' , 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '395.10' , '327.15' , NOW() , NOW() ) 27/12/2022 10:53:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77541' 27/12/2022 10:53:16 am >> DELETE FROM ps_document_detail WHERE id_document = '77541' 27/12/2022 10:53:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '0' , 'OSTIE' , '3' , '-3' , '0' , '2.3000' , '2.3' , '0' , '0' , '6.90' ) 27/12/2022 10:53:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '0' , 'PARTICOLE' , '3' , '-3' , '0' , '3.8000' , '3.8' , '0' , '0' , '11.40' ) 27/12/2022 10:53:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8361' , '22' , '0' , '12.00' ) 27/12/2022 10:53:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '5229' , 'INCENSO PONTIFICAL' , '1' , '-1' , '1' , '24.0000' , '19.6721' , '22' , '0' , '24.00' ) 27/12/2022 10:53:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8525' , '22' , '0' , '112.80' ) 27/12/2022 10:53:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3.0000' , '2.459' , '22' , '0' , '180.00' ) 27/12/2022 10:53:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5574' , '22' , '0' , '48.00' ) 27/12/2022 10:54:25 am >> DELETE FROM ps_document WHERE id_document = '68011' 27/12/2022 10:54:25 am >> DELETE FROM ps_document_detail WHERE id_document = '68011' 27/12/2022 11:04:38 am >> SELECT document_num FROM ps_document WHERE document_num = '4092' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 11:04:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4092' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.00' , '22.49' , NOW() , NOW() ) 27/12/2022 11:04:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77542' 27/12/2022 11:04:38 am >> DELETE FROM ps_document_detail WHERE id_document = '77542' 27/12/2022 11:04:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77542' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '2' , '-2' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '19.00' ) 27/12/2022 11:04:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77542' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 27/12/2022 11:04:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77542' , '6304' , 'MATTHAEUS 25G - CINNAMONO - EVE ' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 27/12/2022 11:04:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77542' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '1' , '1' , '0' , '0' , '2.00' ) 27/12/2022 11:10:26 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'tsj9Vbfc16nYD6hC' , NOW() , NOW() ) 27/12/2022 11:10:26 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7024' , '1' ) 27/12/2022 11:10:26 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7024' , '2' ) 27/12/2022 11:10:26 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7024' , '3' ) 27/12/2022 11:11:45 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7024' 27/12/2022 11:11:45 am >> 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 ( '7024' , '10' , '170' , 'MISSIONARI DELLA CONSOLATA' , 'ROSSI' , 'PADRE ANTONELLO' , 'VIA ROMITAGGIO 1' , '' , '23884' , 'CASTELLO DI BRIANZA' , '' , '' , '3392344021' , '' , '' , NOW() , NOW() ) 27/12/2022 11:11:45 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7024' 27/12/2022 11:12:02 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7024' 27/12/2022 11:12:02 am >> 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 ( '7024' , '10' , '170' , 'MISSIONARI DELLA CONSOLATA' , 'ROSSI' , 'PADRE ANTONELLO' , 'VIA ROMITAGGIO 1' , '' , '23884' , 'CASTELLO DI BRIANZA' , '' , '' , '3392344021' , '' , '' , NOW() , NOW() ) 27/12/2022 11:12:02 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7024' 27/12/2022 11:12:44 am >> SELECT document_num FROM ps_document WHERE document_num = '140' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 11:12:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '140' , '2022-12-27' , '' , '7024' , '0' , '107350756' , 'VIA ROMITAGGIO 1 23884 CASTELLO DI BRIANZA' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 27/12/2022 11:12:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '9245' 27/12/2022 11:12:44 am >> DELETE FROM ps_document_detail WHERE id_document = '9245' 27/12/2022 11:12:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '9245' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 27/12/2022 11:14:11 am >> SELECT document_num FROM ps_document WHERE document_num = '4093' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 11:14:11 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' , '4093' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.50' , '15.34' , NOW() , NOW() ) 27/12/2022 11:14:11 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 = '77543' 27/12/2022 11:14:11 am >> DELETE FROM ps_document_detail WHERE id_document = '77543' 27/12/2022 11:14:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77543' , '5473' , 'IOHANNES 25G - ROSA - EVE ' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/12/2022 11:14:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77543' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/12/2022 11:14:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77543' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 27/12/2022 11:14:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77543' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1' , '1' , '0' , '0' , '1.00' ) 27/12/2022 11:14:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77543' , '20066' , 'CATENINA IN ACCIAIO - NS055' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 27/12/2022 11:16:49 am >> SELECT document_num FROM ps_document WHERE document_num = '107/A' AND id_document != '75559' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-03') 27/12/2022 11:16:49 am >> UPDATE ps_document SET id_document_type = '24', document_num = '107/A', document_date = '2022-12-03', document_letter = 'A', id_customer = '1656', id_supplier = '', id_address = '4677544', address1 = 'VIA NAZIONALE 84060 OMIGNANO SCALO', address2 = '', note = 'acconto € 200,00 - 27/12 € 350,00', 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 = '1000.00', price_tax_excluded = '819.67', date_upd = NOW() WHERE id_document = '75559' 27/12/2022 11:16:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75559' 27/12/2022 11:16:49 am >> DELETE FROM ps_document_detail WHERE id_document = '75559' 27/12/2022 11:16:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75559' , '20044' , 'CASULA LANA S/MOIRE - ALBERO DELLA VITA - 8241' , '1' , '-1' , '1' , '1000.0000' , '819.67213114754' , '22' , '0' , '1000.00' ) 27/12/2022 11:20:06 am >> SELECT document_num FROM ps_document WHERE document_num = '4094' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 11:20:06 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' , '4094' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.80' , '40.80' , NOW() , NOW() ) 27/12/2022 11:20:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77544' 27/12/2022 11:20:06 am >> DELETE FROM ps_document_detail WHERE id_document = '77544' 27/12/2022 11:20:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77544' , '14649' , 'COMPENDIO AL CATECHISMO DI PIO X' , '30' , '-30' , '4' , '1.36' , '1.36' , '0' , '0' , '40.80' ) 27/12/2022 11:26:56 am >> SELECT document_num FROM ps_document WHERE document_num = '105/A' AND id_document != '75504' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-01') 27/12/2022 11:26:56 am >> UPDATE ps_document SET id_document_type = '24', document_num = '105/A', document_date = '2022-12-01', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = 'sordina ACC- 200,00 - 27/12 € 200,00', 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 = '2700.00', price_tax_excluded = '2213.11', date_upd = NOW() WHERE id_document = '75504' 27/12/2022 11:26:56 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '75504' 27/12/2022 11:26:56 am >> DELETE FROM ps_document_detail WHERE id_document = '75504' 27/12/2022 11:26:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75504' , '7306' , 'OSTENSORIO - OTTONE BAGNO ORO ' , '1' , '-1' , '1' , '2700.0000' , '2213.1147540984' , '22' , '0' , '2700.00' ) 27/12/2022 11:26:56 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '75504' , '0' , 'ACCONTO 200€' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 27/12/2022 11:37:13 am >> SELECT document_num FROM ps_document WHERE document_num = '4095' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 11:37:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4095' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 27/12/2022 11:37:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77545' 27/12/2022 11:37:13 am >> DELETE FROM ps_document_detail WHERE id_document = '77545' 27/12/2022 11:37: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 ( '77545' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '20' , '16.393442622951' , '22' , '0' , '80.00' ) 27/12/2022 11:37: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 ( '77545' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '35' , '28.688524590164' , '22' , '0' , '70.00' ) 27/12/2022 11:46:00 am >> SELECT document_num FROM ps_document WHERE document_num = '4096' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 11:46:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4096' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.80' , '7.57' , NOW() , NOW() ) 27/12/2022 11:46: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 = '77546' 27/12/2022 11:46:00 am >> DELETE FROM ps_document_detail WHERE id_document = '77546' 27/12/2022 11:46: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 ( '77546' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '6.80' , '5.5737704918033' , '22' , '0' , '6.80' ) 27/12/2022 11:46: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 ( '77546' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '1' , '1' , '0' , '0' , '2.00' ) 27/12/2022 11:52:38 am >> SELECT document_num FROM ps_document WHERE document_num = '4096' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 11:53:06 am >> SELECT document_num FROM ps_document WHERE document_num = '4097' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 11:53:06 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' , '4097' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 27/12/2022 11:53:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77547' 27/12/2022 11:53:06 am >> DELETE FROM ps_document_detail WHERE id_document = '77547' 27/12/2022 11:53:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77547' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/12/2022 11:55:42 am >> SELECT document_num FROM ps_document WHERE document_num = '4098' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 11:55: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' , '4098' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 27/12/2022 11:55: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 = '77548' 27/12/2022 11:55:42 am >> DELETE FROM ps_document_detail WHERE id_document = '77548' 27/12/2022 11:55: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 ( '77548' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 27/12/2022 12:04:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '4099' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 12:04:17 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4099' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 27/12/2022 12:04:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77549' 27/12/2022 12:04:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '77549' 27/12/2022 12:04:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77549' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '5' , '9.50' ) 27/12/2022 12:06:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '4100' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 12:06:14 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4100' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.23' , NOW() , NOW() ) 27/12/2022 12:06:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77550' 27/12/2022 12:06:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '77550' 27/12/2022 12:06:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77550' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/12/2022 12:21:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '4101' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 12:21: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 ( '11' , '4101' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.60' , '18.52' , NOW() , NOW() ) 27/12/2022 12:21: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 = '77551' 27/12/2022 12:21:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '77551' 27/12/2022 12:21: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 ( '77551' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 27/12/2022 12:21: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 ( '77551' , '1621' , 'CANDELE CONICHE 10 PZ' , '3' , '-3' , '1' , '6.80' , '5.5737704918033' , '22' , '0' , '20.40' ) 27/12/2022 12:36:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '4102' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 12:36:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4102' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 27/12/2022 12:36:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77552' 27/12/2022 12:36:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '77552' 27/12/2022 12:36:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77552' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 27/12/2022 02:30:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '4101' AND id_document != '77551' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 02:30:46 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4101', document_date = '2022-12-27', 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 = '22.60', price_tax_excluded = '18.52', date_upd = NOW() WHERE id_document = '77551' 27/12/2022 02:30:46 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 = '77551' 27/12/2022 02:30:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '77551' 27/12/2022 02:30:46 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 ( '77551' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '2.20' ) 27/12/2022 02:30:46 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 ( '77551' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20.4' , '16.72131147541' , '22' , '0' , '20.40' ) 27/12/2022 02:31:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '4096' AND id_document != '77546' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 02:31:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4096', document_date = '2022-12-27', 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 = '8.80', price_tax_excluded = '7.57', date_upd = NOW() WHERE id_document = '77546' 27/12/2022 02:31: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 = '77546' 27/12/2022 02:31:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '77546' 27/12/2022 02:31: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 ( '77546' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.8' , '5.5737704918033' , '22' , '0' , '6.80' ) 27/12/2022 02:31: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 ( '77546' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 27/12/2022 02:33:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '4091' AND id_document != '77541' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 02:33:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4091', document_date = '2022-12-27', document_letter = '', id_customer = '3029', id_supplier = '', id_address = '4669124', address1 = 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO', 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 = '395.10', price_tax_excluded = '327.15', date_upd = NOW() WHERE id_document = '77541' 27/12/2022 02: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 = '77541' 27/12/2022 02:33:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '77541' 27/12/2022 02: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 ( '77541' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18.3' , '18.3' , '0' , '0' , '18.30' ) 27/12/2022 02: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 ( '77541' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 27/12/2022 02: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 ( '77541' , '5229' , 'INCENSO PONTIFICAL' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 27/12/2022 02: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 ( '77541' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 27/12/2022 02: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 ( '77541' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '180.00' ) 27/12/2022 02: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 ( '77541' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 27/12/2022 02:36:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '4091' AND id_document != '77541' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 02:36:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4091', document_date = '2022-12-27', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO', 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 = '395.10', price_tax_excluded = '327.15', date_upd = NOW() WHERE id_document = '77541' 27/12/2022 02:36: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 = '77541' 27/12/2022 02:36:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '77541' 27/12/2022 02:36:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18.3000' , '18.3' , '0' , '0' , '18.30' ) 27/12/2022 02:36:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 27/12/2022 02:36:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '5229' , 'INCENSO PONTIFICAL' , '1' , '-1' , '1' , '24.0000' , '19.672131147541' , '22' , '0' , '24.00' ) 27/12/2022 02:36:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '112.80' ) 27/12/2022 02:36:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '180.00' ) 27/12/2022 02:36:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77541' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '48.00' ) 27/12/2022 02:40:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801035391' AND id_product != '9536' AND ean13 != '' 27/12/2022 02:40:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/4', ean13 = '9788801035391', date_upd = NOW() WHERE id_product = '9536' 27/12/2022 02:40:23 pm >> UPDATE ps_product_lang SET name = 'SANT\'ANTONIO - L.GJERGJI', description = '' WHERE id_product = '9536' 27/12/2022 02:40:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '9536' 27/12/2022 02:40:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', 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 = '9536' 27/12/2022 02:40:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '9536' 27/12/2022 02:47:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '4084' AND id_document != '77534' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-24') 27/12/2022 02:47:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4084', document_date = '2022-12-24', 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 = '90.29', price_tax_excluded = '90.29', date_upd = NOW() WHERE id_document = '77534' 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77534' 27/12/2022 02:47:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '77534' 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9420' , 'SAN FRANCESCO DASSISI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9438' , 'SAN GENNARO VESCOVO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9610' , 'SANTA TERESA DI GESÙ DAVILA - G.PESENTI' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9441' , 'SAN GERARDO MAIELLA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '7385' , 'PADRE PIO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9536' , 'SANTANTONIO - L.GJERGJI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '6242' , 'MARIA IMMACOLATA - S. CECCHIN' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9527' , 'SANTAGNESE - A. GOVERNALE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '12546' , 'FATIMA IL SEGRETO DEI TRE PASTORELLI - B. FERRERO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9507' , 'SAN ROCCO - G.PESENTI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9454' , 'SAN GIOVANNI DELLA CROCE - G.PESENTI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '15846' , 'CARLO ACUTIS - F. OCCHETTA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9462' , 'SAN GIUSEPPE - T. STRAMARE' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '13959' , 'SAN DOMENICO' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '6042' , 'MADONNA ASSUNTA - G. PESENTI' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '19552' , 'MADONNA CHE SCIOGLIE I NODI - A. CAMPAGNA' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9513' , 'SAN SIMONE APOSTOLO - F. INNOCENTE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9573' , 'SANTA LUCIA' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '20275' , 'SULLA TUA PAROLA GEN/FEB 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '9479' , 'SAN MATTEO APOSTOLO ED EVANGELISTA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '18496' , 'MAZZO DI ROSE A SANTA RITA - 8029' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '4948' , 'IMITAZIONE DI CRISTO - TASC - 8818' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '5' , '6.65' ) 27/12/2022 02:47:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77534' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '5' , '1.43' ) 27/12/2022 02:55:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '4089' AND id_document != '77539' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 02:55:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4089', document_date = '2022-12-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '3.80', price_tax_excluded = '3.11', date_upd = NOW() WHERE id_document = '77539' 27/12/2022 02:55: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 = '77539' 27/12/2022 02:55:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '77539' 27/12/2022 02:55:52 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 ( '77539' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '0.6' , '0.49180327868852' , '22' , '0' , '0.60' ) 27/12/2022 02:55:52 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 ( '77539' , '14837' , 'CERO PROFUMATO NATALE - 204/N9999' , '1' , '-1' , '1' , '3.20' , '2.6229508196721' , '22' , '0' , '3.20' ) 27/12/2022 02:56:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2630' AND id_document != '61158' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-03') 27/12/2022 02:56:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2630', document_date = '2022-09-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '2.50', price_tax_excluded = '2.05', date_upd = NOW() WHERE id_document = '61158' 27/12/2022 02:56:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61158' 27/12/2022 02:56:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '61158' 27/12/2022 02:56:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61158' , '14837' , 'CERO PROFUMATO NATALE - 204/N9999' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 27/12/2022 02:56:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2904' AND id_document != '63584' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-03') 27/12/2022 02:56:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2904', document_date = '2022-10-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '8.75', price_tax_excluded = '7.17', date_upd = NOW() WHERE id_document = '63584' 27/12/2022 02:56:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63584' 27/12/2022 02:56:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '63584' 27/12/2022 02:56:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63584' , '14837' , 'CERO PROFUMATO NATALE - 204/N9999' , '1' , '-1' , '1' , '2.95' , '2.4180327868852' , '22' , '0' , '2.95' ) 27/12/2022 02:56:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63584' , '17604' , 'ROSARIO 100 REQUIEM - RE1018' , '1' , '-1' , '1' , '5.8000' , '4.7540983606557' , '22' , '0' , '5.80' ) 27/12/2022 02:57:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2909' AND id_document != '63590' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-10-04') 27/12/2022 02:57:05 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2909', document_date = '2022-10-04', 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 = '153.00', price_tax_excluded = '125.41', date_upd = NOW() WHERE id_document = '63590' 27/12/2022 02:57:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '63590' 27/12/2022 02:57:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '63590' 27/12/2022 02:57:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63590' , '739' , 'ARC. GABRIELE BABY - 023 AR/G/9 BB' , '18' , '-18' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '144.00' ) 27/12/2022 02:57:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63590' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 27/12/2022 02:57:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63590' , '14837' , 'CERO PROFUMATO NATALE - 204/N9999' , '1' , '-1' , '1' , '2' , '1.6393442622951' , '22' , '0' , '2.00' ) 27/12/2022 02:57:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '63590' , '12139' , 'SANTA FAUSTINA - 336' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 27/12/2022 03:20:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '6/PA' AND id_document != '76096' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-13') 27/12/2022 03:20:47 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '6/PA', document_date = '2022-12-13', document_letter = 'PA', id_customer = '3965', id_supplier = '', id_address = '4677902', address1 = 'PIAZZA GARIBALDI 84020 OLIVETO CITRA', 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 = '435.04', price_tax_excluded = '435.04', date_upd = NOW() WHERE id_document = '76096' 27/12/2022 03:20:47 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 = '76096' 27/12/2022 03:20:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '76096' 27/12/2022 03:20:48 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 ( '76096' , '20277' , 'Grand Central dream' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 27/12/2022 03:20:48 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 ( '76096' , '20278' , 'Violenze e fascismo nel napoletano' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 27/12/2022 03:20:48 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 ( '76096' , '20279' , 'Heinrich Schliemann a Napoli' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 27/12/2022 03:20:48 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 ( '76096' , '20280' , 'C’era una volta Storybrooke' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 27/12/2022 03:20:48 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 ( '76096' , '20281' , 'Bibliografia degli scritti' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 27/12/2022 03:20:48 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 ( '76096' , '20285' , 'Quid est veritas?' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 27/12/2022 03:20:48 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 ( '76096' , '20283' , 'conquista normanna del meridione d’Italia' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 27/12/2022 03:20:48 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 ( '76096' , '20284' , 'bizantini nel Mezzogiorno d’Italia' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 27/12/2022 03:20:48 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 ( '76096' , '20286' , 'Chirone d’Achille' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 27/12/2022 03:20:48 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 ( '76096' , '20287' , 'geopolitica di Francesco' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 27/12/2022 03:20:48 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 ( '76096' , '20288' , 'Codice Corallino' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 27/12/2022 03:20:48 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 ( '76096' , '20289' , 'Folia Follia' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 27/12/2022 03:20:48 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 ( '76096' , '20290' , 'Raffaella Carrà una leggenda in tre minuti' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 27/12/2022 03:20:48 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 ( '76096' , '20291' , 'Futurvesuvio' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 27/12/2022 03:20:48 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 ( '76096' , '20292' , 'A vita nova' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '5' , '13.30' ) 27/12/2022 03:20:48 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 ( '76096' , '20282' , 'Storia politica della Langobardia minore' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 27/12/2022 03:20:48 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 ( '76096' , '20295' , 'GUIDA PER BAMBINE RIBELLI' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '5' , '18.05' ) 27/12/2022 03:20:48 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 ( '76096' , '20294' , 'STORIE DELLA BUONA NOTTE PER BAMBINE RIBELLI ' , '1' , '-1' , '4' , '13.5000' , '13.5' , '0' , '5' , '12.82' ) 27/12/2022 03:20:48 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 ( '76096' , '20293' , 'Storie della buona notte PER BAMBINE RIBELLI 2' , '1' , '-1' , '4' , '13.5000' , '13.5' , '0' , '5' , '12.82' ) 27/12/2022 03:20:48 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 ( '76096' , '20297' , 'STORIE DELLA BUONA NOTTE PER BAMBINE RIBELLI - 100 DONNE...' , '1' , '-1' , '4' , '13.5000' , '13.5' , '0' , '5' , '12.82' ) 27/12/2022 03:20:48 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 ( '76096' , '20296' , 'STORIE DELLA BUONA NOTTE PER BAMBINE RIBELLI - 100 RAGAZZE...' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '5' , '18.05' ) 27/12/2022 03:20:48 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 ( '76096' , '20298' , 'COFANETTO STORIE PER BAMBINI VOL 1 E 2' , '1' , '-1' , '4' , '29.9000' , '29.9' , '0' , '5' , '28.40' ) 27/12/2022 03:20:48 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 ( '76096' , '20299' , 'DONNE E SCIENZA' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.05' ) 27/12/2022 03:20:48 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 ( '76096' , '18291' , 'DALLA DISPERAZIONE ALLA SPERANZA - N. SENATORE' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 27/12/2022 03:20:48 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 ( '76096' , '17630' , 'RACCONTI SOTTO L\'ALBERO - G. CELENTANO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 27/12/2022 03:20:48 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 ( '76096' , '14693' , 'VITE MERAVIGLIOSE - P. MARTINELLI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 27/12/2022 03:20:48 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 ( '76096' , '11838' , 'UNA TERRA BAGNATA DAL SANGUE - A. PALINI' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 27/12/2022 03:20:48 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 ( '76096' , '10052' , 'SOLE A MEZZANOTTE M. GARGANI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 27/12/2022 03:20:48 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 ( '76096' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 27/12/2022 03:20:48 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 ( '76096' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '8.66' , '8.66' , '0' , '5' , '8.23' ) 27/12/2022 03:20:48 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 ( '76096' , '0' , 'Determina affidamento n. 104/799 del 14/11.2022' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 27/12/2022 03:20:48 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 ( '76096' , '0' , 'CUP D89I22000860001 ' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 27/12/2022 03:20:48 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 ( '76096' , '0' , 'CIG: Z37389282E' , '0' , '0' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 27/12/2022 03:43:51 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/12/2022 03:43:51 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20588' , '1' , '' , 'nuovo-prodotto' ) 27/12/2022 03:43:51 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20588' , '1' , '1' , '2' , NOW() , NOW() ) 27/12/2022 03:43:51 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20588' , '0' , '1' , '0' , '0' ) 27/12/2022 03:45:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254780398' AND id_product != '20588' AND ean13 != '' 27/12/2022 03:45:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/6', ean13 = '9791254780398', date_upd = NOW() WHERE id_product = '20588' 27/12/2022 03:45:32 pm >> UPDATE ps_product_lang SET name = 'FELICITA\' DEL CUORE - F. SHEEN', description = '' WHERE id_product = '20588' 27/12/2022 03:45:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22' WHERE id_product = '20588' 27/12/2022 03:45:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22', id_tax_rules_group = '4', id_category_default = '100', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20588' 27/12/2022 03:45:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '20588' 27/12/2022 03:45:33 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20588' 27/12/2022 03:45:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20589' , '1' , '' , 'nuovo-prodotto' ) 27/12/2022 03:45:33 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20589' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20588' 27/12/2022 03:45:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20589' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20588' 27/12/2022 03:46:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '121/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 03:46:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '121/A' , '2022-12-27' , 'A' , '206' , '0' , '4671015' , 'VIA N. BUONSERVIZI, 25 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 27/12/2022 03:46:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77553' 27/12/2022 03:46:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '77553' 27/12/2022 03:46:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77553' , '20588' , 'FELICITA DEL CUORE - F. SHEEN' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 27/12/2022 03:47:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254780374' AND id_product != '20589' AND ean13 != '' 27/12/2022 03:47:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/5', ean13 = '9791254780374', date_upd = NOW() WHERE id_product = '20589' 27/12/2022 03:47:42 pm >> UPDATE ps_product_lang SET name = 'ECCO MIA MADRE - R. BRICHETTI MESSORI', description = '' WHERE id_product = '20589' 27/12/2022 03:47:42 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '20589' 27/12/2022 03:47:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '100', id_argoment_default = '73', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20589' 27/12/2022 03:47:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '20589' 27/12/2022 03:47:44 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20589' 27/12/2022 03:47:44 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20590' , '1' , '' , 'nuovo-prodotto' ) 27/12/2022 03:47:44 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20590' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20589' 27/12/2022 03:47:44 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20590' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20589' 27/12/2022 03:49:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832711561' AND id_product != '20590' AND ean13 != '' 27/12/2022 03:49:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788832711561', date_upd = NOW() WHERE id_product = '20590' 27/12/2022 03:49:30 pm >> UPDATE ps_product_lang SET name = 'PREGHIERA - PAPA FRANCESCO', description = '' WHERE id_product = '20590' 27/12/2022 03:49:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '13' WHERE id_product = '20590' 27/12/2022 03:49:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '13', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20590' 27/12/2022 03:49:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '20590' 27/12/2022 03:49:31 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20590' 27/12/2022 03:49:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20591' , '1' , '' , 'nuovo-prodotto' ) 27/12/2022 03:49:31 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20591' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20590' 27/12/2022 03:49:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20591' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20590' 27/12/2022 03:50:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832711851' AND id_product != '20591' AND ean13 != '' 27/12/2022 03:50:45 pm >> UPDATE ps_product SET id_supplier = '', reference = '5/3', ean13 = '9788832711851', date_upd = NOW() WHERE id_product = '20591' 27/12/2022 03:50:45 pm >> UPDATE ps_product_lang SET name = 'NELLE TUE MANI', description = '' WHERE id_product = '20591' 27/12/2022 03:50:45 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '20591' 27/12/2022 03:50:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20591' 27/12/2022 03:50:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '20591' 27/12/2022 03:52:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '661557' , '2022-12-23' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '59.00' , NOW() , NOW() ) 27/12/2022 03:52:02 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77554' 27/12/2022 03:52:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '77554' 27/12/2022 03:52:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77554' , '20590' , 'PREGHIERA - PAPA FRANCESCO' , '1' , '1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 27/12/2022 03:52:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20590' AND id_supplier = '109' 27/12/2022 03:52:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20590' , '109' , '1' ) 27/12/2022 03:52:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77554' , '20591' , 'NELLE TUE MANI' , '1' , '1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 27/12/2022 03:52:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20591' AND id_supplier = '109' 27/12/2022 03:52:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20591' , '109' , '1' ) 27/12/2022 03:52:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77554' , '20589' , 'ECCO MIA MADRE - R. BRICHETTI MESSORI' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 27/12/2022 03:52:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20589' AND id_supplier = '109' 27/12/2022 03:52:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20589' , '109' , '1' ) 27/12/2022 03:52:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77554' , '20588' , 'FELICITA\' DEL CUORE - F. SHEEN' , '1' , '1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 27/12/2022 03:52:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20588' AND id_supplier = '109' 27/12/2022 03:52:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20588' , '109' , '1' ) 27/12/2022 04:29:58 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '2016' 27/12/2022 04:29:58 pm >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '2016' 27/12/2022 04:31:27 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '2866' 27/12/2022 04:31:27 pm >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '2866' 27/12/2022 04:34:13 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '14488' 27/12/2022 04:34:13 pm >> UPDATE ps_stock_available SET quantity = quantity + '1' WHERE id_product = '14488' 27/12/2022 04:34:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '29/S' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 04:34:46 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 ( '23' , '29/S' , '2022-12-27' , 'S' , '402' , '0' , '4670248' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '197.75' , '197.75' , NOW() , NOW() ) 27/12/2022 04:34:46 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 = '9246' 27/12/2022 04:34:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '9246' 27/12/2022 04:34:46 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 ( '9246' , '17' , 'LA FEDE NELLO ZAINETTO' , '20' , '-20' , '4' , '5.00' , '5' , '0' , '30' , '70.00' ) 27/12/2022 04:34:46 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 ( '9246' , '20' , 'GIOVEDÌ SANTO' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '30' , '2.10' ) 27/12/2022 04:34:46 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 ( '9246' , '125' , 'MIE PREGHIERINE - N. E.' , '30' , '-30' , '4' , '1.50' , '1.5' , '0' , '30' , '31.50' ) 27/12/2022 04:34:46 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 ( '9246' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '25' , '-25' , '4' , '2.50' , '2.5' , '0' , '30' , '43.75' ) 27/12/2022 04:34:46 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 ( '9246' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '30' , '14.70' ) 27/12/2022 04:34:46 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 ( '9246' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '2' , '-2' , '4' , '10.50' , '10.5' , '0' , '30' , '14.70' ) 27/12/2022 04:34:46 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 ( '9246' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '20' , '-20' , '4' , '1.50' , '1.5' , '0' , '30' , '21.00' ) 27/12/2022 04:37:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '29/S' , '2022-12-27' , 'S' , '0' , '127' , '4670004' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '201.95' , '201.95' , NOW() , NOW() ) 27/12/2022 04:37:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77555' 27/12/2022 04:37:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '77555' 27/12/2022 04:37:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77555' , '4120' , 'FEDE NELLO ZAINETTO' , '20' , '20' , '4' , '5.00' , '5' , '0' , '30' , '70.0000' ) 27/12/2022 04:37:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '127' 27/12/2022 04:37:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '127' , '1' ) 27/12/2022 04:37: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 ( '77555' , '18627' , 'GIOVEDI\' SANTO' , '2' , '2' , '4' , '1.50' , '1.5' , '0' , '30' , '2.1000' ) 27/12/2022 04:37:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18627' AND id_supplier = '127' 27/12/2022 04:37:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18627' , '127' , '1' ) 27/12/2022 04:37: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 ( '77555' , '18357' , 'MIE PREGHIERINE N.E.' , '30' , '30' , '4' , '1.50' , '1.5' , '0' , '30' , '31.5000' ) 27/12/2022 04:37:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18357' AND id_supplier = '127' 27/12/2022 04:37:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18357' , '127' , '1' ) 27/12/2022 04:37: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 ( '77555' , '19977' , 'MINISTRANTI IERI, OGGI, DOMANI' , '25' , '25' , '4' , '2.50' , '2.5' , '0' , '30' , '43.7500' ) 27/12/2022 04:37:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19977' AND id_supplier = '127' 27/12/2022 04:37:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19977' , '127' , '1' ) 27/12/2022 04:37: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 ( '77555' , '17350' , 'NATALE SPIEGATO AI BAMBINI' , '7' , '7' , '4' , '3.00' , '3' , '0' , '30' , '14.7000' ) 27/12/2022 04:37:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17350' AND id_supplier = '127' 27/12/2022 04:37:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17350' , '127' , '1' ) 27/12/2022 04:37: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 ( '77555' , '19119' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '2' , '2' , '4' , '10.50' , '10.5' , '0' , '30' , '14.7000' ) 27/12/2022 04:37:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19119' AND id_supplier = '127' 27/12/2022 04:37:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19119' , '127' , '1' ) 27/12/2022 04:37: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 ( '77555' , '15317' , 'SACRAMENTI SPIEGATI AI RAGAZZI - LA COMUNIONE' , '20' , '20' , '4' , '1.80' , '1.8' , '0' , '30' , '25.2000' ) 27/12/2022 04:37:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15317' AND id_supplier = '127' 27/12/2022 04:37:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15317' , '127' , '1' ) 27/12/2022 04:38:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788895783994' AND id_product != '89' AND ean13 != '' 27/12/2022 04:38:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788895783994', date_upd = NOW() WHERE id_product = '89' 27/12/2022 04:38:47 pm >> UPDATE ps_product_lang SET name = 'COMUNIONE SPIEGATA AI RAGAZZI', description = '

Un libretto utile e gioioso per aiutare i bambini che si preparano alla Prima Comunione, ma utile anche a chiunque voglia avvicinarsi a questo Sacramento.

' WHERE id_product = '89' 27/12/2022 04:38:47 pm >> UPDATE ps_product SET wholesale_price = '0.10', on_sale = '0', price = '1.8' WHERE id_product = '89' 27/12/2022 04:38:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.10', price = '1.8', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '449', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '1', date_upd = NOW() WHERE id_product = '89' 27/12/2022 04:38:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '89' 27/12/2022 04:38:47 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '89' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/12/2022 04:39:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '29/S' AND id_document != '9246' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 04:39:00 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '29/S', document_date = '2022-12-27', document_letter = 'S', id_customer = '402', id_supplier = '', id_address = '4670248', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', 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 = '201.95', price_tax_excluded = '201.95', date_upd = NOW() WHERE id_document = '9246' 27/12/2022 04:39: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 = '9246' 27/12/2022 04:39:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '9246' 27/12/2022 04:39: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 ( '9246' , '17' , 'LA FEDE NELLO ZAINETTO' , '20' , '-20' , '4' , '5.0000' , '5' , '0' , '30' , '70.00' ) 27/12/2022 04:39: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 ( '9246' , '20' , 'GIOVEDÌ SANTO' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '30' , '2.10' ) 27/12/2022 04:39: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 ( '9246' , '125' , 'MIE PREGHIERINE - N. E.' , '30' , '-30' , '4' , '1.5000' , '1.5' , '0' , '30' , '31.50' ) 27/12/2022 04:39: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 ( '9246' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '25' , '-25' , '4' , '2.5000' , '2.5' , '0' , '30' , '43.75' ) 27/12/2022 04:39: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 ( '9246' , '129' , 'NATALE SPIEGATO AI BAMBINI' , '7' , '-7' , '4' , '3.0000' , '3' , '0' , '30' , '14.70' ) 27/12/2022 04:39: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 ( '9246' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '2' , '-2' , '4' , '10.5000' , '10.5' , '0' , '30' , '14.70' ) 27/12/2022 04:39: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 ( '9246' , '89' , 'COMUNIONE SPIEGATA AI RAGAZZI' , '20' , '-20' , '4' , '1.80' , '1.8' , '0' , '30' , '25.20' ) 27/12/2022 04:46:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '4103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 04:46:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4103' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 27/12/2022 04:46:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77556' 27/12/2022 04:46:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '77556' 27/12/2022 04:46:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77556' , '20247' , 'DI PASQUA IN PASQUA - ANNO A - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 27/12/2022 04:46:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77556' , '20261' , 'GIOIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 27/12/2022 04:50:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '121/A' AND id_document != '77553' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 04:50:42 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '121/A', document_date = '2022-12-27', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.80', price_tax_excluded = '27.80', date_upd = NOW() WHERE id_document = '77553' 27/12/2022 04:50: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 = '77553' 27/12/2022 04:50:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '77553' 27/12/2022 04:50: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 ( '77553' , '20588' , 'FELICITA DEL CUORE - F. SHEEN' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 27/12/2022 04:50: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 ( '77553' , '20479' , 'PAROLA E PREGHIERA - FEB 2023' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 27/12/2022 04:50: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 ( '77553' , '20583' , 'PAROLA E PREGHIERA - MAR. 23' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '0' , '2.90' ) 27/12/2022 04:51:29 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '16387' 27/12/2022 04:51:29 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '16387' 27/12/2022 04:51:46 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '18535' 27/12/2022 04:51:47 pm >> UPDATE ps_stock_available SET quantity = quantity + '-2' WHERE id_product = '18535' 27/12/2022 05:07:46 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 ( '32' , '700' , '2022-12-23' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '366.61' , '300.50' , NOW() , NOW() ) 27/12/2022 05:07:46 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 = '77557' 27/12/2022 05:07:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '77557' 27/12/2022 05:07:46 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 ( '77557' , '17101' , 'CASULA POLIESTERE CROCE ORO - AECU04' , '1' , '0' , '1' , '29.5000' , '24.1803' , '22' , '0' , '35.99' ) 27/12/2022 05:07:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17101' AND id_supplier = '122' 27/12/2022 05:07:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17101' , '122' , '1' ) 27/12/2022 05:07:46 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 ( '77557' , '18881' , 'STOLA POLIESTERE - PST020' , '30' , '0' , '1' , '8.2000' , '6.7213' , '22' , '0' , '300.12' ) 27/12/2022 05:07:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18881' AND id_supplier = '122' 27/12/2022 05:07:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18881' , '122' , '1' ) 27/12/2022 05:07:46 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 ( '77557' , '18880' , 'COPRILEGGIO MORELLO' , '1' , '0' , '1' , '25.0000' , '20.4918' , '22' , '0' , '30.50' ) 27/12/2022 05:07:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18880' AND id_supplier = '122' 27/12/2022 05:07:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18880' , '122' , '1' ) 27/12/2022 05:20:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '4104' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 05:20:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4104' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.90' , '13.85' , NOW() , NOW() ) 27/12/2022 05:20:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77558' 27/12/2022 05:20:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '77558' 27/12/2022 05:20:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77558' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 27/12/2022 05:20:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77558' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 27/12/2022 05:21:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '4105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 05:21:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4105' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '55.74' , NOW() , NOW() ) 27/12/2022 05:21: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 = '77559' 27/12/2022 05:21:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '77559' 27/12/2022 05:21: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 ( '77559' , '17414' , 'BIBBIA SCRUTATE LE SCRITTURE - TELATA' , '1' , '-1' , '4' , '34.00' , '34' , '0' , '5' , '32.30' ) 27/12/2022 05:21: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 ( '77559' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '23.61' , '19.352459016393' , '22' , '0' , '23.61' ) 27/12/2022 05:21: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 ( '77559' , '6005' , 'LUMEN GENTIUM' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 27/12/2022 05:21: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 ( '77559' , '2528' , 'COMPIETA' , '1' , '-1' , '4' , '1.30' , '1.3' , '0' , '5' , '1.24' ) 27/12/2022 05:24:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '4106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 05:24:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4106' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.60' , '5.41' , NOW() , NOW() ) 27/12/2022 05:24: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 = '77560' 27/12/2022 05:24:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '77560' 27/12/2022 05:24: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 ( '77560' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '6.60' ) 27/12/2022 06:06:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '4107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 06:06: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' , '4107' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.30' , '32.10' , NOW() , NOW() ) 27/12/2022 06:06: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 = '77561' 27/12/2022 06:06:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '77561' 27/12/2022 06:06: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 ( '77561' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 27/12/2022 06:06:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77561' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 27/12/2022 06:06:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77561' , '7673' , 'PARTICOLE MM38' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 27/12/2022 06:06:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77561' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 27/12/2022 07:36:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '4108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 07:36:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '4108' , '2022-12-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '33.25' , '33.25' , NOW() , NOW() ) 27/12/2022 07:36:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '77562' 27/12/2022 07:36:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '77562' 27/12/2022 07:36:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '77562' , '8290' , 'PREGHIERA DEL MATTINO E DELLA SERA - PER LAICI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 27/12/2022 07:38:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '4108' AND id_document != '77562' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-12-27') 27/12/2022 07:38:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '4108', document_date = '2022-12-27', 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 = '33.25', price_tax_excluded = '33.25', date_upd = NOW() WHERE id_document = '77562' 27/12/2022 07:38:58 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 = '77562' 27/12/2022 07:38:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '77562' 27/12/2022 07:38:58 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 ( '77562' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' )