27/09/2023 09:14:07 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001782' AND id_product != '18561' AND ean13 != '' 27/09/2023 09:14:07 am >> UPDATE ps_product SET id_supplier = '13', reference = '', ean13 = '001782', date_upd = NOW() WHERE id_product = '18561' 27/09/2023 09:14:07 am >> UPDATE ps_product_lang SET name = 'FORMELLA SAGOMATA 26X26 ', description = '' WHERE id_product = '18561' 27/09/2023 09:14:07 am >> UPDATE ps_product SET wholesale_price = '36.58', on_sale = '0', price = '72.9508' WHERE id_product = '18561' 27/09/2023 09:14:07 am >> UPDATE ps_product_shop SET wholesale_price = '36.58', price = '72.9508', id_tax_rules_group = '1', id_category_default = '192', 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 = '18561' 27/09/2023 09:14:07 am >> DELETE FROM ps_specific_price WHERE id_product = '18561' 27/09/2023 09:14:43 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001896' AND id_product != '19089' AND ean13 != '' 27/09/2023 09:14:43 am >> UPDATE ps_product SET id_supplier = '22', reference = '', ean13 = '001896', date_upd = NOW() WHERE id_product = '19089' 27/09/2023 09:14:43 am >> UPDATE ps_product_lang SET name = 'OSTIA MAGNA 150 - OM150', description = '' WHERE id_product = '19089' 27/09/2023 09:14:43 am >> UPDATE ps_product SET wholesale_price = '2.04', on_sale = '0', price = '4.3269' WHERE id_product = '19089' 27/09/2023 09:14:43 am >> UPDATE ps_product_shop SET wholesale_price = '2.04', price = '4.3269', id_tax_rules_group = '3', id_category_default = '342', 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 = '19089' 27/09/2023 09:14:43 am >> DELETE FROM ps_specific_price WHERE id_product = '19089' 27/09/2023 09:23:33 am >> SELECT document_num FROM ps_document WHERE document_num = '2926' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 09:23: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 ( '11' , '2926' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 27/09/2023 09:23: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 = '87431' 27/09/2023 09:23:33 am >> DELETE FROM ps_document_detail WHERE id_document = '87431' 27/09/2023 09:23: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 ( '87431' , '21415' , 'MESSA MEDITAZIONE - NOV/DIC 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 27/09/2023 09:23: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 ( '87431' , '21416' , 'MESSA MEDITAZIONE - SET/OTT 2023' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 27/09/2023 09:31:35 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3382' 27/09/2023 09:31:35 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 ( '3382' , '10' , '208' , '' , 'LIVIGNANI' , 'FIORELLA' , 'VIA ARTENA 48' , '' , '00038' , 'VALMONTONE' , '' , '069597321' , '3471086888' , '' , '' , NOW() , NOW() ) 27/09/2023 09:31:35 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3382' 27/09/2023 09:43:11 am >> SELECT document_num FROM ps_document WHERE document_num = '2927' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 09:43:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2927' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '164.00' , '134.43' , NOW() , NOW() ) 27/09/2023 09:43:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87432' 27/09/2023 09:43:11 am >> DELETE FROM ps_document_detail WHERE id_document = '87432' 27/09/2023 09:43:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87432' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 27/09/2023 09:43:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87432' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' ) 27/09/2023 09:43:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87432' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '26.70' ) 27/09/2023 09:43:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87432' , '21563' , 'AGENDA SAN PAOLO 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/09/2023 09:43:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87432' , '9442' , 'SAN GERARDO MAIELLA - 52' , '1' , '-1' , '1' , '3.80' , '3.1147540983607' , '22' , '0' , '3.80' ) 27/09/2023 09:45:34 am >> SELECT document_num FROM ps_document WHERE document_num = '12/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 09:45:35 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 ( '23' , '12/L' , '2023-09-27' , 'L' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '140.20' , '116.16' , NOW() , NOW() ) 27/09/2023 09:45:35 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 = '87433' 27/09/2023 09:45:35 am >> DELETE FROM ps_document_detail WHERE id_document = '87433' 27/09/2023 09:45:35 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 ( '87433' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '99.00' ) 27/09/2023 09:45:35 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 ( '87433' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '24.50' ) 27/09/2023 09:45:35 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 ( '87433' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 27/09/2023 09:45:35 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 ( '87433' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 27/09/2023 09:45:35 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 ( '87433' , '4287' , 'FRANCESCO SAVERIO - F. OCCHIETTA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 27/09/2023 09:50:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2928' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 09:50:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2928' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '0.82' , NOW() , NOW() ) 27/09/2023 09:50:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87434' 27/09/2023 09:50:15 am >> DELETE FROM ps_document_detail WHERE id_document = '87434' 27/09/2023 09:50:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87434' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 27/09/2023 09:55:51 am >> SELECT document_num FROM ps_document WHERE document_num = '12/L' AND id_document != '87433' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 09:55:51 am >> UPDATE ps_document SET id_document_type = '23', document_num = '12/L', document_date = '2023-09-27', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = 'CAPPELLANIA OSPEDALIERA M. S. SEVERINO', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '140.20', price_tax_excluded = '116.16', date_upd = NOW() WHERE id_document = '87433' 27/09/2023 09:55:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87433' 27/09/2023 09:55:51 am >> DELETE FROM ps_document_detail WHERE id_document = '87433' 27/09/2023 09:55:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87433' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '99.00' ) 27/09/2023 09:55:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87433' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '24.50' ) 27/09/2023 09:55:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87433' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 27/09/2023 09:55:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87433' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 27/09/2023 09:55:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87433' , '4287' , 'FRANCESCO SAVERIO - F. OCCHIETTA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 27/09/2023 09:56:16 am >> SELECT document_num FROM ps_document WHERE document_num = '12/L' AND id_document != '87433' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 09:56:16 am >> UPDATE ps_document SET id_document_type = '23', document_num = '12/L', document_date = '2023-09-27', document_letter = 'L', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = 'CAPPELLANIA OSPEDALIERA M. S. SEVERINO', note = 'CAPPELLANIA OSPEDALIERA M. S. SEVERINO', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '140.20', price_tax_excluded = '116.16', date_upd = NOW() WHERE id_document = '87433' 27/09/2023 09:56:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87433' 27/09/2023 09:56:16 am >> DELETE FROM ps_document_detail WHERE id_document = '87433' 27/09/2023 09:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87433' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.3000' , '2.7049180327869' , '22' , '0' , '99.00' ) 27/09/2023 09:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87433' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '24.50' ) 27/09/2023 09:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87433' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.9000' , '7.2950819672131' , '22' , '0' , '8.90' ) 27/09/2023 09:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87433' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 27/09/2023 09:56:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87433' , '4287' , 'FRANCESCO SAVERIO - F. OCCHIETTA' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '0' , '3.50' ) 27/09/2023 10:12:46 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '112' 27/09/2023 10:12:46 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 ( '112' , '10' , '192' , '' , 'DE PAOLI DON CESARE' , '' , 'P.ZZA SACRO CUORE 1' , '' , '27053' , 'LUNGAVILLA' , '' , '3392493867' , '' , '' , '' , NOW() , NOW() ) 27/09/2023 10:12:46 am >> UPDATE ps_customer SET email = 'c.depaoli@parrocchiadilungavilla.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '112' 27/09/2023 10:13:33 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3229' 27/09/2023 10:13:33 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 ( '3229' , '10' , '208' , '' , 'MEUCCI' , 'ADRIANO MARIA' , 'VIA ATTILIO BENIGNI 32' , '' , '00156' , 'ROMA' , '' , '' , '3292296722' , '' , '' , NOW() , NOW() ) 27/09/2023 10:13:33 am >> UPDATE ps_customer SET email = 'ecolampadio@hotmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3229' 27/09/2023 10:22:15 am >> SELECT document_num FROM ps_document WHERE document_num = '2929' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 10:22:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2929' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '109.55' , '95.79' , NOW() , NOW() ) 27/09/2023 10:22:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87435' 27/09/2023 10:22:15 am >> DELETE FROM ps_document_detail WHERE id_document = '87435' 27/09/2023 10:22:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87435' , '8290' , 'PREGHIERA DEL MATTINO E DELLA SERA - PER LAICI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 27/09/2023 10:22:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87435' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 27/09/2023 10:22:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87435' , '20066' , 'CATENINA IN ACCIAIO - NS055' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 27/09/2023 10:22:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87435' , '3103' , 'CROCE SAN BENEDETTO' , '1' , '-1' , '1' , '1.30' , '1.0655737704918' , '22' , '0' , '1.30' ) 27/09/2023 10:24:35 am >> SELECT document_num FROM ps_document WHERE document_num = '58' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 10:24:35 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '58' , '2023-09-27' , '' , '3229' , '0' , '149355610' , 'VIA ATTILIO BENIGNI 32 00156 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 27/09/2023 10:24:35 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 = '12921' 27/09/2023 10:24:35 am >> DELETE FROM ps_document_detail WHERE id_document = '12921' 27/09/2023 10:24:35 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 ( '12921' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 27/09/2023 10:30:05 am >> SELECT document_num FROM ps_document WHERE document_num = '2930' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 10:30: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' , '2930' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.55' , '8.55' , NOW() , NOW() ) 27/09/2023 10:30: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 = '87436' 27/09/2023 10:30:05 am >> DELETE FROM ps_document_detail WHERE id_document = '87436' 27/09/2023 10:30: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 ( '87436' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 27/09/2023 10:32:42 am >> SELECT document_num FROM ps_document WHERE document_num = '59' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 10:32:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '59' , '2023-09-27' , '' , '3525' , '0' , '4670262' , 'VIA NUOVA EREMITAGGIO 2 80053 CASTELLAMARE DI STABIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '90.00' , '90.00' , NOW() , NOW() ) 27/09/2023 10:32:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12922' 27/09/2023 10:32:42 am >> DELETE FROM ps_document_detail WHERE id_document = '12922' 27/09/2023 10:32:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12922' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '5' , '-5' , '4' , '18.00' , '18' , '0' , '0' , '90.00' ) 27/09/2023 10:33:03 am >> SELECT document_num FROM ps_document WHERE document_num = '58' AND id_document != '12921' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 10:33:03 am >> UPDATE ps_document SET id_document_type = '21', document_num = '58', document_date = '2023-09-27', document_letter = '', id_customer = '3229', id_supplier = '', id_address = '149355610', address1 = 'VIA ATTILIO BENIGNI 32 00156 ROMA', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '12921' 27/09/2023 10:33:03 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12921' 27/09/2023 10:33:03 am >> DELETE FROM ps_document_detail WHERE id_document = '12921' 27/09/2023 10:33:03 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12921' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 27/09/2023 10:44:15 am >> SELECT document_num FROM ps_document WHERE document_num = '60' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 10:44:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '60' , '2023-09-27' , '' , '3379' , '0' , '74680486' , 'VIA SALVATORE LA ROSA 92021 ARAGONA' , '' , 'BONIFICO TESE' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 27/09/2023 10:44:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12923' 27/09/2023 10:44:15 am >> DELETE FROM ps_document_detail WHERE id_document = '12923' 27/09/2023 10:44:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12923' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 27/09/2023 10:45:07 am >> SELECT document_num FROM ps_document WHERE document_num = '61' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 10:45:07 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '61' , '2023-09-27' , '' , '2751' , '0' , '74680488' , 'VIA VITTORIO EMANUELE 92020 CASTROFILIPPO' , '' , 'BONIFICO TESE' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 27/09/2023 10:45:07 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 = '12924' 27/09/2023 10:45:07 am >> DELETE FROM ps_document_detail WHERE id_document = '12924' 27/09/2023 10:45:07 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 ( '12924' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 27/09/2023 10:48:51 am >> SELECT document_num FROM ps_document WHERE document_num = '62' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 10:48:51 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '62' , '2023-09-27' , '' , '3455' , '0' , '4670109' , 'PIAZZA DELLA CHIESA 2 28886 PIEVE VERGONTE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 27/09/2023 10:48:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12925' 27/09/2023 10:48:51 am >> DELETE FROM ps_document_detail WHERE id_document = '12925' 27/09/2023 10:48:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12925' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 27/09/2023 10:58:30 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1429' 27/09/2023 10:58:30 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 ( '1429' , '10' , '183' , '' , 'CASTALDI ' , 'DON GIOACCHINO' , 'VIA CASA POLITO 3' , '' , '80075' , 'PANZA DI ISCHIA' , '' , '3395303421' , '' , '' , '' , NOW() , NOW() ) 27/09/2023 10:58:30 am >> UPDATE ps_customer SET email = 'dongioacchino@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1429' 27/09/2023 11:00:39 am >> SELECT document_num FROM ps_document WHERE document_num = '63' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 11:00:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '63' , '2023-09-27' , '' , '1429' , '0' , '149355611' , 'VIA CASA POLITO 3 80075 PANZA DI ISCHIA' , '' , '' , '4' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '40.00' , '40.00' , NOW() , NOW() ) 27/09/2023 11:00:39 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12926' 27/09/2023 11:00:39 am >> DELETE FROM ps_document_detail WHERE id_document = '12926' 27/09/2023 11:00:39 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12926' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '0' , '36.00' ) 27/09/2023 11:12:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2931' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 11:12:24 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2931' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.90' , '34.34' , NOW() , NOW() ) 27/09/2023 11:12:24 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87437' 27/09/2023 11:12:24 am >> DELETE FROM ps_document_detail WHERE id_document = '87437' 27/09/2023 11:12:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87437' , '16494' , 'CLERGY JEANSATA ML MISTO - C01/J' , '1' , '-1' , '1' , '41.90' , '34.344262295082' , '22' , '0' , '41.90' ) 27/09/2023 11:17:10 am >> SELECT document_num FROM ps_document WHERE document_num = '64' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 11:17:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '64' , '2023-09-27' , '' , '3451' , '0' , '4670177' , 'VIA CRESPI, 42 28100 NOVARA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '36.00' , '36.00' , NOW() , NOW() ) 27/09/2023 11:17:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12927' 27/09/2023 11:17:11 am >> DELETE FROM ps_document_detail WHERE id_document = '12927' 27/09/2023 11:17:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12927' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '0' , '36.00' ) 27/09/2023 11:28:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2932' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 11:28:02 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' , '2932' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.80' , '38.91' , NOW() , NOW() ) 27/09/2023 11:28:02 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 = '87438' 27/09/2023 11:28:02 am >> DELETE FROM ps_document_detail WHERE id_document = '87438' 27/09/2023 11:28:02 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 ( '87438' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 27/09/2023 11:28:02 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 ( '87438' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 27/09/2023 11:28:02 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 ( '87438' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 27/09/2023 11:55:40 am >> SELECT document_num FROM ps_document WHERE document_num = '65' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 11:55:40 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '65' , '2023-09-27' , '' , '3433' , '0' , '4670247' , 'P.ZZA MATTEOTTI 18 06038 SPELLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '102.60' , '102.60' , NOW() , NOW() ) 27/09/2023 11:55: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 = '12928' 27/09/2023 11:55:40 am >> DELETE FROM ps_document_detail WHERE id_document = '12928' 27/09/2023 11:55: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 ( '12928' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '6' , '-6' , '4' , '18.00' , '18' , '0' , '5' , '102.60' ) 27/09/2023 11:58:24 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '935' 27/09/2023 11:58:24 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 ( '935' , '10' , '171' , 'PARR. S. MARIA ASSUNTA' , 'CAVALLO ' , 'DON EMANUELE' , 'VIA SOPRANA 11' , '' , '57031' , 'CAPOLIVERI-IS.ELBA' , '' , '0565968554' , '' , '' , '' , NOW() , NOW() ) 27/09/2023 11:58:24 am >> UPDATE ps_customer SET email = 'parrocchiamariassunta@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '935' 27/09/2023 12:16:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '66' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 12:16:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '66' , '2023-09-27' , '' , '3529' , '0' , '4670266' , 'VIA MICHELE ROSI 186 - ARA NOVA 00054 FIUMICINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 27/09/2023 12:16: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 = '12929' 27/09/2023 12:16:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '12929' 27/09/2023 12: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 ( '12929' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 27/09/2023 12:24:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2933' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 12:24:33 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' , '2933' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.00' , '22.95' , NOW() , NOW() ) 27/09/2023 12:24:33 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 = '87439' 27/09/2023 12:24:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '87439' 27/09/2023 12:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87439' , '20837' , 'BRUCIA INCENSO CM 11' , '1' , '-1' , '1' , '24.1' , '19.754098360656' , '22' , '0' , '24.10' ) 27/09/2023 12:24:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87439' , '10475' , 'TEALIGHTS X 50 ' , '1' , '-1' , '1' , '3.90' , '3.1967213114754' , '22' , '0' , '3.90' ) 27/09/2023 12:46:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2631' , '2023-09-25' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '306.25' , '306.25' , NOW() , NOW() ) 27/09/2023 12:46:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87440' 27/09/2023 12:46:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '87440' 27/09/2023 12:46:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '21507' , 'LITURGIA DELLE ORE VOL. I N.E.' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 27/09/2023 12:46:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21507' AND id_supplier = '79' 27/09/2023 12:46:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21507' , '79' , '1' ) 27/09/2023 12:46:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '2' , '2' , '4' , '35.00' , '35' , '0' , '30' , '49.0000' ) 27/09/2023 12:46:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21508' AND id_supplier = '79' 27/09/2023 12:46:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21508' , '79' , '1' ) 27/09/2023 12:46:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 27/09/2023 12:46:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21509' AND id_supplier = '79' 27/09/2023 12:46:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21509' , '79' , '1' ) 27/09/2023 12:46:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '1' , '4' , '15.00' , '15' , '0' , '45' , '8.2500' ) 27/09/2023 12:46:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21512' AND id_supplier = '79' 27/09/2023 12:46:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21512' , '79' , '1' ) 27/09/2023 12:46:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87440' , '17329' , 'MESSALE ROMANO D\'ALTARE N.E' , '1' , '1' , '4' , '110.00' , '110' , '0' , '30' , '77.0000' ) 27/09/2023 12:46:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 27/09/2023 12:46:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 27/09/2023 12:46: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 ( '87440' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO A' , '1' , '1' , '4' , '60.00' , '60' , '0' , '30' , '42.0000' ) 27/09/2023 12:46:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5759' AND id_supplier = '79' 27/09/2023 12:46:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5759' , '79' , '1' ) 27/09/2023 12:46: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 ( '87440' , '18956' , 'LEZIONARIO DOMENICALE E FESTIVO ANNO B' , '1' , '1' , '4' , '60.00' , '60' , '0' , '30' , '42.0000' ) 27/09/2023 12:46:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18956' AND id_supplier = '79' 27/09/2023 12:46:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18956' , '79' , '1' ) 27/09/2023 12:46: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 ( '87440' , '20798' , 'LEZIONARIO FESTIVO ANNO C' , '1' , '1' , '4' , '60.00' , '60' , '0' , '35' , '39.0000' ) 27/09/2023 12:46:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20798' AND id_supplier = '79' 27/09/2023 12:46:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20798' , '79' , '1' ) 27/09/2023 12:51:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2934' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 12:51:28 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2934' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 27/09/2023 12:51:28 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87441' 27/09/2023 12:51:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '87441' 27/09/2023 12:51:28 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87441' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 27/09/2023 03:32:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '67' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 03:32:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '67' , '2023-09-27' , '' , '3382' , '0' , '149355608' , 'VIA ARTENA 48 00038 VALMONTONE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '20.00' , '20.00' , NOW() , NOW() ) 27/09/2023 03:32:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12930' 27/09/2023 03:32:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '12930' 27/09/2023 03:32:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12930' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 27/09/2023 03:32:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12930' , '' , 'contrassegno' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 27/09/2023 03:58:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2935' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 03:58: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' , '2935' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.90' , '27.10' , NOW() , NOW() ) 27/09/2023 03:58: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 = '87442' 27/09/2023 03:58:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '87442' 27/09/2023 03:58: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 ( '87442' , '21409' , 'SUBLIMITAS ET MISERIA HOMINIS' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 27/09/2023 03:58: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 ( '87442' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 27/09/2023 03:58:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87442' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 27/09/2023 04:19:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2936' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 04:19:41 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' , '2936' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '81.70' , '70.09' , NOW() , NOW() ) 27/09/2023 04:19:41 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 = '87443' 27/09/2023 04:19:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '87443' 27/09/2023 04:19:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87443' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 27/09/2023 04:19:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87443' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '3' , '-3' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '3.30' ) 27/09/2023 04:19:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87443' , '16689' , 'OSTIA PAN DI CENA mm80' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 27/09/2023 04:19:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87443' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 27/09/2023 04:57:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '68' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 04:57: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 ( '21' , '68' , '2023-09-27' , '' , '3368' , '0' , '4669974' , 'VIA BELVEDERE 92010 REALMONTE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '37.10' , '37.10' , NOW() , NOW() ) 27/09/2023 04:57: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 = '12931' 27/09/2023 04:57:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '12931' 27/09/2023 04:57: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 ( '12931' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '5' , '34.20' ) 27/09/2023 04:57: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 ( '12931' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 27/09/2023 05:30:49 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/09/2023 05:30:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '136' , '1' , '' , 'nuovo-prodotto' ) 27/09/2023 05:30:49 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '136' , '1' , '1' , '2' , NOW() , NOW() ) 27/09/2023 05:30:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '136' , '0' , '1' , '0' , '0' ) 27/09/2023 05:31:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571535' AND id_product != '136' AND ean13 != '' 27/09/2023 05:31:33 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788899571535', date_upd = NOW() WHERE id_product = '136' 27/09/2023 05:31:33 pm >> UPDATE ps_product_lang SET name = 'ANGELO DI DIO N.E.', description = '' WHERE id_product = '136' 27/09/2023 05:31:33 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.8' WHERE id_product = '136' 27/09/2023 05:31:33 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.8', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '449', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '136' 27/09/2023 05:31:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '136' 27/09/2023 05:31:59 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 27/09/2023 05:31:59 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '137' , '1' , '' , 'nuovo-prodotto' ) 27/09/2023 05:31:59 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '137' , '1' , '1' , '2' , NOW() , NOW() ) 27/09/2023 05:31:59 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '137' , '0' , '1' , '0' , '0' ) 27/09/2023 05:32:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571535' AND id_product != '136' AND ean13 != '' 27/09/2023 05:32:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788899571535', date_upd = NOW() WHERE id_product = '136' 27/09/2023 05:32:47 pm >> UPDATE ps_product_lang SET name = 'ANGELO DI DIO N.E.', description = '' WHERE id_product = '136' 27/09/2023 05:32:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.80' WHERE id_product = '136' 27/09/2023 05:32:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.80', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '449', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '136' 27/09/2023 05:32:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '136' 27/09/2023 05:32:48 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '136' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/09/2023 05:34:01 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '444/23' , '2023-09-27' , '23' , '0' , '129' , '74680480' , 'STRADA STATALE 7/bis 45-47 83030 MANOCALZATI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '322.40' , '310.00' , NOW() , NOW() ) 27/09/2023 05:34:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '12932' 27/09/2023 05:34:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '12932' 27/09/2023 05:34:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '12932' , '136' , 'ANGELO DI DIO N.E.' , '2000' , '2000' , '3' , '0.155' , '0.14903846153846' , '4' , '0' , '322.4000' ) 27/09/2023 05:34:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '136' AND id_supplier = '129' 27/09/2023 05:34:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '136' , '129' , '1' ) 27/09/2023 06:09:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '2763' AND id_document != '87223' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-07') 27/09/2023 06:09:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2763', document_date = '2023-09-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 = '22.00', price_tax_excluded = '19.30', date_upd = NOW() WHERE id_document = '87223' 27/09/2023 06:09: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 = '87223' 27/09/2023 06:09:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '87223' 27/09/2023 06:09: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 ( '87223' , '15097' , 'CORONA MATRIMONIO - ORO' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 27/09/2023 06:09: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 ( '87223' , '21600' , 'nuova agenda del cittadino' , '1' , '-1' , '4' , '7' , '7' , '0' , '0' , '7.00' ) 27/09/2023 06:10:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2746' AND id_document != '87199' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-05') 27/09/2023 06:10:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2746', document_date = '2023-09-05', 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 = '29.90', price_tax_excluded = '29.90', date_upd = NOW() WHERE id_document = '87199' 27/09/2023 06:10: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 = '87199' 27/09/2023 06:10:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '87199' 27/09/2023 06:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87199' , '5457' , 'IO SONO CON VOI 1 PARTE' , '2' , '-2' , '4' , '2.36' , '2.36' , '0' , '0' , '4.72' ) 27/09/2023 06:10:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87199' , '21601' , 'mindset 1' , '1' , '-1' , '4' , '26.50' , '26.5' , '0' , '5' , '25.18' ) 27/09/2023 06:11:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 27/09/2023 06:11:32 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '100.60', price_tax_excluded = '100.60', date_upd = NOW() WHERE id_document = '81317' 27/09/2023 06:11:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81317' 27/09/2023 06:11:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 27/09/2023 06:11: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 ( '81317' , '21293' , 'GRIDO DELLA PACE - A. RICCARDI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 27/09/2023 06:11: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 ( '81317' , '21345' , 'buio oltre la siepe - h. lee' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 27/09/2023 06:11: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 ( '81317' , '21433' , 'PAROLA E PREGHIERA - OTT 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 27/09/2023 06:11: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 ( '81317' , '21495' , 'AMARE ED ESSERE AMATI - J. TOWEY' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 27/09/2023 06:11: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 ( '81317' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '0' , '15.00' ) 27/09/2023 06:11:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21539' , 'PAROLA E PREGHIERA - NOV. 23' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 27/09/2023 06:11:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 27/09/2023 06:11:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21538' , 'AMEN - NOV. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 27/09/2023 06:11:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21537' , 'AMEN - DIC. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 27/09/2023 06:11:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '21575' , 'CONDIVIDERE LA PAROLA - ANNO B - U. DE VANNA' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 27/09/2023 06:11:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '22/A' AND id_document != '81317' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-02-10') 27/09/2023 06:11:54 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '22/A', document_date = '2023-02-10', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '81317' 27/09/2023 06:11: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 = '81317' 27/09/2023 06:11:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '81317' 27/09/2023 06:11:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81317' , '3612' , 'DOLOROSA PASSIONE DI N.S. GESÙ CRISTO - 8319' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 27/09/2023 06:12:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '2662' AND id_document != '87102' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-30') 27/09/2023 06:12:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2662', document_date = '2023-08-30', 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 = '34.00', price_tax_excluded = '29.67', date_upd = NOW() WHERE id_document = '87102' 27/09/2023 06:12:41 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 = '87102' 27/09/2023 06:12:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '87102' 27/09/2023 06:12:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87102' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '24.00' ) 27/09/2023 06:12:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87102' , '21345' , 'buio oltre la siepe - h. lee' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 27/09/2023 06:14:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2713' AND id_document != '87159' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-01') 27/09/2023 06:14:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2713', document_date = '2023-09-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 = '48.00', price_tax_excluded = '43.31', date_upd = NOW() WHERE id_document = '87159' 27/09/2023 06:14: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 = '87159' 27/09/2023 06:14:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '87159' 27/09/2023 06:14: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 ( '87159' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 27/09/2023 06:14: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 ( '87159' , '21539' , 'PAROLA E PREGHIERA - NOV. 23' , '1' , '-1' , '4' , '2.95' , '2.95' , '0' , '0' , '2.95' ) 27/09/2023 06:14: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 ( '87159' , '17005' , 'BIGLIETTO AUGURALE medio' , '4' , '-4' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '4.00' ) 27/09/2023 06:14: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 ( '87159' , '21338' , 'DIO DI ABRAMO - A. MELLO' , '1' , '-1' , '4' , '17.0000' , '17' , '0' , '5' , '16.15' ) 27/09/2023 06:14: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 ( '87159' , '6053' , 'MADONNA DEL CARMELO - CM 13 - 023 CAR/13' , '1' , '-1' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '9.00' ) 27/09/2023 06:14: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 ( '87159' , '21433' , 'PAROLA E PREGHIERA - OTT 23' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 27/09/2023 06:15:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2771' AND id_document != '87232' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-08') 27/09/2023 06:15:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2771', document_date = '2023-09-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 = '3.50', price_tax_excluded = '3.50', date_upd = NOW() WHERE id_document = '87232' 27/09/2023 06:15:33 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 = '87232' 27/09/2023 06:15:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '87232' 27/09/2023 06:15:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87232' , '21538' , 'AMEN - NOV. 23' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 27/09/2023 06:16:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '2753' AND id_document != '87207' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-06') 27/09/2023 06:16:10 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2753', document_date = '2023-09-06', 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 = '13.50', price_tax_excluded = '13.50', date_upd = NOW() WHERE id_document = '87207' 27/09/2023 06:16:10 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87207' 27/09/2023 06:16:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '87207' 27/09/2023 06:16: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 ( '87207' , '21512' , 'VANGELO DI OGNI DOMENICA - MARCO - PAPA FRANCESCO' , '1' , '-1' , '4' , '13.5' , '13.5' , '0' , '0' , '13.50' ) 27/09/2023 06:16:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2723' AND id_document != '87172' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-04') 27/09/2023 06:16:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2723', document_date = '2023-09-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '114.38', price_tax_excluded = '113.21', date_upd = NOW() WHERE id_document = '87172' 27/09/2023 06:16:41 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 = '87172' 27/09/2023 06:16:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '87172' 27/09/2023 06:16:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87172' , '21293' , 'GRIDO DELLA PACE - A. RICCARDI' , '1' , '-1' , '4' , '15.75' , '15.75' , '0' , '0' , '15.75' ) 27/09/2023 06:16:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87172' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 27/09/2023 06:16:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87172' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 27/09/2023 06:16:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87172' , '21196' , 'CALENDARIO LITURGICO 2024' , '4' , '-4' , '4' , '0.5000' , '0.5' , '0' , '0' , '2.00' ) 27/09/2023 06:16:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87172' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '2' , '-2' , '4' , '1.0000' , '1' , '0' , '0' , '2.00' ) 27/09/2023 06:16:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87172' , '816' , 'ATTI DEGLI APOSTOLI' , '1' , '-1' , '4' , '8.5000' , '8.5' , '0' , '5' , '8.08' ) 27/09/2023 06:16:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87172' , '21136' , 'REGOLA DI BENEDETTO - J. CHITTISTER' , '1' , '-1' , '4' , '24.0000' , '24' , '0' , '5' , '22.80' ) 27/09/2023 06:16:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87172' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 27/09/2023 06:19:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2796' AND id_document != '87262' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-12') 27/09/2023 06:19:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2796', document_date = '2023-09-12', 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 = '40.00', price_tax_excluded = '40.00', date_upd = NOW() WHERE id_document = '87262' 27/09/2023 06:19:14 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87262' 27/09/2023 06:19:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '87262' 27/09/2023 06:19: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 ( '87262' , '21398' , 'ARCA DI NOE - CREA E GIOCA' , '1' , '-1' , '4' , '10.5000' , '10.5' , '0' , '0' , '10.50' ) 27/09/2023 06:19: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 ( '87262' , '21495' , 'AMARE ED ESSERE AMATI - J. TOWEY' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 27/09/2023 06:19: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 ( '87262' , '21519' , 'SULLA TUA PAROLA - NOV/DIC 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/09/2023 06:19: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 ( '87262' , '21537' , 'AMEN - DIC. 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 27/09/2023 06:19: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 ( '87262' , '5458' , 'IO SONO CON VOI 2 PARTE' , '2' , '-2' , '4' , '1.97' , '1.97' , '0' , '0' , '3.94' ) 27/09/2023 06:19:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '2860' AND id_document != '87344' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-19') 27/09/2023 06:19:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2860', document_date = '2023-09-19', 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 = '14.50', price_tax_excluded = '14.50', date_upd = NOW() WHERE id_document = '87344' 27/09/2023 06:19:48 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 = '87344' 27/09/2023 06:19:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '87344' 27/09/2023 06:19:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87344' , '21575' , 'CONDIVIDERE LA PAROLA - ANNO B - U. DE VANNA' , '1' , '-1' , '4' , '14.5' , '14.5' , '0' , '0' , '14.50' ) 27/09/2023 07:09:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2937' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-27') 27/09/2023 07:09:49 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2937' , '2023-09-27' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 27/09/2023 07:09:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87444' 27/09/2023 07:09:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '87444' 27/09/2023 07:09:49 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87444' , '8318' , 'PREGHIERA SEMPLICE' , '5' , '-5' , '4' , '0.20' , '0.2' , '0' , '0' , '1.00' ) 27/09/2023 07:45:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2801' AND id_document != '87268' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-09-12') 27/09/2023 07:45:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2801', document_date = '2023-09-12', 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 = '37.90', price_tax_excluded = '31.07', date_upd = NOW() WHERE id_document = '87268' 27/09/2023 07:45:27 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 = '87268' 27/09/2023 07:45:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '87268' 27/09/2023 07:45:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87268' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '3' , '-3' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '9.90' ) 27/09/2023 07:45:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87268' , '19015' , 'BRACCIALI MULTICOLOR CON DECINA' , '2' , '-2' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '8.00' ) 27/09/2023 07:45:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87268' , '20507' , 'CONFEZIONE SCATOLA PORTA CIUCCIO - CEL' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' )