11/01/2023 09:12:08 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'HTETbEnfZdIc5BCE' , NOW() , NOW() ) 11/01/2023 09:12:08 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3998' , '1' ) 11/01/2023 09:12:08 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3998' , '2' ) 11/01/2023 09:12:08 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3998' , '3' ) 11/01/2023 09:14:23 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3998' 11/01/2023 09:14:23 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3998' , '10' , '200' , 'PARR. SANTA MARIA IN CIELO ASSUNTA' , 'PETROCELLI' , 'DON DOMENICO' , 'VIA TEMPIO' , '' , '85050' , 'SARCONI' , '' , '' , '' , '' , '94000430762' , NOW() , NOW() ) 11/01/2023 09:14:23 am >> UPDATE ps_customer SET email = 'petrocelli.don@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3998' 11/01/2023 09:20:45 am >> SELECT document_num FROM ps_document WHERE document_num = '5' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-11') 11/01/2023 09:20:45 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' , '5' , '2023-01-11' , '' , '3998' , '0' , '4678092' , 'VIA TEMPIO 85050 SARCONI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '75.06' , '75.06' , NOW() , NOW() ) 11/01/2023 09:20:45 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 = '78252' 11/01/2023 09:20:45 am >> DELETE FROM ps_document_detail WHERE id_document = '78252' 11/01/2023 09:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78252' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '0' , '40.00' , '40' , '' , '15' , '34.00' ) 11/01/2023 09:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78252' , '8509' , 'PRIMI PASSI CON GESÙ - ANNO A' , '10' , '-10' , '4' , '3.50' , '3.5' , '0' , '15' , '29.75' ) 11/01/2023 09:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78252' , '8513' , 'PRIMI PASSI CON GESÙ ANNO A - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 11/01/2023 09:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78252' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '15' , '1.70' ) 11/01/2023 09:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78252' , '17695' , 'VIA LUCIS CON SAN CESARE DE BUS' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '15' , '3.23' ) 11/01/2023 09:20:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78252' , '17696' , 'VIA CRUCIS CON SAN CESARE DE BUS' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '15' , '2.13' ) 11/01/2023 09:36:23 am >> SELECT document_num FROM ps_document WHERE document_num = '108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-11') 11/01/2023 09:36:23 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '108' , '2023-01-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.40' , '82.30' , NOW() , NOW() ) 11/01/2023 09: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 = '78253' 11/01/2023 09:36:23 am >> DELETE FROM ps_document_detail WHERE id_document = '78253' 11/01/2023 09:36:23 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78253' , '17161' , 'CARBONCINI NERI - CARNE' , '2' , '-2' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '24.00' ) 11/01/2023 09: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 ( '78253' , '17160' , 'CARBONCINI ROSSI - CARRO' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 11/01/2023 09: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 ( '78253' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 11/01/2023 10:14:13 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3998' 11/01/2023 10:14:13 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 ( '3998' , '10' , '200' , 'PARR. SANTA MARIA IN CIELO ASSUNTA' , 'PETROCELLI' , 'DON DOMENICO' , 'VIA TEMPIO' , '' , '85050' , 'SARCONI' , 'spedizione: Petrocelli don Domenico\r\nVia G. Amendola, 135\r\n85047 MOLITERNO (PZ)\r\nCell. 339 8141840\r\n' , '' , '' , '' , '94000430762' , NOW() , NOW() ) 11/01/2023 10:14:13 am >> UPDATE ps_customer SET email = 'petrocelli.don@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3998' 11/01/2023 10:14:25 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3998' 11/01/2023 10:14:25 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 ( '3998' , '10' , '200' , 'PARR. SANTA MARIA IN CIELO ASSUNTA' , 'PETROCELLI' , 'DON DOMENICO' , 'VIA TEMPIO' , '' , '85050' , 'SARCONI' , 'spedizione: Petrocelli don Domenico\r\nVia G. Amendola, 135\r\n85047 MOLITERNO (PZ)\r\nCell. 339 8141840\r\n' , '' , '339 8141840' , '' , '94000430762' , NOW() , NOW() ) 11/01/2023 10:14:25 am >> UPDATE ps_customer SET email = 'petrocelli.don@tiscali.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3998' 11/01/2023 10:27:37 am >> SELECT document_num FROM ps_document WHERE document_num = '109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-11') 11/01/2023 10:27:37 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' , '109' , '2023-01-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '35.00' , '28.69' , NOW() , NOW() ) 11/01/2023 10:27: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 = '78254' 11/01/2023 10:27:37 am >> DELETE FROM ps_document_detail WHERE id_document = '78254' 11/01/2023 10:27:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78254' , '18045' , 'TECA INCISA - 515' , '1' , '-1' , '1' , '29.00' , '23.770491803279' , '22' , '0' , '29.00' ) 11/01/2023 10:27:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78254' , '14167' , 'BORSETTA PORTA TECA ' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 11/01/2023 10:29:55 am >> SELECT document_num FROM ps_document WHERE document_num = '109' AND id_document != '78254' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-11') 11/01/2023 10:29:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '109', document_date = '2023-01-11', 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 = '35.00', price_tax_excluded = '28.69', date_upd = NOW() WHERE id_document = '78254' 11/01/2023 10:29:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78254' 11/01/2023 10:29:55 am >> DELETE FROM ps_document_detail WHERE id_document = '78254' 11/01/2023 10:29: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 ( '78254' , '18045' , 'TECA INCISA - 515' , '1' , '-1' , '1' , '29.0000' , '23.770491803279' , '22' , '0' , '29.00' ) 11/01/2023 10:29: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 ( '78254' , '8197' , 'PORTATECA - 059' , '1' , '-1' , '1' , '6' , '4.9180327868852' , '22' , '0' , '6.00' ) 11/01/2023 10:34:12 am >> SELECT document_num FROM ps_document WHERE document_num = '110' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-11') 11/01/2023 10:34:12 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' , '110' , '2023-01-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 11/01/2023 10:34:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78255' 11/01/2023 10:34:12 am >> DELETE FROM ps_document_detail WHERE id_document = '78255' 11/01/2023 10:34:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78255' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '5' , '-5' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '11.00' ) 11/01/2023 10:55:32 am >> SELECT document_num FROM ps_document WHERE document_num = '111' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-11') 11/01/2023 10:55:32 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' , '111' , '2023-01-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.40' , '8.40' , NOW() , NOW() ) 11/01/2023 10:55:32 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 = '78256' 11/01/2023 10:55:32 am >> DELETE FROM ps_document_detail WHERE id_document = '78256' 11/01/2023 10:55: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 ( '78256' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '12' , '-12' , '4' , '0.70' , '0.7' , '0' , '0' , '8.40' ) 11/01/2023 11:23:57 am >> SELECT document_num FROM ps_document WHERE document_num = '112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-11') 11/01/2023 11:23:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '112' , '2023-01-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.26' , '12.26' , NOW() , NOW() ) 11/01/2023 11:23:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78257' 11/01/2023 11:23:57 am >> DELETE FROM ps_document_detail WHERE id_document = '78257' 11/01/2023 11:23:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78257' , '19501' , 'PACE INTERIORE - C. AMIRANTE' , '1' , '-1' , '4' , '12.90' , '12.9' , '0' , '5' , '12.26' ) 11/01/2023 11:45:06 am >> SELECT document_num FROM ps_document WHERE document_num = '113' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-11') 11/01/2023 11:45:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '113' , '2023-01-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '80.00' , '66.30' , NOW() , NOW() ) 11/01/2023 11:45:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78258' 11/01/2023 11:45:06 am >> DELETE FROM ps_document_detail WHERE id_document = '78258' 11/01/2023 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78258' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '0' , '4.00' ) 11/01/2023 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78258' , '11624' , 'PALLA 16X16 - SERV 3 ' , '2' , '-2' , '1' , '5.90' , '4.8360655737705' , '22' , '0' , '11.80' ) 11/01/2023 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78258' , '20522' , 'CROCE BASE NIK - 105 ALV' , '2' , '-2' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '5.00' ) 11/01/2023 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78258' , '10501' , 'TECA STANDARD IHS ' , '2' , '-2' , '1' , '23.1' , '18.934426229508' , '22' , '0' , '46.20' ) 11/01/2023 11:45:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78258' , '8197' , 'PORTATECA - 059' , '2' , '-2' , '1' , '6.50' , '5.327868852459' , '22' , '0' , '13.00' ) 11/01/2023 11:51:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '503SAL' AND id_product != '10501' AND ean13 != '' 11/01/2023 11:51:20 am >> UPDATE ps_product SET id_supplier = '71', reference = '2014', ean13 = '503SAL', date_upd = NOW() WHERE id_product = '10501' 11/01/2023 11:51:20 am >> UPDATE ps_product_lang SET name = 'TECA STANDARD IHS ', description = '' WHERE id_product = '10501' 11/01/2023 11:51:20 am >> UPDATE ps_product SET wholesale_price = '7.74', on_sale = '0', price = '20.491803278688526' WHERE id_product = '10501' 11/01/2023 11:51:20 am >> UPDATE ps_product_shop SET wholesale_price = '7.74', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '184', 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 = '10501' 11/01/2023 11:51:20 am >> DELETE FROM ps_specific_price WHERE id_product = '10501' 11/01/2023 12:12:07 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 11/01/2023 12:12:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20615' , '1' , '' , 'nuovo-prodotto' ) 11/01/2023 12:12:07 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20615' , '1' , '1' , '2' , NOW() , NOW() ) 11/01/2023 12:12:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20615' , '0' , '1' , '0' , '0' ) 11/01/2023 12:12:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '882630744X' AND id_product != '20615' AND ean13 != '' 11/01/2023 12:12:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '882630744X', date_upd = NOW() WHERE id_product = '20615' 11/01/2023 12:12:56 pm >> UPDATE ps_product_lang SET name = 'OGNI GIORNO UN\'ALBA', description = '' WHERE id_product = '20615' 11/01/2023 12:12:56 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.5' WHERE id_product = '20615' 11/01/2023 12:12:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.5', id_tax_rules_group = '4', id_category_default = '201', 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 = '20615' 11/01/2023 12:12:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '20615' 11/01/2023 12:12:57 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20615' 11/01/2023 12:12:57 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20616' , '1' , '' , 'nuovo-prodotto' ) 11/01/2023 12:12:57 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20616' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20615' 11/01/2023 12:12:57 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20616' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20615' 11/01/2023 12:13:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830803978' AND id_product != '20616' AND ean13 != '' 11/01/2023 12:13:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788830803978', date_upd = NOW() WHERE id_product = '20616' 11/01/2023 12:13:47 pm >> UPDATE ps_product_lang SET name = 'VANGELO DELLA GIOIA', description = '' WHERE id_product = '20616' 11/01/2023 12:13:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20616' 11/01/2023 12:13:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '11', 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 = '20616' 11/01/2023 12:13:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '20616' 11/01/2023 12:13:49 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20616' 11/01/2023 12:13:49 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20617' , '1' , '' , 'nuovo-prodotto' ) 11/01/2023 12:13:49 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20617' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20616' 11/01/2023 12:13:49 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20617' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20616' 11/01/2023 12:15:39 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788894557510' AND id_product != '20617' AND ean13 != '' 11/01/2023 12:15:39 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788894557510', date_upd = NOW() WHERE id_product = '20617' 11/01/2023 12:15:39 pm >> UPDATE ps_product_lang SET name = 'PASQUA - BENEDETTO XVI', description = '' WHERE id_product = '20617' 11/01/2023 12:15:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28' WHERE id_product = '20617' 11/01/2023 12:15:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28', id_tax_rules_group = '4', id_category_default = '475', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20617' 11/01/2023 12:15:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '20617' 11/01/2023 12:15:40 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '20617' 11/01/2023 12:15:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20618' , '1' , '' , 'nuovo-prodotto' ) 11/01/2023 12:15:40 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20618' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20617' 11/01/2023 12:15:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20618' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20617' 11/01/2023 12:16:58 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' , '2023000000125' , '2023-01-10' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.17' , '150.17' , NOW() , NOW() ) 11/01/2023 12:16:58 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 = '78259' 11/01/2023 12:16:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '78259' 11/01/2023 12:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78259' , '20615' , 'OGNI GIORNO UNALBA' , '1' , '1' , '4' , '12.50' , '12.5' , '0' , '35' , '8.1250' ) 11/01/2023 12:16:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20615' AND id_supplier = '107' 11/01/2023 12:16:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20615' , '107' , '1' ) 11/01/2023 12:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78259' , '20616' , 'VANGELO DELLA GIOIA' , '1' , '1' , '4' , '10.00' , '10' , '0' , '35' , '6.5000' ) 11/01/2023 12:16:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20616' AND id_supplier = '107' 11/01/2023 12:16:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20616' , '107' , '1' ) 11/01/2023 12:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78259' , '18311' , 'ANDATE E FATE IN MODO ... ANNO A - E. DELLA CORTE' , '1' , '1' , '4' , '27.00' , '27' , '0' , '35' , '17.5500' ) 11/01/2023 12:16:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18311' AND id_supplier = '107' 11/01/2023 12:16:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18311' , '107' , '1' ) 11/01/2023 12:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78259' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '3' , '3' , '4' , '14.80' , '14.8' , '0' , '35' , '28.8600' ) 11/01/2023 12:16:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20150' AND id_supplier = '107' 11/01/2023 12:16:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20150' , '107' , '1' ) 11/01/2023 12:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78259' , '20617' , 'PASQUA - BENEDETTO XVI' , '1' , '1' , '4' , '28.00' , '28' , '0' , '35' , '18.2000' ) 11/01/2023 12:16:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20617' AND id_supplier = '107' 11/01/2023 12:16:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20617' , '107' , '1' ) 11/01/2023 12:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78259' , '18075' , 'PER CRUCEM AD LUCEM - J. RATZINGER' , '2' , '2' , '4' , '12.00' , '12' , '0' , '35' , '15.6000' ) 11/01/2023 12:16:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18075' AND id_supplier = '107' 11/01/2023 12:16:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18075' , '107' , '1' ) 11/01/2023 12:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78259' , '4229' , 'FONTI FRANCESCANE - ED. MINOR' , '2' , '2' , '4' , '32.00' , '32' , '0' , '35' , '41.6000' ) 11/01/2023 12:16:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4229' AND id_supplier = '107' 11/01/2023 12:16:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4229' , '107' , '1' ) 11/01/2023 12:16:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78259' , '8469' , 'PRETE UNO SPOSO - BONETTI/PEDROLI' , '1' , '1' , '4' , '11.90' , '11.9' , '0' , '35' , '7.7350' ) 11/01/2023 12:16:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8469' AND id_supplier = '107' 11/01/2023 12:16:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8469' , '107' , '1' ) 11/01/2023 03:59:21 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '18697' 11/01/2023 03:59:21 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '18697' 11/01/2023 04:09:25 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '11849' 11/01/2023 04:09:25 pm >> UPDATE ps_stock_available SET quantity = quantity + '-1' WHERE id_product = '11849' 11/01/2023 04:10:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801063646' AND id_product != '13259' AND ean13 != '' 11/01/2023 04:10:13 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/1', ean13 = '9788801063646', date_upd = NOW() WHERE id_product = '13259' 11/01/2023 04:10:13 pm >> UPDATE ps_product_lang SET name = 'CHIESA - G. ALBANO', description = '' WHERE id_product = '13259' 11/01/2023 04:10:13 pm >> UPDATE ps_product SET wholesale_price = '14.30', on_sale = '0', price = '22.0000' WHERE id_product = '13259' 11/01/2023 04:10:13 pm >> UPDATE ps_product_shop SET wholesale_price = '14.30', price = '22.0000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13259' 11/01/2023 04:10:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '13259' 11/01/2023 04:18:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892226517' AND id_product != '19020' AND ean13 != '' 11/01/2023 04:18:35 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788892226517', date_upd = NOW() WHERE id_product = '19020' 11/01/2023 04:18:35 pm >> UPDATE ps_product_lang SET name = 'TEOLOGIA SPIRITUALE - C.A. BERNARD', description = '' WHERE id_product = '19020' 11/01/2023 04:18:35 pm >> UPDATE ps_product SET wholesale_price = '33.50', on_sale = '0', price = '50.0000' WHERE id_product = '19020' 11/01/2023 04:18:35 pm >> UPDATE ps_product_shop SET wholesale_price = '33.50', price = '50.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19020' 11/01/2023 04:18:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '19020' 11/01/2023 04:19:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892226517' AND id_product != '19020' AND ean13 != '' 11/01/2023 04:19:50 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788892226517', date_upd = NOW() WHERE id_product = '19020' 11/01/2023 04:19:50 pm >> UPDATE ps_product_lang SET name = 'TEOLOGIA SPIRITUALE - C.A. BERNARD', description = '' WHERE id_product = '19020' 11/01/2023 04:19:50 pm >> UPDATE ps_product SET wholesale_price = '33.50', on_sale = '0', price = '50.0000' WHERE id_product = '19020' 11/01/2023 04:19:50 pm >> UPDATE ps_product_shop SET wholesale_price = '33.50', price = '50.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19020' 11/01/2023 04:19:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '19020' 11/01/2023 04:20:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821573293' AND id_product != '3528' AND ean13 != '' 11/01/2023 04:20:16 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788821573293', date_upd = NOW() WHERE id_product = '3528' 11/01/2023 04:20:16 pm >> UPDATE ps_product_lang SET name = 'DIO VIVO E VERO - L. F. LADARIA', description = '' WHERE id_product = '3528' 11/01/2023 04:20:16 pm >> UPDATE ps_product SET wholesale_price = '39.53', on_sale = '0', price = '59.0000' WHERE id_product = '3528' 11/01/2023 04:20:16 pm >> UPDATE ps_product_shop SET wholesale_price = '39.53', price = '59.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3528' 11/01/2023 04:20:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '3528' 11/01/2023 04:20:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788868794583' AND id_product != '12353' AND ean13 != '' 11/01/2023 04:20:44 pm >> UPDATE ps_product SET id_supplier = '109', reference = '13/7', ean13 = '9788868794583', date_upd = NOW() WHERE id_product = '12353' 11/01/2023 04:20:44 pm >> UPDATE ps_product_lang SET name = 'VERITA\' E\' SINTETICA - M. GAGLIARDI', description = '' WHERE id_product = '12353' 11/01/2023 04:20:44 pm >> UPDATE ps_product SET wholesale_price = '20.99', on_sale = '0', price = '30.0000' WHERE id_product = '12353' 11/01/2023 04:20:45 pm >> UPDATE ps_product_shop SET wholesale_price = '20.99', price = '30.0000', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12353' 11/01/2023 04:20:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '12353' 11/01/2023 04:21:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839921987' AND id_product != '15234' AND ean13 != '' 11/01/2023 04:21:05 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/7', ean13 = '9788839921987', date_upd = NOW() WHERE id_product = '15234' 11/01/2023 04:21:05 pm >> UPDATE ps_product_lang SET name = 'INTRODUZIONE ALLA TEOLOGIA - B. SESBOUE\'', description = '' WHERE id_product = '15234' 11/01/2023 04:21:05 pm >> UPDATE ps_product SET wholesale_price = '11.20', on_sale = '0', price = '16.0000' WHERE id_product = '15234' 11/01/2023 04:21:05 pm >> UPDATE ps_product_shop SET wholesale_price = '11.20', price = '16.0000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15234' 11/01/2023 04:21:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '15234' 11/01/2023 04:21:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788883338496' AND id_product != '16643' AND ean13 != '' 11/01/2023 04:21:19 pm >> UPDATE ps_product SET id_supplier = '107', reference = '13/7', ean13 = '9788883338496', date_upd = NOW() WHERE id_product = '16643' 11/01/2023 04:21:19 pm >> UPDATE ps_product_lang SET name = 'GESU\', COSCIENZA, LIBERTA\' - A. DUCAY', description = '' WHERE id_product = '16643' 11/01/2023 04:21:19 pm >> UPDATE ps_product SET wholesale_price = '9.75', on_sale = '0', price = '15.0000' WHERE id_product = '16643' 11/01/2023 04:21:19 pm >> UPDATE ps_product_shop SET wholesale_price = '9.75', price = '15.0000', id_tax_rules_group = '4', id_category_default = '272', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16643' 11/01/2023 04:21:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '16643' 11/01/2023 04:22:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810506950' AND id_product != '7879' AND ean13 != '' 11/01/2023 04:22:24 pm >> UPDATE ps_product SET id_supplier = '109', reference = '13/6', ean13 = '9788810506950', date_upd = NOW() WHERE id_product = '7879' 11/01/2023 04:22:24 pm >> UPDATE ps_product_lang SET name = 'PERCHÉ NON MUOIA LA SPERANZA - PER SACERDOTI E RELIGIOSI', description = '' WHERE id_product = '7879' 11/01/2023 04:22:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.7000' WHERE id_product = '7879' 11/01/2023 04:22:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.7000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '36', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7879' 11/01/2023 04:22:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '7879' 11/01/2023 04:22:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788810506950' AND id_product != '7879' AND ean13 != '' 11/01/2023 04:22:37 pm >> UPDATE ps_product SET id_supplier = '109', reference = '13/6', ean13 = '9788810506950', date_upd = NOW() WHERE id_product = '7879' 11/01/2023 04:22:38 pm >> UPDATE ps_product_lang SET name = 'PERCHÉ NON MUOIA LA SPERANZA - PER SACERDOTI E RELIGIOSI', description = '' WHERE id_product = '7879' 11/01/2023 04:22:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12.7000' WHERE id_product = '7879' 11/01/2023 04:22:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12.7000', id_tax_rules_group = '4', id_category_default = '9', id_argoment_default = '36', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7879' 11/01/2023 04:22:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '7879' 11/01/2023 04:23:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791259620675' AND id_product != '19048' AND ean13 != '' 11/01/2023 04:23:06 pm >> UPDATE ps_product SET id_supplier = '109', reference = '13/7', ean13 = '9791259620675', date_upd = NOW() WHERE id_product = '19048' 11/01/2023 04:23:06 pm >> UPDATE ps_product_lang SET name = 'CELIBATO E CONTINENZA ECCLESIALI - C. BONIVENTO', description = '' WHERE id_product = '19048' 11/01/2023 04:23:07 pm >> UPDATE ps_product SET wholesale_price = '14.29', on_sale = '0', price = '22.0000' WHERE id_product = '19048' 11/01/2023 04:23:07 pm >> UPDATE ps_product_shop SET wholesale_price = '14.29', price = '22.0000', id_tax_rules_group = '4', id_category_default = '143', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19048' 11/01/2023 04:23:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '19048' 11/01/2023 04:23:36 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869297359' AND id_product != '18792' AND ean13 != '' 11/01/2023 04:23:36 pm >> UPDATE ps_product SET id_supplier = '109', reference = '13/7', ean13 = '9788869297359', date_upd = NOW() WHERE id_product = '18792' 11/01/2023 04:23:36 pm >> UPDATE ps_product_lang SET name = 'ECCO IO FACCIO NUOVE TUTTE LE COSE - E. CIBELLI', description = '' WHERE id_product = '18792' 11/01/2023 04:23:36 pm >> UPDATE ps_product SET wholesale_price = '11.70', on_sale = '0', price = '18.0000' WHERE id_product = '18792' 11/01/2023 04:23:36 pm >> UPDATE ps_product_shop SET wholesale_price = '11.70', price = '18.0000', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18792' 11/01/2023 04:23:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '18792' 11/01/2023 04:25:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869297359' AND id_product != '18792' AND ean13 != '' 11/01/2023 04:25:42 pm >> UPDATE ps_product SET id_supplier = '109', reference = '13/7', ean13 = '9788869297359', date_upd = NOW() WHERE id_product = '18792' 11/01/2023 04:25:42 pm >> UPDATE ps_product_lang SET name = 'ECCO IO FACCIO NUOVE TUTTE LE COSE - E. CIBELLI', description = '' WHERE id_product = '18792' 11/01/2023 04:25:42 pm >> UPDATE ps_product SET wholesale_price = '11.70', on_sale = '0', price = '18.0000' WHERE id_product = '18792' 11/01/2023 04:25:42 pm >> UPDATE ps_product_shop SET wholesale_price = '11.70', price = '18.0000', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18792' 11/01/2023 04:25:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '18792' 11/01/2023 04:26:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '99' AND id_document != '78241' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-10') 11/01/2023 04:26:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '99', document_date = '2023-01-10', 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 = '8.50', price_tax_excluded = '8.50', date_upd = NOW() WHERE id_document = '78241' 11/01/2023 04:26:41 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78241' 11/01/2023 04:26:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '78241' 11/01/2023 04:26:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78241' , '8469' , 'PRETE UNO SPOSO - BONETTI/PEDROLI' , '1' , '-1' , '4' , '8.5' , '8.5' , '0' , '0' , '8.50' ) 11/01/2023 04:27:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892229556' AND id_product != '19945' AND ean13 != '' 11/01/2023 04:27:23 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788892229556', date_upd = NOW() WHERE id_product = '19945' 11/01/2023 04:27:23 pm >> UPDATE ps_product_lang SET name = 'GENERE DEL SACRAMENTO - A. GRILLO', description = '' WHERE id_product = '19945' 11/01/2023 04:27:23 pm >> UPDATE ps_product SET wholesale_price = '23.45', on_sale = '0', price = '35.0000' WHERE id_product = '19945' 11/01/2023 04:27:23 pm >> UPDATE ps_product_shop SET wholesale_price = '23.45', price = '35.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19945' 11/01/2023 04:27:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '19945' 11/01/2023 04:27:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892228580' AND id_product != '19521' AND ean13 != '' 11/01/2023 04:27:37 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788892228580', date_upd = NOW() WHERE id_product = '19521' 11/01/2023 04:27:37 pm >> UPDATE ps_product_lang SET name = 'DA GESU\' ALLA CHIESA - G. MAZZILLO', description = '' WHERE id_product = '19521' 11/01/2023 04:27:37 pm >> UPDATE ps_product SET wholesale_price = '26.13', on_sale = '0', price = '39.0000' WHERE id_product = '19521' 11/01/2023 04:27:37 pm >> UPDATE ps_product_shop SET wholesale_price = '26.13', price = '39.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19521' 11/01/2023 04:27:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '19521' 11/01/2023 04:27:41 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19521' 11/01/2023 04:27:41 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20619' , '1' , '' , 'nuovo-prodotto' ) 11/01/2023 04:27:41 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '20619' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19521' 11/01/2023 04:27:41 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20619' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19521' 11/01/2023 04:27:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892227385' AND id_product != '19178' AND ean13 != '' 11/01/2023 04:27:54 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788892227385', date_upd = NOW() WHERE id_product = '19178' 11/01/2023 04:27:54 pm >> UPDATE ps_product_lang SET name = 'KYRIOS VERSO IL TRIONFO FINALE', description = '' WHERE id_product = '19178' 11/01/2023 04:27:54 pm >> UPDATE ps_product SET wholesale_price = '18.76', on_sale = '0', price = '28.0000' WHERE id_product = '19178' 11/01/2023 04:27:54 pm >> UPDATE ps_product_shop SET wholesale_price = '18.76', price = '28.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19178' 11/01/2023 04:27:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '19178' 11/01/2023 04:28:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892220454' AND id_product != '16302' AND ean13 != '' 11/01/2023 04:28:07 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788892220454', date_upd = NOW() WHERE id_product = '16302' 11/01/2023 04:28:07 pm >> UPDATE ps_product_lang SET name = 'MISERICORDIA E TENEREZZA', description = '' WHERE id_product = '16302' 11/01/2023 04:28:07 pm >> UPDATE ps_product SET wholesale_price = '40.20', on_sale = '0', price = '60.0000' WHERE id_product = '16302' 11/01/2023 04:28:07 pm >> UPDATE ps_product_shop SET wholesale_price = '40.20', price = '60.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16302' 11/01/2023 04:28:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '16302' 11/01/2023 04:28:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892211377' AND id_product != '12707' AND ean13 != '' 11/01/2023 04:28:20 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788892211377', date_upd = NOW() WHERE id_product = '12707' 11/01/2023 04:28:20 pm >> UPDATE ps_product_lang SET name = 'AMORI LAETITIA, UN PUNTO DI SVOLTA', description = '' WHERE id_product = '12707' 11/01/2023 04:28:20 pm >> UPDATE ps_product SET wholesale_price = '16.75', on_sale = '0', price = '25.0000' WHERE id_product = '12707' 11/01/2023 04:28:20 pm >> UPDATE ps_product_shop SET wholesale_price = '16.75', price = '25.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12707' 11/01/2023 04:28:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '12707' 11/01/2023 04:28:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892216303' AND id_product != '14665' AND ean13 != '' 11/01/2023 04:28:34 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788892216303', date_upd = NOW() WHERE id_product = '14665' 11/01/2023 04:28:35 pm >> UPDATE ps_product_lang SET name = 'COSCIENZA E DISCERNIMENTO', description = '' WHERE id_product = '14665' 11/01/2023 04:28:35 pm >> UPDATE ps_product SET wholesale_price = '14.74', on_sale = '0', price = '22.0000' WHERE id_product = '14665' 11/01/2023 04:28:35 pm >> UPDATE ps_product_shop SET wholesale_price = '14.74', price = '22.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '14665' 11/01/2023 04:28:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '14665' 11/01/2023 04:28:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788892218321' AND id_product != '15627' AND ean13 != '' 11/01/2023 04:28:46 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788892218321', date_upd = NOW() WHERE id_product = '15627' 11/01/2023 04:28:46 pm >> UPDATE ps_product_lang SET name = 'PER UNA NUOVA CULTURA PASTORALE - A. AUTIERO', description = '' WHERE id_product = '15627' 11/01/2023 04:28:46 pm >> UPDATE ps_product SET wholesale_price = '12.06', on_sale = '0', price = '18.0000' WHERE id_product = '15627' 11/01/2023 04:28:46 pm >> UPDATE ps_product_shop SET wholesale_price = '12.06', price = '18.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15627' 11/01/2023 04:28:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '15627' 11/01/2023 04:29:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839924025' AND id_product != '10571' AND ean13 != '' 11/01/2023 04:29:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '13/2', ean13 = '9788839924025', date_upd = NOW() WHERE id_product = '10571' 11/01/2023 04:29:54 pm >> UPDATE ps_product_lang SET name = 'TEOLOGIA FONDAMENTALE - M. EPIS', description = '' WHERE id_product = '10571' 11/01/2023 04:29:54 pm >> UPDATE ps_product SET wholesale_price = '31.20', on_sale = '0', price = '48.0000' WHERE id_product = '10571' 11/01/2023 04:29:54 pm >> UPDATE ps_product_shop SET wholesale_price = '31.20', price = '48.0000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10571' 11/01/2023 04:29:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '10571' 11/01/2023 04:30:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839924131' AND id_product != '3898' AND ean13 != '' 11/01/2023 04:30:08 pm >> UPDATE ps_product SET id_supplier = '7', reference = '13/2', ean13 = '9788839924131', date_upd = NOW() WHERE id_product = '3898' 11/01/2023 04:30:08 pm >> UPDATE ps_product_lang SET name = 'ESCATOLOGIA CRISTIANA - G. ANCONA', description = '' WHERE id_product = '3898' 11/01/2023 04:30:08 pm >> UPDATE ps_product SET wholesale_price = '19.60', on_sale = '0', price = '28.0000' WHERE id_product = '3898' 11/01/2023 04:30:08 pm >> UPDATE ps_product_shop SET wholesale_price = '19.60', price = '28.0000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '65', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3898' 11/01/2023 04:30:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '3898' 11/01/2023 04:30:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788830818378' AND id_product != '19575' AND ean13 != '' 11/01/2023 04:30:49 pm >> UPDATE ps_product SET id_supplier = '107', reference = '13/7', ean13 = '9788830818378', date_upd = NOW() WHERE id_product = '19575' 11/01/2023 04:30:49 pm >> UPDATE ps_product_lang SET name = 'DIMENSIONE REGALE ... - SCORRANO', description = '' WHERE id_product = '19575' 11/01/2023 04:30:49 pm >> UPDATE ps_product SET wholesale_price = '19.18', on_sale = '0', price = '29.5000' WHERE id_product = '19575' 11/01/2023 04:30:49 pm >> UPDATE ps_product_shop SET wholesale_price = '19.18', price = '29.5000', id_tax_rules_group = '4', id_category_default = '11', id_argoment_default = '59', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19575' 11/01/2023 04:30:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '19575' 11/01/2023 04:50:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788886616966' AND id_product != '2777' AND ean13 != '' 11/01/2023 04:50:35 pm >> UPDATE ps_product SET id_supplier = '38', reference = 'ESPOSITORE SHALOM', ean13 = '9788886616966', date_upd = NOW() WHERE id_product = '2777' 11/01/2023 04:50:35 pm >> UPDATE ps_product_lang SET name = 'CORONCINA E NOVENA ALLA DIVINA MISERICORDIA - 8189', description = '' WHERE id_product = '2777' 11/01/2023 04:50:35 pm >> UPDATE ps_product SET wholesale_price = '1.20', on_sale = '0', price = '2.0000' WHERE id_product = '2777' 11/01/2023 04:50:35 pm >> UPDATE ps_product_shop SET wholesale_price = '1.20', price = '2.0000', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2777' 11/01/2023 04:50:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '2777' 11/01/2023 04:53:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '114' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-11') 11/01/2023 04:53:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '114' , '2023-01-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.90' , '20.85' , NOW() , NOW() ) 11/01/2023 04:53:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78260' 11/01/2023 04:53:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '78260' 11/01/2023 04:53:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78260' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 11/01/2023 04:53:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78260' , '7673' , 'PARTICOLE MM38' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 11/01/2023 04:53:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78260' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 11/01/2023 04:58:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '115' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-11') 11/01/2023 04:58:05 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '115' , '2023-01-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '69.60' , '60.68' , NOW() , NOW() ) 11/01/2023 04:58:05 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78261' 11/01/2023 04:58:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '78261' 11/01/2023 04:58:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78261' , '19911' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 11/01/2023 04:58:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78261' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 11/01/2023 04:58:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78261' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 11/01/2023 04:58:05 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78261' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '2.3' , '2.3' , '0' , '0' , '4.60' ) 11/01/2023 05:16:53 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6022334811' , '2022-12-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0.24' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '8.04' , '8.04' , NOW() , NOW() ) 11/01/2023 05:16:53 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78262' 11/01/2023 05:16:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '78262' 11/01/2023 05:16:53 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78262' , '20491' , 'DIO E\' MISERICORDIA - D. BARSOTTI' , '1' , '0' , '4' , '7.8' , '7.8' , '0' , '0' , '7.8000' ) 11/01/2023 05:16:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20491' AND id_supplier = '109' 11/01/2023 05:16:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20491' , '109' , '1' ) 11/01/2023 05:21:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6022334813' , '2022-12-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '1.94' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '70.17' , '70.17' , NOW() , NOW() ) 11/01/2023 05:21:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78263' 11/01/2023 05:21:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '78263' 11/01/2023 05:21:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78263' , '20299' , 'DONNE E SCIENZA' , '1' , '0' , '4' , '12' , '12' , '0' , '0' , '12.0000' ) 11/01/2023 05:21:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20299' AND id_supplier = '109' 11/01/2023 05:21:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20299' , '109' , '1' ) 11/01/2023 05:21:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78263' , '13841' , 'PADRE MIO MI ABBANDONO A TE - C. CARRETTO' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 11/01/2023 05:21:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13841' AND id_supplier = '109' 11/01/2023 05:21:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13841' , '109' , '1' ) 11/01/2023 05:21:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78263' , '20298' , 'COFANETTO STORIE PER BAMBINI VOL 1 E 2' , '1' , '0' , '4' , '21.23' , '21.23' , '0' , '0' , '21.2300' ) 11/01/2023 05:21:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20298' AND id_supplier = '109' 11/01/2023 05:21:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20298' , '109' , '1' ) 11/01/2023 05:21:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78263' , '20588' , 'FELICITA DEL CUORE - F. SHEEN' , '1' , '0' , '4' , '15.4' , '15.4' , '0' , '0' , '15.4000' ) 11/01/2023 05:21:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20588' AND id_supplier = '109' 11/01/2023 05:21:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20588' , '109' , '1' ) 11/01/2023 05:21:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78263' , '20589' , 'ECCO MIA MADRE - R. BRICHETTI MESSORI' , '1' , '0' , '4' , '10.5' , '10.5' , '0' , '0' , '10.5000' ) 11/01/2023 05:21:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20589' AND id_supplier = '109' 11/01/2023 05:21:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20589' , '109' , '1' ) 11/01/2023 05:24:57 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6022334810' , '2022-10-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '1.48' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '49.57' , '49.57' , NOW() , NOW() ) 11/01/2023 05:24:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78264' 11/01/2023 05:24:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '78264' 11/01/2023 05:24:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78264' , '20490' , 'DIACONO' , '1' , '0' , '4' , '9.75' , '9.75' , '0' , '0' , '9.7500' ) 11/01/2023 05:24:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20490' AND id_supplier = '109' 11/01/2023 05:24:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20490' , '109' , '1' ) 11/01/2023 05:24:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78264' , '20488' , 'CHIESA E VIVA - J. RATZINGER' , '1' , '0' , '4' , '5.85' , '5.85' , '0' , '0' , '5.8500' ) 11/01/2023 05:24:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20488' AND id_supplier = '109' 11/01/2023 05:24:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20488' , '109' , '1' ) 11/01/2023 05:24:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78264' , '20489' , 'SALMI NEL CANTO LAMORE - M. VERSACI' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 11/01/2023 05:24:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20489' AND id_supplier = '109' 11/01/2023 05:24:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20489' , '109' , '1' ) 11/01/2023 05:24:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78264' , '20587' , 'CATECHESI CREATIVA - A. QUEIROLO' , '1' , '0' , '4' , '9.1' , '9.1' , '0' , '0' , '9.1000' ) 11/01/2023 05:24:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20587' AND id_supplier = '109' 11/01/2023 05:24:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20587' , '109' , '1' ) 11/01/2023 05:24:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78264' , '20590' , 'PREGHIERA - PAPA FRANCESCO' , '1' , '0' , '4' , '8.44' , '8.44' , '0' , '0' , '8.4400' ) 11/01/2023 05:24:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20590' AND id_supplier = '109' 11/01/2023 05:24:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20590' , '109' , '1' ) 11/01/2023 05:24:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78264' , '20591' , 'NELLE TUE MANI' , '1' , '0' , '4' , '5.85' , '5.85' , '0' , '0' , '5.8500' ) 11/01/2023 05:24:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20591' AND id_supplier = '109' 11/01/2023 05:24:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20591' , '109' , '1' ) 11/01/2023 05:26:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6022334814' , '2022-12-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '32' , '4' , '0' , '0' , '0' , '' , '13' , '0' , '1047.39' , '1047.39' , NOW() , NOW() ) 11/01/2023 05:26:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78265' 11/01/2023 05:26:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '78265' 11/01/2023 05:26:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78265' , '1134' , 'BIBBIA DI GERUSALEMME NERA' , '50' , '0' , '4' , '20.3078' , '20.3078' , '0' , '0' , '1015.3900' ) 11/01/2023 05:26:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1134' AND id_supplier = '109' 11/01/2023 05:26:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1134' , '109' , '1' ) 11/01/2023 05:28:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '6022334812' , '2022-12-31' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '2.85' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '100.15' , '100.15' , NOW() , NOW() ) 11/01/2023 05:28:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78266' 11/01/2023 05:28:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '78266' 11/01/2023 05:28:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78266' , '20352' , 'STORIA DELLA CHIESA VOL 1' , '1' , '0' , '4' , '19.12' , '19.12' , '0' , '0' , '19.1200' ) 11/01/2023 05:28:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20352' AND id_supplier = '109' 11/01/2023 05:28:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20352' , '109' , '1' ) 11/01/2023 05:28:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78266' , '17865' , 'MESSALE QUOTIDIANO - N. E.' , '2' , '0' , '4' , '26.97' , '26.97' , '0' , '0' , '53.9400' ) 11/01/2023 05:28:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17865' AND id_supplier = '109' 11/01/2023 05:28:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17865' , '109' , '1' ) 11/01/2023 05:28:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78266' , '3988' , 'EVANGELII GAUDIUM ' , '3' , '0' , '4' , '2.39' , '2.39' , '0' , '0' , '7.1700' ) 11/01/2023 05:28:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3988' AND id_supplier = '109' 11/01/2023 05:28:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3988' , '109' , '1' ) 11/01/2023 05:28:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78266' , '20355' , 'TEOLOGIA DELLE RELIGIONI' , '1' , '0' , '4' , '17.07' , '17.07' , '0' , '0' , '17.0700' ) 11/01/2023 05:28:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20355' AND id_supplier = '109' 11/01/2023 05:28:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20355' , '109' , '1' ) 11/01/2023 06:08:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '116' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-11') 11/01/2023 06:08:35 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' , '116' , '2023-01-11' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.00' , '12.50' , NOW() , NOW() ) 11/01/2023 06:08:35 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 = '78267' 11/01/2023 06:08:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '78267' 11/01/2023 06:08:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78267' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 11/01/2023 06:08:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78267' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 11/01/2023 06:41:37 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3444' 11/01/2023 06:41:37 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 ( '3444' , '10' , '208' , 'PARROCCHIA S. PIETRO AP' , 'MAIOLATI' , 'P. SANTINO' , 'VICOLO BEOMONTI 2' , '' , '00010' , 'POLI' , 'PORZIANI DANILO - VIA UMBERTO I 75 - 00010 POLI RM - 3391586293\r\ndaniloporziani@tim.it' , '' , '3394557062' , '' , '' , NOW() , NOW() ) 11/01/2023 06:41:37 pm >> UPDATE ps_customer SET email = 'parrocchiapoli@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3444'