06/11/2025 08:38:48 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'GzqkXC2XrS6mzfrI' , NOW() , NOW() ) 06/11/2025 08:38:48 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4276' , '1' ) 06/11/2025 08:38:48 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4276' , '2' ) 06/11/2025 08:38:48 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4276' , '3' ) 06/11/2025 08:40:05 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4276' 06/11/2025 08:40:05 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 ( '4276' , '10' , '210' , 'PARR. S. MARIA ASSUNTA' , 'MANSI' , 'DON ANGELO ' , 'P. ZZA DUOMO 1' , '' , '84010' , 'RAVELLO' , '' , '' , '3667013670' , '' , '' , NOW() , NOW() ) 06/11/2025 08:40:05 am >> UPDATE ps_customer SET email = 'donangelo2019@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4276' 06/11/2025 08:41:33 am >> SELECT document_num FROM ps_document WHERE document_num = '198' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 08:41: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 ( '21' , '198' , '2025-11-06' , '' , '4276' , '0' , '4679623' , 'P. ZZA DUOMO 1 84010 RAVELLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '72.20' , '72.20' , NOW() , NOW() ) 06/11/2025 08:41: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 = '99713' 06/11/2025 08:41:33 am >> DELETE FROM ps_document_detail WHERE id_document = '99713' 06/11/2025 08:41: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 ( '99713' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '5' , '57.00' ) 06/11/2025 08:41: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 ( '99713' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 06/11/2025 09:03:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3662' AND id_document != '99705' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-05') 06/11/2025 09:03:36 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3662', document_date = '2025-11-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 = '7.90', price_tax_excluded = '6.48', date_upd = NOW() WHERE id_document = '99705' 06/11/2025 09:03:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99705' 06/11/2025 09:03:36 am >> DELETE FROM ps_document_detail WHERE id_document = '99705' 06/11/2025 09:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99705' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.9' , '6.4754098360656' , '22' , '0' , '7.90' ) 06/11/2025 09:47:08 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2755' 06/11/2025 09:47:08 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 ( '2755' , '10' , '168' , '' , 'ALICANDRO' , 'FERNANDA ' , 'VIA APPIA' , '' , '04026' , 'MINTURNO' , '' , '' , '3711617041' , '' , '' , NOW() , NOW() ) 06/11/2025 09:47:08 am >> UPDATE ps_customer SET email = 'FERNANDA.ALICANDRO@POSTEITALIANE.IT', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2755' 06/11/2025 09:47:16 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2755' 06/11/2025 09:47:16 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 ( '2755' , '10' , '168' , '' , 'ALICANDRO' , 'FERNANDA ' , 'VIA APPIA 1425' , '' , '04026' , 'MINTURNO' , '' , '' , '3711617041' , '' , '' , NOW() , NOW() ) 06/11/2025 09:47:16 am >> UPDATE ps_customer SET email = 'FERNANDA.ALICANDRO@POSTEITALIANE.IT', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2755' 06/11/2025 09:47:23 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2755' 06/11/2025 09:47:23 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 ( '2755' , '10' , '168' , '' , 'ALICANDRO' , 'FERNANDA ' , 'VIA APPIA 1425' , '' , '04026' , 'MINTURNO' , '' , '' , '3711617041' , '' , '' , NOW() , NOW() ) 06/11/2025 09:47:23 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2755' 06/11/2025 09:53:57 am >> SELECT document_num FROM ps_document WHERE document_num = '199' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 09:53:57 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' , '199' , '2025-11-06' , '' , '2755' , '0' , '4679626' , 'VIA APPIA 1425 04026 MINTURNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '76.70' , '76.70' , NOW() , NOW() ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99714' 06/11/2025 09:53:57 am >> DELETE FROM ps_document_detail WHERE id_document = '99714' 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '7968' , 'PIACERE DIO! 1 QUADERNO - A. PEIRETTI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '7967' , 'PIACERE DIO! 1 GUIDA - PEIRETTI/FERRERO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '23917' , 'CE SPAZIO PER TE 2026 - 6-8 ANNI' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '5' , '15.68' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '24181' , 'DIO HA TANTO AMATO IL MONDO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '24201' , 'PORTA IL DONO' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '5' , '2.66' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '24200' , 'AVVENTURE SPAZIALI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '24182' , 'ANDIAMO INCONTRO A GESU' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '21739' , 'PADRE NOSTRO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 06/11/2025 09:53:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99714' , '16856' , 'PADRE NOSTRO' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '5' , '4.66' ) 06/11/2025 09:54:35 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1235' 06/11/2025 09:54: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 ( '1235' , '10' , '210' , 'PARR. SAN MARCO A ROTA' , '' , '' , 'P. ZZA SAN MARCO - CURTERI' , '' , '84085' , 'MERCATO S. SEVERINO' , '' , '' , '' , '' , '95006090658' , NOW() , NOW() ) 06/11/2025 09:54:35 am >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1235' 06/11/2025 09:55:34 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2912' 06/11/2025 09:55:34 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 ( '2912' , '10' , '210' , 'PARROCCHIA S. MARIA DELLE GRAZIE' , 'DE CRISTOFARO' , 'DON RAFFAELE ' , 'P. ZZA CARMINE PASTORE 10' , '' , '84080' , 'CAPRIGLIA - PELLEZZANO' , '' , '' , '3245508040' , '' , '95019720655' , NOW() , NOW() ) 06/11/2025 09:55:34 am >> UPDATE ps_customer SET email = 'decristofaro.r@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2912' 06/11/2025 10:00:02 am >> SELECT document_num FROM ps_document WHERE document_num = '200' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:00: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 ( '21' , '200' , '2025-11-06' , '' , '2912' , '0' , '4679628' , 'P. ZZA CARMINE PASTORE 10 84080 CAPRIGLIA - PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '86.53' , '86.53' , NOW() , NOW() ) 06/11/2025 10:00: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 = '99715' 06/11/2025 10:00:02 am >> DELETE FROM ps_document_detail WHERE id_document = '99715' 06/11/2025 10:00: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 ( '99715' , '2679' , 'CONOSCERE GESU\'' , '8' , '-8' , '4' , '3.50' , '3.5' , '0' , '15' , '23.80' ) 06/11/2025 10:00: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 ( '99715' , '12813' , 'MARIA MADRE NOSTRA' , '7' , '-7' , '4' , '3.00' , '3' , '0' , '15' , '17.85' ) 06/11/2025 10:00: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 ( '99715' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '15' , '25.50' ) 06/11/2025 10:00: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 ( '99715' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '2' , '-2' , '4' , '2.40' , '2.4' , '0' , '15' , '4.08' ) 06/11/2025 10:00: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 ( '99715' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '6' , '-6' , '4' , '3.00' , '3' , '0' , '15' , '15.30' ) 06/11/2025 10:02:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3668' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:02:29 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' , '3668' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 06/11/2025 10:02:29 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 = '99716' 06/11/2025 10:02:29 am >> DELETE FROM ps_document_detail WHERE id_document = '99716' 06/11/2025 10:02:29 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 ( '99716' , '12819' , 'REGISTRO DEL CATECHISTA ' , '5' , '-5' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '5.00' ) 06/11/2025 10:02:29 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 ( '99716' , '7920' , 'PERGAMENE - ANNIVERSARIO MATRIM. MOD. A' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 06/11/2025 10:07:54 am >> SELECT document_num FROM ps_document WHERE document_num = '199' AND id_document != '99714' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:07:54 am >> UPDATE ps_document SET id_document_type = '21', document_num = '199', document_date = '2025-11-06', document_letter = '', id_customer = '2755', id_supplier = '', id_address = '4679626', address1 = 'VIA APPIA 1425 04026 MINTURNO', 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 = '90.95', price_tax_excluded = '90.95', date_upd = NOW() WHERE id_document = '99714' 06/11/2025 10:07:54 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 = '99714' 06/11/2025 10:07:54 am >> DELETE FROM ps_document_detail WHERE id_document = '99714' 06/11/2025 10:07:54 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 ( '99714' , '21484' , 'MIA IMPRONTA NELLA TUA - GUIDA 1 - N.E.' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 06/11/2025 10:07:54 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 ( '99714' , '21436' , 'MIA IMPRONTA NELLA TUA - CALENDALBUM 1 - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 06/11/2025 10:07:54 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 ( '99714' , '7968' , 'PIACERE DIO! 1 QUADERNO - A. PEIRETTI' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 06/11/2025 10:07:54 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 ( '99714' , '7967' , 'PIACERE DIO! 1 GUIDA - PEIRETTI/FERRERO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 06/11/2025 10:07:54 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 ( '99714' , '23467' , 'VIA CRUCIS CAMMINO DI REDENZIONE - R. LUPI' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 06/11/2025 10:07:54 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 ( '99714' , '23917' , 'CE SPAZIO PER TE 2026 - 6-8 ANNI' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '5' , '15.68' ) 06/11/2025 10:07:54 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 ( '99714' , '24181' , 'DIO HA TANTO AMATO IL MONDO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 06/11/2025 10:07:54 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 ( '99714' , '24201' , 'PORTA IL DONO' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 06/11/2025 10:07:54 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 ( '99714' , '24200' , 'AVVENTURE SPAZIALI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 06/11/2025 10:07:55 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 ( '99714' , '24182' , 'ANDIAMO INCONTRO A GESU' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 06/11/2025 10:07:55 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 ( '99714' , '18049' , 'PADRE NOSTRO SPIEGATO AI BAMBINI' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 06/11/2025 10:07:55 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 ( '99714' , '21739' , 'PADRE NOSTRO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 06/11/2025 10:07:55 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 ( '99714' , '16856' , 'PADRE NOSTRO' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 06/11/2025 10:07:55 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 ( '99714' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 06/11/2025 10:09:12 am >> SELECT document_num FROM ps_document WHERE document_num = '200' AND id_document != '99715' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:09:12 am >> UPDATE ps_document SET id_document_type = '21', document_num = '200', document_date = '2025-11-06', document_letter = '', id_customer = '2912', id_supplier = '', id_address = '4679628', address1 = 'P. ZZA CARMINE PASTORE 10 84080 CAPRIGLIA - PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '86.50', price_tax_excluded = '86.50', date_upd = NOW() WHERE id_document = '99715' 06/11/2025 10:09:12 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 = '99715' 06/11/2025 10:09:12 am >> DELETE FROM ps_document_detail WHERE id_document = '99715' 06/11/2025 10:09:12 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 ( '99715' , '2679' , 'CONOSCERE GESU\'' , '8' , '-8' , '4' , '3.5000' , '3.5' , '0' , '15' , '23.80' ) 06/11/2025 10:09:12 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 ( '99715' , '12813' , 'MARIA MADRE NOSTRA' , '7' , '-7' , '4' , '3.0000' , '3' , '0' , '15' , '17.85' ) 06/11/2025 10:09:12 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 ( '99715' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '10' , '-10' , '4' , '3.0000' , '3' , '0' , '15' , '25.50' ) 06/11/2025 10:09:12 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 ( '99715' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '2' , '-2' , '4' , '2.4000' , '2.4' , '0' , '15' , '4.08' ) 06/11/2025 10:09:12 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 ( '99715' , '16199' , 'DIO E IN DIECI PAROLE - COMANDAMENTI' , '6' , '-6' , '4' , '3.0000' , '3' , '0' , '15' , '15.30' ) 06/11/2025 10:09:12 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 ( '99715' , '' , 'arrotondamento' , '1' , '-1' , '0' , '-0.03' , '-0.03' , '' , '0' , '-0.03' ) 06/11/2025 10:12:04 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2755' 06/11/2025 10:12:04 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 ( '2755' , '10' , '168' , '' , 'ALICANDRO' , 'FERNANDA ' , 'VIA APPIA 1425' , '' , '04026' , 'MINTURNO' , '' , '' , '3711617041' , '' , '' , NOW() , NOW() ) 06/11/2025 10:12:04 am >> UPDATE ps_customer SET email = 'fernanda.alicandro@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '2755' 06/11/2025 10:48:44 am >> SELECT document_num FROM ps_document WHERE document_num = '201' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:48:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '201' , '2025-11-06' , '' , '3984' , '0' , '4679386' , 'VIA M. ALETTA 1 84030 MONTE S. GIACOMO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '242.25' , '242.25' , NOW() , NOW() ) 06/11/2025 10:48:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99717' 06/11/2025 10:48:44 am >> DELETE FROM ps_document_detail WHERE id_document = '99717' 06/11/2025 10:48:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99717' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '25' , '-25' , '4' , '3.80' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 10:48:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99717' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '25' , '-25' , '4' , '3.80' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 10:48:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99717' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.80' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 10:49:26 am >> SELECT document_num FROM ps_document WHERE document_num = '202' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:49:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '202' , '2025-11-06' , '' , '3191' , '0' , '4679345' , 'VIA QUINTINO DI VONA 84133 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '15' , '0' , '50.15' , '50.15' , NOW() , NOW() ) 06/11/2025 10:49:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99718' 06/11/2025 10:49:26 am >> DELETE FROM ps_document_detail WHERE id_document = '99718' 06/11/2025 10:49:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99718' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 06/11/2025 10:49:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99718' , '8408' , 'PRENDETE E MANGIATE' , '18' , '-18' , '4' , '3.00' , '3' , '0' , '15' , '45.90' ) 06/11/2025 10:51:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3669' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:51:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3669' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '88.35' , '88.35' , NOW() , NOW() ) 06/11/2025 10:51:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99719' 06/11/2025 10:51:06 am >> DELETE FROM ps_document_detail WHERE id_document = '99719' 06/11/2025 10:51:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99719' , '8598' , 'IO SONO CON VOI 1 - MAGNIFICAT' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '5' , '57.00' ) 06/11/2025 10:51:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99719' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '11' , '-11' , '4' , '3.00' , '3' , '0' , '5' , '31.35' ) 06/11/2025 10:52:25 am >> SELECT document_num FROM ps_document WHERE document_num = '3670' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:52:25 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' , '3670' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '102.72' , '93.52' , NOW() , NOW() ) 06/11/2025 10:52:25 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 = '99720' 06/11/2025 10:52:25 am >> DELETE FROM ps_document_detail WHERE id_document = '99720' 06/11/2025 10:52:25 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 ( '99720' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 06/11/2025 10:52:25 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 ( '99720' , '6629' , 'MIA PREGHIERA' , '5' , '-5' , '4' , '0.90' , '0.9' , '0' , '0' , '4.50' ) 06/11/2025 10:52:25 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 ( '99720' , '22107' , 'SIGNORE INSEGNACI A PREGARE - F. SHEEN' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 06/11/2025 10:52:25 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 ( '99720' , '23508' , 'CON TE SULLALTARE' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 06/11/2025 10:52:25 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 ( '99720' , '24176' , 'VANGELO SECONDO GIOVANNI ' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 06/11/2025 10:52:25 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 ( '99720' , '24096' , 'AVVENTO E NATALE 2025/26' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 06/11/2025 10:52:25 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 ( '99720' , '23997' , 'E NATO PER NOI UN SALVATORE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 06/11/2025 10:54:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3671' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:54:46 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3671' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '417.00' , '341.80' , NOW() , NOW() ) 06/11/2025 10:54:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99721' 06/11/2025 10:54:46 am >> DELETE FROM ps_document_detail WHERE id_document = '99721' 06/11/2025 10:54:46 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 ( '99721' , '21932' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148' , '2' , '-2' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '70.00' ) 06/11/2025 10:54:46 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 ( '99721' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '100.00' ) 06/11/2025 10:54:46 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 ( '99721' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '2' , '-2' , '1' , '13.50' , '11.065573770492' , '22' , '0' , '27.00' ) 06/11/2025 10:54:46 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 ( '99721' , '16767' , 'COPPIA CANDELIERI DA PROCESSIONE - 2591' , '1' , '-1' , '1' , '220.00' , '180.32786885246' , '22' , '0' , '220.00' ) 06/11/2025 10:57:23 am >> SELECT document_num FROM ps_document WHERE document_num = '3671' AND id_document != '99721' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:57:23 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3671', document_date = '2025-11-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 = '417.00', price_tax_excluded = '341.80', date_upd = NOW() WHERE id_document = '99721' 06/11/2025 10:57:23 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 = '99721' 06/11/2025 10:57:24 am >> DELETE FROM ps_document_detail WHERE id_document = '99721' 06/11/2025 10:57: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 ( '99721' , '21932' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148' , '2' , '-2' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '70.00' ) 06/11/2025 10:57: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 ( '99721' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '50.0000' , '40.983606557377' , '22' , '0' , '100.00' ) 06/11/2025 10:57: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 ( '99721' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 06/11/2025 10:57: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 ( '99721' , '16767' , 'COPPIA CANDELIERI DA PROCESSIONE - 2591' , '1' , '-1' , '1' , '220.0000' , '180.32786885246' , '22' , '0' , '220.00' ) 06/11/2025 10:57: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 ( '99721' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '22.00' ) 06/11/2025 10:58:12 am >> SELECT document_num FROM ps_document WHERE document_num = '201' AND id_document != '99717' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:58:12 am >> UPDATE ps_document SET id_document_type = '21', document_num = '201', document_date = '2025-11-06', document_letter = '', id_customer = '3984', id_supplier = '', id_address = '4679386', address1 = 'VIA M. ALETTA 1 84030 MONTE S. GIACOMO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '242.25', price_tax_excluded = '242.25', date_upd = NOW() WHERE id_document = '99717' 06/11/2025 10:58:12 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 = '99717' 06/11/2025 10:58:12 am >> DELETE FROM ps_document_detail WHERE id_document = '99717' 06/11/2025 10:58:12 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 ( '99717' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 10:58:12 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 ( '99717' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 10:58:12 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 ( '99717' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 10:58:39 am >> SELECT document_num FROM ps_document WHERE document_num = '201' AND id_document != '99717' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 10:58:39 am >> UPDATE ps_document SET id_document_type = '21', document_num = '201', document_date = '2025-11-06', document_letter = '', id_customer = '3984', id_supplier = '', id_address = '4679386', address1 = 'VIA M. ALETTA 1 84030 MONTE S. GIACOMO', 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 = '242.25', price_tax_excluded = '242.25', date_upd = NOW() WHERE id_document = '99717' 06/11/2025 10:58: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 = '99717' 06/11/2025 10:58:39 am >> DELETE FROM ps_document_detail WHERE id_document = '99717' 06/11/2025 10:58: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 ( '99717' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 10:58: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 ( '99717' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 10:58: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 ( '99717' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 11:01:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3672' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 11:01: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' , '3672' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '116.69' , '108.39' , NOW() , NOW() ) 06/11/2025 11:01: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 = '99722' 06/11/2025 11:01:05 am >> DELETE FROM ps_document_detail WHERE id_document = '99722' 06/11/2025 11:01: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 ( '99722' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '20.00' ) 06/11/2025 11:01: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 ( '99722' , '3257' , 'CUSTODIA LEZIONARIO ECONOMICA ' , '1' , '-1' , '1' , '26.00' , '21.311475409836' , '22' , '0' , '26.00' ) 06/11/2025 11:01: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 ( '99722' , '24057' , 'AVVENTO 2025' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 06/11/2025 11:01: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 ( '99722' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 06/11/2025 11:01: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 ( '99722' , '21534' , 'QUELLO CHE SO DI LEI - G. FORLAI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 06/11/2025 11:01: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 ( '99722' , '23407' , 'PROCESSO AL PROCESSETTO' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 06/11/2025 11:01: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 ( '99722' , '22522' , 'PREGHIERA COME CONTEMPLAZIONE - G. FORLAI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 06/11/2025 11:01: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 ( '99722' , '23443' , 'MA COME SI FA?' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 06/11/2025 11:01: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 ( '99722' , '24180' , 'DILEXI TE' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 06/11/2025 11:03:11 am >> SELECT document_num FROM ps_document WHERE document_num = '201' AND id_document != '99717' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 11:03:11 am >> UPDATE ps_document SET id_document_type = '21', document_num = '201', document_date = '2025-11-06', document_letter = '', id_customer = '3984', id_supplier = '', id_address = '4679386', address1 = 'VIA M. ALETTA 1 84030 MONTE S. GIACOMO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '242.25', price_tax_excluded = '242.25', date_upd = NOW() WHERE id_document = '99717' 06/11/2025 11:03: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 = '99717' 06/11/2025 11:03:11 am >> DELETE FROM ps_document_detail WHERE id_document = '99717' 06/11/2025 11:03: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 ( '99717' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 11:03:12 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 ( '99717' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 11:03:12 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 ( '99717' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 11:03:36 am >> SELECT document_num FROM ps_document WHERE document_num = '201' AND id_document != '99717' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 11:03:36 am >> UPDATE ps_document SET id_document_type = '21', document_num = '201', document_date = '2025-11-06', document_letter = '', id_customer = '3984', id_supplier = '', id_address = '4679386', address1 = 'VIA M. ALETTA 1 84030 MONTE S. GIACOMO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '242.00', price_tax_excluded = '242.00', date_upd = NOW() WHERE id_document = '99717' 06/11/2025 11:03:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99717' 06/11/2025 11:03:36 am >> DELETE FROM ps_document_detail WHERE id_document = '99717' 06/11/2025 11:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99717' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 11:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99717' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 11:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99717' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 11:03:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99717' , '' , 'arrotondamento' , '1' , '-1' , '0' , '-0.25' , '-0.25' , '' , '0' , '-0.25' ) 06/11/2025 11:21:55 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 ( '32' , '335/25' , '2025-10-31' , '25' , '0' , '0' , '2612' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '38.25' , '38.25' , NOW() , NOW() ) 06/11/2025 11:21:55 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 = '99723' 06/11/2025 11:21:55 am >> DELETE FROM ps_document_detail WHERE id_document = '99723' 06/11/2025 11:21:55 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 ( '99723' , '24181' , 'DIO HA TANTO AMATO IL MONDO' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 06/11/2025 11:21:55 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 ( '99723' , '24182' , 'ANDIAMO INCONTRO A GESU' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 06/11/2025 11:21:55 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 ( '99723' , '24183' , 'PAPA LEONE XIV - F. INNOCENTE' , '5' , '0' , '4' , '7.5000' , '7.5' , '0' , '50' , '18.75' ) 06/11/2025 11:21:55 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 ( '99723' , '24221' , 'DILEXI TE' , '5' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '7.00' ) 06/11/2025 11:22:22 am >> DELETE FROM ps_document WHERE id_document = '99678' 06/11/2025 11:22:23 am >> DELETE FROM ps_document_detail WHERE id_document = '99678' 06/11/2025 11:25:22 am >> UPDATE ps_document SET id_document_type = '31', document_num = '2474', document_date = '2023-07-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2607', address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI', address2 = '', note = '', price_shipping = '11.00', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '569.17', price_tax_excluded = '466.53', date_upd = NOW() WHERE id_document = '86810' 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86810' 06/11/2025 11:25:22 am >> DELETE FROM ps_document_detail WHERE id_document = '86810' 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '16409' , 'RICAMBIO VETRO - 32/V' , '3' , '3' , '1' , '6.5000' , '5.327868852459' , '22' , '5' , '22.60' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '2097' , 'CIPOLLINA MANGIAFUMO - 1057' , '4' , '4' , '1' , '3.5000' , '2.8688524590164' , '22' , '5' , '16.23' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '8935' , 'ANTIVENTO PER TORCIA NIKEL - DIAM. 4 - 32' , '2' , '2' , '1' , '18.5000' , '15.16393442623' , '22' , '5' , '42.88' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '8935' , 'ANTIVENTO PER TORCIA NIKEL - DIAM. 4 - 32' , '2' , '2' , '1' , '20.5' , '16.803278688525' , '22' , '5' , '47.5190' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '12578' , 'RICAMBIO VETRO PER ART. 486 - 65' , '10' , '10' , '1' , '6.5000' , '5.327868852459' , '22' , '5' , '75.34' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '2' , '2' , '1' , '8.0000' , '6.5573770491803' , '22' , '5' , '18.54' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '100' , '100' , '1' , '0.2300' , '0.18852459016393' , '22' , '5' , '26.66' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '10' , '10' , '1' , '5.5000' , '4.5081967213115' , '22' , '5' , '63.75' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '10' , '10' , '1' , '5.5000' , '4.5081967213115' , '22' , '5' , '63.75' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '3' , '3' , '1' , '5.5000' , '4.5081967213115' , '22' , '5' , '19.12' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '2' , '1' , '8.0000' , '6.5573770491803' , '22' , '5' , '18.54' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '3' , '3' , '1' , '20.0000' , '16.393442622951' , '22' , '5' , '69.54' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '15000' , 'TECA ALTA IHS - 825' , '3' , '3' , '1' , '13.0000' , '10.655737704918' , '22' , '5' , '45.20' ) 06/11/2025 11:25:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86810' , '6011' , 'LUMINELLO VETRO - 474' , '5' , '5' , '1' , '4.5000' , '3.6885245901639' , '22' , '5' , '26.08' ) 06/11/2025 11:27:39 am >> UPDATE ps_document SET id_document_type = '31', document_num = '3943', document_date = '2023-12-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2607', address1 = 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI', address2 = '', note = '', price_shipping = '12.02', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '664.28', price_tax_excluded = '544.49', date_upd = NOW() WHERE id_document = '89316' 06/11/2025 11:27: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 = '89316' 06/11/2025 11:27:39 am >> DELETE FROM ps_document_detail WHERE id_document = '89316' 06/11/2025 11:27: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 ( '89316' , '16767' , 'COPPIA CANDELIERI DA PROCESSIONE - 2591' , '1' , '1' , '1' , '91.0000' , '74.590163934426' , '22' , '5' , '105.47' ) 06/11/2025 11:27: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 ( '89316' , '21932' , 'FINTA CANDELA COMPLETA DI CARTUCCIA 4X80 - 1148' , '2' , '2' , '1' , '14.5000' , '11.885245901639' , '22' , '5' , '33.61' ) 06/11/2025 11:27: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 ( '89316' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '1' , '1' , '1' , '21.0000' , '17.213114754098' , '22' , '5' , '24.34' ) 06/11/2025 11:27: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 ( '89316' , '21933' , 'FINTA CANDELA CON CARTUCCIA 8X30- 1180' , '6' , '6' , '1' , '18.5000' , '15.16393442623' , '22' , '5' , '128.65' ) 06/11/2025 11:27: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 ( '89316' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '12' , '12' , '1' , '3.0000' , '2.4590163934426' , '22' , '5' , '41.72' ) 06/11/2025 11:27: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 ( '89316' , '15351' , 'PORTATECA A BUSTINA - 928' , '2' , '2' , '1' , '24.0000' , '19.672131147541' , '22' , '5' , '55.63' ) 06/11/2025 11:27: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 ( '89316' , '15767' , 'ANTIVENTO PER TORCIA NIKEL - DIAM. 5 - 34' , '2' , '2' , '1' , '19.5' , '15.983606557377' , '22' , '5' , '45.2010' ) 06/11/2025 11:27: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 ( '89316' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '1' , '1' , '42.5000' , '34.83606557377' , '22' , '5' , '49.26' ) 06/11/2025 11:27: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 ( '89316' , '539' , 'AMPOLLA RICAMBIO PER ART. 506 - 17' , '2' , '2' , '1' , '3.0000' , '2.4590163934426' , '22' , '5' , '6.95' ) 06/11/2025 11:27: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 ( '89316' , '19108' , 'PORTATECA COMPLETA - 947' , '2' , '2' , '1' , '21.0000' , '17.213114754098' , '22' , '5' , '48.68' ) 06/11/2025 11:27: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 ( '89316' , '12645' , 'TORCIA PROCESSIONE DIAM. 3,2 - 90 CM - 486' , '2' , '2' , '1' , '39.0000' , '31.967213114754' , '22' , '5' , '90.40' ) 06/11/2025 11:27: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 ( '89316' , '5976' , 'LUCERNA VETRO - 1493' , '2' , '2' , '1' , '8.5000' , '6.9672131147541' , '22' , '5' , '19.70' ) 06/11/2025 11:30:20 am >> SELECT document_num FROM ps_document WHERE document_num = '3340' AND id_document != '99214' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-13') 06/11/2025 11:30:20 am >> UPDATE ps_document SET id_document_type = '11', document_num = '3340', document_date = '2025-10-13', 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 = '386.30', price_tax_excluded = '324.73', date_upd = NOW() WHERE id_document = '99214' 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99214' 06/11/2025 11:30:20 am >> DELETE FROM ps_document_detail WHERE id_document = '99214' 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99214' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '97' , '-97' , '1' , '0.3000' , '0.24590163934426' , '22' , '0' , '29.10' ) 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99214' , '19102' , 'CARBONCINI MM 40' , '2' , '-2' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '26.00' ) 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99214' , '20220' , 'MEDAGLIA SAN BENEDETTO CM 2 - 400/n0217' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99214' , '23757' , 'MEDAGLIA SAN BENEDETTO - M244/A SM' , '10' , '-10' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '20.00' ) 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99214' , '7311' , 'OSTIA SOTTILE 74MM' , '20' , '-20' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '40.00' ) 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99214' , '24142' , 'DILEXI TE' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99214' , '23262' , 'COPRI LEGGIO AGNELLO - 61AGN' , '1' , '-1' , '1' , '150.0000' , '122.95081967213' , '22' , '0' , '150.00' ) 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99214' , '23721' , 'BEATITUDINI - M. DE ROSA' , '1' , '-1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99214' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '6' , '-6' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '6.00' ) 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99214' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '1' , '-1' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '0.50' ) 06/11/2025 11:30:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99214' , '15768' , 'ANTIVENTO PER TORCIA ORO DIAM. 5 - 35' , '2' , '-2' , '1' , '50.00' , '40.983606557377' , '22' , '0' , '100.00' ) 06/11/2025 11:33:48 am >> SELECT document_num FROM ps_document WHERE document_num = '128/A' AND id_document != '99397' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-22') 06/11/2025 11:33:48 am >> UPDATE ps_document SET id_document_type = '24', document_num = '128/A', document_date = '2025-10-22', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4679589', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '482.40', price_tax_excluded = '481.86', date_upd = NOW() WHERE id_document = '99397' 06/11/2025 11:33:48 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99397' 06/11/2025 11:33:48 am >> DELETE FROM ps_document_detail WHERE id_document = '99397' 06/11/2025 11:33:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99397' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 06/11/2025 11:33:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99397' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 06/11/2025 11:33:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99397' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '50' , '-50' , '4' , '3.8000' , '3.8' , '0' , '15' , '161.50' ) 06/11/2025 11:33:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99397' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '-20' , '4' , '3.8000' , '3.8' , '0' , '15' , '64.60' ) 06/11/2025 11:33:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99397' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 11:33:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99397' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 06/11/2025 11:33:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99397' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 06/11/2025 11:33:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99397' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 06/11/2025 11:33:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99397' , '12819' , 'REGISTRO DEL CATECHISTA ' , '3' , '-3' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '3.00' ) 06/11/2025 11:35:09 am >> SELECT document_num FROM ps_document WHERE document_num = '3673' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 11:35:09 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' , '3673' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.50' , '5.50' , NOW() , NOW() ) 06/11/2025 11:35:09 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 = '99724' 06/11/2025 11:35:09 am >> DELETE FROM ps_document_detail WHERE id_document = '99724' 06/11/2025 11:35:09 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 ( '99724' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 06/11/2025 11:38:17 am >> SELECT document_num FROM ps_document WHERE document_num = '128/A' AND id_document != '99397' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-10-22') 06/11/2025 11:38:17 am >> UPDATE ps_document SET id_document_type = '24', document_num = '128/A', document_date = '2025-10-22', document_letter = 'A', id_customer = '371', id_supplier = '', id_address = '4679589', address1 = 'VIA PIAVE, 4 84080 CASTEL SAN GIORGIO', 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 = '482.40', price_tax_excluded = '482.40', date_upd = NOW() WHERE id_document = '99397' 06/11/2025 11:38:17 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 = '99397' 06/11/2025 11:38:17 am >> DELETE FROM ps_document_detail WHERE id_document = '99397' 06/11/2025 11:38:17 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 ( '99397' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 06/11/2025 11:38:17 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 ( '99397' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 06/11/2025 11:38:17 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 ( '99397' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '50' , '-50' , '4' , '3.8000' , '3.8' , '0' , '15' , '161.50' ) 06/11/2025 11:38:17 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 ( '99397' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '20' , '-20' , '4' , '3.8000' , '3.8' , '0' , '15' , '64.60' ) 06/11/2025 11:38:17 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 ( '99397' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 06/11/2025 11:38:17 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 ( '99397' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 06/11/2025 11:38:17 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 ( '99397' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '3' , '-3' , '4' , '10.0000' , '10' , '0' , '15' , '25.50' ) 06/11/2025 11:38:17 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 ( '99397' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '15' , '2.55' ) 06/11/2025 11:38:17 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 ( '99397' , '12819' , 'REGISTRO DEL CATECHISTA ' , '3' , '-3' , '4' , '1.0000' , '1' , '0' , '0' , '3.00' ) 06/11/2025 11:43:40 am >> SELECT document_num FROM ps_document WHERE document_num = '203' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 11:43: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' , '203' , '2025-11-06' , '' , '2385' , '0' , '4678091' , 'PIAZZA REGINA MARGHERITA 84084 LANCUSI BOLANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '60.18' , '60.18' , NOW() , NOW() ) 06/11/2025 11:43: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 = '99725' 06/11/2025 11:43:40 am >> DELETE FROM ps_document_detail WHERE id_document = '99725' 06/11/2025 11:43: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 ( '99725' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 06/11/2025 11:43:41 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 ( '99725' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '16' , '-16' , '4' , '3.80' , '3.8' , '0' , '15' , '51.68' ) 06/11/2025 11:44:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3674' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 11:44:23 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' , '3674' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.51' , '7.51' , NOW() , NOW() ) 06/11/2025 11:44:23 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 = '99726' 06/11/2025 11:44:23 am >> DELETE FROM ps_document_detail WHERE id_document = '99726' 06/11/2025 11:44:23 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 ( '99726' , '24069' , 'CINQUE PANI DORZO 2026' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 06/11/2025 11:50:18 am >> SELECT document_num FROM ps_document WHERE document_num = '3675' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 11:50:18 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' , '3675' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.94' , '51.94' , NOW() , NOW() ) 06/11/2025 11:50:18 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 = '99727' 06/11/2025 11:50:18 am >> DELETE FROM ps_document_detail WHERE id_document = '99727' 06/11/2025 11:50:18 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 ( '99727' , '23988' , 'AMEN - DIC 25' , '14' , '-14' , '4' , '3.90' , '3.9' , '0' , '5' , '51.94' ) 06/11/2025 11:52:31 am >> SELECT document_num FROM ps_document WHERE document_num = '3676' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 11:52:31 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' , '3676' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '126.00' , '121.13' , NOW() , NOW() ) 06/11/2025 11:52:31 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 = '99728' 06/11/2025 11:52:31 am >> DELETE FROM ps_document_detail WHERE id_document = '99728' 06/11/2025 11:52:31 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 ( '99728' , '6809' , 'MOCCOLO 60X165' , '2' , '-2' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '10.00' ) 06/11/2025 11:52:31 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 ( '99728' , '6811' , 'MOCCOLO 80X200' , '1' , '-1' , '1' , '9.50' , '7.7868852459016' , '22' , '0' , '9.50' ) 06/11/2025 11:52:31 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 ( '99728' , '21137' , 'MOCCOLO 70X200' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 06/11/2025 11:52:31 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 ( '99728' , '5444' , 'IO SONO CON VOI - CAT.' , '18' , '-18' , '4' , '5.50' , '5.5' , '0' , '0' , '99.00' ) 06/11/2025 11:54:08 am >> SELECT document_num FROM ps_document WHERE document_num = '204' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 11:54:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '204' , '2025-11-06' , '' , '4119' , '0' , '4679375' , 'PIAZZA MICHELE D\\\'ASTE 2 84042 ACERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.87' , '120.87' , NOW() , NOW() ) 06/11/2025 11:54:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99729' 06/11/2025 11:54:08 am >> DELETE FROM ps_document_detail WHERE id_document = '99729' 06/11/2025 11:54:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99729' , '5457' , 'IO SONO CON VOI 1 PARTE' , '18' , '-18' , '4' , '2.80' , '2.8' , '0' , '15' , '42.84' ) 06/11/2025 11:54:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99729' , '5458' , 'IO SONO CON VOI 2 PARTE' , '18' , '-18' , '4' , '2.80' , '2.8' , '0' , '15' , '42.84' ) 06/11/2025 11:54:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99729' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '15' , '3.23' ) 06/11/2025 11:54:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99729' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '15' , '3.23' ) 06/11/2025 11:54:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99729' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '15' , '3.23' ) 06/11/2025 11:54:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99729' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 06/11/2025 11:54:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99729' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 06/11/2025 11:54:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99729' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 06/11/2025 12:01:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3677' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 12:01:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3677' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 06/11/2025 12:01: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 = '99730' 06/11/2025 12:01:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '99730' 06/11/2025 12:01: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 ( '99730' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 06/11/2025 12:13:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '3678' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 12:13:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3678' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '11.00' , NOW() , NOW() ) 06/11/2025 12:13:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99731' 06/11/2025 12:13:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '99731' 06/11/2025 12:13:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99731' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '11' , '11' , '0' , '0' , '11.00' ) 06/11/2025 12:23:11 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'nf4BFj7r3k07Hvyy' , NOW() , NOW() ) 06/11/2025 12:23:11 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4277' , '1' ) 06/11/2025 12:23:11 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4277' , '2' ) 06/11/2025 12:23:11 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4277' , '3' ) 06/11/2025 12:24:32 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4277' 06/11/2025 12:24:32 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4277' , '10' , '216' , '' , 'ANGELILLO' , 'MANUELA ' , 'VIA SAN ROCCO 39' , '' , '74011' , 'CASTELLANETA' , '' , '' , '3286115645' , '' , '' , NOW() , NOW() ) 06/11/2025 12:24:32 pm >> UPDATE ps_customer SET email = 'Danilarocci2507@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4277' 06/11/2025 12:25:02 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4277' 06/11/2025 12:25:02 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4277' , '10' , '216' , '' , 'ANGELILLO' , 'MANUELA ' , 'VIA SAN ROCCO 39' , '' , '74011' , 'CASTELLANETA' , '' , '' , '3286115645' , '' , '' , NOW() , NOW() ) 06/11/2025 12:25:02 pm >> UPDATE ps_customer SET email = 'Danilarocci2507@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4277' 06/11/2025 12:25:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '3679' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 12:25:39 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' , '3679' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 06/11/2025 12:25:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99732' 06/11/2025 12:25:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '99732' 06/11/2025 12:25:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99732' , '24022' , 'SULLA TUA PAROLA NOV/DIC 2025 - 531' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 06/11/2025 12:26:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '205' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 12:26:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '205' , '2025-11-06' , '' , '4277' , '0' , '4679631' , 'VIA SAN ROCCO 39 74011 CASTELLANETA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '38.25' , '38.25' , NOW() , NOW() ) 06/11/2025 12:26:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99733' 06/11/2025 12:26:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '99733' 06/11/2025 12:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99733' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '5' , '33.25' ) 06/11/2025 12:33:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '303' , '2025-11-06' , '' , '0' , '161' , '4673833' , 'VIA TORRIONE 125 84127 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '135.00' , '135.00' , NOW() , NOW() ) 06/11/2025 12:33: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 = '99734' 06/11/2025 12:33:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '99734' 06/11/2025 12:33: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 ( '99734' , '24144' , 'LIBERI NELLA VERITA\' - M. DE MAIO' , '5' , '0' , '4' , '36.0000' , '36' , '0' , '25' , '135.00' ) 06/11/2025 12:33:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '24144' AND id_supplier = '161' 06/11/2025 12:33:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '24144' , '161' , '1' ) 06/11/2025 12:52:03 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' , '4954' , '2025-11-05' , '' , '0' , '47' , '2642' , 'V.LE BACCHIGLIONE, 20 20139 MILANO' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.60' , '171.60' , NOW() , NOW() ) 06/11/2025 12:52:03 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 = '99735' 06/11/2025 12:52:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '99735' 06/11/2025 12:52:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99735' , '23503' , 'TRISTE CASO DELL\'OMELIA - F. ROSINI' , '14' , '14' , '4' , '17.00' , '17' , '0' , '30' , '166.6000' ) 06/11/2025 12:52:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23503' AND id_supplier = '47' 06/11/2025 12:52:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23503' , '47' , '1' ) 06/11/2025 12:52:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99735' , '23503' , 'TRISTE CASO DELLOMELIA - F. ROSINI' , '1' , '1' , '4' , '17.00' , '17' , '0' , '100' , '0.0000' ) 06/11/2025 12:52:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '23503' AND id_supplier = '47' 06/11/2025 12:52:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23503' , '47' , '1' ) 06/11/2025 12:53:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '28' AND id_document != '99242' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2025-10-14') 06/11/2025 12:53:12 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '28', document_date = '2025-10-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2642', address1 = 'V.LE BACCHIGLIONE, 20 20139 MILANO', address2 = '', note = 'RESA - n.c. ricevuta', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '9', price_tax_included = '109.00', price_tax_excluded = '109.00', date_upd = NOW() WHERE id_document = '99242' 06/11/2025 12:53:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99242' 06/11/2025 12:53:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '99242' 06/11/2025 12:53:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99242' , '13941' , 'SANTO VOLTO' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 06/11/2025 12:53:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99242' , '19164' , 'SULLE ORME DI DON TONINO BELLO - E. TOLVE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 06/11/2025 12:53:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99242' , '10525' , 'TEMPO DI LIBERAZIONE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 06/11/2025 12:53:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99242' , '12564' , 'PIU BELLE PREGHIERE IN LATINO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 06/11/2025 12:53:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99242' , '19166' , 'SANTO ANGELO CUSTODE - B. DENTE' , '1' , '-1' , '4' , '7.0000' , '7' , '0' , '0' , '7.00' ) 06/11/2025 12:53:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99242' , '19384' , 'PREGHIERE DI GUARiGIONE' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 06/11/2025 12:53:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99242' , '20580' , 'PREGHIERE DI GUARIGIONE NELLA MALATTIA' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '0' , '13.00' ) 06/11/2025 12:53:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99242' , '16055' , 'FIORETTI DI GIOVANNI DELLA CROCE - J.V. RODRIGUEZ' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 06/11/2025 12:53: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 ( '99242' , '16054' , 'FIORETTI DI TERESA DI GESU - T. ALVAREZ' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '0' , '12.00' ) 06/11/2025 02:25:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '206' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 02:25:48 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' , '206' , '2025-11-06' , '' , '4270' , '0' , '4679603' , 'VIA ROMA 17 03040 PIGNATARO INTERAMNA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.40' , '13.40' , NOW() , NOW() ) 06/11/2025 02:25: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 = '99736' 06/11/2025 02:25:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '99736' 06/11/2025 02:25: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 ( '99736' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.50' , '5.5' , '0' , '0' , '5.50' ) 06/11/2025 02:25: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 ( '99736' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 06/11/2025 02:26:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '206' AND id_document != '99736' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 02:26:05 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '206', document_date = '2025-11-06', document_letter = '', id_customer = '4270', id_supplier = '', id_address = '4679603', address1 = 'VIA ROMA 17 03040 PIGNATARO INTERAMNA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '13.40', price_tax_excluded = '13.40', date_upd = NOW() WHERE id_document = '99736' 06/11/2025 02:26:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99736' 06/11/2025 02:26:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '99736' 06/11/2025 02:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99736' , '5444' , 'IO SONO CON VOI - CAT.' , '1' , '-1' , '4' , '5.5000' , '5.5' , '0' , '0' , '5.50' ) 06/11/2025 02:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99736' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 06/11/2025 02:31:00 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4277' 06/11/2025 02:31:00 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4277' , '10' , '216' , 'CALDOROSSO' , 'ANGELILLO' , 'MANUELA ' , 'VIA SAN ROCCO 39' , '' , '74011' , 'CASTELLANETA' , '' , '' , '3286115645' , '' , '' , NOW() , NOW() ) 06/11/2025 02:31:00 pm >> UPDATE ps_customer SET email = 'Danilarocci2507@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4277' 06/11/2025 02:31:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '205' AND id_document != '99733' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 02:31:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '205', document_date = '2025-11-06', document_letter = '', id_customer = '4277', id_supplier = '0', id_address = '4679632', address1 = 'VIA SAN ROCCO 39 74011 CASTELLANETA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '38.25', price_tax_excluded = '38.25', date_upd = NOW() WHERE id_document = '99733' 06/11/2025 02:31:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99733' 06/11/2025 02:31:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '99733' 06/11/2025 02:31:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99733' , '2679' , 'CONOSCERE GESU\'' , '10' , '-10' , '4' , '3.5000' , '3.5' , '0' , '5' , '33.25' ) 06/11/2025 02:31:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '204' AND id_document != '99729' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 02:31:47 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '204', document_date = '2025-11-06', document_letter = '', id_customer = '4119', id_supplier = '', id_address = '4679375', address1 = 'PIAZZA MICHELE D\\\'ASTE 2 84042 ACERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '120.87', price_tax_excluded = '120.87', date_upd = NOW() WHERE id_document = '99729' 06/11/2025 02:31:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99729' 06/11/2025 02:31:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '99729' 06/11/2025 02:31: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 ( '99729' , '5457' , 'IO SONO CON VOI 1 PARTE' , '18' , '-18' , '4' , '2.8000' , '2.8' , '0' , '15' , '42.84' ) 06/11/2025 02:31: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 ( '99729' , '5458' , 'IO SONO CON VOI 2 PARTE' , '18' , '-18' , '4' , '2.8000' , '2.8' , '0' , '15' , '42.84' ) 06/11/2025 02:31: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 ( '99729' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '15' , '3.23' ) 06/11/2025 02:31: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 ( '99729' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '15' , '3.23' ) 06/11/2025 02:31: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 ( '99729' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.8000' , '3.8' , '0' , '15' , '3.23' ) 06/11/2025 02:31: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 ( '99729' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 06/11/2025 02:31: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 ( '99729' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 06/11/2025 02:31: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 ( '99729' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 06/11/2025 02:39:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801044157' AND id_product != '9573' AND ean13 != '' 06/11/2025 02:39:15 pm >> UPDATE ps_product SET id_supplier = '17', reference = '6/4', ean13 = '9788801044157', date_upd = NOW() WHERE id_product = '9573' 06/11/2025 02:39:15 pm >> UPDATE ps_product_lang SET name = 'SANTA LUCIA', description = '' WHERE id_product = '9573' 06/11/2025 02:39:15 pm >> UPDATE ps_product SET wholesale_price = '2.50', on_sale = '0', price = '5.0000' WHERE id_product = '9573' 06/11/2025 02:39:15 pm >> UPDATE ps_product_shop SET wholesale_price = '2.50', price = '5.0000', id_tax_rules_group = '4', id_category_default = '501', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9573' 06/11/2025 02:39:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '9573' 06/11/2025 02:41:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801059069' AND id_product != '9532' AND ean13 != '' 06/11/2025 02:41:17 pm >> UPDATE ps_product SET id_supplier = '17', reference = '6/4', ean13 = '9788801059069', date_upd = NOW() WHERE id_product = '9532' 06/11/2025 02:41:17 pm >> UPDATE ps_product_lang SET name = 'SANT\'ALFONSO MARIA DE LIGUORI - E. MARCELLI', description = '' WHERE id_product = '9532' 06/11/2025 02:41:17 pm >> UPDATE ps_product SET wholesale_price = '1.75', on_sale = '0', price = '3.5000' WHERE id_product = '9532' 06/11/2025 02:41:17 pm >> UPDATE ps_product_shop SET wholesale_price = '1.75', price = '3.5000', id_tax_rules_group = '4', id_category_default = '501', id_argoment_default = '53', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9532' 06/11/2025 02:41:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '9532' 06/11/2025 03:36:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '3680' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 03:36:51 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' , '3680' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '52.00' , '42.62' , NOW() , NOW() ) 06/11/2025 03:36:51 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 = '99737' 06/11/2025 03:36:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '99737' 06/11/2025 03:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99737' , '19351' , 'SERVIZIO MESSA MISTO LINO - 7050' , '1' , '-1' , '1' , '52.00' , '42.622950819672' , '22' , '0' , '52.00' ) 06/11/2025 03:38:47 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4274' 06/11/2025 03:38:47 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4274' , '10' , '216' , 'PARROCCHIA SAN PAOLO DELLA CROCE' , 'FRACASSO' , 'P. LUCA' , 'VIALE MANCINI 28' , '' , '74024' , 'MANDURIA' , 'CONVENTO PASSIONISTI' , '' , '3282408839' , '' , '90013810735' , NOW() , NOW() ) 06/11/2025 03:38:47 pm >> UPDATE ps_customer SET email = 'fracassoluca78@gmail.com', sdi = '0000000', pec = '', date_upd = NOW() WHERE id_customer = '4274' 06/11/2025 03:39:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '33/L' AND id_document != '99703' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-11-05') 06/11/2025 03:39:14 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '33/L', document_date = '2025-11-05', document_letter = 'L', id_customer = '4274', id_supplier = '0', id_address = '4679633', address1 = 'VIALE MANCINI 28 84024 MANDURIA', 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 = '60.00', price_tax_excluded = '49.18', date_upd = NOW() WHERE id_document = '99703' 06/11/2025 03:39: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 = '99703' 06/11/2025 03:39:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '99703' 06/11/2025 03:39: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 ( '99703' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '2' , '-2' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '60.00' ) 06/11/2025 03:57:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3681' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 03:57:50 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' , '3681' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.28' , NOW() , NOW() ) 06/11/2025 03:57:50 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 = '99738' 06/11/2025 03:57:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '99738' 06/11/2025 03:57:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99738' , '24095' , 'MEDAGLIA ACUTIS DORATA - G474-D.254' , '3' , '-3' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '2.40' ) 06/11/2025 03:57:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99738' , '6337' , 'MEDAGLIA OVALE DECORATA - SACRO CUORE - G291-D' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 06/11/2025 03:57:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99738' , '6332' , 'MEDAGLIA OVALE DECORATA - MISERICORDIOSO - G291-D' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 06/11/2025 04:07:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '3682' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 04:07:50 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' , '3682' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 06/11/2025 04:07:50 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 = '99739' 06/11/2025 04:07:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '99739' 06/11/2025 04:07:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99739' , '6014' , 'LUMINO BIANCO - 10B' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 06/11/2025 04:07:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99739' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 06/11/2025 04:09:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '207' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 04:09:30 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' , '207' , '2025-11-06' , '' , '284' , '0' , '4671723' , 'VIA GUIDO D\\\'AREZZO snc 92027 LICATA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '476.00' , '476.00' , NOW() , NOW() ) 06/11/2025 04:09:30 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 = '99740' 06/11/2025 04:09:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '99740' 06/11/2025 04:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99740' , '5458' , 'IO SONO CON VOI 2 PARTE' , '100' , '-100' , '4' , '2.80' , '2.8' , '0' , '15' , '238.00' ) 06/11/2025 04:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99740' , '11192' , 'VENITE CON ME 2 PARTE' , '100' , '-100' , '4' , '2.80' , '2.8' , '0' , '15' , '238.00' ) 06/11/2025 04:21:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3683' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 04:21: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' , '3683' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.50' , '29.33' , NOW() , NOW() ) 06/11/2025 04:21: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 = '99741' 06/11/2025 04:21:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '99741' 06/11/2025 04:21: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 ( '99741' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 06/11/2025 04:21: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 ( '99741' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '7' , '-7' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '24.50' ) 06/11/2025 04:23:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '3684' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 04:23: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' , '3684' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.80' , '22.80' , NOW() , NOW() ) 06/11/2025 04:23: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 = '99742' 06/11/2025 04:23:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '99742' 06/11/2025 04:23: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 ( '99742' , '24197' , 'PAROLA DI DIO OGNI GIORNO 2026 - V. PAGLIA' , '1' , '-1' , '4' , '24.00' , '24' , '0' , '5' , '22.80' ) 06/11/2025 05:24:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '208' AND id_document != '' AND id_document_type LIKE '25' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 05:24:25 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '208' , '2025-11-06' , '' , '4214' , '0' , '4679505' , 'VIA AIA DEL GALLO 62 83055 STURNO' , '' , '' , '5.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.45' , '15.45' , NOW() , NOW() ) 06/11/2025 05:24:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99743' 06/11/2025 05:24:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '99743' 06/11/2025 05:24:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99743' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 06/11/2025 05:24:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99743' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 06/11/2025 05:25:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '209' AND id_document != '' AND id_document_type LIKE '25' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 05:25:34 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '25' , '209' , '2025-11-06' , '' , '939' , '0' , '4670801' , 'VIA MAZZARINO,12 90018 TERMINI IMERESE' , '' , 'STORNO E.C. 73 DEL 28/05/2025' , '5.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '41.00' , '41.00' , NOW() , NOW() ) 06/11/2025 05:25:34 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99744' 06/11/2025 05:25:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '99744' 06/11/2025 05:25:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99744' , '13397' , 'MIO GESU\'' , '10' , '10' , '4' , '3.5000' , '3.5' , '0' , '5' , '33.25' ) 06/11/2025 05:25:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99744' , '0' , 'spese di contrassegno' , '1' , '1' , '4' , '2.7500' , '2.75' , '0' , '0' , '2.75' ) 06/11/2025 05:26:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '208' AND id_document != '99743' AND id_document_type LIKE '25' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 05:26:05 pm >> UPDATE ps_document SET id_document_type = '25', document_num = '208', document_date = '2025-11-06', document_letter = '', id_customer = '4214', id_supplier = '', id_address = '4679505', address1 = 'VIA AIA DEL GALLO 62 83055 STURNO', address2 = '', note = 'STORNO E.C. 61 DEL 05/05/2025', price_shipping = '5.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 = '15.45', price_tax_excluded = '15.45', date_upd = NOW() WHERE id_document = '99743' 06/11/2025 05:26:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99743' 06/11/2025 05:26:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '99743' 06/11/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99743' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '1' , '1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 06/11/2025 05:26:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99743' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '1' , '1' , '4' , '8.0000' , '8' , '0' , '5' , '7.60' ) 06/11/2025 05:33:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3685' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 05:33:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3685' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '19.23' , NOW() , NOW() ) 06/11/2025 05:33: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 = '99745' 06/11/2025 05:33:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '99745' 06/11/2025 05:33: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 ( '99745' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 06/11/2025 05:33: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 ( '99745' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 06/11/2025 05:33: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 ( '99745' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '9.00' ) 06/11/2025 05:41:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '3686' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 05:41:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3686' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.75' , '42.75' , NOW() , NOW() ) 06/11/2025 05:41: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 = '99746' 06/11/2025 05:41:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '99746' 06/11/2025 05:41: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 ( '99746' , '10684' , 'TORAH E STORIOGRAFIE DELLA. T. - 2 - CORSO STUDI BIBLICI - LOGOS' , '1' , '-1' , '4' , '45.00' , '45' , '0' , '5' , '42.75' ) 06/11/2025 05:47:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '3687' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 05:47:47 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' , '3687' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.30' , '4.98' , NOW() , NOW() ) 06/11/2025 05:47:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99747' 06/11/2025 05:47:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '99747' 06/11/2025 05:47: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 ( '99747' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 06/11/2025 05:47: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 ( '99747' , '5105' , 'IMMAGINI SACRE SERIE STELLA 20X25 - AVRSTEL' , '1' , '-1' , '1' , '0.80' , '0.65573770491803' , '22' , '0' , '0.80' ) 06/11/2025 07:28:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3688' AND id_document != '' AND id_document_type LIKE '13' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 07:28:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3688' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '70.00' , '57.38' , NOW() , NOW() ) 06/11/2025 07:28:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99748' 06/11/2025 07:28:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '99748' 06/11/2025 07:28:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99748' , '939' , 'BAMBINO CM 4 - CARNE - P1' , '200' , '-200' , '1' , '0.35' , '0.28688524590164' , '22' , '0' , '70.00' ) 06/11/2025 07:28:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000418' AND id_product != '939' AND ean13 != '' 06/11/2025 07:28:37 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '000418', date_upd = NOW() WHERE id_product = '939' 06/11/2025 07:28:37 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 4 - CARNE - P1', description = '' WHERE id_product = '939' 06/11/2025 07:28:37 pm >> UPDATE ps_product SET wholesale_price = '0.12', on_sale = '0', price = '0.3278688524590164' WHERE id_product = '939' 06/11/2025 07:28:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.12', price = '0.3278688524590164', id_tax_rules_group = '1', id_category_default = '95', 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 = '939' 06/11/2025 07:28:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '939' 06/11/2025 07:28:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000419' AND id_product != '940' AND ean13 != '' 06/11/2025 07:28:51 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '000419', date_upd = NOW() WHERE id_product = '940' 06/11/2025 07:28:51 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 4 - FOSFORO - P1', description = '' WHERE id_product = '940' 06/11/2025 07:28:51 pm >> UPDATE ps_product SET wholesale_price = '0.12', on_sale = '0', price = '0.3278688524590164' WHERE id_product = '940' 06/11/2025 07:28:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.12', price = '0.3278688524590164', id_tax_rules_group = '1', id_category_default = '95', 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 = '940' 06/11/2025 07:28:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '940' 06/11/2025 07:28:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3689' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-11-06') 06/11/2025 07:28:59 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' , '3689' , '2025-11-06' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '11.54' , NOW() , NOW() ) 06/11/2025 07:28: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 = '99749' 06/11/2025 07:28:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '99749' 06/11/2025 07:28: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 ( '99749' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '12.00' ) 06/11/2025 07:32:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '3405' AND id_document != '99321' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-10-18') 06/11/2025 07:32:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3405', document_date = '2025-10-18', 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 = '49.00', price_tax_excluded = '49.00', date_upd = NOW() WHERE id_document = '99321' 06/11/2025 07:32:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '99321' 06/11/2025 07:32:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '99321' 06/11/2025 07:32:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99321' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16.79' , '16.79' , '0' , '0' , '16.79' ) 06/11/2025 07:32:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99321' , '23759' , 'NON IO MA DIO - A. SALZANO ACUTIS' , '1' , '-1' , '4' , '18.9000' , '18.9' , '0' , '5' , '17.96' ) 06/11/2025 07:32:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '99321' , '23752' , 'TUTTA LA MESSA MINUTO PER MINUTO - V. ANGELUCCI' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 06/11/2025 07:32:48 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000416' AND id_product != '941' AND ean13 != '' 06/11/2025 07:32:48 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '000416', date_upd = NOW() WHERE id_product = '941' 06/11/2025 07:32:48 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 5 - CARNE - PX', description = '' WHERE id_product = '941' 06/11/2025 07:32:48 pm >> UPDATE ps_product SET wholesale_price = '0.17', on_sale = '0', price = '0.4098360655737705' WHERE id_product = '941' 06/11/2025 07:32:48 pm >> UPDATE ps_product_shop SET wholesale_price = '0.17', price = '0.4098360655737705', id_tax_rules_group = '1', id_category_default = '95', 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 = '941' 06/11/2025 07:32:48 pm >> DELETE FROM ps_specific_price WHERE id_product = '941' 06/11/2025 07:33:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000417' AND id_product != '942' AND ean13 != '' 06/11/2025 07:33:37 pm >> UPDATE ps_product SET id_supplier = '28', reference = '2013', ean13 = '000417', date_upd = NOW() WHERE id_product = '942' 06/11/2025 07:33:37 pm >> UPDATE ps_product_lang SET name = 'BAMBINO CM 5 - FOSFORO - PX', description = '' WHERE id_product = '942' 06/11/2025 07:33:37 pm >> UPDATE ps_product SET wholesale_price = '0.13', on_sale = '0', price = '0.4098360655737705' WHERE id_product = '942' 06/11/2025 07:33:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.13', price = '0.4098360655737705', id_tax_rules_group = '1', id_category_default = '95', 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 = '942' 06/11/2025 07:33:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '942'