27/09/2022 08:35:20 am >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '5548' 27/09/2022 08:35:20 am >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '5548' 27/09/2022 08:44:01 am >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 08:44:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '25' , '2022-09-27' , '' , '0' , '144' , '4670971' , 'VIA DELLE FRATTE, 3 84080 PELLEZZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1559.62' , '1559.62' , NOW() , NOW() ) 27/09/2022 08:44: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 = '61951' 27/09/2022 08:44:01 am >> DELETE FROM ps_document_detail WHERE id_document = '61951' 27/09/2022 08:44: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 ( '61951' , '6629' , 'MIA PREGHIERA' , '169' , '-169' , '4' , '0.13' , '0.13' , '0' , '0' , '21.97' ) 27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '144' 27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '144' , '1' ) 27/09/2022 08:44: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 ( '61951' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '108' , '-108' , '4' , '3.46' , '3.46' , '0' , '0' , '373.68' ) 27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = '144' 27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '144' , '1' ) 27/09/2022 08:44: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 ( '61951' , '3511' , 'DIO PARLA ALLUOMO' , '117' , '-117' , '4' , '1.17' , '1.17' , '0' , '0' , '136.89' ) 27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '3511' AND id_supplier = '144' 27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3511' , '144' , '1' ) 27/09/2022 08:44: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 ( '61951' , '5251' , 'INCONTRI EUCARISTICI' , '87' , '-87' , '4' , '0.8' , '0.8' , '0' , '0' , '69.60' ) 27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '144' 27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '144' , '1' ) 27/09/2022 08:44: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 ( '61951' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '301' , '-301' , '4' , '0.5' , '0.5' , '0' , '0' , '150.50' ) 27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '19160' AND id_supplier = '144' 27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19160' , '144' , '1' ) 27/09/2022 08:44: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 ( '61951' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '147' , '-147' , '4' , '1.33' , '1.33' , '0' , '0' , '195.51' ) 27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1001' AND id_supplier = '144' 27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1001' , '144' , '1' ) 27/09/2022 08:44: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 ( '61951' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '186' , '-186' , '4' , '1.33' , '1.33' , '0' , '0' , '247.38' ) 27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1002' AND id_supplier = '144' 27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1002' , '144' , '1' ) 27/09/2022 08:44: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 ( '61951' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '153' , '-153' , '4' , '1.33' , '1.33' , '0' , '0' , '203.49' ) 27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '1003' AND id_supplier = '144' 27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1003' , '144' , '1' ) 27/09/2022 08:44: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 ( '61951' , '3978' , 'EUCARISTIA: RITO E VITA' , '146' , '-146' , '4' , '1.1' , '1.1' , '0' , '0' , '160.60' ) 27/09/2022 08:44:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = '144' 27/09/2022 08:44:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '144' , '1' ) 27/09/2022 09:03:37 am >> SELECT document_num FROM ps_document WHERE document_num = '10' AND id_document != '6083' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-22') 27/09/2022 09:03:37 am >> UPDATE ps_document SET id_document_type = '24', document_num = '10', document_date = '2022-09-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670189', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'macero', 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 = '1234.67', price_tax_excluded = '1234.67', date_upd = NOW() WHERE id_document = '6083' 27/09/2022 09:03: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 = '6083' 27/09/2022 09:03:38 am >> DELETE FROM ps_document_detail WHERE id_document = '6083' 27/09/2022 09:03: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 ( '6083' , '23' , 'FATE QUESTO IN MEMORIA DI ME' , '349' , '-349' , '4' , '0.2600' , '0.26' , '0' , '0' , '90.74' ) 27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '23' AND id_supplier = '' 27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '67' , 'CON GESU SULLA VIA DELLA CROCE - VIA CRUCIS ' , '4' , '-4' , '4' , '0.2200' , '0.22' , '0' , '0' , '0.88' ) 27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '67' AND id_supplier = '' 27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '67' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '116' , 'DIZIONARIO DEI SIMBOLI DEL PICCOLO CRISTIANO NE' , '14' , '-14' , '4' , '0.2700' , '0.27' , '0' , '0' , '3.78' ) 27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '116' AND id_supplier = '' 27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '116' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '66' , 'BEATI GLI INVITATI ALLA CENA DEL SIGNORE' , '5' , '-5' , '4' , '0.9000' , '0.9' , '0' , '0' , '4.50' ) 27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '66' AND id_supplier = '' 27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '66' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '127' , 'SPIRITO SANTO SPIEGATO AI RAGAZZI - N.E.' , '13' , '-13' , '4' , '0.5000' , '0.5' , '0' , '0' , '6.50' ) 27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '127' AND id_supplier = '' 27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '127' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '118' , 'Il Credo spiegato ai ragazzi n.e.' , '62' , '-62' , '4' , '0.3000' , '0.3' , '0' , '0' , '18.60' ) 27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '118' AND id_supplier = '' 27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '118' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '25' , 'PICCOLO DIZIONARIO DEL CRISTIANO' , '7' , '-7' , '4' , '0.3500' , '0.35' , '0' , '0' , '2.45' ) 27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '25' AND id_supplier = '' 27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '25' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '21' , 'LA COMUNIONE' , '4' , '-4' , '4' , '0.2600' , '0.26' , '0' , '0' , '1.04' ) 27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '21' AND id_supplier = '' 27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '17' , 'LA FEDE NELLO ZAINETTO' , '3' , '-3' , '4' , '0.4000' , '0.4' , '0' , '0' , '1.20' ) 27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '17' AND id_supplier = '' 27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '103' , 'Lo Spirito Santo raccontato ai ragazzi N.E.' , '3' , '-3' , '4' , '0.3000' , '0.3' , '0' , '0' , '0.90' ) 27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '103' AND id_supplier = '' 27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '103' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '60' , 'IL NATALE SPIEGATO AI BAMBINI' , '31' , '-31' , '4' , '0.3000' , '0.3' , '0' , '0' , '9.30' ) 27/09/2022 09:03:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '60' AND id_supplier = '' 27/09/2022 09:03:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '60' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '47' , 'IL ROSARIO SPIEGATO AI BAMBINI ' , '42' , '-42' , '4' , '0.1900' , '0.19' , '0' , '0' , '7.98' ) 27/09/2022 09:03:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '47' AND id_supplier = '' 27/09/2022 09:03:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '47' , '' , '1' ) 27/09/2022 09:03: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 ( '6083' , '131' , 'LIBRO AGENDA CATTOLICO 2022' , '286' , '-286' , '4' , '3.8000' , '3.8' , '0' , '0' , '1086.80' ) 27/09/2022 09:03:39 am >> DELETE FROM ps_product_supplier WHERE id_product = '131' AND id_supplier = '' 27/09/2022 09:03:39 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '131' , '' , '1' ) 27/09/2022 09:06:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2848' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 09:06:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2848' , '2022-09-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.80' , '8.03' , NOW() , NOW() ) 27/09/2022 09:06:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61952' 27/09/2022 09:06:44 am >> DELETE FROM ps_document_detail WHERE id_document = '61952' 27/09/2022 09:06:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61952' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 27/09/2022 09:06:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 27/09/2022 09:06:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 27/09/2022 09:10:17 am >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '61951' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 09:10:17 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25', document_date = '2022-09-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670971', address1 = 'VIA DELLE FRATTE, 3 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1646.20', price_tax_excluded = '1646.20', date_upd = NOW() WHERE id_document = '61951' 27/09/2022 09:10:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61951' 27/09/2022 09:10:17 am >> DELETE FROM ps_document_detail WHERE id_document = '61951' 27/09/2022 09:10:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '6629' , 'MIA PREGHIERA' , '835' , '-835' , '4' , '0.1300' , '0.13' , '0' , '0' , '108.55' ) 27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 27/09/2022 09:10:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '108' , '-108' , '4' , '3.4600' , '3.46' , '0' , '0' , '373.68' ) 27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = '' 27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' ) 27/09/2022 09:10:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '3511' , 'DIO PARLA ALLUOMO' , '117' , '-117' , '4' , '1.1700' , '1.17' , '0' , '0' , '136.89' ) 27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '3511' AND id_supplier = '' 27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3511' , '' , '1' ) 27/09/2022 09:10:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '5251' , 'INCONTRI EUCARISTICI' , '87' , '-87' , '4' , '0.8000' , '0.8' , '0' , '0' , '69.60' ) 27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 27/09/2022 09:10:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '301' , '-301' , '4' , '0.5000' , '0.5' , '0' , '0' , '150.50' ) 27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '19160' AND id_supplier = '' 27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19160' , '' , '1' ) 27/09/2022 09:10:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '147' , '-147' , '4' , '1.3300' , '1.33' , '0' , '0' , '195.51' ) 27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '1001' AND id_supplier = '' 27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1001' , '' , '1' ) 27/09/2022 09:10:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '186' , '-186' , '4' , '1.3300' , '1.33' , '0' , '0' , '247.38' ) 27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '1002' AND id_supplier = '' 27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1002' , '' , '1' ) 27/09/2022 09:10:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '153' , '-153' , '4' , '1.3300' , '1.33' , '0' , '0' , '203.49' ) 27/09/2022 09:10:18 am >> DELETE FROM ps_product_supplier WHERE id_product = '1003' AND id_supplier = '' 27/09/2022 09:10:18 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1003' , '' , '1' ) 27/09/2022 09:10: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 ( '61951' , '3978' , 'EUCARISTIA: RITO E VITA' , '146' , '-146' , '4' , '1.1000' , '1.1' , '0' , '0' , '160.60' ) 27/09/2022 09:10:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = '' 27/09/2022 09:10:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '' , '1' ) 27/09/2022 09:12:07 am >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '61951' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 09:12:07 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25', document_date = '2022-09-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670971', address1 = 'VIA DELLE FRATTE, 3 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1733.82', price_tax_excluded = '1733.82', date_upd = NOW() WHERE id_document = '61951' 27/09/2022 09:12:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61951' 27/09/2022 09:12:07 am >> DELETE FROM ps_document_detail WHERE id_document = '61951' 27/09/2022 09:12:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '6629' , 'MIA PREGHIERA' , '1509' , '-1509' , '4' , '0.1300' , '0.13' , '0' , '0' , '196.17' ) 27/09/2022 09:12:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 27/09/2022 09:12:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 27/09/2022 09:12:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '1886' , 'CELEBRIAMO CON GIOIA 3A EDIZ. - A. SORRENTINO' , '108' , '-108' , '4' , '3.4600' , '3.46' , '0' , '0' , '373.68' ) 27/09/2022 09:12:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '1886' AND id_supplier = '' 27/09/2022 09:12:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1886' , '' , '1' ) 27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '3511' , 'DIO PARLA ALLUOMO' , '117' , '-117' , '4' , '1.1700' , '1.17' , '0' , '0' , '136.89' ) 27/09/2022 09:12:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '3511' AND id_supplier = '' 27/09/2022 09:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3511' , '' , '1' ) 27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '5251' , 'INCONTRI EUCARISTICI' , '87' , '-87' , '4' , '0.8000' , '0.8' , '0' , '0' , '69.60' ) 27/09/2022 09:12:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 27/09/2022 09:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '301' , '-301' , '4' , '0.5000' , '0.5' , '0' , '0' , '150.50' ) 27/09/2022 09:12:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19160' AND id_supplier = '' 27/09/2022 09:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19160' , '' , '1' ) 27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '147' , '-147' , '4' , '1.3300' , '1.33' , '0' , '0' , '195.51' ) 27/09/2022 09:12:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '1001' AND id_supplier = '' 27/09/2022 09:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1001' , '' , '1' ) 27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '186' , '-186' , '4' , '1.3300' , '1.33' , '0' , '0' , '247.38' ) 27/09/2022 09:12:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '1002' AND id_supplier = '' 27/09/2022 09:12:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1002' , '' , '1' ) 27/09/2022 09:12:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '153' , '-153' , '4' , '1.3300' , '1.33' , '0' , '0' , '203.49' ) 27/09/2022 09:12:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '1003' AND id_supplier = '' 27/09/2022 09:12:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1003' , '' , '1' ) 27/09/2022 09:12:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '3978' , 'EUCARISTIA: RITO E VITA' , '146' , '-146' , '4' , '1.1000' , '1.1' , '0' , '0' , '160.60' ) 27/09/2022 09:12:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = '' 27/09/2022 09:12:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '' , '1' ) 27/09/2022 10:06:27 am >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '61951' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 10:06:27 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25', document_date = '2022-09-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670971', address1 = 'VIA DELLE FRATTE, 3 84080 PELLEZZANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1643.63', price_tax_excluded = '1643.63', date_upd = NOW() WHERE id_document = '61951' 27/09/2022 10:06:27 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 = '61951' 27/09/2022 10:06:27 am >> DELETE FROM ps_document_detail WHERE id_document = '61951' 27/09/2022 10:06: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 ( '61951' , '6629' , 'MIA PREGHIERA' , '1509' , '-1509' , '4' , '0.1300' , '0.13' , '0' , '0' , '196.17' ) 27/09/2022 10:06:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 27/09/2022 10:06:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 27/09/2022 10:06: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 ( '61951' , '3511' , 'DIO PARLA ALLUOMO' , '117' , '-117' , '4' , '1.1700' , '1.17' , '0' , '0' , '136.89' ) 27/09/2022 10:06:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '3511' AND id_supplier = '' 27/09/2022 10:06:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3511' , '' , '1' ) 27/09/2022 10:06: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 ( '61951' , '5251' , 'INCONTRI EUCARISTICI' , '87' , '-87' , '4' , '0.8000' , '0.8' , '0' , '0' , '69.60' ) 27/09/2022 10:06:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 27/09/2022 10:06:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 27/09/2022 10:06: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 ( '61951' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '301' , '-301' , '4' , '0.5000' , '0.5' , '0' , '0' , '150.50' ) 27/09/2022 10:06:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19160' AND id_supplier = '' 27/09/2022 10:06:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19160' , '' , '1' ) 27/09/2022 10:06: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 ( '61951' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '147' , '-147' , '4' , '1.3300' , '1.33' , '0' , '0' , '195.51' ) 27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '1001' AND id_supplier = '' 27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1001' , '' , '1' ) 27/09/2022 10:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '186' , '-186' , '4' , '1.3300' , '1.33' , '0' , '0' , '247.38' ) 27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '1002' AND id_supplier = '' 27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1002' , '' , '1' ) 27/09/2022 10:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '153' , '-153' , '4' , '1.3300' , '1.33' , '0' , '0' , '203.49' ) 27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '1003' AND id_supplier = '' 27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1003' , '' , '1' ) 27/09/2022 10:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '3978' , 'EUCARISTIA: RITO E VITA' , '46' , '-46' , '4' , '1.1000' , '1.1' , '0' , '0' , '50.60' ) 27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = '' 27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '' , '1' ) 27/09/2022 10:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '11426' , 'VITA DEL CRISTIANO' , '100' , '-100' , '4' , '1.1' , '1.1' , '0' , '0' , '110.00' ) 27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '11426' AND id_supplier = '' 27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11426' , '' , '1' ) 27/09/2022 10:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '9970' , 'SIAMO CHIESA' , '183' , '-183' , '4' , '0.87' , '0.87' , '0' , '0' , '159.21' ) 27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '9970' AND id_supplier = '' 27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9970' , '' , '1' ) 27/09/2022 10:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '5457' , 'IO SONO CON VOI 1 PARTE' , '478' , '-478' , '4' , '0.26' , '0.26' , '0' , '0' , '124.28' ) 27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/09/2022 10:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '5458' , 'IO SONO CON VOI 2 PARTE' , '333' , '-333' , '4' , '' , '0' , '0' , '0' , '0.00' ) 27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 27/09/2022 10:06:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '5458' , 'IO SONO CON VOI 2 PARTE' , '333' , '-333' , '4' , '0.26' , '0.26' , '0' , '0' , '86.58' ) 27/09/2022 10:06:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 27/09/2022 10:06:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 27/09/2022 10:07:52 am >> SELECT document_num FROM ps_document WHERE document_num = '25' AND id_document != '61951' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 10:07:53 am >> UPDATE ps_document SET id_document_type = '24', document_num = '25', document_date = '2022-09-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670971', address1 = 'VIA DELLE FRATTE, 3 84080 PELLEZZANO', address2 = '', note = 'MACERO', 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 = '1845.34', price_tax_excluded = '1845.34', date_upd = NOW() WHERE id_document = '61951' 27/09/2022 10:07: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 = '61951' 27/09/2022 10:07:53 am >> DELETE FROM ps_document_detail WHERE id_document = '61951' 27/09/2022 10:07: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 ( '61951' , '6629' , 'MIA PREGHIERA' , '1509' , '-1509' , '4' , '0.1300' , '0.13' , '0' , '0' , '196.17' ) 27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '6629' AND id_supplier = '' 27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6629' , '' , '1' ) 27/09/2022 10:07: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 ( '61951' , '3511' , 'DIO PARLA ALLUOMO' , '117' , '-117' , '4' , '1.1700' , '1.17' , '0' , '0' , '136.89' ) 27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '3511' AND id_supplier = '' 27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3511' , '' , '1' ) 27/09/2022 10:07: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 ( '61951' , '5251' , 'INCONTRI EUCARISTICI' , '87' , '-87' , '4' , '0.8000' , '0.8' , '0' , '0' , '69.60' ) 27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 27/09/2022 10:07: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 ( '61951' , '19160' , 'PERCHE IL DESERTO TORNI A FIORIRE - A. SALVOLDI' , '301' , '-301' , '4' , '0.5000' , '0.5' , '0' , '0' , '150.50' ) 27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19160' AND id_supplier = '' 27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19160' , '' , '1' ) 27/09/2022 10:07: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 ( '61951' , '1001' , 'BEATO CHI ASCOLTA... - ANNO A - B. PREVITALI' , '147' , '-147' , '4' , '1.3300' , '1.33' , '0' , '0' , '195.51' ) 27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '1001' AND id_supplier = '' 27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1001' , '' , '1' ) 27/09/2022 10:07: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 ( '61951' , '1002' , 'BEATO CHI ASCOLTA... - ANNO B - B. PREVITALI' , '186' , '-186' , '4' , '1.3300' , '1.33' , '0' , '0' , '247.38' ) 27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '1002' AND id_supplier = '' 27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1002' , '' , '1' ) 27/09/2022 10:07: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 ( '61951' , '1003' , 'BEATO CHI ASCOLTA... - ANNO C - B. PREVITALI ' , '153' , '-153' , '4' , '1.3300' , '1.33' , '0' , '0' , '203.49' ) 27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '1003' AND id_supplier = '' 27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1003' , '' , '1' ) 27/09/2022 10:07: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 ( '61951' , '3978' , 'EUCARISTIA: RITO E VITA' , '46' , '-46' , '4' , '1.1000' , '1.1' , '0' , '0' , '50.60' ) 27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '3978' AND id_supplier = '' 27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3978' , '' , '1' ) 27/09/2022 10:07: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 ( '61951' , '11426' , 'VITA DEL CRISTIANO' , '100' , '-100' , '4' , '1.1000' , '1.1' , '0' , '0' , '110.00' ) 27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '11426' AND id_supplier = '' 27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11426' , '' , '1' ) 27/09/2022 10:07: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 ( '61951' , '9970' , 'SIAMO CHIESA' , '183' , '-183' , '4' , '0.8700' , '0.87' , '0' , '0' , '159.21' ) 27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '9970' AND id_supplier = '' 27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9970' , '' , '1' ) 27/09/2022 10:07: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 ( '61951' , '5457' , 'IO SONO CON VOI 1 PARTE' , '478' , '-478' , '4' , '0.2600' , '0.26' , '0' , '0' , '124.28' ) 27/09/2022 10:07:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '5457' AND id_supplier = '' 27/09/2022 10:07:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5457' , '' , '1' ) 27/09/2022 10:07:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '5458' , 'IO SONO CON VOI 2 PARTE' , '333' , '-333' , '4' , '0.26' , '0.26' , '0' , '0' , '86.58' ) 27/09/2022 10:07:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 27/09/2022 10:07:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 27/09/2022 10:07:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61951' , '11192' , 'VENITE CON ME 2 PARTE' , '397' , '-397' , '4' , '0.29' , '0.29' , '0' , '0' , '115.13' ) 27/09/2022 10:07:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 27/09/2022 10:07:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 27/09/2022 10:18:28 am >> SELECT document_num FROM ps_document WHERE document_num = '2849' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 10:18:28 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' , '2849' , '2022-09-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '6.00' , NOW() , NOW() ) 27/09/2022 10:18:28 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 = '61953' 27/09/2022 10:18:28 am >> DELETE FROM ps_document_detail WHERE id_document = '61953' 27/09/2022 10:18:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61953' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 27/09/2022 10:18:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 27/09/2022 10:18:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 27/09/2022 10:18:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61953' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '1' , '-1' , '4' , '1.25' , '1.25' , '0' , '' , '1.25' ) 27/09/2022 10:18:28 am >> DELETE FROM ps_product_supplier WHERE id_product = '11103' AND id_supplier = '' 27/09/2022 10:18:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11103' , '' , '1' ) 27/09/2022 10:53:54 am >> SELECT document_num FROM ps_document WHERE document_num = '123' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 10:53:54 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '123' , '2022-09-27' , '' , '3191' , '0' , '4670958' , 'VIA QUINTINO DI VONA 84133 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '54.60' , '52.38' , NOW() , NOW() ) 27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61954' 27/09/2022 10:53:54 am >> DELETE FROM ps_document_detail WHERE id_document = '61954' 27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '10' , '9.00' ) 27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '10' , '3.15' ) 27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '10' , '0.90' ) 27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '10' , '3.15' ) 27/09/2022 10:53:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '10' , '3.15' ) 27/09/2022 10:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '10' , '9.00' ) 27/09/2022 10:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '10' , '9.00' ) 27/09/2022 10:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '10' , '4.50' ) 27/09/2022 10:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '10419' , 'SUPPLICA ALLA REGINA DEL SS. ROSARIO' , '100' , '-100' , '1' , '0.10' , '0.081967213114754' , '22' , '0' , '10.00' ) 27/09/2022 10:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '13840' , 'NONNI SONO UN TESORO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '10' , '1.35' ) 27/09/2022 10:53:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '18222' , 'ROSARIO COLORATO - R316' , '2' , '-2' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '1.40' ) 27/09/2022 11:03:14 am >> SELECT document_num FROM ps_document WHERE document_num = '124' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 11:03: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 ( '21' , '124' , '2022-09-27' , '' , '835' , '0' , '4671989' , 'VIA BRIGNANO INF 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.46' , '31.46' , NOW() , NOW() ) 27/09/2022 11:03: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 = '61955' 27/09/2022 11:03:14 am >> DELETE FROM ps_document_detail WHERE id_document = '61955' 27/09/2022 11:03: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 ( '61955' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.00' , '10' , '0' , '15' , '17.00' ) 27/09/2022 11:03: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 ( '61955' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 27/09/2022 11:03: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 ( '61955' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '15' , '8.50' ) 27/09/2022 11:03: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 ( '61955' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '15' , '2.98' ) 27/09/2022 11:03:31 am >> SELECT document_num FROM ps_document WHERE document_num = '124' AND id_document != '61955' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 11:03:31 am >> UPDATE ps_document SET id_document_type = '21', document_num = '124', document_date = '2022-09-27', document_letter = '', id_customer = '835', id_supplier = '', id_address = '4671989', address1 = 'VIA BRIGNANO INF 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 = '1', id_causal = '0', price_tax_included = '31.46', price_tax_excluded = '31.46', date_upd = NOW() WHERE id_document = '61955' 27/09/2022 11: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 = '61955' 27/09/2022 11:03:31 am >> DELETE FROM ps_document_detail WHERE id_document = '61955' 27/09/2022 11:03: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 ( '61955' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '2' , '-2' , '4' , '10.0000' , '10' , '0' , '15' , '17.00' ) 27/09/2022 11:03:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 27/09/2022 11:03:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 27/09/2022 11: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 ( '61955' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 27/09/2022 11:03:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 27/09/2022 11:03:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 27/09/2022 11: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 ( '61955' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '15' , '8.50' ) 27/09/2022 11:03:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 27/09/2022 11:03:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 27/09/2022 11: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 ( '61955' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '15' , '2.98' ) 27/09/2022 11:03:32 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 27/09/2022 11:03:32 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 27/09/2022 11:10:08 am >> SELECT document_num FROM ps_document WHERE document_num = '123' AND id_document != '61954' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 11:10:08 am >> UPDATE ps_document SET id_document_type = '21', document_num = '123', document_date = '2022-09-27', document_letter = '', id_customer = '3191', id_supplier = '', id_address = '4670958', address1 = 'VIA QUINTINO DI VONA 84133 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '54.60', price_tax_excluded = '52.38', date_upd = NOW() WHERE id_document = '61954' 27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61954' 27/09/2022 11:10:08 am >> DELETE FROM ps_document_detail WHERE id_document = '61954' 27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '10' , '9.00' ) 27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '10' , '3.15' ) 27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '12819' , 'REGISTRO DEL CATECHISTA ' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '10' , '0.90' ) 27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '10' , '3.15' ) 27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '10' , '3.15' ) 27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '10' , '9.00' ) 27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '10' , '9.00' ) 27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 27/09/2022 11:10:08 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '10' , '4.50' ) 27/09/2022 11:10:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 27/09/2022 11:10:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 27/09/2022 11:10:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '10419' , 'SUPPLICA ALLA REGINA DEL SS. ROSARIO' , '100' , '-100' , '1' , '0.1000' , '0.081967213114754' , '22' , '0' , '10.00' ) 27/09/2022 11:10:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '10419' AND id_supplier = '' 27/09/2022 11:10:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10419' , '' , '1' ) 27/09/2022 11:10:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '13840' , 'NONNI SONO UN TESORO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '10' , '1.35' ) 27/09/2022 11:10:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '13840' AND id_supplier = '' 27/09/2022 11:10:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13840' , '' , '1' ) 27/09/2022 11:10:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '18222' , 'ROSARIO COLORATO - R316' , '2' , '-2' , '1' , '0.7000' , '0.57377049180328' , '22' , '0' , '1.40' ) 27/09/2022 11:10:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 27/09/2022 11:10:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 27/09/2022 11:14:26 am >> SELECT document_num FROM ps_document WHERE document_num = '125' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 11:14:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '125' , '2022-09-27' , '' , '3134' , '0' , '4672062' , 'VIA MIGHELANGELO, 2 94013 LEONFORTE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '239.00' , '239.00' , NOW() , NOW() ) 27/09/2022 11:14: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 = '61956' 27/09/2022 11:14:26 am >> DELETE FROM ps_document_detail WHERE id_document = '61956' 27/09/2022 11:14: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 ( '61956' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '6' , '-6' , '4' , '5.50' , '5.5' , '0' , '5' , '31.35' ) 27/09/2022 11:14: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 ( '61956' , '9675' , 'SARETE MIEI TESTIMONI' , '15' , '-15' , '4' , '3.00' , '3' , '0' , '15' , '38.25' ) 27/09/2022 11:14: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 ( '61956' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '15' , '2.13' ) 27/09/2022 11:14: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 ( '61956' , '11193' , 'VENITE CON ME CAT.' , '7' , '-7' , '4' , '5.50' , '5.5' , '0' , '5' , '36.57' ) 27/09/2022 11:14: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 ( '61956' , '11191' , 'VENITE CON ME 1 PARTE' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 27/09/2022 11:14: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 ( '61956' , '11192' , 'VENITE CON ME 2 PARTE' , '15' , '-15' , '4' , '2.50' , '2.5' , '0' , '15' , '31.88' ) 27/09/2022 11:14: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 ( '61956' , '5444' , 'IO SONO CON VOI - CAT.' , '7' , '-7' , '4' , '5.50' , '5.5' , '0' , '5' , '36.57' ) 27/09/2022 11:14: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 ( '61956' , '5458' , 'IO SONO CON VOI 2 PARTE' , '13' , '-13' , '4' , '2.50' , '2.5' , '0' , '15' , '27.63' ) 27/09/2022 11:14: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 ( '61956' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.74' , '2.74' , '0' , '0' , '2.74' ) 27/09/2022 11:32:38 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3134' 27/09/2022 11:32:38 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3134' , '10' , '154' , 'PARROCCHIA MARIA SS. DELLA CATENA' , 'LO GRASSO' , 'DON ANTONINO' , 'VIA MICHELANGELO, 2' , '' , '94013' , 'LEONFORTE' , '' , '0935901388' , '' , '' , '91005260863' , NOW() , NOW() ) 27/09/2022 11:32:38 am >> UPDATE ps_customer SET email = 'antoninolograsso@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3134' 27/09/2022 11:36:23 am >> SELECT document_num FROM ps_document WHERE document_num = '123' AND id_document != '61954' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 11:36:23 am >> UPDATE ps_document SET id_document_type = '21', document_num = '123', document_date = '2022-09-27', document_letter = '', id_customer = '3191', id_supplier = '', id_address = '4670958', address1 = 'VIA QUINTINO DI VONA 84133 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '1', id_causal = '0', price_tax_included = '43.20', price_tax_excluded = '43.20', date_upd = NOW() WHERE id_document = '61954' 27/09/2022 11:36:23 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61954' 27/09/2022 11:36:23 am >> DELETE FROM ps_document_detail WHERE id_document = '61954' 27/09/2022 11:36:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4393' , 'GESÙ CI CHIAMA 1 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '10' , '9.00' ) 27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4393' AND id_supplier = '' 27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4393' , '' , '1' ) 27/09/2022 11:36:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '10' , '3.15' ) 27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4394' AND id_supplier = '' 27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4394' , '' , '1' ) 27/09/2022 11:36:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '10' , '0.90' ) 27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 27/09/2022 11:36:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '10' , '3.15' ) 27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4397' AND id_supplier = '' 27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4397' , '' , '1' ) 27/09/2022 11:36:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '10' , '3.15' ) 27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 27/09/2022 11:36:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4396' , 'GESÙ CI RIVELA IL PADRE 2 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '10' , '9.00' ) 27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4396' AND id_supplier = '' 27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4396' , '' , '1' ) 27/09/2022 11:36:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '10' , '9.00' ) 27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 27/09/2022 11:36:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '4120' , 'FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '10' , '4.50' ) 27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '4120' AND id_supplier = '' 27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4120' , '' , '1' ) 27/09/2022 11:36:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61954' , '13840' , 'NONNI SONO UN TESORO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '10' , '1.35' ) 27/09/2022 11:36:24 am >> DELETE FROM ps_product_supplier WHERE id_product = '13840' AND id_supplier = '' 27/09/2022 11:36:24 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13840' , '' , '1' ) 27/09/2022 12:18:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '125' AND id_document != '61956' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 12:18:00 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '125', document_date = '2022-09-27', document_letter = '', id_customer = '3134', id_supplier = '', id_address = '4672062', address1 = 'VIA MIGHELANGELO, 2 94013 LEONFORTE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '254.84', price_tax_excluded = '254.84', date_upd = NOW() WHERE id_document = '61956' 27/09/2022 12:18:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61956' 27/09/2022 12:18:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '61956' 27/09/2022 12:18: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 ( '61956' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '7' , '-7' , '4' , '5.5000' , '5.5' , '0' , '5' , '36.57' ) 27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9676' AND id_supplier = '' 27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9676' , '' , '1' ) 27/09/2022 12:18: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 ( '61956' , '9675' , 'SARETE MIEI TESTIMONI' , '15' , '-15' , '4' , '3.0000' , '3' , '0' , '15' , '38.25' ) 27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9675' AND id_supplier = '' 27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9675' , '' , '1' ) 27/09/2022 12:18: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 ( '61956' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '15' , '2.13' ) 27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 27/09/2022 12:18: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 ( '61956' , '11193' , 'VENITE CON ME CAT.' , '8' , '-8' , '4' , '5.5000' , '5.5' , '0' , '5' , '41.80' ) 27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11193' AND id_supplier = '' 27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11193' , '' , '1' ) 27/09/2022 12:18: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 ( '61956' , '11191' , 'VENITE CON ME 1 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11191' AND id_supplier = '' 27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11191' , '' , '1' ) 27/09/2022 12:18: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 ( '61956' , '11192' , 'VENITE CON ME 2 PARTE' , '15' , '-15' , '4' , '2.5000' , '2.5' , '0' , '15' , '31.88' ) 27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11192' AND id_supplier = '' 27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11192' , '' , '1' ) 27/09/2022 12:18: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 ( '61956' , '5444' , 'IO SONO CON VOI - CAT.' , '8' , '-8' , '4' , '5.5000' , '5.5' , '0' , '5' , '41.80' ) 27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5444' AND id_supplier = '' 27/09/2022 12:18:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5444' , '' , '1' ) 27/09/2022 12:18: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 ( '61956' , '5458' , 'IO SONO CON VOI 2 PARTE' , '13' , '-13' , '4' , '2.5000' , '2.5' , '0' , '15' , '27.63' ) 27/09/2022 12:18:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5458' AND id_supplier = '' 27/09/2022 12:18:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5458' , '' , '1' ) 27/09/2022 12:18:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61956' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 27/09/2022 12:18:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 27/09/2022 12:18:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 27/09/2022 12:33:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '2850' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 12:33:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2850' , '2022-09-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 27/09/2022 12:33:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61957' 27/09/2022 12:33:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '61957' 27/09/2022 12:33:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61957' , '19429' , 'QUADRO DECORATO 35X29 - RC' , '1' , '-1' , '1' , '48' , '39.344262295082' , '22' , '0' , '48.00' ) 27/09/2022 12:33:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19429' AND id_supplier = '' 27/09/2022 12:33:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19429' , '' , '1' ) 27/09/2022 12:33:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61957' , '16252' , 'CUORE PENDENTE' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 27/09/2022 12:33:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16252' AND id_supplier = '' 27/09/2022 12:33:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16252' , '' , '1' ) 27/09/2022 12:41:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '72/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 12:41:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '72/A' , '2022-09-27' , 'A' , '3030' , '0' , '4671709' , 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '144.00' , '144.00' , NOW() , NOW() ) 27/09/2022 12:41:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61958' 27/09/2022 12:41:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '61958' 27/09/2022 12:41:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61958' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '60' , '-60' , '4' , '2.40' , '2.4' , '0' , '0' , '144.00' ) 27/09/2022 12:47:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2851' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 12:47:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2851' , '2022-09-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.33' , NOW() , NOW() ) 27/09/2022 12:47:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61959' 27/09/2022 12:47:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '61959' 27/09/2022 12:47: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 ( '61959' , '17710' , 'OSTIA MAGNA CM 14 - OM 140' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 27/09/2022 12:47:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17710' AND id_supplier = '' 27/09/2022 12:47:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17710' , '' , '1' ) 27/09/2022 02:43:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788864344065' AND id_product != '19851' AND ean13 != '' 27/09/2022 02:43:27 pm >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '9788864344065', date_upd = NOW() WHERE id_product = '19851' 27/09/2022 02:43:27 pm >> UPDATE ps_product_lang SET name = 'SINODALMENTE', description = '' WHERE id_product = '19851' 27/09/2022 02:43:27 pm >> UPDATE ps_product SET wholesale_price = '15.00', on_sale = '0', price = '20.0000' WHERE id_product = '19851' 27/09/2022 02:43:27 pm >> UPDATE ps_product_shop SET wholesale_price = '15.00', price = '20.0000', id_tax_rules_group = '4', id_category_default = '30', 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 = '19851' 27/09/2022 02:43:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '19851' 27/09/2022 02:43:53 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 27/09/2022 02:43:53 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '505' , '1' ) 27/09/2022 02:43:53 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '505' , '2' ) 27/09/2022 02:43:53 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '505' , '3' ) 27/09/2022 02:43:53 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '505' , '1' , 'NERBINI' , LOWER('NERBINI') ) 27/09/2022 02:43:53 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '505' , '1' , '0' ) 27/09/2022 02:44:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788864344065' AND id_product != '19851' AND ean13 != '' 27/09/2022 02:44:11 pm >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '9788864344065', date_upd = NOW() WHERE id_product = '19851' 27/09/2022 02:44:11 pm >> UPDATE ps_product_lang SET name = 'SINODALMENTE', description = '' WHERE id_product = '19851' 27/09/2022 02:44:11 pm >> UPDATE ps_product SET wholesale_price = '15.00', on_sale = '0', price = '20.0000' WHERE id_product = '19851' 27/09/2022 02:44:11 pm >> UPDATE ps_product_shop SET wholesale_price = '15.00', price = '20.0000', id_tax_rules_group = '4', id_category_default = '505', 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 = '19851' 27/09/2022 02:44:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '19851' 27/09/2022 02:45:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861452091' AND id_product != '19850' AND ean13 != '' 27/09/2022 02:45:10 pm >> UPDATE ps_product SET id_supplier = '7', reference = '', ean13 = '9788861452091', date_upd = NOW() WHERE id_product = '19850' 27/09/2022 02:45:10 pm >> UPDATE ps_product_lang SET name = 'CANTO DI BERNADETTE', description = '' WHERE id_product = '19850' 27/09/2022 02:45:10 pm >> UPDATE ps_product SET wholesale_price = '16.50', on_sale = '0', price = '22.0000' WHERE id_product = '19850' 27/09/2022 02:45:10 pm >> UPDATE ps_product_shop SET wholesale_price = '16.50', price = '22.0000', id_tax_rules_group = '4', id_category_default = '505', 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 = '19850' 27/09/2022 02:45:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '19850' 27/09/2022 02:46:46 pm >> DELETE FROM ps_document WHERE id_document = '61712' 27/09/2022 02:46:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '61712' 27/09/2022 02:47:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001754' AND id_product != '18319' AND ean13 != '' 27/09/2022 02:47:32 pm >> UPDATE ps_product SET id_supplier = '149', reference = '', ean13 = '001754', date_upd = NOW() WHERE id_product = '18319' 27/09/2022 02:47:32 pm >> UPDATE ps_product_lang SET name = 'CALICE IN ARG. g 1170 - 049A', description = '' WHERE id_product = '18319' 27/09/2022 02:47:32 pm >> UPDATE ps_product SET wholesale_price = '1,350.00', on_sale = '0', price = '0.0000' WHERE id_product = '18319' 27/09/2022 02:47:32 pm >> UPDATE ps_product_shop SET wholesale_price = '1,350.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '480', 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 = '18319' 27/09/2022 02:47:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '18319' 27/09/2022 04:40:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2852' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 04:40:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2852' , '2022-09-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '168.00' , '143.66' , NOW() , NOW() ) 27/09/2022 04:40: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 = '61960' 27/09/2022 04:40:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '61960' 27/09/2022 04:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61960' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '500' , '-500' , '1' , '0.27' , '0.22131147540984' , '22' , '0' , '135.00' ) 27/09/2022 04:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19716' AND id_supplier = '' 27/09/2022 04:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19716' , '' , '1' ) 27/09/2022 04:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61960' , '19574' , 'FINO A FARSI FRATELLO DI TUTTI - SALVARANI' , '1' , '-1' , '4' , '14' , '14' , '0' , '0' , '14.00' ) 27/09/2022 04:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19574' AND id_supplier = '' 27/09/2022 04:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19574' , '' , '1' ) 27/09/2022 04:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61960' , '19342' , 'VOLTI DELLA PREGHIERA - R. CHEAIB' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 27/09/2022 04:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19342' AND id_supplier = '' 27/09/2022 04:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19342' , '' , '1' ) 27/09/2022 05:18:37 pm >> SELECT document_num FROM ps_document WHERE document_num = '2227' AND id_document != '59125' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-09') 27/09/2022 05:18:37 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2227', document_date = '2022-07-09', 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.00', price_tax_excluded = '19.03', date_upd = NOW() WHERE id_document = '59125' 27/09/2022 05:18: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 = '59125' 27/09/2022 05:18:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '59125' 27/09/2022 05:18: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 ( '59125' , '8195' , 'GIGLER COMPLETO DORATO - 250 ' , '1' , '-1' , '1' , '4.0000' , '3.2786885245902' , '22' , '0' , '4.00' ) 27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8195' AND id_supplier = '' 27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8195' , '' , '1' ) 27/09/2022 05:18: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 ( '59125' , '564' , 'GIGLER COMPLETO PER ART. 534/536/537 - 249' , '1' , '-1' , '1' , '3.2000' , '2.6229508196721' , '22' , '0' , '3.20' ) 27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '564' AND id_supplier = '' 27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '564' , '' , '1' ) 27/09/2022 05:18: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 ( '59125' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '4.90' ) 27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 27/09/2022 05:18: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 ( '59125' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18176' AND id_supplier = '' 27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18176' , '' , '1' ) 27/09/2022 05:18: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 ( '59125' , '1914' , 'CERA DELLA LITURGIA' , '1' , '-1' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '4.90' ) 27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 27/09/2022 05:18: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 ( '59125' , '8039' , 'PINZE PER CARBONI - PIN ' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8039' AND id_supplier = '' 27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8039' , '' , '1' ) 27/09/2022 05:18: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 ( '59125' , '18216' , 'BRACCIALE PERLA - BC534' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18216' AND id_supplier = '' 27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18216' , '' , '1' ) 27/09/2022 05:18: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 ( '59125' , '7940' , 'PERGAMENE - OCCASIONI MOD. A' , '2' , '-2' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '1.00' ) 27/09/2022 05:18:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7940' AND id_supplier = '' 27/09/2022 05:18:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7940' , '' , '1' ) 27/09/2022 05:19:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '2021' AND id_document != '58874' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-23') 27/09/2022 05:19:16 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2021', document_date = '2022-06-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 = '46.00', price_tax_excluded = '37.70', date_upd = NOW() WHERE id_document = '58874' 27/09/2022 05:19:16 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 = '58874' 27/09/2022 05:19:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '58874' 27/09/2022 05:19:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58874' , '15893' , 'CINGOLO - CING17' , '1' , '-1' , '1' , '46' , '37.704918032787' , '22' , '0' , '46.00' ) 27/09/2022 05:19:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15893' AND id_supplier = '' 27/09/2022 05:19:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15893' , '' , '1' ) 27/09/2022 05:28:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886423687' AND id_product != '8509' AND ean13 != '' 27/09/2022 05:28:05 pm >> UPDATE ps_product SET id_supplier = '53', reference = '4/1', ean13 = '9788886423687', date_upd = NOW() WHERE id_product = '8509' 27/09/2022 05:28:05 pm >> UPDATE ps_product_lang SET name = 'PRIMI PASSI CON GESÙ - ANNO A', description = '

Il sussidio offre una catechesi biblico-liturgica, per bambini di 6-7 anni alla scoperta di Gesù attraverso il Vangelo della domenica.

Il disegno da colorare e le frasi da completare, aiutano i bambini a cogliere il messaggio del Vangelo.

' WHERE id_product = '8509' 27/09/2022 05:28:05 pm >> UPDATE ps_product SET wholesale_price = '0.58', on_sale = '0', price = '3.5' WHERE id_product = '8509' 27/09/2022 05:28:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.58', price = '3.5', id_tax_rules_group = '4', id_category_default = '395', id_argoment_default = '12', id_internal_category = '4', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8509' 27/09/2022 05:28:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '8509' 27/09/2022 05:28:05 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '8509' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 27/09/2022 05:57: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 ( '33' , '347' , '2022-09-22' , '' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '500.00' , '500.00' , NOW() , NOW() ) 27/09/2022 05:57: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 = '61961' 27/09/2022 05:57:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '61961' 27/09/2022 05:57: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 ( '61961' , '19730' , 'RISPONDERE AL NATALE RINASCENDO - V. SALVOLDI' , '200' , '200' , '4' , '2.50' , '2.5' , '0' , '0' , '500.0000' ) 27/09/2022 05:57:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19730' AND id_supplier = '145' 27/09/2022 05:57:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19730' , '145' , '1' ) 27/09/2022 05:59:17 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'xsFaqqN3OZOxKs3I' , NOW() , NOW() ) 27/09/2022 05:59:17 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6981' , '1' ) 27/09/2022 05:59:17 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6981' , '2' ) 27/09/2022 05:59:17 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '6981' , '3' ) 27/09/2022 06:01:12 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6981' 27/09/2022 06:01:12 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 ( '6981' , '10' , '183' , 'PARROCCHIA S. PIETRO AP.' , 'MILO' , 'DON GIUSEPPE' , 'VIA ROMA 52' , '' , '80051' , 'AGEROLA' , '' , '' , '3386115777' , '' , '' , NOW() , NOW() ) 27/09/2022 06:01:12 pm >> UPDATE ps_customer SET email = 'josephum.m@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6981' 27/09/2022 06:02:49 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'VReDG9l41Jrv9454' , NOW() , NOW() ) 27/09/2022 06:02:49 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3908' , '1' ) 27/09/2022 06:02:49 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3908' , '2' ) 27/09/2022 06:02:49 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3908' , '3' ) 27/09/2022 06:04:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2853' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 06:04:26 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' , '2853' , '2022-09-27' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.70' , '12.05' , NOW() , NOW() ) 27/09/2022 06:04:26 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 = '61962' 27/09/2022 06:04:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '61962' 27/09/2022 06:04:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61962' , '1914' , 'CERA DELLA LITURGIA' , '3' , '-3' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '14.70' ) 27/09/2022 06:04:26 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 27/09/2022 06:04:26 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 27/09/2022 06:06:10 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3908' 27/09/2022 06:06:10 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 ( '3908' , '10' , '183' , 'PARROCCHIA SAN PIETRO AP.' , 'MILO' , 'DON GIUSEPPE' , 'VIA ROMA 52' , '' , '80051' , 'AGEROLA' , '' , '' , '3386115777' , '' , '' , NOW() , NOW() ) 27/09/2022 06:06:10 pm >> UPDATE ps_customer SET email = 'josephum.m@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3908' 27/09/2022 06:08:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '126' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 06:08: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 ( '21' , '126' , '2022-09-27' , '' , '3908' , '0' , '4674904' , 'VIA ROMA 52 80051 AGEROLA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.51' , '53.51' , NOW() , NOW() ) 27/09/2022 06:08: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 = '61963' 27/09/2022 06:08:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '61963' 27/09/2022 06:08: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 ( '61963' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '0' , '12.00' , '12' , '' , '5' , '22.80' ) 27/09/2022 06:08: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 ( '61963' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '5' , '2.38' ) 27/09/2022 06:08: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 ( '61963' , '12819' , 'REGISTRO DEL CATECHISTA ' , '12' , '-12' , '0' , '1.00' , '1' , '' , '5' , '11.40' ) 27/09/2022 06:08: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 ( '61963' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 27/09/2022 06:08: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 ( '61963' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 27/09/2022 06:08: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 ( '61963' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 27/09/2022 06:10:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '127' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 06:10:27 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' , '127' , '2022-09-27' , '' , '284' , '0' , '4671723' , 'VIA GUIDO D\\\'AREZZO snc 92027 LICATA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '395.25' , '395.25' , NOW() , NOW() ) 27/09/2022 06:10:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61964' 27/09/2022 06:10:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '61964' 27/09/2022 06:10:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61964' , '18176' , 'ANTIQUUM MINISTERIUM - PAPA FRANCESCO' , '10' , '-10' , '4' , '1.00' , '1' , '0' , '15' , '8.50' ) 27/09/2022 06:10:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61964' , '12819' , 'REGISTRO DEL CATECHISTA ' , '10' , '-10' , '0' , '1.00' , '1' , '' , '15' , '8.50' ) 27/09/2022 06:10:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61964' , '5457' , 'IO SONO CON VOI 1 PARTE' , '80' , '-80' , '4' , '2.50' , '2.5' , '0' , '15' , '170.00' ) 27/09/2022 06:10:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61964' , '11192' , 'VENITE CON ME 2 PARTE' , '80' , '-80' , '4' , '2.50' , '2.5' , '0' , '15' , '170.00' ) 27/09/2022 06:10:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61964' , '14223' , 'PRONTUARIO BIBLICO - LITURGICO - F. GIGLIO' , '5' , '-5' , '4' , '9.00' , '9' , '0' , '15' , '38.25' ) 27/09/2022 06:10:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '126' AND id_document != '61963' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-09-27') 27/09/2022 06:10:54 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '126', document_date = '2022-09-27', document_letter = '', id_customer = '3908', id_supplier = '', id_address = '4674904', address1 = 'VIA ROMA 52 80051 AGEROLA', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '53.51', price_tax_excluded = '53.51', date_upd = NOW() WHERE id_document = '61963' 27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61963' 27/09/2022 06:10:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '61963' 27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61963' , '16603' , 'LIBRO INTENZIONI SANTE MESSE' , '2' , '-2' , '0' , '12.0000' , '12' , '0' , '5' , '22.80' ) 27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16603' AND id_supplier = '' 27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16603' , '' , '1' ) 27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61963' , '2880' , 'CRESIMA: UN DONO E UN PROGETTO' , '1' , '-1' , '4' , '2.5000' , '2.5' , '0' , '5' , '2.38' ) 27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2880' AND id_supplier = '' 27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2880' , '' , '1' ) 27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61963' , '12819' , 'REGISTRO DEL CATECHISTA ' , '12' , '-12' , '0' , '1.0000' , '1' , '0' , '5' , '11.40' ) 27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12819' AND id_supplier = '' 27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12819' , '' , '1' ) 27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61963' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.0000' , '6' , '0' , '5' , '5.70' ) 27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12842' AND id_supplier = '' 27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12842' , '' , '1' ) 27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61963' , '1829' , 'CATECHISMO PRIMARIO DEI SACRAMENTI' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1829' AND id_supplier = '' 27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1829' , '' , '1' ) 27/09/2022 06:10:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61963' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 27/09/2022 06:10:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 27/09/2022 06:10:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' )