08/06/2023 08:34:40 am >> SELECT document_num FROM ps_document WHERE document_num = '1987' AND id_document != '85751' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-07') 08/06/2023 08:34:40 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1987', document_date = '2023-06-07', 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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '85751' 08/06/2023 08:34: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 = '85751' 08/06/2023 08:34:40 am >> DELETE FROM ps_document_detail WHERE id_document = '85751' 08/06/2023 08:34: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 ( '85751' , '7917' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. B' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 08/06/2023 09:07:10 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/06/2023 09:07:10 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21149' , '1' , '' , 'nuovo-prodotto' ) 08/06/2023 09:07:10 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21149' , '1' , '1' , '2' , NOW() , NOW() ) 08/06/2023 09:07:10 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21149' , '0' , '1' , '0' , '0' ) 08/06/2023 09:09:39 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616041' AND id_product != '21149' AND ean13 != '' 08/06/2023 09:09:39 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788886616041', date_upd = NOW() WHERE id_product = '21149' 08/06/2023 09:09:39 am >> UPDATE ps_product_lang SET name = 'MEDJUGORJE - RACCOLTA MESSAGGI - 8104', description = '' WHERE id_product = '21149' 08/06/2023 09:09:39 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '21149' 08/06/2023 09:09:39 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21149' 08/06/2023 09:09:39 am >> DELETE FROM ps_specific_price WHERE id_product = '21149' 08/06/2023 09:10:47 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 ( '31' , '9493/00/2023' , '2023-06-06' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '126.00' , '126.00' , NOW() , NOW() ) 08/06/2023 09:10:47 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 = '85752' 08/06/2023 09:10:47 am >> DELETE FROM ps_document_detail WHERE id_document = '85752' 08/06/2023 09:10:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85752' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '20' , '20' , '4' , '5.00' , '5' , '0' , '40' , '60.0000' ) 08/06/2023 09:10:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21037' AND id_supplier = '38' 08/06/2023 09:10:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21037' , '38' , '1' ) 08/06/2023 09:10: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 ( '85752' , '19924' , 'SACRA BIBBIA BIANCA - 8056' , '1' , '1' , '4' , '25.00' , '25' , '0' , '40' , '15.0000' ) 08/06/2023 09:10:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19924' AND id_supplier = '38' 08/06/2023 09:10:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19924' , '38' , '1' ) 08/06/2023 09:10: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 ( '85752' , '19583' , 'ROSARIO AL SACRO CUORE - 8063' , '3' , '3' , '4' , '3.00' , '3' , '0' , '40' , '5.4000' ) 08/06/2023 09:10:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19583' AND id_supplier = '38' 08/06/2023 09:10:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19583' , '38' , '1' ) 08/06/2023 09:10: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 ( '85752' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '3' , '3' , '4' , '5.00' , '5' , '0' , '40' , '9.0000' ) 08/06/2023 09:10:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19584' AND id_supplier = '38' 08/06/2023 09:10:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19584' , '38' , '1' ) 08/06/2023 09:10: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 ( '85752' , '21149' , 'MEDJUGORJE - RACCOLTA MESSAGGI - 8104' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 08/06/2023 09:10:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '21149' AND id_supplier = '38' 08/06/2023 09:10:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21149' , '38' , '1' ) 08/06/2023 09:10: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 ( '85752' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 08/06/2023 09:10:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '38' 08/06/2023 09:10:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '38' , '1' ) 08/06/2023 09:10: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 ( '85752' , '8335' , 'PREGHIERE A SANTANTONIO DI PADOVA' , '2' , '2' , '4' , '8.00' , '8' , '0' , '40' , '9.6000' ) 08/06/2023 09:10:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '8335' AND id_supplier = '38' 08/06/2023 09:10:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8335' , '38' , '1' ) 08/06/2023 09:10: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 ( '85752' , '8342' , 'PREGHIERE ALLO SPIRITO SANTO - 8177' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 08/06/2023 09:10:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '8342' AND id_supplier = '38' 08/06/2023 09:10:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8342' , '38' , '1' ) 08/06/2023 09:10: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 ( '85752' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '1' , '4' , '3.00' , '3' , '0' , '40' , '1.8000' ) 08/06/2023 09:10:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '15746' AND id_supplier = '38' 08/06/2023 09:10:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15746' , '38' , '1' ) 08/06/2023 09:10: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 ( '85752' , '16446' , 'LOURDES ROSARIO DI S. BERNARDETTE - 8981' , '2' , '2' , '4' , '3.00' , '3' , '0' , '40' , '3.6000' ) 08/06/2023 09:10:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '16446' AND id_supplier = '38' 08/06/2023 09:10:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16446' , '38' , '1' ) 08/06/2023 09:29:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1988' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 09:29:38 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1988' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '156.40' , '134.38' , NOW() , NOW() ) 08/06/2023 09:29:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85753' 08/06/2023 09:29:38 am >> DELETE FROM ps_document_detail WHERE id_document = '85753' 08/06/2023 09:29:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85753' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 08/06/2023 09:29:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85753' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 08/06/2023 09:29:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85753' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 08/06/2023 10:16:08 am >> SELECT document_num FROM ps_document WHERE document_num = '1989' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 10:16:08 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' , '1989' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 08/06/2023 10:16:08 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 = '85754' 08/06/2023 10:16:08 am >> DELETE FROM ps_document_detail WHERE id_document = '85754' 08/06/2023 10:16:08 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 ( '85754' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 08/06/2023 10:17:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1990' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 10:17:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1990' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.56' , '8.56' , NOW() , NOW() ) 08/06/2023 10:17:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85755' 08/06/2023 10:17:05 am >> DELETE FROM ps_document_detail WHERE id_document = '85755' 08/06/2023 10:17:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85755' , '21143' , 'AGGIUNTA CANTI 2023' , '2' , '-2' , '4' , '4.50' , '4.5' , '0' , '5' , '8.56' ) 08/06/2023 10:37:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8053853003522' AND id_product != '21143' AND ean13 != '' 08/06/2023 10:37:07 am >> UPDATE ps_product SET id_supplier = '7', reference = '1/5', ean13 = '8053853003522', date_upd = NOW() WHERE id_product = '21143' 08/06/2023 10:37:07 am >> UPDATE ps_product_lang SET name = 'AGGIUNTA CANTI 2023', description = '' WHERE id_product = '21143' 08/06/2023 10:37:07 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.5000' WHERE id_product = '21143' 08/06/2023 10:37:07 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.5000', id_tax_rules_group = '4', id_category_default = '76', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21143' 08/06/2023 10:37:07 am >> DELETE FROM ps_specific_price WHERE id_product = '21143' 08/06/2023 10:50:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1991' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 10:50:21 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' , '1991' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.17' , '12.17' , NOW() , NOW() ) 08/06/2023 10:50:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85756' 08/06/2023 10:50:21 am >> DELETE FROM ps_document_detail WHERE id_document = '85756' 08/06/2023 10:50:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85756' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/06/2023 10:50:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85756' , '20999' , 'AMEN - LUG 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 08/06/2023 10:50:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85756' , '21067' , 'AMEN - AGO 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 08/06/2023 11:12:55 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'cEZuNzLsYoeoh1YF' , NOW() , NOW() ) 08/06/2023 11:12:55 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7051' , '1' ) 08/06/2023 11:12:55 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7051' , '2' ) 08/06/2023 11:12:55 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7051' , '3' ) 08/06/2023 11:14:59 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7051' 08/06/2023 11:14:59 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '7051' , '10' , '165' , 'PARROCCHIA S. CATERINA V. M. ' , 'CELLUCCI' , 'P. GIUSEPPE' , 'PIAZZA GUGLIELMO PEPE 1' , '' , '86077' , 'OZZILLI' , '' , '' , '3283581558' , '' , '80051300947' , NOW() , NOW() ) 08/06/2023 11:14:59 am >> UPDATE ps_customer SET email = 'giuseppecellucci.omi@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7051' 08/06/2023 11:33:05 am >> SELECT document_num FROM ps_document WHERE document_num = '1992' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 11:33:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1992' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '127.63' , NOW() , NOW() ) 08/06/2023 11:33:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85757' 08/06/2023 11:33:05 am >> DELETE FROM ps_document_detail WHERE id_document = '85757' 08/06/2023 11:33:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85757' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 08/06/2023 11:33:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85757' , '19819' , 'INCENSO NATURALE 1 ST GRADE - KG 1' , '1' , '-1' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '27.00' ) 08/06/2023 11:33:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85757' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 08/06/2023 11:33:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85757' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '3.30' ) 08/06/2023 11:33:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85757' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '4' , '-4' , '1' , '3.20' , '2.6229508196721' , '22' , '0' , '12.80' ) 08/06/2023 11:33:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85757' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '2' , '-2' , '1' , '9.95' , '8.155737704918' , '22' , '0' , '19.90' ) 08/06/2023 11:33:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85757' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '10' , '-10' , '3' , '3.30' , '3.1730769230769' , '4' , '0' , '33.00' ) 08/06/2023 12:00:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1993' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 12:00:54 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' , '1993' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '156.00' , '127.87' , NOW() , NOW() ) 08/06/2023 12:00:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85758' 08/06/2023 12:00:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '85758' 08/06/2023 12:00:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85758' , '12824' , 'PIZZO BIANCO ORO MARIANO' , '2' , '-2' , '1' , '78' , '63.934426229508' , '22' , '0' , '156.00' ) 08/06/2023 12:01:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1994' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 12:01:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1994' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '47.82' , NOW() , NOW() ) 08/06/2023 12:01:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85759' 08/06/2023 12:01:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '85759' 08/06/2023 12:01:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85759' , '19101' , 'INCENSO C' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 08/06/2023 12:01:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85759' , '9333' , 'SACRO CUORE DI GESÙ - 208 ' , '2' , '-2' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '7.60' ) 08/06/2023 12:01:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85759' , '8335' , 'PREGHIERE A SANTANTONIO DI PADOVA' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 08/06/2023 12:01:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85759' , '19584' , 'UN MESE CON IL SACRO CUORE - 8065' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 08/06/2023 12:01:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85759' , '18012' , 'NOVENA AL SACRO CUORE DI GESU - 8020' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 08/06/2023 12:01:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85759' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 08/06/2023 12:03:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1995' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 12:03:11 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' , '1995' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 08/06/2023 12:03:11 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 = '85760' 08/06/2023 12:03:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '85760' 08/06/2023 12:03:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85760' , '17617' , 'IMMAGINI ISONZO X 100' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 08/06/2023 12:03:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85760' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '2' , '-2' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '2.20' ) 08/06/2023 12:03:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85760' , '8147' , 'POLO BASIC' , '2' , '-2' , '1' , '27.00' , '22.131147540984' , '22' , '0' , '54.00' ) 08/06/2023 12:04:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '1996' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 12:04:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1996' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.00' , '59.02' , NOW() , NOW() ) 08/06/2023 12:04:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85761' 08/06/2023 12:04:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '85761' 08/06/2023 12:04:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85761' , '19594' , 'POLO JERSEY COTONE 100%' , '2' , '-2' , '1' , '36' , '29.508196721311' , '22' , '0' , '72.00' ) 08/06/2023 12:07:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1997' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 12:07:42 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' , '1997' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.80' , '16.11' , NOW() , NOW() ) 08/06/2023 12:07:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85762' 08/06/2023 12:07:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '85762' 08/06/2023 12:07:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85762' , '13703' , 'GESU E BELLO INCONTRARTI - ALBUM PRIMA COMUNIONE' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 08/06/2023 12:07:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85762' , '1290' , 'BRACCIALE 7 DONI - 820/07' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 08/06/2023 12:13:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '85732' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-07') 08/06/2023 12:13:13 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '63/A', document_date = '2023-06-07', document_letter = 'A', id_customer = '188', id_supplier = '', id_address = '4668955', address1 = 'VIA ROMA 84121 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '36.50', price_tax_excluded = '35.58', date_upd = NOW() WHERE id_document = '85732' 08/06/2023 12:13:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85732' 08/06/2023 12:13:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '85732' 08/06/2023 12:13:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85732' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '14.00' ) 08/06/2023 12:13:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85732' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 08/06/2023 12:13:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85732' , '' , 'candele 20x40 comunione' , '5' , '-5' , '0' , '2.5' , '2.5' , '' , '0' , '12.50' ) 08/06/2023 12:14:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '1094' AND id_document != '82603' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-04-01') 08/06/2023 12:14:54 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1094', document_date = '2023-04-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 = '52.00', price_tax_excluded = '42.62', date_upd = NOW() WHERE id_document = '82603' 08/06/2023 12:14:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82603' 08/06/2023 12:14:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '82603' 08/06/2023 12:14:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82603' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 08/06/2023 12:14:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82603' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' ) 08/06/2023 12:14:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82603' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '1' , '-1' , '1' , '15' , '12.295081967213' , '22' , '0' , '15.00' ) 08/06/2023 02:12:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '1993' AND id_document != '85758' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 02:12:09 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1993', document_date = '2023-06-08', 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 = '156.00', price_tax_excluded = '127.87', date_upd = NOW() WHERE id_document = '85758' 08/06/2023 02:12:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85758' 08/06/2023 02:12:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '85758' 08/06/2023 02:12: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 ( '85758' , '14016' , 'BALZA SU TESSUTO AZZURRO' , '4' , '-4' , '1' , '39' , '31.967213114754' , '22' , '0' , '156.00' ) 08/06/2023 02:12:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '937' AND id_document != '82423' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-23') 08/06/2023 02:12:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '937', document_date = '2023-03-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 = '95.00', price_tax_excluded = '77.87', date_upd = NOW() WHERE id_document = '82423' 08/06/2023 02:12:59 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 = '82423' 08/06/2023 02:12:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '82423' 08/06/2023 02:12:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82423' , '15089' , 'QUADRETTO EFFETTO PIETRA - SACRA FAMIGLIA - 2950' , '3' , '-3' , '1' , '6.5000' , '5.327868852459' , '22' , '0' , '19.50' ) 08/06/2023 02:12:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82423' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '25.00' ) 08/06/2023 02:12:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82423' , '14016' , 'BALZA SU TESSUTO AZZURRO' , '2' , '-2' , '1' , '25.25' , '20.696721311475' , '22' , '0' , '50.50' ) 08/06/2023 02:13:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '966' AND id_document != '82457' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-24') 08/06/2023 02:13:29 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '966', document_date = '2023-03-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '93.00', price_tax_excluded = '76.77', date_upd = NOW() WHERE id_document = '82457' 08/06/2023 02:13: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 = '82457' 08/06/2023 02:13:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '82457' 08/06/2023 02:13: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 ( '82457' , '12824' , 'PIZZO BIANCO ORO MARIANO' , '2' , '-2' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '90.00' ) 08/06/2023 02:13: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 ( '82457' , '17993' , 'TRIDUO PASQUALE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 08/06/2023 02:16:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1992' AND id_document != '85757' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 02:16:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1992', document_date = '2023-06-08', 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 = '150.00', price_tax_excluded = '127.63', date_upd = NOW() WHERE id_document = '85757' 08/06/2023 02:16: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 = '85757' 08/06/2023 02:16:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '85757' 08/06/2023 02:16: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 ( '85757' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 08/06/2023 02:16: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 ( '85757' , '19819' , 'INCENSO NATURALE 1 ST GRADE - KG 1' , '1' , '-1' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '27.00' ) 08/06/2023 02:16: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 ( '85757' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '24.00' ) 08/06/2023 02:16: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 ( '85757' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '3.30' ) 08/06/2023 02:16: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 ( '85757' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '3' , '-3' , '1' , '3.2000' , '2.6229508196721' , '22' , '0' , '9.60' ) 08/06/2023 02:16: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 ( '85757' , '18799' , 'PARAFIAMMA PIREX PER CARTUCCIA 4 CM - 474/30' , '2' , '-2' , '1' , '9.9500' , '8.155737704918' , '22' , '0' , '19.90' ) 08/06/2023 02:16: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 ( '85757' , '20431' , 'PARTICOLA TAGLIO CHIUSO 35MM - W500' , '10' , '-10' , '3' , '3.3000' , '3.1730769230769' , '4' , '0' , '33.00' ) 08/06/2023 02:16: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 ( '85757' , '8195' , 'GIGLER COMPLETO DORATO - 250 ' , '1' , '-1' , '1' , '3.2' , '2.6229508196721' , '22' , '0' , '3.20' ) 08/06/2023 02:32:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '84273' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-11') 08/06/2023 02:32:00 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '61/A', document_date = '2023-05-11', document_letter = 'A', id_customer = '949', id_supplier = '', id_address = '4671033', address1 = 'VIA P. PALMIERI, 39 10138 TORINO', 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 = '328.45', price_tax_excluded = '328.45', date_upd = NOW() WHERE id_document = '84273' 08/06/2023 02:32:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '84273' 08/06/2023 02:32:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '84273' 08/06/2023 02:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '0' , '84.00' ) 08/06/2023 02:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '0' , 'GIA\' INVIATI' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/06/2023 02:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '15055' , 'CROCE PADRE NOSTRO' , '24' , '-24' , '0' , '2.8000' , '2.8' , '0' , '0' , '67.20' ) 08/06/2023 02:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '0' , 'quadretto smussato' , '25' , '-25' , '0' , '2.2500' , '2.25' , '0' , '0' , '56.25' ) 08/06/2023 02:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '20516' , 'CROCE COMUNIONE - 42/08' , '50' , '-50' , '0' , '1.3' , '1.3' , '' , '0' , '65.00' ) 08/06/2023 02:32:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '20' , '-20' , '4' , '2.80' , '2.8' , '0' , '0' , '56.00' ) 08/06/2023 02:33:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '61/A' AND id_document != '84273' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-05-11') 08/06/2023 02:33:59 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '61/A', document_date = '2023-05-11', document_letter = 'A', id_customer = '949', id_supplier = '', id_address = '4671033', address1 = 'VIA P. PALMIERI, 39 10138 TORINO', 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 = '1428.45', price_tax_excluded = '1428.45', date_upd = NOW() WHERE id_document = '84273' 08/06/2023 02:33:59 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 = '84273' 08/06/2023 02:33:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '84273' 08/06/2023 02:33:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '30' , '-30' , '4' , '2.8000' , '2.8' , '0' , '0' , '84.00' ) 08/06/2023 02:33:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '0' , 'GIA\' INVIATI' , '1' , '-1' , '0' , '0.0000' , '0' , '0' , '0' , '0.00' ) 08/06/2023 02:33:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '15055' , 'CROCE PADRE NOSTRO' , '24' , '-24' , '0' , '2.8000' , '2.8' , '0' , '0' , '67.20' ) 08/06/2023 02:33:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '0' , 'quadretto smussato' , '25' , '-25' , '0' , '2.2500' , '2.25' , '0' , '0' , '56.25' ) 08/06/2023 02:33:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '20516' , 'CROCE COMUNIONE - 42/08' , '50' , '-50' , '0' , '1.3000' , '1.3' , '0' , '0' , '65.00' ) 08/06/2023 02:33:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '20' , '-20' , '4' , '2.8000' , '2.8' , '0' , '0' , '56.00' ) 08/06/2023 02:33:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '84273' , '' , 'CANDELIERE VOTIVO' , '1' , '-1' , '0' , '1100' , '1100' , '' , '0' , '1100.00' ) 08/06/2023 03:17:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '26' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 03:17:08 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' , '26' , '2023-06-08' , '' , '7051' , '0' , '135353948' , 'PIAZZA GUGLIELMO PEPE 1 86077 OZZILLI' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '113.15' , '113.15' , NOW() , NOW() ) 08/06/2023 03:17:08 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 = '11338' 08/06/2023 03:17:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '11338' 08/06/2023 03:17:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '11338' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '50' , '-50' , '4' , '2.50' , '2.5' , '0' , '15' , '106.25' ) 08/06/2023 03:23:03 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7051' 08/06/2023 03:23:03 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 ( '7051' , '10' , '165' , 'PARROCCHIA S. CATERINA V. M. ' , 'CELLUCCI' , 'P. GIUSEPPE' , 'PIAZZA GUGLIELMO PEPE 1' , '' , '86077' , 'POZZILLI' , '' , '' , '3283581558' , '' , '80051300947' , NOW() , NOW() ) 08/06/2023 03:23:03 pm >> UPDATE ps_customer SET email = 'giuseppecellucci.omi@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7051' 08/06/2023 04:05:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '1998' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 04:05:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1998' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.60' , '2.95' , NOW() , NOW() ) 08/06/2023 04:05:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85763' 08/06/2023 04:05:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '85763' 08/06/2023 04:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85763' , '18276' , 'CINGOLO CON NODI - 3280' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 08/06/2023 04:05:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85763' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '1.4' , '1.1475409836066' , '22' , '0' , '1.40' ) 08/06/2023 04:52:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1999' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 04:52:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1999' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '8.61' , NOW() , NOW() ) 08/06/2023 04:52:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85764' 08/06/2023 04:52:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '85764' 08/06/2023 04:52:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85764' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '3' , '-3' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '10.50' ) 08/06/2023 05:08:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '119/A' AND id_document != '77503' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-12-23') 08/06/2023 05:08:19 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '119/A', document_date = '2022-12-23', document_letter = 'A', id_customer = '3843', id_supplier = '', id_address = '4673209', address1 = 'RIONE PIOMBINO 84080 PELLEZZANO', address2 = '', note = '01/03 € 100,00-01/04 100 - 01/05 - 100 - 08/06 100', 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 = '1950.00', price_tax_excluded = '1950.00', date_upd = NOW() WHERE id_document = '77503' 08/06/2023 05:08: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 = '77503' 08/06/2023 05:08:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '77503' 08/06/2023 05:08: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 ( '77503' , '0' , 'STOLA' , '1' , '-1' , '0' , '1950.0000' , '1950' , '0' , '0' , '1950.00' ) 08/06/2023 05:09:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '26' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 05:09: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 ( '24' , '26' , '2023-06-08' , '' , '3843' , '0' , '4673209' , 'RIONE PIOMBINO 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.50' , '32.38' , NOW() , NOW() ) 08/06/2023 05:09: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 = '85765' 08/06/2023 05:09:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '85765' 08/06/2023 05:09: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 ( '85765' , '21132' , 'CLERGY F/F MC' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 08/06/2023 05:10:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '65/A' AND id_document != '85765' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 05:10:12 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '65/A', document_date = '2023-06-08', document_letter = 'A', id_customer = '3843', id_supplier = '', id_address = '4673209', address1 = 'RIONE PIOMBINO 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '39.50', price_tax_excluded = '32.38', date_upd = NOW() WHERE id_document = '85765' 08/06/2023 05:10:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85765' 08/06/2023 05:10:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '85765' 08/06/2023 05:10:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85765' , '21132' , 'CLERGY F/F MC' , '1' , '-1' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '39.50' ) 08/06/2023 05:22:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'BD235' AND id_product != '16243' AND ean13 != '' 08/06/2023 05:22:58 pm >> UPDATE ps_product SET id_supplier = '50', reference = '', ean13 = 'BD235', date_upd = NOW() WHERE id_product = '16243' 08/06/2023 05:22:58 pm >> UPDATE ps_product_lang SET name = 'QUADRO 10X10', description = '' WHERE id_product = '16243' 08/06/2023 05:22:58 pm >> UPDATE ps_product SET wholesale_price = '3.00', on_sale = '0', price = '10.245901639344263' WHERE id_product = '16243' 08/06/2023 05:22:58 pm >> UPDATE ps_product_shop SET wholesale_price = '3.00', price = '10.245901639344263', id_tax_rules_group = '1', id_category_default = '276', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16243' 08/06/2023 05:22:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '16243' 08/06/2023 05:25:14 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 08/06/2023 05:25:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21150' , '1' , '' , 'nuovo-prodotto' ) 08/06/2023 05:25:14 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21150' , '1' , '1' , '2' , NOW() , NOW() ) 08/06/2023 05:25:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21150' , '0' , '1' , '0' , '0' ) 08/06/2023 05:26:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'BD36' AND id_product != '21150' AND ean13 != '' 08/06/2023 05:26:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'BD36', date_upd = NOW() WHERE id_product = '21150' 08/06/2023 05:26:03 pm >> UPDATE ps_product_lang SET name = 'QUADRO 15X15', description = '' WHERE id_product = '21150' 08/06/2023 05:26:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.98360655737705' WHERE id_product = '21150' 08/06/2023 05:26:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.98360655737705', id_tax_rules_group = '1', id_category_default = '276', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21150' 08/06/2023 05:26:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '21150' 08/06/2023 05:28:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '337/2023' , '2023-05-26' , '2023' , '0' , '50' , '2645' , 'VIA P. G. SEMERIA, 19 70014 CONVERSANO' , '' , '' , '15' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '452.62' , '371.00' , NOW() , NOW() ) 08/06/2023 05:28:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85766' 08/06/2023 05:28:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '85766' 08/06/2023 05:28:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85766' , '20705' , 'CANDELA CUBO' , '20' , '20' , '1' , '11' , '9.016393442623' , '22' , '50' , '134.2000' ) 08/06/2023 05:28:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20705' AND id_supplier = '50' 08/06/2023 05:28:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20705' , '50' , '1' ) 08/06/2023 05:28:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85766' , '16243' , 'QUADRO 10X10' , '6' , '6' , '1' , '10' , '8.1967213114754' , '22' , '50' , '36.6000' ) 08/06/2023 05:28:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16243' AND id_supplier = '50' 08/06/2023 05:28:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16243' , '50' , '1' ) 08/06/2023 05:28:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85766' , '21150' , 'QUADRO 15X15' , '8' , '8' , '1' , '16' , '13.114754098361' , '22' , '50' , '78.0800' ) 08/06/2023 05:28:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21150' AND id_supplier = '50' 08/06/2023 05:28:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21150' , '50' , '1' ) 08/06/2023 05:28:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85766' , '17846' , 'QUADRO DECORATO 23X15' , '8' , '8' , '1' , '20' , '16.393442622951' , '22' , '50' , '97.6000' ) 08/06/2023 05:28:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17846' AND id_supplier = '50' 08/06/2023 05:28:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17846' , '50' , '1' ) 08/06/2023 05:28:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85766' , '20707' , 'LUME LEGNO' , '6' , '6' , '1' , '24' , '19.672131147541' , '22' , '50' , '87.8400' ) 08/06/2023 05:28:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20707' AND id_supplier = '50' 08/06/2023 05:28:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20707' , '50' , '1' ) 08/06/2023 06:08:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2000' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 06:08: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' , '2000' , '2023-06-08' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '46.72' , NOW() , NOW() ) 08/06/2023 06:08: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 = '85767' 08/06/2023 06:08:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '85767' 08/06/2023 06:08: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 ( '85767' , '859' , 'AVE MARIA ITALIANO FUCSIA - MY AMIT10 57' , '1' , '-1' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '39.00' ) 08/06/2023 06:08: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 ( '85767' , '18350' , 'ORECCHINI' , '1' , '-1' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '18.00' ) 08/06/2023 07:38:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '26' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-06-08') 08/06/2023 07:38:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '26' , '2023-06-08' , '' , '2739' , '0' , '4671014' , 'VIA F. WENNER, 37 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '897.00' , '735.25' , NOW() , NOW() ) 08/06/2023 07:38: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 = '85768' 08/06/2023 07:38:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '85768' 08/06/2023 07:38: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 ( '85768' , '20707' , 'LUME LEGNO' , '30' , '-30' , '1' , '29.90' , '24.508196721311' , '22' , '0' , '897.00' ) 08/06/2023 07:39:11 pm >> DELETE FROM ps_document WHERE id_document = '85768' 08/06/2023 07:39:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '85768'