21/11/2024 09:13:57 am >> SELECT document_num FROM ps_document WHERE document_num = '3567' AND id_document != '94388' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-20') 21/11/2024 09:13:57 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3567', document_date = '2024-11-20', 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 = '18.00', price_tax_excluded = '14.75', date_upd = NOW() WHERE id_document = '94388' 21/11/2024 09:13:57 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 = '94388' 21/11/2024 09:13:57 am >> DELETE FROM ps_document_detail WHERE id_document = '94388' 21/11/2024 09:13:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94388' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 21/11/2024 09:29:15 am >> SELECT document_num FROM ps_document WHERE document_num = '3570' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 09:29:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3570' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '9.00' , NOW() , NOW() ) 21/11/2024 09:29:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94393' 21/11/2024 09:29:15 am >> DELETE FROM ps_document_detail WHERE id_document = '94393' 21/11/2024 09:29:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94393' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '9' , '9' , '0' , '0' , '9.00' ) 21/11/2024 10:10:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3571' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 10:10: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' , '3571' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.90' , '35.98' , NOW() , NOW() ) 21/11/2024 10:10: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 = '94394' 21/11/2024 10:10:06 am >> DELETE FROM ps_document_detail WHERE id_document = '94394' 21/11/2024 10:10: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 ( '94394' , '5997' , 'LUME SOFFIATO CON PIEDE - 1022' , '2' , '-2' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '36.00' ) 21/11/2024 10:10: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 ( '94394' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 21/11/2024 10:14:24 am >> SELECT document_num FROM ps_document WHERE document_num = '3572' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 10:14:24 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' , '3572' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.80' , '3.80' , NOW() , NOW() ) 21/11/2024 10:14:24 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 = '94395' 21/11/2024 10:14:24 am >> DELETE FROM ps_document_detail WHERE id_document = '94395' 21/11/2024 10:14:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94395' , '9105' , 'ROSARIO EUCARISTICO - 8183' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 21/11/2024 10:22:15 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'fqwIKiUetumYOSmZ' , NOW() , NOW() ) 21/11/2024 10:22:15 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4144' , '1' ) 21/11/2024 10:22:15 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4144' , '2' ) 21/11/2024 10:22:15 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4144' , '3' ) 21/11/2024 10:25:40 am >> SELECT document_num FROM ps_document WHERE document_num = '3573' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 10:25:40 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' , '3573' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.16' , '16.16' , NOW() , NOW() ) 21/11/2024 10:25:40 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 = '94396' 21/11/2024 10:25:40 am >> DELETE FROM ps_document_detail WHERE id_document = '94396' 21/11/2024 10:25:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94396' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '2' , '-2' , '4' , '3.00' , '3' , '0' , '5' , '5.70' ) 21/11/2024 10:25:40 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94396' , '5444' , 'IO SONO CON VOI - CAT.' , '2' , '-2' , '4' , '5.50' , '5.5' , '0' , '5' , '10.46' ) 21/11/2024 10:26:50 am >> SELECT document_num FROM ps_document WHERE document_num = '3574' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 10:26:50 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' , '3574' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '689.65' , '578.57' , NOW() , NOW() ) 21/11/2024 10:26:50 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94397' 21/11/2024 10:26:50 am >> DELETE FROM ps_document_detail WHERE id_document = '94397' 21/11/2024 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94397' , '22365' , 'CRISTO CON BASE CM 71 - 08.0271' , '1' , '-1' , '1' , '130.00' , '106.55737704918' , '22' , '0' , '130.00' ) 21/11/2024 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94397' , '14061' , 'LEGGIO PLEX 28X30' , '1' , '-1' , '1' , '136.00' , '111.47540983607' , '22' , '0' , '136.00' ) 21/11/2024 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94397' , '23237' , 'MARIA ALLALBA DELLOTTAVO GIORNO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 21/11/2024 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94397' , '2679' , 'CONOSCERE GESU' , '5' , '-5' , '4' , '3.50' , '3.5' , '0' , '5' , '16.65' ) 21/11/2024 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94397' , '22975' , 'VERGINITA DELLA MADRE DI GESU - S.M. PERRELLA' , '1' , '-1' , '4' , '55.00' , '55' , '0' , '5' , '52.25' ) 21/11/2024 10:26:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94397' , '19659' , 'CASULA POLIESTERE - 65/18355' , '1' , '-1' , '1' , '350' , '286.88524590164' , '22' , '0' , '350.00' ) 21/11/2024 10:32:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3575' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 10:32:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3575' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '135.00' , '110.66' , NOW() , NOW() ) 21/11/2024 10:32:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94398' 21/11/2024 10:32:26 am >> DELETE FROM ps_document_detail WHERE id_document = '94398' 21/11/2024 10:32:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94398' , '17400' , 'STATUA MIRACOLOSA CM 40 - 805' , '1' , '-1' , '1' , '80' , '65.573770491803' , '22' , '0' , '80.00' ) 21/11/2024 10:32:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94398' , '20076' , 'ROSARIO ARGENTO/QUARZO' , '1' , '-1' , '1' , '55' , '45.081967213115' , '22' , '0' , '55.00' ) 21/11/2024 10:35:10 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 21/11/2024 10:35:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23241' , '1' , '' , 'nuovo-prodotto' ) 21/11/2024 10:35:11 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23241' , '1' , '1' , '2' , NOW() , NOW() ) 21/11/2024 10:35:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23241' , '0' , '1' , '0' , '0' ) 21/11/2024 10:35:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3576' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 10:35:14 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' , '3576' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.50' , '13.15' , NOW() , NOW() ) 21/11/2024 10:35:14 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 = '94399' 21/11/2024 10:35:14 am >> DELETE FROM ps_document_detail WHERE id_document = '94399' 21/11/2024 10:35:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94399' , '18620' , 'MEDAGLIA MIRACOLOSA BLU PICCOLA - 022M/SM' , '15' , '-15' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '7.50' ) 21/11/2024 10:35:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94399' , '6323' , 'MEDAGLIA MIRACOLOSA E CATERINA LABOURÈ - 8814' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 21/11/2024 10:41:14 am >> SELECT document_num FROM ps_document WHERE document_num = '3577' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 10:41:14 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' , '3577' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 21/11/2024 10:41:14 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 = '94400' 21/11/2024 10:41:14 am >> DELETE FROM ps_document_detail WHERE id_document = '94400' 21/11/2024 10:41:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94400' , '23122' , 'PRIMI CINQUE SABATI DEL MESE' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 21/11/2024 11:42:26 am >> SELECT document_num FROM ps_document WHERE document_num = '3578' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 11:42:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3578' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.90' , '6.48' , NOW() , NOW() ) 21/11/2024 11:42:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94401' 21/11/2024 11:42:26 am >> DELETE FROM ps_document_detail WHERE id_document = '94401' 21/11/2024 11:42:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94401' , '1621' , 'CANDELE CONICHE 10 PZ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 21/11/2024 11:48:48 am >> SELECT document_num FROM ps_document WHERE document_num = '247' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 11:48:48 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' , '247' , '2024-11-21' , '' , '727' , '0' , '4679429' , 'VIA SAN GIOVANNI BATTISTA, 2 84082 BRACIGLIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '608.43' , '608.43' , NOW() , NOW() ) 21/11/2024 11:48:48 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 = '94402' 21/11/2024 11:48:48 am >> DELETE FROM ps_document_detail WHERE id_document = '94402' 21/11/2024 11:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '35' , '-35' , '4' , '3.80' , '3.8' , '0' , '15' , '113.05' ) 21/11/2024 11:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 21/11/2024 11:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '41' , '-41' , '4' , '3.80' , '3.8' , '0' , '15' , '132.43' ) 21/11/2024 11:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '15' , '25.50' ) 21/11/2024 11:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '50' , '-50' , '4' , '3.80' , '3.8' , '0' , '15' , '161.50' ) 21/11/2024 11:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '-3' , '4' , '10.00' , '10' , '0' , '15' , '25.50' ) 21/11/2024 11:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '53' , '-53' , '4' , '3.00' , '3' , '0' , '15' , '135.15' ) 21/11/2024 11:48:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94402' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '15' , '6.80' ) 21/11/2024 11:49:37 am >> SELECT document_num FROM ps_document WHERE document_num = '3579' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 11:49:37 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' , '3579' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.06' , '56.06' , NOW() , NOW() ) 21/11/2024 11:49:37 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 = '94403' 21/11/2024 11:49:37 am >> DELETE FROM ps_document_detail WHERE id_document = '94403' 21/11/2024 11:49:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94403' , '16204' , 'PREGHIERE DEI FEDELI - FESTIVI' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 21/11/2024 11:49:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94403' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 21/11/2024 11:49:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94403' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 21/11/2024 11:53:13 am >> SELECT document_num FROM ps_document WHERE document_num = '3580' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 11:53: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' , '3580' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '2.20' , NOW() , NOW() ) 21/11/2024 11:53: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 = '94404' 21/11/2024 11:53:13 am >> DELETE FROM ps_document_detail WHERE id_document = '94404' 21/11/2024 11:53: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 ( '94404' , '23169' , 'DILEXIT NOS ' , '1' , '-1' , '4' , '2.20' , '2.2' , '0' , '0' , '2.20' ) 21/11/2024 12:03:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810440360' AND id_product != '23237' AND ean13 != '' 21/11/2024 12:03:58 pm >> UPDATE ps_product SET id_supplier = '109', reference = '13/3', ean13 = '9788810440360', date_upd = NOW() WHERE id_product = '23237' 21/11/2024 12:03:58 pm >> UPDATE ps_product_lang SET name = 'MARIA ALL\'ALBA DELL\'OTTAVO GIORNO', description = '' WHERE id_product = '23237' 21/11/2024 12:03:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.0000' WHERE id_product = '23237' 21/11/2024 12:03:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.0000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '150', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '23237' 21/11/2024 12:03:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '23237' 21/11/2024 12:09:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '3581' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 12:09:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3581' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.40' , '82.23' , NOW() , NOW() ) 21/11/2024 12:09: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 = '94405' 21/11/2024 12:09:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '94405' 21/11/2024 12:09: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 ( '94405' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 21/11/2024 12:09: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 ( '94405' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '3' , '-3' , '4' , '3.5' , '3.5' , '0' , '0' , '10.50' ) 21/11/2024 12:09: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 ( '94405' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '3' , '-3' , '4' , '3.5' , '3.5' , '0' , '0' , '10.50' ) 21/11/2024 12:09: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 ( '94405' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '5' , '-5' , '4' , '3' , '3' , '0' , '0' , '15.00' ) 21/11/2024 12:13:29 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'wF3IbyH2Q45luxoC' , NOW() , NOW() ) 21/11/2024 12:13:29 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4145' , '1' ) 21/11/2024 12:13:29 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4145' , '2' ) 21/11/2024 12:13:29 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4145' , '3' ) 21/11/2024 12:15:23 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4145' 21/11/2024 12:15:23 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4145' , '10' , '145' , 'PARR. S. MICHELE ARC E SAN NICOLA' , 'MARANDOLA' , 'DON LUCIO' , 'VIA CHIESA 13' , '' , '81049' , 'SAN PIETRO IN FINE' , '' , '' , '335227234' , '' , '' , NOW() , NOW() ) 21/11/2024 12:15:23 pm >> UPDATE ps_customer SET email = 'lucio.marandola@virgilio.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4145' 21/11/2024 12:17:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '248' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 12:17:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '248' , '2024-11-21' , '' , '4145' , '0' , '4679433' , 'VIA CHIESA 13 81049 SAN PIETRO IN FINE' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '13.65' , '13.65' , NOW() , NOW() ) 21/11/2024 12:17:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94406' 21/11/2024 12:17:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '94406' 21/11/2024 12:17:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94406' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 21/11/2024 12:17:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94406' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 21/11/2024 12:17:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94406' , '9675' , 'SARETE MIEI TESTIMONI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 21/11/2024 12:18:52 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4145' 21/11/2024 12:18:52 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4145' , '10' , '145' , 'PARR. S. MICHELE ARC E SAN NICOLA' , 'MARANDOLA' , 'DON LUCIO' , 'VIA CHIESA 13' , '' , '81049' , 'SAN PIETRO IN FINE' , 'SPEDIRE A: CARFIERO CARMELA VIA FORNILLO 23/A' , '' , '335227234' , '' , '' , NOW() , NOW() ) 21/11/2024 12:18:52 pm >> UPDATE ps_customer SET email = 'lucio.marandola@virgilio.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4145' 21/11/2024 12:19:42 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4145' 21/11/2024 12:19:42 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4145' , '10' , '145' , 'PARR. S. MICHELE ARC E SAN NICOLA' , 'MARANDOLA' , 'DON LUCIO' , 'VIA CHIESA 13' , '' , '81049' , 'SAN PIETRO IN FINE' , 'SPEDIRE A: CARFIERO MARIA CARMELA VIA FORNILLO 23/A' , '' , '335227234' , '' , '' , NOW() , NOW() ) 21/11/2024 12:19:42 pm >> UPDATE ps_customer SET email = 'lucio.marandola@virgilio.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4145' 21/11/2024 12:21:05 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4145' 21/11/2024 12:21:05 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4145' , '10' , '145' , 'PARR. S. MICHELE ARC E SAN NICOLA' , 'MARANDOLA' , 'DON LUCIO' , 'VIA CHIESA 13' , '' , '81049' , 'SAN PIETRO INFINE' , 'SPEDIRE A: CARFIERO MARIA CARMELA VIA FORNILLO 23/A' , '' , '335227234' , '' , '' , NOW() , NOW() ) 21/11/2024 12:21:05 pm >> UPDATE ps_customer SET email = 'lucio.marandola@virgilio.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4145' 21/11/2024 12:37:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3582' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 12:37:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3582' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.64' , '58.64' , NOW() , NOW() ) 21/11/2024 12:37:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94407' 21/11/2024 12:37:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '94407' 21/11/2024 12:37:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94407' , '2528' , 'COMPIETA' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 21/11/2024 12:37:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94407' , '23106' , 'DILEXIT NOS' , '2' , '-2' , '4' , '3.50' , '3.5' , '0' , '5' , '6.66' ) 21/11/2024 12:37:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94407' , '17024' , 'PICCOLO PRINCICE - A. DE S. EXUPERY' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 21/11/2024 12:37:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94407' , '13249' , 'PICCOLO PRINCIPE' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 21/11/2024 12:37:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94407' , '23006' , 'SEI UNICA - PAPA FRANCESCO' , '2' , '-2' , '4' , '16.90' , '16.9' , '0' , '5' , '32.12' ) 21/11/2024 12:39:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3583' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 12:39:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3583' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.40' , '4.43' , NOW() , NOW() ) 21/11/2024 12:39: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 = '94408' 21/11/2024 12:39:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '94408' 21/11/2024 12:39: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 ( '94408' , '22733' , 'BRACCIALE ELASTICO - RL436/435' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 21/11/2024 12:39: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 ( '94408' , '18892' , 'BRACCIALE DECINA AZZURRO - BC822NP' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 21/11/2024 12:39: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 ( '94408' , '21099' , 'BRACCIALE DECINA - BD008' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 21/11/2024 12:41:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3584' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 12:41:19 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' , '3584' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '68.20' , '56.48' , NOW() , NOW() ) 21/11/2024 12:41:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94409' 21/11/2024 12:41:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '94409' 21/11/2024 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94409' , '22923' , 'ROLL UP GIUBILEO 2025' , '1' , '-1' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '65.00' ) 21/11/2024 12:41:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94409' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.04' , '0.04' , '0' , '0' , '3.20' ) 21/11/2024 03:13:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3585' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 03:13:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3585' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '91.81' , '90.26' , NOW() , NOW() ) 21/11/2024 03:13:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94410' 21/11/2024 03:13:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '94410' 21/11/2024 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94410' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '2' , '-2' , '1' , '3.70' , '3.0327868852459' , '22' , '0' , '7.40' ) 21/11/2024 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94410' , '18051' , 'MIA BIBBIA' , '6' , '-6' , '4' , '3.50' , '3.5' , '0' , '5' , '19.98' ) 21/11/2024 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94410' , '1090' , 'BIBBIA' , '3' , '-3' , '4' , '9.90' , '9.9' , '0' , '5' , '28.23' ) 21/11/2024 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94410' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '6' , '-6' , '4' , '2.80' , '2.8' , '0' , '5' , '15.96' ) 21/11/2024 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94410' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '8' , '-8' , '4' , '2.50' , '2.5' , '0' , '5' , '19.04' ) 21/11/2024 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94410' , '18129' , 'TAU COLORATO - T56' , '1' , '-1' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '1.20' ) 21/11/2024 04:03:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '96/A' AND id_document != '93088' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-11') 21/11/2024 04:03:58 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '96/A', document_date = '2024-09-11', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4679091', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'ACCONTO € 200 25/9/24 + € 140,00 29/10/24', 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 = '1293.30', price_tax_excluded = '1082.35', date_upd = NOW() WHERE id_document = '93088' 21/11/2024 04:03: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 = '93088' 21/11/2024 04:03:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '93088' 21/11/2024 04:03: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 ( '93088' , '21695' , 'CASULA MARIANA - 65/027108-M' , '1' , '-1' , '1' , '975.0000' , '799.18032786885' , '22' , '0' , '975.00' ) 21/11/2024 04:03: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 ( '93088' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 21/11/2024 04:03: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 ( '93088' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 21/11/2024 04:03: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 ( '93088' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 21/11/2024 04:03: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 ( '93088' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 21/11/2024 04:03: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 ( '93088' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '3' , '-3' , '1' , '15.0000' , '12.295081967213' , '22' , '0' , '45.00' ) 21/11/2024 04:03: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 ( '93088' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '-2' , '4' , '30.0000' , '30' , '0' , '5' , '57.00' ) 21/11/2024 04:03: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 ( '93088' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '2' , '-2' , '4' , '25.0000' , '25' , '0' , '5' , '47.50' ) 21/11/2024 04:03: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 ( '93088' , '' , '21/11' , '1' , '-1' , '0' , '0' , '0' , '' , '0' , '0' ) 21/11/2024 04:03: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 ( '93088' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 21/11/2024 04:03: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 ( '93088' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '3' , '-3' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '45.00' ) 21/11/2024 04:07:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2765' AND id_document != '93246' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-23') 21/11/2024 04:07:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2765', document_date = '2024-09-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 = '104.00', price_tax_excluded = '85.25', date_upd = NOW() WHERE id_document = '93246' 21/11/2024 04:07:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93246' 21/11/2024 04:07:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '93246' 21/11/2024 04:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93246' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '2.1' , '1.7213114754098' , '22' , '0' , '2.10' ) 21/11/2024 04:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93246' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 21/11/2024 04:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93246' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 21/11/2024 04:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93246' , '19819' , 'INCENSO NATURALE 1 ST GRADE - KG 1' , '1' , '-1' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '27.00' ) 21/11/2024 04:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93246' , '19099' , 'INCENSO A' , '1' , '-1' , '1' , '46.0000' , '37.704918032787' , '22' , '0' , '46.00' ) 21/11/2024 04:07:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93246' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '5.90' ) 21/11/2024 04:09:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3586' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 04:09:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3586' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.60' , '2.60' , NOW() , NOW() ) 21/11/2024 04:09:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94411' 21/11/2024 04:09:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '94411' 21/11/2024 04:09:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94411' , '1740' , 'CARTONCINO ANGELO DI DIO' , '20' , '-20' , '4' , '0.13' , '0.13' , '0' , '0' , '2.60' ) 21/11/2024 04:11:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '3587' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 04:11:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3587' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 21/11/2024 04:11:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94412' 21/11/2024 04:11:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '94412' 21/11/2024 04:11:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94412' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 21/11/2024 04:41:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3588' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 04:41:49 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' , '3588' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 21/11/2024 04:41:49 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 = '94413' 21/11/2024 04:41:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '94413' 21/11/2024 04:41:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94413' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 21/11/2024 04:45:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '3589' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 04:45:29 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' , '3589' , '2024-11-21' , '' , '0' , '0' , '0' , 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '213.50' , '197.27' , NOW() , NOW() ) 21/11/2024 04:45:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94414' 21/11/2024 04:45:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '94414' 21/11/2024 04:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94414' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '3' , '-3' , '1' , '15.0000' , '12.2951' , '22' , '0' , '45.00' ) 21/11/2024 04:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94414' , '21612' , 'RITO DELLE ESEQUIE - ED. MIN.- N.E.' , '2' , '-2' , '4' , '30.0000' , '30' , '0' , '5' , '57.00' ) 21/11/2024 04:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94414' , '5762' , 'LEZIONARIO E RITO DEL MATRIMONIO - KIT 2 VOL.' , '2' , '-2' , '4' , '25.0000' , '25' , '0' , '5' , '47.50' ) 21/11/2024 04:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94414' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 21/11/2024 04:45:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94414' , '20885' , 'BIGLIETTI SANTINI X 100 PZ' , '3' , '-3' , '1' , '15.0000' , '12.2951' , '22' , '0' , '45.00' ) 21/11/2024 04:47:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '96/A' AND id_document != '93088' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-11') 21/11/2024 04:47:39 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '96/A', document_date = '2024-09-11', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4679091', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', address2 = '', note = 'ACCONTO € 200 25/9/24 + € 140,00 29/10/24', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1079.80', price_tax_excluded = '885.08', date_upd = NOW() WHERE id_document = '93088' 21/11/2024 04:47:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '93088' 21/11/2024 04:47:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '93088' 21/11/2024 04:47:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '21695' , 'CASULA MARIANA - 65/027108-M' , '1' , '-1' , '1' , '975.0000' , '799.18032786885' , '22' , '0' , '975.00' ) 21/11/2024 04:47:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '9.80' ) 21/11/2024 04:47:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '22922' , 'COPRI LEGGIO GIUBILEO 2025' , '1' , '-1' , '1' , '65.0000' , '53.27868852459' , '22' , '0' , '65.00' ) 21/11/2024 04:47:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '19128' , 'MENSA 60X200 CELESTE - M6020C' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 21/11/2024 04:47:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '93088' , '21137' , 'MOCCOLO 70X200' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 21/11/2024 04:53:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '3590' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 04:53:18 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3590' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.75' , '21.14' , NOW() , NOW() ) 21/11/2024 04:53:18 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94415' 21/11/2024 04:53:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '94415' 21/11/2024 04:53:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94415' , '21663' , 'CORAGGIO DI UNA DONNA ' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 21/11/2024 04:53:18 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94415' , '22870' , 'AGENDA SAN PAOLO 2025' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 21/11/2024 05:17:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '3591' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 05:17:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3591' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.08' , '108.77' , NOW() , NOW() ) 21/11/2024 05:17: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 = '94416' 21/11/2024 05:17:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '94416' 21/11/2024 05:17: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 ( '94416' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 21/11/2024 05:17: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 ( '94416' , '20012' , 'MARIA LIMMACOLATA - NOVENA IMMACOLATA - A. CALZOLARO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 21/11/2024 05:17: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 ( '94416' , '23121' , 'AVVENTO 2024 GIORNO PER GIORNO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 21/11/2024 05:17: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 ( '94416' , '23135' , 'SUSSIDIO AVVENTO E NATALE 2024/25 RAGAZZI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 21/11/2024 05:17: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 ( '94416' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '1.35' , '1.1065573770492' , '22' , '0' , '5.40' ) 21/11/2024 05:24:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '3592' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 05:24:37 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3592' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.92' , '48.92' , NOW() , NOW() ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94417' 21/11/2024 05:24:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '94417' 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '3388' , 'DEVOZIONE AL SANTO VOLTO DI GESÙ - 8426' , '2' , '-2' , '4' , '4.00' , '4' , '0' , '5' , '7.60' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '22118' , 'PIEGHEVOLE LA MEDAGLIA MIRACOLOSA' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '7108' , 'NOVENA AL SANTO NATALE - 8521' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '20719' , 'CORONA DELL’ADDOLORATA' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '5' , '1.71' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '22669' , 'ABBI CURA - 8669' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '13083' , 'PREGHIERA PER I DEFUNTI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '5' , '1.90' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '6629' , 'MIA PREGHIERA' , '1' , '-1' , '4' , '0.90' , '0.9' , '0' , '0' , '0.90' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '7098' , 'NOVENA A MARIA CHE SCIOGLIE I NODI - 8558' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '7111' , 'NOVENA ALLA MADONNA CHE SCIOGLIE I NODI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '17124' , '100 PREGHIERE N.E. - A. COMASTRI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '16175' , 'MALATTIA, SOFFERENZA E UNZIONE DEGLI INFERMI - PAPA FRANCESCO' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 21/11/2024 05:24:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94417' , '16220' , 'GUARISCIMI LIBERAMI CONSOLAMI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 21/11/2024 05:30:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '3593' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 05:30: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' , '3593' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '59.02' , NOW() , NOW() ) 21/11/2024 05:30: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 = '94418' 21/11/2024 05:30:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '94418' 21/11/2024 05:30: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 ( '94418' , '20117' , 'FATIMA CM 55 - 1036' , '1' , '-1' , '1' , '72.00' , '59.016393442623' , '22' , '0' , '72.00' ) 21/11/2024 06:40:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '3594' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-11-21') 21/11/2024 06:40:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3594' , '2024-11-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '4.92' , NOW() , NOW() ) 21/11/2024 06:40:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94419' 21/11/2024 06:40:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '94419' 21/11/2024 06:40:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94419' , '20153' , 'QUADRETTO CULLA ANGELO DI DIO CELESTE - 5510SC' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 21/11/2024 06:40:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94419' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' )