05/04/2024 08:57:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 05/04/2024 08:57:31 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '123.30', price_tax_excluded = '123.30', date_upd = NOW() WHERE id_document = '89846' 05/04/2024 08:57: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 = '89846' 05/04/2024 08:57:31 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 05/04/2024 08:57: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 ( '89846' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 05/04/2024 08:57: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 ( '89846' , '22227' , 'MALE NEGLI OCCHI DELLAMORE - G. BORGHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/04/2024 08:57: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 ( '89846' , '10064' , 'SOLO L\'AMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/04/2024 08:57: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 ( '89846' , '22270' , 'QUESTA E LA NOSTRA FEDE - AAVV' , '1' , '-1' , '4' , '36.0000' , '36' , '0' , '0' , '36.00' ) 05/04/2024 08:57: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 ( '89846' , '22291' , 'DOMANDE DI DIO, DOMANDE A DIO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 05/04/2024 08:57: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 ( '89846' , '22332' , 'NULLA SARA PIU COME PRIMA - L. NOWLIN' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 05/04/2024 08:57: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 ( '89846' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 05/04/2024 08:57: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 ( '89846' , '22333' , 'NARRAZIONI DELLA PASSIONE DI GESU CRISTO - G. BETORI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 05/04/2024 08:59:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 05/04/2024 08:59:38 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '118.30', price_tax_excluded = '118.30', date_upd = NOW() WHERE id_document = '89846' 05/04/2024 08:59:38 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89846' 05/04/2024 08:59:38 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 05/04/2024 08:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 05/04/2024 08:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22227' , 'MALE NEGLI OCCHI DELLAMORE - G. BORGHI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/04/2024 08:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '10064' , 'SOLO L\'AMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.0000' , '14' , '0' , '0' , '14.00' ) 05/04/2024 08:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22270' , 'QUESTA E LA NOSTRA FEDE - AAVV' , '1' , '-1' , '4' , '36.0000' , '36' , '0' , '0' , '36.00' ) 05/04/2024 08:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22291' , 'DOMANDE DI DIO, DOMANDE A DIO' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 05/04/2024 08:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22332' , 'NULLA SARA PIU COME PRIMA - L. NOWLIN' , '1' , '-1' , '4' , '9.9000' , '9.9' , '0' , '0' , '9.90' ) 05/04/2024 08:59:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89846' , '22333' , 'NARRAZIONI DELLA PASSIONE DI GESU CRISTO - G. BETORI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 05/04/2024 09:00:02 am >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 05/04/2024 09:00:02 am >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.00', price_tax_excluded = '5.00', date_upd = NOW() WHERE id_document = '89846' 05/04/2024 09: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 = '89846' 05/04/2024 09:00:02 am >> DELETE FROM ps_document_detail WHERE id_document = '89846' 05/04/2024 09: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 ( '89846' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 05/04/2024 09:02:01 am >> SELECT document_num FROM ps_document WHERE document_num = '542' AND id_document != '90477' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-23') 05/04/2024 09:02:01 am >> UPDATE ps_document SET id_document_type = '11', document_num = '542', document_date = '2024-02-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '75.00', price_tax_excluded = '75.00', date_upd = NOW() WHERE id_document = '90477' 05/04/2024 09:02:01 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 = '90477' 05/04/2024 09:02:01 am >> DELETE FROM ps_document_detail WHERE id_document = '90477' 05/04/2024 09:02:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90477' , '22227' , 'MALE NEGLI OCCHI DELLAMORE - G. BORGHI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 05/04/2024 09:02:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90477' , '22270' , 'QUESTA E LA NOSTRA FEDE - AAVV' , '1' , '-1' , '4' , '36.00' , '36' , '0' , '5' , '34.20' ) 05/04/2024 09:02:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90477' , '22291' , 'DOMANDE DI DIO, DOMANDE A DIO' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 05/04/2024 09:02:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90477' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.70' , '0.7' , '0' , '0' , '1.40' ) 05/04/2024 09:02:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90477' , '5457' , 'IO SONO CON VOI 1 PARTE' , '1' , '-1' , '4' , '2.35' , '2.35' , '0' , '0' , '2.35' ) 05/04/2024 09:03:31 am >> SELECT document_num FROM ps_document WHERE document_num = '649' AND id_document != '90633' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-05') 05/04/2024 09:03:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '649', document_date = '2024-03-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 = '40.00', price_tax_excluded = '40.00', date_upd = NOW() WHERE id_document = '90633' 05/04/2024 09:03: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 = '90633' 05/04/2024 09:03:31 am >> DELETE FROM ps_document_detail WHERE id_document = '90633' 05/04/2024 09:03:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90633' , '10064' , 'SOLO LAMORE CREA - F. ROSINI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 05/04/2024 09:03:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90633' , '22333' , 'NARRAZIONI DELLA PASSIONE DI GESU CRISTO - G. BETORI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 05/04/2024 09:03:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90633' , '22332' , 'NULLA SARA PIU COME PRIMA - L. NOWLIN' , '1' , '-1' , '4' , '9.6' , '9.6' , '0' , '' , '9.60' ) 05/04/2024 09:07:38 am >> SELECT document_num FROM ps_document WHERE document_num = '1026' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 09:07:39 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1026' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 05/04/2024 09:07: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 = '91100' 05/04/2024 09:07:39 am >> DELETE FROM ps_document_detail WHERE id_document = '91100' 05/04/2024 09:07: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 ( '91100' , '15387' , 'VESTINA BATTESIMALE ' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 05/04/2024 09:07: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 ( '91100' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 05/04/2024 09:16:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1027' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 09:16:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1027' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.60' , '16.07' , NOW() , NOW() ) 05/04/2024 09:16: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 = '91101' 05/04/2024 09:16:26 am >> DELETE FROM ps_document_detail WHERE id_document = '91101' 05/04/2024 09:16: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 ( '91101' , '1914' , 'CERA DELLA LITURGIA' , '4' , '-4' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '19.60' ) 05/04/2024 10:04:37 am >> SELECT document_num FROM ps_document WHERE document_num = '42/A' AND id_document != '90923' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-23') 05/04/2024 10:04:37 am >> UPDATE ps_document SET id_document_type = '24', document_num = '42/A', document_date = '2024-03-23', document_letter = 'A', id_customer = '3842', id_supplier = '', id_address = '4673208', address1 = 'VIA SAN LEONARDO 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '76.89', price_tax_excluded = '73.64', date_upd = NOW() WHERE id_document = '90923' 05/04/2024 10:04:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90923' 05/04/2024 10:04:37 am >> DELETE FROM ps_document_detail WHERE id_document = '90923' 05/04/2024 10:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 05/04/2024 10:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 05/04/2024 10:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 05/04/2024 10:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.70' , '0.7' , '0' , '0' , '24.50' ) 05/04/2024 10:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '22168' , 'AMEN - GIU. 2024' , '5' , '-5' , '4' , '3.90' , '3.9' , '0' , '5' , '18.52' ) 05/04/2024 10:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 05/04/2024 10:04:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '2448' , 'COLUI IN CUI CREDO' , '2' , '-2' , '4' , '2.50' , '2.5' , '0' , '5' , '4.75' ) 05/04/2024 10:06:14 am >> SELECT document_num FROM ps_document WHERE document_num = '42/A' AND id_document != '90923' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-23') 05/04/2024 10:06:14 am >> UPDATE ps_document SET id_document_type = '24', document_num = '42/A', document_date = '2024-03-23', document_letter = 'A', id_customer = '3842', id_supplier = '', id_address = '4673208', address1 = 'VIA SAN LEONARDO 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '94.89', price_tax_excluded = '88.40', date_upd = NOW() WHERE id_document = '90923' 05/04/2024 10:06:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90923' 05/04/2024 10:06:14 am >> DELETE FROM ps_document_detail WHERE id_document = '90923' 05/04/2024 10:06:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 05/04/2024 10:06:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 05/04/2024 10:06:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 05/04/2024 10:06:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '35' , '-35' , '4' , '0.7000' , '0.7' , '0' , '0' , '24.50' ) 05/04/2024 10:06:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '22168' , 'AMEN - GIU. 2024' , '5' , '-5' , '4' , '3.9000' , '3.9' , '0' , '5' , '18.52' ) 05/04/2024 10:06:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 05/04/2024 10:06:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '2448' , 'COLUI IN CUI CREDO' , '2' , '-2' , '4' , '2.5000' , '2.5' , '0' , '5' , '4.75' ) 05/04/2024 10:06:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90923' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '18.00' ) 05/04/2024 10:16:16 am >> SELECT document_num FROM ps_document WHERE document_num = '1028' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 10:16:16 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' , '1028' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '36.00' , '29.51' , NOW() , NOW() ) 05/04/2024 10:16:16 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91102' 05/04/2024 10:16:16 am >> DELETE FROM ps_document_detail WHERE id_document = '91102' 05/04/2024 10:16:16 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91102' , '22105' , 'CANDELINE NON GOCCIOLANTI IN BUSTA - CHA25' , '2' , '-2' , '1' , '18.00' , '14.754098360656' , '22' , '0' , '36.00' ) 05/04/2024 10:53:53 am >> SELECT document_num FROM ps_document WHERE document_num = '1029' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 10:53:53 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' , '1029' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.50' , '17.16' , NOW() , NOW() ) 05/04/2024 10:53:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91103' 05/04/2024 10:53:53 am >> DELETE FROM ps_document_detail WHERE id_document = '91103' 05/04/2024 10:53:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91103' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 05/04/2024 10:53:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91103' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '1' , '1' , '0' , '0' , '2.00' ) 05/04/2024 10:53:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91103' , '3102' , 'CROCE SAGOMATA IN POL. CON ORO A CALDO - MISERICORDIOSO - OGGETTI' , '2' , '-2' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '6.00' ) 05/04/2024 11:01:11 am >> SELECT document_num FROM ps_document WHERE document_num = '1030' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 11:01:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1030' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 05/04/2024 11:01: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 = '91104' 05/04/2024 11:01:11 am >> DELETE FROM ps_document_detail WHERE id_document = '91104' 05/04/2024 11:01: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 ( '91104' , '13322' , 'IMMAGINI 70X100 GESU MISERICORDIOSO' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 05/04/2024 11:12:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , 'FPR22/24' , '2024-04-05' , '24' , '0' , '174' , '4678466' , 'VIA ADRIANA 18 84012 ANGRI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '79.03' , '79.03' , NOW() , NOW() ) 05/04/2024 11:12:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91105' 05/04/2024 11:12:21 am >> DELETE FROM ps_document_detail WHERE id_document = '91105' 05/04/2024 11:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91105' , '20687' , 'NON HO CHE LOGGI PENSIERI TERASA DI LISIEUX - S. LONGOBARDI' , '3' , '3' , '4' , '16.00' , '16' , '0' , '30' , '33.6000' ) 05/04/2024 11:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20687' AND id_supplier = '174' 05/04/2024 11:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20687' , '174' , '1' ) 05/04/2024 11:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91105' , '20691' , 'LUIGI E ZELIA MARTIN - J. CLAPIER' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 05/04/2024 11:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20691' AND id_supplier = '174' 05/04/2024 11:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20691' , '174' , '1' ) 05/04/2024 11:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91105' , '20692' , 'COME ACCOMPAGNARE I FIDANZATI - S. LONGOBARDI' , '2' , '2' , '4' , '19.00' , '19' , '0' , '30' , '26.6000' ) 05/04/2024 11:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20692' AND id_supplier = '174' 05/04/2024 11:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20692' , '174' , '1' ) 05/04/2024 11:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91105' , '20698' , 'DIARIO DI BORDO - S. LONGOBARDI' , '1' , '1' , '4' , '5.90' , '5.9' , '0' , '30' , '4.1300' ) 05/04/2024 11:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20698' AND id_supplier = '174' 05/04/2024 11:12:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20698' , '174' , '1' ) 05/04/2024 11:12:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91105' , '20695' , 'VENITE ALLE NOZZE - S. LONGOBARDI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '30' , '3.5000' ) 05/04/2024 11:12:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '20695' AND id_supplier = '174' 05/04/2024 11:12:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20695' , '174' , '1' ) 05/04/2024 11:13:19 am >> SELECT document_num FROM ps_document WHERE document_num = '1031' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 11:13:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1031' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 05/04/2024 11:13:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91106' 05/04/2024 11:13:19 am >> DELETE FROM ps_document_detail WHERE id_document = '91106' 05/04/2024 11:13:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91106' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '30' , '-30' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '90.00' ) 05/04/2024 11:16:29 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/04/2024 11:16:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22368' , '1' , '' , 'nuovo-prodotto' ) 05/04/2024 11:16:29 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22368' , '1' , '1' , '2' , NOW() , NOW() ) 05/04/2024 11:16:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22368' , '0' , '1' , '0' , '0' ) 05/04/2024 11:17:05 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002262' AND id_product != '22368' AND ean13 != '' 05/04/2024 11:17:05 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002262', date_upd = NOW() WHERE id_product = '22368' 05/04/2024 11:17:05 am >> UPDATE ps_product_lang SET name = 'UN FIORETTO PER MARIA', description = '' WHERE id_product = '22368' 05/04/2024 11:17:05 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '2' WHERE id_product = '22368' 05/04/2024 11:17:05 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '2', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22368' 05/04/2024 11:17:05 am >> DELETE FROM ps_specific_price WHERE id_product = '22368' 05/04/2024 11:17:06 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22368' 05/04/2024 11:17:06 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22369' , '1' , '' , 'nuovo-prodotto' ) 05/04/2024 11:17:06 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22369' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22368' 05/04/2024 11:17:06 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22369' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22368' 05/04/2024 11:19:18 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791281505124' AND id_product != '22369' AND ean13 != '' 05/04/2024 11:19:19 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9791281505124', date_upd = NOW() WHERE id_product = '22369' 05/04/2024 11:19:19 am >> UPDATE ps_product_lang SET name = 'MIA CRESIMA', description = '' WHERE id_product = '22369' 05/04/2024 11:19:19 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '22369' 05/04/2024 11:19:19 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22369' 05/04/2024 11:19:19 am >> DELETE FROM ps_specific_price WHERE id_product = '22369' 05/04/2024 11:19:26 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22369' 05/04/2024 11:19:26 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22370' , '1' , '' , 'nuovo-prodotto' ) 05/04/2024 11:19:26 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22370' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22369' 05/04/2024 11:19:26 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22370' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22369' 05/04/2024 11:20:26 am >> UPDATE ps_document SET id_document_type = '31', document_num = 'FPR22/24', document_date = '2024-04-05', document_letter = '24', id_customer = '0', id_supplier = '', id_address = '4678466', address1 = 'VIA ADRIANA 18 84012 ANGRI', 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 = '299.69', price_tax_excluded = '299.69', date_upd = NOW() WHERE id_document = '91105' 05/04/2024 11:20: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 = '91105' 05/04/2024 11:20:26 am >> DELETE FROM ps_document_detail WHERE id_document = '91105' 05/04/2024 11:20: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 ( '91105' , '20687' , 'NON HO CHE LOGGI PENSIERI TERASA DI LISIEUX - S. LONGOBARDI' , '3' , '3' , '4' , '16.0000' , '16' , '0' , '30' , '33.60' ) 05/04/2024 11:20: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 ( '91105' , '20691' , 'LUIGI E ZELIA MARTIN - J. CLAPIER' , '1' , '1' , '4' , '16.0000' , '16' , '0' , '30' , '11.20' ) 05/04/2024 11:20: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 ( '91105' , '20692' , 'COME ACCOMPAGNARE I FIDANZATI - S. LONGOBARDI' , '2' , '2' , '4' , '19.0000' , '19' , '0' , '30' , '26.60' ) 05/04/2024 11:20: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 ( '91105' , '20698' , 'DIARIO DI BORDO - S. LONGOBARDI' , '1' , '1' , '4' , '5.9000' , '5.9' , '0' , '30' , '4.13' ) 05/04/2024 11:20: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 ( '91105' , '20695' , 'VENITE ALLE NOZZE - S. LONGOBARDI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '30' , '3.50' ) 05/04/2024 11:20: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 ( '91105' , '20700' , 'AMORE, SESSO E VERGINITA - C. GALATOLO' , '2' , '2' , '4' , '10.00' , '10' , '0' , '30' , '14.0000' ) 05/04/2024 11:20: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 ( '91105' , '20697' , 'VOGLIO DONARMI COMPLETAMENTE A TE - C. GALATOLO' , '2' , '2' , '4' , '10.00' , '10' , '0' , '30' , '14.0000' ) 05/04/2024 11:20: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 ( '91105' , '20693' , 'TROVA LA PERLA PREZIOSA - G. ABBAGNARA' , '2' , '2' , '4' , '7.00' , '7' , '0' , '30' , '9.8000' ) 05/04/2024 11:20: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 ( '91105' , '20699' , 'VOI SIETE LADESSO DI DIO - IPPOLITO/ABBAGNARA' , '2' , '2' , '4' , '15.00' , '15' , '0' , '30' , '21.0000' ) 05/04/2024 11:20: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 ( '91105' , '20696' , 'NOSTRE NOZZE ' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 05/04/2024 11:20: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 ( '91105' , '20701' , 'CI SPOSIAMO COMPRENDERE LA POTENZA' , '2' , '2' , '4' , '4.50' , '4.5' , '0' , '30' , '6.3000' ) 05/04/2024 11:20:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91105' , '20694' , 'COSTRUIRE LA CASA SULLA ROCCIA - K. WOJTYLA' , '2' , '2' , '4' , '7.00' , '7' , '0' , '30' , '9.8000' ) 05/04/2024 11:20:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91105' , '22368' , 'UN FIORETTO PER MARIA' , '50' , '50' , '4' , '2.00' , '2' , '0' , '50' , '50.0000' ) 05/04/2024 11:20:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91105' , '20689' , 'PER IL TUO SOLO AMORE -TERESA DI LISIEUX - J. FAU' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 05/04/2024 11:20:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91105' , '21057' , 'MIA CONFESSIONE' , '10' , '10' , '4' , '3.90' , '3.9' , '0' , '30' , '27.3000' ) 05/04/2024 11:20:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91105' , '21055' , 'MIA PRIMA EUCARISTIA ' , '10' , '10' , '4' , '3.90' , '3.9' , '0' , '30' , '27.3000' ) 05/04/2024 11:20:27 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91105' , '22369' , 'MIA CRESIMA' , '10' , '10' , '4' , '3.90' , '3.9' , '0' , '30' , '27.3000' ) 05/04/2024 11:20:44 am >> DELETE FROM ps_document WHERE id_document = '80602' 05/04/2024 11:20:45 am >> DELETE FROM ps_document_detail WHERE id_document = '80602' 05/04/2024 11:48:14 am >> SELECT document_num FROM ps_document WHERE document_num = '1032' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 11:48:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1032' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 05/04/2024 11:48:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91107' 05/04/2024 11:48:14 am >> DELETE FROM ps_document_detail WHERE id_document = '91107' 05/04/2024 11:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91107' , '4696' , 'GLOBO PIREX DIAM. 3,5 COMPLETO - 89 ' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 05/04/2024 11:48:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91107' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 05/04/2024 12:04:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1033' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 12:04: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' , '1033' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.00' , '16.91' , NOW() , NOW() ) 05/04/2024 12:04: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 = '91108' 05/04/2024 12:04:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '91108' 05/04/2024 12:04: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 ( '91108' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.70' , '0.7' , '0' , '0' , '7.00' ) 05/04/2024 12:04: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 ( '91108' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '8' , '8' , '0' , '0' , '8.00' ) 05/04/2024 12:04: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 ( '91108' , '21004' , 'CREAZIONE' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 05/04/2024 12:04: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 ( '91108' , '4840' , 'HOLY CARD - MISERICORDIOSO - M0100/G001' , '1' , '-1' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '0.50' ) 05/04/2024 12:05:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '61' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 12:05: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' , '61' , '2024-04-05' , '' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.50' , '59.50' , NOW() , NOW() ) 05/04/2024 12:05: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 = '91109' 05/04/2024 12:05:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '91109' 05/04/2024 12:05: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 ( '91109' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '10' , '-10' , '4' , '7.00' , '7' , '0' , '15' , '59.50' ) 05/04/2024 12:06:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '1034' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 12:06:46 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1034' , '2024-04-05' , '' , '333' , '0' , '4671072' , 'P.ZZA S. MICHELE 84135 RUFOLI' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '113.50' , '112.89' , NOW() , NOW() ) 05/04/2024 12:06:46 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91110' 05/04/2024 12:06:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '91110' 05/04/2024 12:06:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91110' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '1' , '-1' , '4' , '99.0000' , '99' , '0' , '5' , '94.05' ) 05/04/2024 12:06:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91110' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.05' ) 05/04/2024 12:06:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91110' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '2' , '-2' , '1' , '1.2000' , '0.9836' , '22' , '0' , '2.40' ) 05/04/2024 12:06:46 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91110' , '18891' , 'ROSARIO LEGNO - R984' , '1' , '-1' , '1' , '1.0000' , '0.8197' , '22' , '0' , '1.00' ) 05/04/2024 12:06:55 pm >> DELETE FROM ps_document WHERE id_document = '90896' 05/04/2024 12:06:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '90896' 05/04/2024 12:08:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '61' AND id_document != '91109' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 12:08:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '61', document_date = '2024-04-05', document_letter = '', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '15', id_causal = '0', price_tax_included = '59.50', price_tax_excluded = '59.50', date_upd = NOW() WHERE id_document = '91109' 05/04/2024 12:08: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 = '91109' 05/04/2024 12:08:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '91109' 05/04/2024 12:08: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 ( '91109' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '10' , '-10' , '4' , '7.0000' , '7' , '0' , '15' , '59.50' ) 05/04/2024 12:11:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '1035' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 12:11:22 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' , '1035' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 05/04/2024 12:11: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 = '91111' 05/04/2024 12:11:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '91111' 05/04/2024 12:11: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 ( '91111' , '15602' , 'AMICO GESU ALBUM' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 05/04/2024 12:11: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 ( '91111' , '475' , 'AMICO GESÙ - FIGURINE' , '20' , '-20' , '4' , '0.50' , '0.5' , '0' , '0' , '10.00' ) 05/04/2024 12:21:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '1036' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 12:21:38 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' , '1036' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.91' , '19.91' , NOW() , NOW() ) 05/04/2024 12:21:38 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 = '91112' 05/04/2024 12:21:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '91112' 05/04/2024 12:21:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91112' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '11' , '-11' , '4' , '1.90' , '1.9' , '0' , '5' , '19.91' ) 05/04/2024 12:40:26 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608976' AND id_product != '22370' AND ean13 != '' 05/04/2024 12:40:26 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826608976', date_upd = NOW() WHERE id_product = '22370' 05/04/2024 12:40:26 pm >> UPDATE ps_product_lang SET name = 'DIGNITAS INFINITA', description = '' WHERE id_product = '22370' 05/04/2024 12:40:26 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.9' WHERE id_product = '22370' 05/04/2024 12:40:26 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.9', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '69', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22370' 05/04/2024 12:40:26 pm >> DELETE FROM ps_specific_price WHERE id_product = '22370' 05/04/2024 12:43:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '1037' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 12:43:14 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' , '1037' , '2024-04-05' , '' , '0' , '0' , '0' , 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '365.00' , '300.08' , NOW() , NOW() ) 05/04/2024 12:43: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 = '91113' 05/04/2024 12:43:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '91113' 05/04/2024 12:43: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 ( '91113' , '1544' , 'CAMICE RAGLAN - CM 150 - ART.54' , '1' , '-1' , '1' , '45.0000' , '36.8852' , '22' , '0' , '45.00' ) 05/04/2024 12:43: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 ( '91113' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '45.0000' , '36.8852' , '22' , '0' , '90.00' ) 05/04/2024 12:43: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 ( '91113' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '3' , '-3' , '1' , '19.00' , '15.573770491803' , '22' , '0' , '57.00' ) 05/04/2024 12:43: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 ( '91113' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 05/04/2024 12:43: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 ( '91113' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 05/04/2024 12:43: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 ( '91113' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 05/04/2024 12:43: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 ( '91113' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 05/04/2024 12:44:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '1038' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 12:44: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 ( '11' , '1038' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '91.77' , '77.70' , NOW() , NOW() ) 05/04/2024 12:44: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 = '91114' 05/04/2024 12:44:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '91114' 05/04/2024 12:44: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 ( '91114' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 05/04/2024 12:44: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 ( '91114' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 05/04/2024 12:44: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 ( '91114' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 05/04/2024 12:44: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 ( '91114' , '22261' , 'DIO MENO DI UNO SPRIZ? - P. PELLEGRINO' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 05/04/2024 12:44: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 ( '91114' , '22262' , 'CRISTIANI PERCHE NO? - P. PELLEGRINO' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '5' , '4.28' ) 05/04/2024 12:44: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 ( '91114' , '17529' , 'NUOVO RITO DELLA MESSA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 05/04/2024 12:48:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '39/A' AND id_document != '90880' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-21') 05/04/2024 12:48:24 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '39/A', document_date = '2024-03-21', document_letter = 'A', id_customer = '3865', id_supplier = '', id_address = '4673708', address1 = 'VIA CROCE 1 - FRAZ. SALITTO 84062 OLEVANO SUL TUSCIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1700.00', price_tax_excluded = '1700.00', date_upd = NOW() WHERE id_document = '90880' 05/04/2024 12:48:24 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 = '90880' 05/04/2024 12:48:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '90880' 05/04/2024 12:48:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90880' , '' , 'BALDACCHINO' , '1' , '-1' , '0' , '1700' , '1700' , '' , '0' , '1700.00' ) 05/04/2024 01:03:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2024-DL001093' , '2024-04-03' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '42.90' , '42.90' , NOW() , NOW() ) 05/04/2024 01:03:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91115' 05/04/2024 01:03:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '91115' 05/04/2024 01:03: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 ( '91115' , '22370' , 'DIGNITAS INFINITA' , '20' , '20' , '4' , '3.90' , '3.9' , '0' , '45' , '42.9000' ) 05/04/2024 01:03:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22370' AND id_supplier = '79' 05/04/2024 01:03:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22370' , '79' , '1' ) 05/04/2024 03:21:33 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000448' AND id_product != '1750' AND ean13 != '' 05/04/2024 03:21:33 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000448', date_upd = NOW() WHERE id_product = '1750' 05/04/2024 03:21:33 pm >> UPDATE ps_product_lang SET name = 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454', description = '' WHERE id_product = '1750' 05/04/2024 03:21:33 pm >> UPDATE ps_product SET wholesale_price = '5.23', on_sale = '0', price = '11.475409836065573' WHERE id_product = '1750' 05/04/2024 03:21:33 pm >> UPDATE ps_product_shop SET wholesale_price = '5.23', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '147', 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 = '1750' 05/04/2024 03:21:33 pm >> DELETE FROM ps_specific_price WHERE id_product = '1750' 05/04/2024 03:21:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000448' AND id_product != '1750' AND ean13 != '' 05/04/2024 03:21:59 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000448', date_upd = NOW() WHERE id_product = '1750' 05/04/2024 03:21:59 pm >> UPDATE ps_product_lang SET name = 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454', description = '' WHERE id_product = '1750' 05/04/2024 03:21:59 pm >> UPDATE ps_product SET wholesale_price = '5.23', on_sale = '0', price = '11.475409836065573' WHERE id_product = '1750' 05/04/2024 03:21:59 pm >> UPDATE ps_product_shop SET wholesale_price = '5.23', price = '11.475409836065573', id_tax_rules_group = '1', id_category_default = '147', 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 = '1750' 05/04/2024 03:21:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '1750' 05/04/2024 03:23:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001253' AND id_product != '15871' AND ean13 != '' 05/04/2024 03:23:20 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001253', date_upd = NOW() WHERE id_product = '15871' 05/04/2024 03:23:20 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA 4X100 - 143', description = '' WHERE id_product = '15871' 05/04/2024 03:23:20 pm >> UPDATE ps_product SET wholesale_price = '9.98', on_sale = '0', price = '24.59016393442623' WHERE id_product = '15871' 05/04/2024 03:23:20 pm >> UPDATE ps_product_shop SET wholesale_price = '9.98', price = '24.59016393442623', id_tax_rules_group = '1', id_category_default = '147', 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 = '15871' 05/04/2024 03:23:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '15871' 05/04/2024 03:24:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000016550' AND id_product != '12203' AND ean13 != '' 05/04/2024 03:24:22 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000016550', date_upd = NOW() WHERE id_product = '12203' 05/04/2024 03:24:22 pm >> UPDATE ps_product_lang SET name = 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50', description = '' WHERE id_product = '12203' 05/04/2024 03:24:22 pm >> UPDATE ps_product SET wholesale_price = '8.55', on_sale = '0', price = '16.3934' WHERE id_product = '12203' 05/04/2024 03:24:22 pm >> UPDATE ps_product_shop SET wholesale_price = '8.55', price = '16.3934', id_tax_rules_group = '1', id_category_default = '147', 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 = '12203' 05/04/2024 03:24:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '12203' 05/04/2024 03:28:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000016550' AND id_product != '12203' AND ean13 != '' 05/04/2024 03:28:37 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000016550', date_upd = NOW() WHERE id_product = '12203' 05/04/2024 03:28:37 pm >> UPDATE ps_product_lang SET name = 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50', description = '' WHERE id_product = '12203' 05/04/2024 03:28:37 pm >> UPDATE ps_product SET wholesale_price = '8.55', on_sale = '0', price = '18.0327868852459' WHERE id_product = '12203' 05/04/2024 03:28:37 pm >> UPDATE ps_product_shop SET wholesale_price = '8.55', price = '18.0327868852459', id_tax_rules_group = '1', id_category_default = '147', 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 = '12203' 05/04/2024 03:28:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '12203' 05/04/2024 03:29:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000016543' AND id_product != '12202' AND ean13 != '' 05/04/2024 03:29:44 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000016543', date_upd = NOW() WHERE id_product = '12202' 05/04/2024 03:29:44 pm >> UPDATE ps_product_lang SET name = 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40', description = '' WHERE id_product = '12202' 05/04/2024 03:29:44 pm >> UPDATE ps_product SET wholesale_price = '8.08', on_sale = '0', price = '16.39344262295082' WHERE id_product = '12202' 05/04/2024 03:29:44 pm >> UPDATE ps_product_shop SET wholesale_price = '8.08', price = '16.39344262295082', id_tax_rules_group = '1', id_category_default = '147', 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 = '12202' 05/04/2024 03:29:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '12202' 05/04/2024 03:32:08 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 05/04/2024 03:32:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22371' , '1' , '' , 'nuovo-prodotto' ) 05/04/2024 03:32:08 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22371' , '1' , '1' , '2' , NOW() , NOW() ) 05/04/2024 03:32:08 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22371' , '0' , '1' , '0' , '0' ) 05/04/2024 03:33:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000016246' AND id_product != '22371' AND ean13 != '' 05/04/2024 03:33:12 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000016246', date_upd = NOW() WHERE id_product = '22371' 05/04/2024 03:33:12 pm >> UPDATE ps_product_lang SET name = 'RICAMBIO AMPOLLA PER ART. 869 - 71', description = '' WHERE id_product = '22371' 05/04/2024 03:33:13 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.836065573770492' WHERE id_product = '22371' 05/04/2024 03:33:13 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.836065573770492', id_tax_rules_group = '1', id_category_default = '147', 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 = '22371' 05/04/2024 03:33:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '22371' 05/04/2024 03:35:13 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000507' AND id_product != '564' AND ean13 != '' 05/04/2024 03:35:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000507', date_upd = NOW() WHERE id_product = '564' 05/04/2024 03:35:13 pm >> UPDATE ps_product_lang SET name = 'GIGLER COMPLETO PER ART. 534/536/537 - 249', description = '' WHERE id_product = '564' 05/04/2024 03:35:13 pm >> UPDATE ps_product SET wholesale_price = '1.43', on_sale = '0', price = '3.606557377049181' WHERE id_product = '564' 05/04/2024 03:35:13 pm >> UPDATE ps_product_shop SET wholesale_price = '1.43', price = '3.606557377049181', id_tax_rules_group = '1', id_category_default = '147', 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 = '564' 05/04/2024 03:35:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '564' 05/04/2024 03:37:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000691' AND id_product != '11154' AND ean13 != '' 05/04/2024 03:37:19 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2015', ean13 = '000691', date_upd = NOW() WHERE id_product = '11154' 05/04/2024 03:37:19 pm >> UPDATE ps_product_lang SET name = 'VASETTO BASSO CON ANELLO - 820', description = '' WHERE id_product = '11154' 05/04/2024 03:37:19 pm >> UPDATE ps_product SET wholesale_price = '6.65', on_sale = '0', price = '15.573770491803279' WHERE id_product = '11154' 05/04/2024 03:37:19 pm >> UPDATE ps_product_shop SET wholesale_price = '6.65', price = '15.573770491803279', id_tax_rules_group = '1', id_category_default = '147', 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 = '11154' 05/04/2024 03:37:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '11154' 05/04/2024 03:41:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1145' , '2024-04-04' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '12' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '433.62' , '355.43' , NOW() , NOW() ) 05/04/2024 03:41:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91116' 05/04/2024 03:41:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '91116' 05/04/2024 03:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91116' , '1749' , 'CARTUCCIA TRASPARENTE DIAM. 5 - 456 ' , '10' , '10' , '1' , '6.5' , '5.327868852459' , '22' , '5' , '75.3350' ) 05/04/2024 03:41:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1749' AND id_supplier = '12' 05/04/2024 03:41:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1749' , '12' , '1' ) 05/04/2024 03:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91116' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '12' , '12' , '1' , '6' , '4.9180327868852' , '22' , '5' , '83.4480' ) 05/04/2024 03:41:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1750' AND id_supplier = '12' 05/04/2024 03:41:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1750' , '12' , '1' ) 05/04/2024 03:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91116' , '15871' , 'FINTA CANDELA 4X100 - 143' , '1' , '1' , '1' , '13' , '10.655737704918' , '22' , '5' , '15.0670' ) 05/04/2024 03:41:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15871' AND id_supplier = '12' 05/04/2024 03:41:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15871' , '12' , '1' ) 05/04/2024 03:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91116' , '12203' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 5 - 73/50' , '2' , '2' , '1' , '9.5' , '7.7868852459016' , '22' , '5' , '22.0210' ) 05/04/2024 03:41:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12203' AND id_supplier = '12' 05/04/2024 03:41:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12203' , '12' , '1' ) 05/04/2024 03:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91116' , '12202' , 'VETRO ANTIVENTO PER F. CAND. DIAM. 4 - 73/40' , '3' , '3' , '1' , '8.5' , '6.9672131147541' , '22' , '5' , '29.5545' ) 05/04/2024 03:41:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12202' AND id_supplier = '12' 05/04/2024 03:41:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12202' , '12' , '1' ) 05/04/2024 03:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91116' , '16939' , 'SACCO PORTAELEMOSINA CON ASTA 1 m - 1750' , '2' , '2' , '1' , '19' , '15.573770491803' , '22' , '5' , '44.0420' ) 05/04/2024 03:41:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16939' AND id_supplier = '12' 05/04/2024 03:41:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16939' , '12' , '1' ) 05/04/2024 03:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91116' , '22371' , 'RICAMBIO AMPOLLA PER ART. 869 - 71' , '1' , '1' , '1' , '5' , '4.0983606557377' , '22' , '5' , '5.7950' ) 05/04/2024 03:41:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22371' AND id_supplier = '12' 05/04/2024 03:41:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22371' , '12' , '1' ) 05/04/2024 03:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91116' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '50' , '50' , '1' , '1.9' , '1.5573770491803' , '22' , '5' , '110.1050' ) 05/04/2024 03:41:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '564' AND id_supplier = '12' 05/04/2024 03:41:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '564' , '12' , '1' ) 05/04/2024 03:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91116' , '11154' , 'VASETTO BASSO CON ANELLO - 820' , '1' , '1' , '1' , '8' , '6.5573770491803' , '22' , '5' , '9.2720' ) 05/04/2024 03:41:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11154' AND id_supplier = '12' 05/04/2024 03:41:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11154' , '12' , '1' ) 05/04/2024 03:41:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91116' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '1' , '1' , '1' , '21' , '17.213114754098' , '22' , '5' , '24.3390' ) 05/04/2024 03:41:29 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8936' AND id_supplier = '12' 05/04/2024 03:41:29 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8936' , '12' , '1' ) 05/04/2024 03:45:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 05/04/2024 03:45:51 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '19.90', price_tax_excluded = '19.90', date_upd = NOW() WHERE id_document = '89846' 05/04/2024 03:45: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 = '89846' 05/04/2024 03:45:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 05/04/2024 03:45: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 ( '89846' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 05/04/2024 03:45: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 ( '89846' , '22370' , 'DIGNITAS INFINITA' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 05/04/2024 03:45: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 ( '89846' , '13499' , 'VITA CRISTIANA - SANTAGOSTINO - 8742' , '1' , '-1' , '4' , '11.00' , '11' , '0' , '0' , '11.00' ) 05/04/2024 04:02:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '62' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 04:02: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' , '62' , '2024-04-05' , '' , '3496' , '0' , '4679247' , 'VIA ALLA BASILICA 1 23808 VERCURAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 05/04/2024 04:02: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 = '91117' 05/04/2024 04:02:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '91117' 05/04/2024 04:02: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 ( '91117' , '22152' , 'A TE RICORRIAMO' , '30' , '-30' , '4' , '3.00' , '3' , '0' , '100' , '0.00' ) 05/04/2024 04:03:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '62' AND id_document != '91117' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 04:03:24 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '62', document_date = '2024-04-05', document_letter = '', id_customer = '3496', id_supplier = '', id_address = '4679247', address1 = 'VIA ALLA BASILICA 1 23808 VERCURAGO', address2 = '', note = 'OMAGGIO AUTORE', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '91117' 05/04/2024 04:03:24 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 = '91117' 05/04/2024 04:03:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '91117' 05/04/2024 04:03:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91117' , '22152' , 'A TE RICORRIAMO' , '30' , '-30' , '4' , '3.0000' , '3' , '0' , '100' , '0.00' ) 05/04/2024 04:14:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1039' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 04:14:55 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1039' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '46.72' , NOW() , NOW() ) 05/04/2024 04:14:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91118' 05/04/2024 04:14:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '91118' 05/04/2024 04:14:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91118' , '21787' , 'AUSILIATRICE CM 30 - 623' , '1' , '-1' , '1' , '57.00' , '46.72131147541' , '22' , '0' , '57.00' ) 05/04/2024 04:40:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788831555593' AND id_product != '20728' AND ean13 != '' 05/04/2024 04:40:17 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/6', ean13 = '9788831555593', date_upd = NOW() WHERE id_product = '20728' 05/04/2024 04:40:17 pm >> UPDATE ps_product_lang SET name = 'OCCHI CHE SI APRONO', description = '' WHERE id_product = '20728' 05/04/2024 04:40:17 pm >> UPDATE ps_product SET wholesale_price = '4.02', on_sale = '0', price = '6.0000' WHERE id_product = '20728' 05/04/2024 04:40:17 pm >> UPDATE ps_product_shop SET wholesale_price = '4.02', price = '6.0000', id_tax_rules_group = '4', id_category_default = '27', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20728' 05/04/2024 04:40:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '20728' 05/04/2024 04:40:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892240605' AND id_product != '20663' AND ean13 != '' 05/04/2024 04:40:38 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/6', ean13 = '9788892240605', date_upd = NOW() WHERE id_product = '20663' 05/04/2024 04:40:38 pm >> UPDATE ps_product_lang SET name = 'CON MARIA SULLA STRADA DELLA PASQUA - L. FANZAGA', description = '' WHERE id_product = '20663' 05/04/2024 04:40:38 pm >> UPDATE ps_product SET wholesale_price = '8.04', on_sale = '0', price = '12.0000' WHERE id_product = '20663' 05/04/2024 04:40:38 pm >> UPDATE ps_product_shop SET wholesale_price = '8.04', price = '12.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20663' 05/04/2024 04:40:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '20663' 05/04/2024 04:40:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892243606' AND id_product != '22079' AND ean13 != '' 05/04/2024 04:40:51 pm >> UPDATE ps_product SET id_supplier = '7', reference = '7/6', ean13 = '9788892243606', date_upd = NOW() WHERE id_product = '22079' 05/04/2024 04:40:51 pm >> UPDATE ps_product_lang SET name = 'CAMMINANDO VERSO LA PASQUA - E. FORTUNATO', description = '' WHERE id_product = '22079' 05/04/2024 04:40:51 pm >> UPDATE ps_product SET wholesale_price = '8.04', on_sale = '0', price = '12.0000' WHERE id_product = '22079' 05/04/2024 04:40:51 pm >> UPDATE ps_product_shop SET wholesale_price = '8.04', price = '12.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22079' 05/04/2024 04:40:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '22079' 05/04/2024 05:18:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1040' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 05:18:52 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' , '1040' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '35.00' , NOW() , NOW() ) 05/04/2024 05:18:52 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 = '91119' 05/04/2024 05:18:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '91119' 05/04/2024 05:18:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91119' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '50' , '-50' , '4' , '0.70' , '0.7' , '0' , '0' , '35.00' ) 05/04/2024 05:21:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1041' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 05:21:44 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' , '1041' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '10.66' , NOW() , NOW() ) 05/04/2024 05:21:44 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 = '91120' 05/04/2024 05:21:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '91120' 05/04/2024 05:21:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91120' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 05/04/2024 05:22:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1042' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 05:22: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' , '1042' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.40' , '8.40' , NOW() , NOW() ) 05/04/2024 05:22: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 = '91121' 05/04/2024 05:22:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '91121' 05/04/2024 05:22:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91121' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '12' , '-12' , '4' , '0.70' , '0.7' , '0' , '0' , '8.40' ) 05/04/2024 05:52:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1043' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 05:52:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1043' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.99' , '33.68' , NOW() , NOW() ) 05/04/2024 05:52:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91122' 05/04/2024 05:52:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '91122' 05/04/2024 05:52:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91122' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '6.00' ) 05/04/2024 05:52:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91122' , '18615' , 'SAN ROCCO CM 20 - 340' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 05/04/2024 05:52:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91122' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.99' , '4.99' , '0' , '0' , '4.99' ) 05/04/2024 05:57:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/E' AND id_document != '91079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-04') 05/04/2024 05:57:57 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '17/E', document_date = '2024-04-04', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'venduto marzo 2024', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '3125.30', price_tax_excluded = '3124.40', date_upd = NOW() WHERE id_document = '91079' 05/04/2024 05:57:57 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 = '91079' 05/04/2024 05:57:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '91079' 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '48' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '57.60' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '5457' , 'IO SONO CON VOI 1 PARTE' , '26' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '36.40' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '5458' , 'IO SONO CON VOI 2 PARTE' , '6' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '8.40' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11191' , 'VENITE CON ME 1 PARTE' , '21' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '29.40' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11192' , 'VENITE CON ME 2 PARTE' , '19' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '26.60' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '42' , '0' , '4' , '0.8500' , '0.85' , '0' , '50' , '17.85' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '23' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '39.10' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '10' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '40.00' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '6629' , 'MIA PREGHIERA' , '27' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '12.15' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '8408' , 'PRENDETE E MANGIATE' , '105' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '157.50' ) 05/04/2024 05:57:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '4' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '10.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '7' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '17.50' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '4154' , 'FESTA DEL PERDONO' , '141' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '211.50' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '2679' , 'CONOSCERE GESU' , '15' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '26.25' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '3' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '7.50' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '3511' , 'DIO PARLA ALLUOMO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '0.80' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '10' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '8.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '0' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '5.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '1.40' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '12' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '21.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '18' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '54.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '13956' , 'MIRACOLI DI GESU' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '9' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '4.50' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '15019' , 'PREGHIAMO CON MARIA' , '20' , '0' , '4' , '0.8000' , '0.8' , '0' , '50' , '8.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '15020' , 'PREGARE OGNI GIORNO' , '22' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '11.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '8' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '24.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '217' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '108.50' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '73' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '73.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16667' , 'VIA CRUCIS' , '2' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '3.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '16997' , 'PREGHIAMO IL PADRONE DELLA MESSE ' , '9' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '11.25' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '5' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '37.50' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17257' , 'IO TI BATTEZZO ' , '13' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '11.70' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '10' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '12.50' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '45' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '42.75' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '85' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '63.75' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '8' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '28.00' ) 05/04/2024 05:57:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '10' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '10.00' ) 05/04/2024 05:57: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 ( '91079' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 05/04/2024 05:57: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 ( '91079' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 05/04/2024 05:57: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 ( '91079' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 05/04/2024 05:57: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 ( '91079' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '6' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '36.00' ) 05/04/2024 05:57: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 ( '91079' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '6' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '13.50' ) 05/04/2024 05:57: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 ( '91079' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '50' , '17.50' ) 05/04/2024 05:57: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 ( '91079' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '49' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '49.00' ) 05/04/2024 05:57: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 ( '91079' , '20721' , 'AVE MARIA - L. CALABRETTA' , '2' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '4.50' ) 05/04/2024 05:57: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 ( '91079' , '20722' , 'SEMINATORI DI GIOIA' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 05/04/2024 05:57: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 ( '91079' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 05/04/2024 05:57: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 ( '91079' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 05/04/2024 05:57: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 ( '91079' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '2' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '20.00' ) 05/04/2024 05:57: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 ( '91079' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '20' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '25.00' ) 05/04/2024 05:57: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 ( '91079' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '2' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '8.00' ) 05/04/2024 05:57: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 ( '91079' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '71' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '106.50' ) 05/04/2024 05:57: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 ( '91079' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '71' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '88.75' ) 05/04/2024 05:57: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 ( '91079' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '12' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '12.00' ) 05/04/2024 05:57: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 ( '91079' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '16' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '16.00' ) 05/04/2024 05:57: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 ( '91079' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '9' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '36.00' ) 05/04/2024 05:57: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 ( '91079' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '4' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '20.00' ) 05/04/2024 05:57: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 ( '91079' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '12' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '15.00' ) 05/04/2024 05:57: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 ( '91079' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '85' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '340.00' ) 05/04/2024 05:57: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 ( '91079' , '20954' , 'TEMPO DELL’APOCALISSE ' , '4' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '30.00' ) 05/04/2024 05:57: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 ( '91079' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '82' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '114.80' ) 05/04/2024 05:57: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 ( '91079' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '84' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '117.60' ) 05/04/2024 05:57: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 ( '91079' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 05/04/2024 05:57: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 ( '91079' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '27' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '33.75' ) 05/04/2024 05:57: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 ( '91079' , '22151' , 'MA DIO LO HA RISUSCITATO' , '70' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '350.00' ) 05/04/2024 05:57: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 ( '91079' , '22153' , 'UNA VITA CONSUMATA NELLAMORE' , '18' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '54.00' ) 05/04/2024 05:57: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 ( '91079' , '22152' , 'A TE RICORRIAMO' , '193' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '289.50' ) 05/04/2024 05:58:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '17/E' AND id_document != '91079' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-04') 05/04/2024 05:58:38 pm >> UPDATE ps_document SET id_document_type = '22', document_num = '17/E', document_date = '2024-04-04', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'VENDUTO MARZO 2024', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '3125.30', price_tax_excluded = '3124.40', date_upd = NOW() WHERE id_document = '91079' 05/04/2024 05:58:38 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 = '91079' 05/04/2024 05:58:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '91079' 05/04/2024 05:58:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '48' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '57.60' ) 05/04/2024 05:58:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 05/04/2024 05:58: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 ( '91079' , '5457' , 'IO SONO CON VOI 1 PARTE' , '26' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '36.40' ) 05/04/2024 05:58: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 ( '91079' , '5458' , 'IO SONO CON VOI 2 PARTE' , '6' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '8.40' ) 05/04/2024 05:58: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 ( '91079' , '11191' , 'VENITE CON ME 1 PARTE' , '21' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '29.40' ) 05/04/2024 05:58: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 ( '91079' , '11192' , 'VENITE CON ME 2 PARTE' , '19' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '26.60' ) 05/04/2024 05:58: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 ( '91079' , '523' , 'AMORE VINCE LA MORTE - VIA CRUCIS' , '42' , '0' , '4' , '0.8500' , '0.85' , '0' , '50' , '17.85' ) 05/04/2024 05:58: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 ( '91079' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '1' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '4.00' ) 05/04/2024 05:58: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 ( '91079' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '23' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '39.10' ) 05/04/2024 05:58: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 ( '91079' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/04/2024 05:58: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 ( '91079' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '10' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '40.00' ) 05/04/2024 05:58: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 ( '91079' , '6629' , 'MIA PREGHIERA' , '27' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '12.15' ) 05/04/2024 05:58: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 ( '91079' , '8408' , 'PRENDETE E MANGIATE' , '105' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '157.50' ) 05/04/2024 05:58: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 ( '91079' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '4' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '10.00' ) 05/04/2024 05:58: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 ( '91079' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '7' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '17.50' ) 05/04/2024 05:58: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 ( '91079' , '4154' , 'FESTA DEL PERDONO' , '141' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '211.50' ) 05/04/2024 05:58: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 ( '91079' , '2679' , 'CONOSCERE GESU' , '15' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '26.25' ) 05/04/2024 05:58: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 ( '91079' , '2680' , 'CONOSCERE GESU - GUIDA' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 05/04/2024 05:58: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 ( '91079' , '11097' , 'VANGELO E ATTI DEGLI APOSTOLI' , '3' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '7.50' ) 05/04/2024 05:58: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 ( '91079' , '3511' , 'DIO PARLA ALLUOMO' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 05/04/2024 05:58: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 ( '91079' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '0.80' ) 05/04/2024 05:58: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 ( '91079' , '11104' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC. RAGAZZI' , '10' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '8.00' ) 05/04/2024 05:58: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 ( '91079' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '0' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '5.00' ) 05/04/2024 05:58: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 ( '91079' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '1.40' ) 05/04/2024 05:58: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 ( '91079' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '12' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '21.00' ) 05/04/2024 05:58: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 ( '91079' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '18' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '54.00' ) 05/04/2024 05:58: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 ( '91079' , '13956' , 'MIRACOLI DI GESU' , '1' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '1.50' ) 05/04/2024 05:58: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 ( '91079' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 05/04/2024 05:58: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 ( '91079' , '15030' , 'PREGHIERE A SAN MICHELE ARCANGELO' , '9' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '4.50' ) 05/04/2024 05:58: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 ( '91079' , '15019' , 'PREGHIAMO CON MARIA' , '20' , '0' , '4' , '0.8000' , '0.8' , '0' , '50' , '8.00' ) 05/04/2024 05:58: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 ( '91079' , '15020' , 'PREGARE OGNI GIORNO' , '22' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '11.00' ) 05/04/2024 05:58: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 ( '91079' , '16050' , 'BELLEZZA DELLA CELEBRAZIONE EUCARISTICA ' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 05/04/2024 05:58: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 ( '91079' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '8' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '24.00' ) 05/04/2024 05:58: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 ( '91079' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '217' , '0' , '4' , '1.0000' , '1' , '0' , '50' , '108.50' ) 05/04/2024 05:58: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 ( '91079' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '73' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '73.00' ) 05/04/2024 05:58: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 ( '91079' , '16667' , 'VIA CRUCIS' , '2' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '3.00' ) 05/04/2024 05:58: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 ( '91079' , '16997' , 'PREGHIAMO IL PADRONE DELLA MESSE ' , '9' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '11.25' ) 05/04/2024 05:58: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 ( '91079' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '5' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '37.50' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17257' , 'IO TI BATTEZZO ' , '13' , '0' , '4' , '1.8000' , '1.8' , '0' , '50' , '11.70' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '10' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '12.50' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '1.25' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '45' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '42.75' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18528' , 'CON GESU VERSO IL CALVARIO - G. VALSECCHI' , '85' , '0' , '4' , '1.5000' , '1.5' , '0' , '50' , '63.75' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '8' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '28.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '10' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '10.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '2' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '9.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '6' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '36.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '6' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '13.50' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '0' , '4' , '35.0000' , '35' , '0' , '50' , '17.50' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '49' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '49.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20721' , 'AVE MARIA - L. CALABRETTA' , '2' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '4.50' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20722' , 'SEMINATORI DI GIOIA' , '7' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '8.75' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '5' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '6.25' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '2' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '20.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '20' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '25.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '2' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '8.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22028' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - N.E.' , '71' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '106.50' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22031' , 'GLI ULTIMI SARANNO PRIMI - R. LUPI' , '71' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '88.75' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '12' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '12.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '16' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '16.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22033' , 'PRIMA CONFESSIONE E MESSA DI PRIMA COMUNIONE - GUIDA N.E.' , '9' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '36.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22032' , 'ECCO ORA IL MOMENTO FAVOREVOLE ' , '4' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '20.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '12' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '15.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22034' , 'MISTERI DEL ROSARIO - M. DE ROSA' , '85' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '340.00' ) 05/04/2024 05:58:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20954' , 'TEMPO DELL’APOCALISSE ' , '4' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '30.00' ) 05/04/2024 05:58:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20953' , 'VANGELO E ATTI DEGLI APOSTOLI' , '82' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '114.80' ) 05/04/2024 05:58:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '84' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '117.60' ) 05/04/2024 05:58:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 05/04/2024 05:58:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22053' , 'AMO IL SIGNORE, PERCHÉ ASCOLTA IL GRIDO DELLA MIA PREGHIERA' , '27' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '33.75' ) 05/04/2024 05:58:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22151' , 'MA DIO LO HA RISUSCITATO' , '70' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '350.00' ) 05/04/2024 05:58:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22153' , 'UNA VITA CONSUMATA NELLAMORE' , '18' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '54.00' ) 05/04/2024 05:58:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91079' , '22152' , 'A TE RICORRIAMO' , '193' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '289.50' ) 05/04/2024 06:01:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '18/E' AND id_document != '91088' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-04-04') 05/04/2024 06:01:06 pm >> UPDATE ps_document SET id_document_type = '25', document_num = '18/E', document_date = '2024-04-04', document_letter = 'E', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'RESA MARZO 2024', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '14', id_causal = '0', price_tax_included = '2571.95', price_tax_excluded = '2568.34', date_upd = NOW() WHERE id_document = '91088' 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91088' 05/04/2024 06:01:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91088' 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '170' , '0' , '4' , '2.4000' , '2.4' , '0' , '50' , '204.00' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '3' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '5446' , 'IO SONO CON VOI - GUIDA' , '3' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '12.00' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '11183' , 'VENITE CON ME - GUIDA' , '3' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '12.00' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '0' , '4' , '6.2000' , '6.2' , '0' , '50' , '3.10' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '9675' , 'SARETE MIEI TESTIMONI' , '28' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '49.00' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '2869' , 'CREDO, PREGHIERA E IMPEGNO' , '2' , '0' , '4' , '2.1000' , '2.1' , '0' , '50' , '2.10' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '5457' , 'IO SONO CON VOI 1 PARTE' , '27' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '37.80' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '5458' , 'IO SONO CON VOI 2 PARTE' , '27' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '37.80' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '11191' , 'VENITE CON ME 1 PARTE' , '4' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '5.60' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '11192' , 'VENITE CON ME 2 PARTE' , '5' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '7.00' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '17' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '29.75' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '9677' , 'SARETE MIEI TESTIMONI - GUIDA' , '7' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '28.00' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '19' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '32.30' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '2' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '10.00' ) 05/04/2024 06:01:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '1873' , 'CELEBRARE LA PAROLA - ANNO B' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '7' , '0' , '4' , '3.4000' , '3.4' , '0' , '50' , '11.90' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '8515' , 'PRIMI PASSI CON GESÙ ANNO C - GUIDA' , '13' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '32.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '21' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '84.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '6629' , 'MIA PREGHIERA' , '19' , '0' , '4' , '0.9000' , '0.9' , '0' , '50' , '8.55' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '8408' , 'PRENDETE E MANGIATE' , '48' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '72.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '11' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '27.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '3' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '7.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '4154' , 'FESTA DEL PERDONO' , '35' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '52.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '2679' , 'CONOSCERE GESU' , '34' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '59.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '2680' , 'CONOSCERE GESU - GUIDA' , '8' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '24.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '3' , '0' , '4' , '5.0000' , '5' , '0' , '50' , '7.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '10364' , 'SULLA STRADA DEL MAESTRO' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '50' , '7.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '0' , '4' , '1.6000' , '1.6' , '0' , '50' , '0.80' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '2' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '12.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '7543' , 'PARABOLE DI GESÙ' , '5' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '7.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '3' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '5.25' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '8' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '14.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '12819' , 'REGISTRO DEL CATECHISTA ' , '40' , '0' , '1' , '1.0000' , '0.81967213114754' , '22' , '50' , '20.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '12813' , 'MARIA MADRE NOSTRA' , '12' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '18.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '12812' , 'CATECHISTA SECONDO PAPA FRANCESCO' , '2' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '6' , '0' , '4' , '3.5000' , '3.5' , '0' , '50' , '10.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '2' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '6.00' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '15115' , 'CONVERSIONE - G. CELENTANO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '1' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '4.50' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '15019' , 'PREGHIAMO CON MARIA' , '8' , '0' , '4' , '0.8000' , '0.8' , '0' , '50' , '3.20' ) 05/04/2024 06:01:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '16041' , 'PRIMI PASSI NEL CAMMINO DI FEDE - M. VIANI' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '50' , '3.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '8' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '8.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '16667' , 'VIA CRUCIS' , '7' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '10.50' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '17117' , 'MADRE DEL SIGNORE - M. VIANI' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '17274' , 'VENITE BENEDETTI DEL PADRE MIO' , '6' , '0' , '4' , '3.0000' , '3' , '0' , '50' , '9.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '10.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '1' , '0' , '4' , '3.8000' , '3.8' , '0' , '50' , '1.90' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18036' , 'FERITE FERITOIE ' , '8' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '32.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18052' , 'CONVERSAZIONI CON MADRE TERESA - GJERGJI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '6.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18460' , 'CON CUORE DI PADRE - V. SALVOLDI' , '15' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '15.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '4' , '0' , '4' , '1.9000' , '1.9' , '0' , '50' , '3.80' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '17861' , 'CARTA DIDENTITA DELLA CHIESA - R. LUPI' , '4' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '5.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18497' , 'BUONA DOMENICA - ANNO A - G. BAGET BOZZO' , '2' , '0' , '4' , '16.0000' , '16' , '0' , '50' , '16.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18498' , 'BUONA DOMENICA - ANNO B - G. BAGET BOZZO' , '2' , '0' , '4' , '16.0000' , '16' , '0' , '50' , '16.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18499' , 'BUONA DOMENICA - ANNO C - G. BAGET BOZZO' , '4' , '0' , '4' , '16.0000' , '16' , '0' , '50' , '32.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18527' , 'SOGNI DI PACE - V. SALVOLDI' , '21' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '21.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18718' , 'TUA VOCE IN ME + CD - FRA F. MARIA REA' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '7.50' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18657' , 'HO DATO LORO LA TUA PAROLA - TEMPI FORTI- G. VALSECCHI' , '3' , '0' , '4' , '16.0000' , '16' , '0' , '50' , '24.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19050' , 'VENITE ADORIAMO - G. DAMORE' , '3' , '0' , '4' , '7.0000' , '7' , '0' , '50' , '10.50' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18423' , 'VIA DI SAN FRANCESCO - G. POLIDORO' , '2' , '0' , '4' , '4.8000' , '4.8' , '0' , '50' , '4.80' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19159' , 'VOLTI DELLAMORE - V. SALVOLDI' , '7' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '7.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '29' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '130.50' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '22' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '99.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '14' , '0' , '4' , '9.0000' , '9' , '0' , '50' , '63.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '3' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '15.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '5.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '3' , '0' , '4' , '12.0000' , '12' , '0' , '50' , '18.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '10.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '17' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '21.25' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '3' , '0' , '4' , '35.0000' , '35' , '0' , '50' , '52.50' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '19872' , 'CANTO DI LODE AL SIGNORE CHE VIENE - SALVOLDI' , '29' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '36.25' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20231' , 'PREGANDO NON SPRECATE PAROLE - G. DAMORE' , '7' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '35.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20640' , 'GESU, MOSSO A COMPASSIONE V. SALVOLDI' , '22' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '27.50' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20652' , 'VIA CRUCIS CON GLI SCRITTI DI C. LUBICH - G. VALSECCHI' , '8' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '8.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20721' , 'AVE MARIA - L. CALABRETTA' , '7' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '15.75' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20720' , 'PADRE NOSTRO - L. CALABRETTA' , '4' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '9.00' ) 05/04/2024 06:01:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91088' , '20722' , 'SEMINATORI DI GIOIA' , '12' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '15.00' ) 05/04/2024 06:01: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 ( '91088' , '20785' , 'CARTA DIDENTITA DEL CREATO - R. LUPI' , '13' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '16.25' ) 05/04/2024 06:01: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 ( '91088' , '20786' , 'GIUSEPPE DI NAZARET - M. VIANI' , '7' , '0' , '4' , '10.0000' , '10' , '0' , '50' , '35.00' ) 05/04/2024 06:01: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 ( '91088' , '20876' , 'HO DATO LORO LA TUA PAROLA - A/B/C - G. VALSECCHI' , '4' , '0' , '4' , '20.0000' , '20' , '0' , '50' , '40.00' ) 05/04/2024 06:01: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 ( '91088' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '97' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '121.25' ) 05/04/2024 06:01: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 ( '91088' , '21644' , 'INCONTRO AL DIO CHE VIENE' , '48' , '0' , '4' , '8.0000' , '8' , '0' , '50' , '192.00' ) 05/04/2024 06:01: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 ( '91088' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '2' , '0' , '4' , '25.0000' , '25' , '0' , '50' , '25.00' ) 05/04/2024 06:01: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 ( '91088' , '22029' , 'PREPARIAMOCI ALLA PRIMA CONFESSIONE - POSTER' , '4' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '4.00' ) 05/04/2024 06:01: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 ( '91088' , '22030' , 'PREPARIAMOCI ALLA PRIMA COMUNIONE - POSTER' , '4' , '0' , '4' , '2.0000' , '2' , '0' , '50' , '4.00' ) 05/04/2024 06:01: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 ( '91088' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '101' , '0' , '4' , '2.5000' , '2.5' , '0' , '50' , '126.25' ) 05/04/2024 06:01: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 ( '91088' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '32' , '0' , '4' , '2.8000' , '2.8' , '0' , '50' , '44.80' ) 05/04/2024 06:01: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 ( '91088' , '20951' , 'STORIE DEL NOSTRO TEMPO - F. CERRI' , '4' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '30.00' ) 05/04/2024 06:01: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 ( '91088' , '20954' , 'TEMPO DELL’APOCALISSE ' , '11' , '0' , '4' , '15.0000' , '15' , '0' , '50' , '82.50' ) 05/04/2024 06:01: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 ( '91088' , '19728' , 'MOSTRATI MADRE - V. SALVOLDI' , '11' , '0' , '4' , '4.5000' , '4.5' , '0' , '50' , '24.75' ) 05/04/2024 06:10:23 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'fPdkohudfDOYBV3D' , NOW() , NOW() ) 05/04/2024 06:10:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4096' , '1' ) 05/04/2024 06:10:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4096' , '2' ) 05/04/2024 06:10:23 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4096' , '3' ) 05/04/2024 06:11:27 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4096' 05/04/2024 06:11:27 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 ( '4096' , '10' , '210' , '' , 'FISCINA' , 'CARMELINA ' , 'VIA SERCALE' , '' , '84034' , 'PADULA' , '' , '' , '3490617631' , '' , '' , NOW() , NOW() ) 05/04/2024 06:11:27 pm >> UPDATE ps_customer SET email = 'carmelinafiscina@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4096' 05/04/2024 06:12:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '63' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 06:12:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '63' , '2024-04-05' , '' , '4096' , '0' , '4679295' , 'VIA SERCALE 84034 PADULA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '33.50' , '33.50' , NOW() , NOW() ) 05/04/2024 06:12:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91123' 05/04/2024 06:12:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '91123' 05/04/2024 06:12:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91123' , '15020' , 'PREGARE OGNI GIORNO' , '30' , '-30' , '4' , '1.00' , '1' , '0' , '5' , '28.50' ) 05/04/2024 06:18:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1044' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 06:18:15 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' , '1044' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.70' , '22.70' , NOW() , NOW() ) 05/04/2024 06:18:15 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 = '91124' 05/04/2024 06:18:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '91124' 05/04/2024 06:18:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91124' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 05/04/2024 06:18:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91124' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 05/04/2024 06:18:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91124' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.65' , '2.172131147541' , '22' , '0' , '2.65' ) 05/04/2024 06:18:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91124' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 05/04/2024 06:18:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91124' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/04/2024 06:18:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91124' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/04/2024 06:19:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '658' AND id_document != '90643' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 05/04/2024 06:19:24 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '658', document_date = '2024-03-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 = '23.85', price_tax_excluded = '23.64', date_upd = NOW() WHERE id_document = '90643' 05/04/2024 06:19:24 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 = '90643' 05/04/2024 06:19:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '90643' 05/04/2024 06:19:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90643' , '22124' , 'UNA CAREZZA PER TUTTI - R. SEREGNI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 05/04/2024 06:19:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90643' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '6' , '-6' , '4' , '1.00' , '1' , '0' , '0' , '6.00' ) 05/04/2024 06:19:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90643' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '3.50' ) 05/04/2024 06:19:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90643' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 05/04/2024 06:19:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '670' AND id_document != '90656' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 05/04/2024 06:19:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '670', document_date = '2024-03-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 = '2.40', price_tax_excluded = '2.40', date_upd = NOW() WHERE id_document = '90656' 05/04/2024 06:19:37 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90656' 05/04/2024 06:19:37 pm >> DELETE FROM ps_document_detail WHERE id_document = '90656' 05/04/2024 06:19:37 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90656' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 05/04/2024 06:19:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90656' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 05/04/2024 06:19:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '585' AND id_document != '90535' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-28') 05/04/2024 06:19:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '585', document_date = '2024-02-28', 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 = '9.50', price_tax_excluded = '9.50', date_upd = NOW() WHERE id_document = '90535' 05/04/2024 06:19: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 = '90535' 05/04/2024 06:20:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '90535' 05/04/2024 06:20:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90535' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 05/04/2024 06:20:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90535' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '0.75' , '0.75' , '0' , '' , '0.75' ) 05/04/2024 06:20:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90535' , '2777' , 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '0' , '3.00' ) 05/04/2024 06:20:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90535' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 05/04/2024 06:20:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '520' AND id_document != '90443' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-21') 05/04/2024 06:20:14 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '520', document_date = '2024-02-21', 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 = '1.20', price_tax_excluded = '1.20', date_upd = NOW() WHERE id_document = '90443' 05/04/2024 06:20: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 = '90443' 05/04/2024 06:20:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '90443' 05/04/2024 06:20: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 ( '90443' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '2' , '-2' , '4' , '0.6' , '0.6' , '0' , '0' , '1.20' ) 05/04/2024 06:20:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '670' AND id_document != '90656' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-06') 05/04/2024 06:20:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '670', document_date = '2024-03-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 = '2.40', price_tax_excluded = '2.40', date_upd = NOW() WHERE id_document = '90656' 05/04/2024 06:20: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 = '90656' 05/04/2024 06:20:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '90656' 05/04/2024 06:20: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 ( '90656' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '2' , '-2' , '4' , '0.7000' , '0.7' , '0' , '0' , '1.40' ) 05/04/2024 06:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90656' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 05/04/2024 07:17:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '1045' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 07:17: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 ( '11' , '1045' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 05/04/2024 07:17: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 = '91125' 05/04/2024 07:17:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '91125' 05/04/2024 07:17: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 ( '91125' , '22341' , 'SULLA TUA PAROLA - MAG/GIU 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 05/04/2024 07:45:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '1046' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 07:45:32 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' , '1046' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 05/04/2024 07:45:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91126' 05/04/2024 07:45:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '91126' 05/04/2024 07:45:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91126' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 05/04/2024 07:50:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '1034' AND id_document != '91110' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 07:50:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1034', document_date = '2024-04-05', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '113.50', price_tax_excluded = '112.89', date_upd = NOW() WHERE id_document = '91110' 05/04/2024 07:50: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 = '91110' 05/04/2024 07:50:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '91110' 05/04/2024 07:50: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 ( '91110' , '20151' , 'CODICE DI DIRITTO CANONICO - 8 EDIZ.' , '1' , '-1' , '4' , '99.0000' , '99' , '0' , '5' , '94.05' ) 05/04/2024 07:50: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 ( '91110' , '21934' , 'TI VOGLIO BENE - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.9000' , '16.9' , '0' , '5' , '16.05' ) 05/04/2024 07:50: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 ( '91110' , '19298' , 'BIGLIETTO AUGURALE GRANDE' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 05/04/2024 07:50: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 ( '91110' , '18891' , 'ROSARIO LEGNO - R984' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 05/04/2024 07:55:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '1047' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 07:55:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1047' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.80' , '2.30' , NOW() , NOW() ) 05/04/2024 07:55:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91127' 05/04/2024 07:55:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '91127' 05/04/2024 07:55:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91127' , '22352' , 'CROCE CON CORDONCINO COMUNIONE - 42/200-251K' , '2' , '-2' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '2.80' ) 05/04/2024 07:59:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '1048' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-05') 05/04/2024 07:59: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' , '1048' , '2024-04-05' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.20' , '1.80' , NOW() , NOW() ) 05/04/2024 07:59: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 = '91128' 05/04/2024 07:59:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '91128' 05/04/2024 07:59: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 ( '91128' , '15105' , 'ROSARIO BOTTIGLIA - 187' , '1' , '-1' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '2.20' ) 05/04/2024 08:03:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '1004' AND id_document != '91071' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-03') 05/04/2024 08:03:19 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1004', document_date = '2024-04-03', 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 = '51.10', price_tax_excluded = '41.89', date_upd = NOW() WHERE id_document = '91071' 05/04/2024 08:03:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91071' 05/04/2024 08:03:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '91071' 05/04/2024 08:03:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91071' , '20066' , 'CATENINA IN ACCIAIO - NS055' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 05/04/2024 08:03:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91071' , '20064' , 'CATENINA IN ACCIAIO - NS053' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 05/04/2024 08:03:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91071' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '2' , '-2' , '1' , '0.2500' , '0.20491803278689' , '22' , '0' , '0.50' ) 05/04/2024 08:03:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91071' , '3046' , 'CROCE METALLO BUON PASTORE CM 7 - G354' , '1' , '-1' , '1' , '2.6' , '2.1311475409836' , '22' , '0' , '2.60' ) 05/04/2024 08:03:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91071' , '12040' , 'MEDAGLIA MIRACOLOSA GRANDE IN ARGENTO - M058' , '2' , '-2' , '1' , '13.5000' , '11.065573770492' , '22' , '0' , '27.00' ) 05/04/2024 08:03:19 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91071' , '18339' , 'CROCE SAN BENEDETTO - CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '11.0000' , '9.016393442623' , '22' , '0' , '11.00' )