01/06/2024 09:07:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1842' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-01') 01/06/2024 09:07:04 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' , '1842' , '2024-06-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.50' , '89.75' , NOW() , NOW() ) 01/06/2024 09:07:04 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 = '92113' 01/06/2024 09:07:04 am >> DELETE FROM ps_document_detail WHERE id_document = '92113' 01/06/2024 09:07:04 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 ( '92113' , '19396' , 'CLERGY MISTO COTONE MM - C01' , '3' , '-3' , '1' , '36.50' , '29.918032786885' , '22' , '0' , '109.50' ) 01/06/2024 09:19:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1843' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-01') 01/06/2024 09:19:52 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' , '1843' , '2024-06-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '18.03' , NOW() , NOW() ) 01/06/2024 09:19:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92114' 01/06/2024 09:19:52 am >> DELETE FROM ps_document_detail WHERE id_document = '92114' 01/06/2024 09:19:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92114' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '22' , '18.032786885246' , '22' , '0' , '22.00' ) 01/06/2024 09:21:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1843' AND id_document != '92114' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-01') 01/06/2024 09:21:19 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1843', document_date = '2024-06-01', 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.00', price_tax_excluded = '18.03', date_upd = NOW() WHERE id_document = '92114' 01/06/2024 09:21: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 = '92114' 01/06/2024 09:21:19 am >> DELETE FROM ps_document_detail WHERE id_document = '92114' 01/06/2024 09:21: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 ( '92114' , '20325' , 'AMITTO IN LINO - 86/000030' , '1' , '-1' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '22.00' ) 01/06/2024 09:59:33 am >> SELECT document_num FROM ps_document WHERE document_num = '71/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-06-01') 01/06/2024 09:59:33 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '71/A' , '2024-06-01' , 'A' , '3544' , '0' , '4674054' , 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '60.00' , NOW() , NOW() ) 01/06/2024 09:59:33 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 = '92115' 01/06/2024 09:59:33 am >> DELETE FROM ps_document_detail WHERE id_document = '92115' 01/06/2024 09:59:33 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 ( '92115' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '5' , '-5' , '0' , '12.00' , '12' , '' , '0' , '60.00' ) 01/06/2024 09:59:53 am >> SELECT document_num FROM ps_document WHERE document_num = '71/A' AND id_document != '92115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-06-01') 01/06/2024 09:59:53 am >> UPDATE ps_document SET id_document_type = '24', document_num = '71/A', document_date = '2024-06-01', document_letter = 'A', id_customer = '3544', id_supplier = '', id_address = '4674054', address1 = 'VIA SAN MARCO 53 - FRAZ. MONTICELLI 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '92115' 01/06/2024 09:59:53 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 = '92115' 01/06/2024 09:59:53 am >> DELETE FROM ps_document_detail WHERE id_document = '92115' 01/06/2024 09:59:53 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 ( '92115' , '21096' , 'CROCE REMOVIBILE EFFETTO PIETRA - 3873' , '5' , '-5' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '60.00' ) 01/06/2024 10:17:44 am >> SELECT document_num FROM ps_document WHERE document_num = '1844' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-01') 01/06/2024 10:17: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 ( '11' , '1844' , '2024-06-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '66.50' , '66.50' , NOW() , NOW() ) 01/06/2024 10:17: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 = '92116' 01/06/2024 10:17:44 am >> DELETE FROM ps_document_detail WHERE id_document = '92116' 01/06/2024 10:17: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 ( '92116' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 01/06/2024 10:17: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 ( '92116' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 01/06/2024 10:26:52 am >> SELECT document_num FROM ps_document WHERE document_num = '1845' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-01') 01/06/2024 10:26:52 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' , '1845' , '2024-06-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '139.34' , NOW() , NOW() ) 01/06/2024 10:26:52 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92117' 01/06/2024 10:26:52 am >> DELETE FROM ps_document_detail WHERE id_document = '92117' 01/06/2024 10:26:52 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92117' , '19190' , 'STOLA MARIANA - 7335' , '1' , '-1' , '1' , '170.00' , '139.34426229508' , '22' , '0' , '170.00' ) 01/06/2024 10:43:14 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 01/06/2024 10:43:14 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22683' , '1' , '' , 'nuovo-prodotto' ) 01/06/2024 10:43:14 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22683' , '1' , '1' , '2' , NOW() , NOW() ) 01/06/2024 10:43:14 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22683' , '0' , '1' , '0' , '0' ) 01/06/2024 10:55:36 am >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '90734' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-13') 01/06/2024 10:55:36 am >> UPDATE ps_document SET id_document_type = '24', document_num = '37/A', document_date = '2024-03-13', document_letter = 'A', id_customer = '357', id_supplier = '', id_address = '4676034', address1 = 'VIA TORRIONE 84100 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 = '258.00', price_tax_excluded = '241.41', date_upd = NOW() WHERE id_document = '90734' 01/06/2024 10:55:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90734' 01/06/2024 10:55:36 am >> DELETE FROM ps_document_detail WHERE id_document = '90734' 01/06/2024 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 01/06/2024 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '19106' , 'FRAGRANZA NARDO' , '3' , '-3' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '48.00' ) 01/06/2024 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '22' , '-22' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '44.00' ) 01/06/2024 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '22511' , 'VIVE - CD' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '0' , '16.90' ) 01/06/2024 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '5780' , 'LEZIONARIO QUOTIDIANO 4' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 01/06/2024 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '5779' , 'LEZIONARIO QUOTIDIANO 3' , '1' , '-1' , '4' , '36.00' , '36' , '0' , '5' , '34.20' ) 01/06/2024 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '5777' , 'LEZIONARIO QUOTIDIANO 1' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 01/06/2024 10:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90734' , '5778' , 'LEZIONARIO QUOTIDIANO 2' , '1' , '-1' , '4' , '32.00' , '32' , '0' , '5' , '30.40' ) 01/06/2024 11:09:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1846' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-01') 01/06/2024 11:09: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' , '1846' , '2024-06-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.80' , '0.66' , NOW() , NOW() ) 01/06/2024 11:09: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 = '92118' 01/06/2024 11:09:19 am >> DELETE FROM ps_document_detail WHERE id_document = '92118' 01/06/2024 11:09: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 ( '92118' , '17004' , 'BIGLIETTO AUGURALE PICCOLO' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 01/06/2024 11:13:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1847' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-01') 01/06/2024 11:13: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' , '1847' , '2024-06-01' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '14.59' , NOW() , NOW() ) 01/06/2024 11:13: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 = '92119' 01/06/2024 11:13:14 am >> DELETE FROM ps_document_detail WHERE id_document = '92119' 01/06/2024 11:13: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 ( '92119' , '11389' , 'VINO ROSSO DOLCE - 103' , '2' , '-2' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '17.80' )