20/11/2023 09:24:05 am >> SELECT document_num FROM ps_document WHERE document_num = '3659' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 09:24:05 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3659' , '2023-11-20' , '' , '0' , '0' , '0' , 'VIA CIRILLO 84085 MERCATO SAN SEVERINO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '63.46' , '63.46' , NOW() , NOW() ) 20/11/2023 09:24:05 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89030' 20/11/2023 09:24:05 am >> DELETE FROM ps_document_detail WHERE id_document = '89030' 20/11/2023 09:24:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89030' , '18704' , 'IN_SEGUENDO GESU A NAZARET' , '6' , '-6' , '4' , '5.0000' , '5' , '0' , '5' , '28.50' ) 20/11/2023 09:24:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89030' , '18691' , 'IN_SEGUENDO GESU a emmaus - QUADERNO' , '6' , '-6' , '4' , '5.0000' , '5' , '0' , '5' , '28.50' ) 20/11/2023 09:24:05 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89030' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '2' , '-2' , '4' , '3.4000' , '3.4' , '0' , '5' , '6.46' ) 20/11/2023 09:26:34 am >> DELETE FROM ps_document WHERE id_document = '88980' 20/11/2023 09:26:34 am >> DELETE FROM ps_document_detail WHERE id_document = '88980' 20/11/2023 09:26:51 am >> DELETE FROM ps_document WHERE id_document = '88960' 20/11/2023 09:26:51 am >> DELETE FROM ps_document_detail WHERE id_document = '88960' 20/11/2023 09:27:22 am >> SELECT document_num FROM ps_document WHERE document_num = '47' AND id_document != '88758' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-11-06') 20/11/2023 09:27:22 am >> UPDATE ps_document SET id_document_type = '24', document_num = '47', document_date = '2023-11-06', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '13580.00', price_tax_excluded = '13580.00', date_upd = NOW() WHERE id_document = '88758' 20/11/2023 09:27: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 = '88758' 20/11/2023 09:27:23 am >> DELETE FROM ps_document_detail WHERE id_document = '88758' 20/11/2023 09:27: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 ( '88758' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '2160' , '-2160' , '4' , '2.4000' , '2.4' , '0' , '0' , '5184.00' ) 20/11/2023 09:27: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 ( '88758' , '11191' , 'VENITE CON ME 1 PARTE' , '2100' , '-2100' , '4' , '2.8000' , '2.8' , '0' , '0' , '5880.00' ) 20/11/2023 09:27: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 ( '88758' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '240' , '-240' , '4' , '3.4000' , '3.4' , '0' , '0' , '816.00' ) 20/11/2023 09:27: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 ( '88758' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '40' , '-40' , '4' , '5.0000' , '5' , '0' , '0' , '200.00' ) 20/11/2023 09:27: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 ( '88758' , '4154' , 'FESTA DEL PERDONO' , '500' , '-500' , '4' , '3.0000' , '3' , '0' , '0' , '1500.00' ) 20/11/2023 09:29:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3660' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 09:29:36 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' , '3660' , '2023-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.80' , '49.84' , NOW() , NOW() ) 20/11/2023 09:29:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89031' 20/11/2023 09:29:36 am >> DELETE FROM ps_document_detail WHERE id_document = '89031' 20/11/2023 09:29:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89031' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 20/11/2023 09:29:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89031' , '1914' , 'CERA DELLA LITURGIA' , '2' , '-2' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '9.80' ) 20/11/2023 09:48:32 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'bzbiYBrXpKgGrrBs' , NOW() , NOW() ) 20/11/2023 09:48:32 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4057' , '1' ) 20/11/2023 09:48:32 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4057' , '2' ) 20/11/2023 09:48:32 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4057' , '3' ) 20/11/2023 09:49:44 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4057' 20/11/2023 09:49:44 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 ( '4057' , '10' , '190' , '' , 'CUCCHIARA' , 'SALVATORE' , 'VIA GIUSEPPE FAVA 21' , '' , '90045' , 'CINISI' , '' , '' , '3207849320' , '' , '' , NOW() , NOW() ) 20/11/2023 09:49:44 am >> UPDATE ps_customer SET email = 'salvogiugno58@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4057' 20/11/2023 09:50:17 am >> SELECT document_num FROM ps_document WHERE document_num = '277' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 09:50:17 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' , '277' , '2023-11-20' , '' , '4057' , '0' , '4679191' , 'VIA GIUSEPPE FAVA 21 90045 CINISI' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '94.05' , '94.05' , NOW() , NOW() ) 20/11/2023 09:50: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 = '89032' 20/11/2023 09:50:17 am >> DELETE FROM ps_document_detail WHERE id_document = '89032' 20/11/2023 09:50:18 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89032' , '9676' , 'SARETE MIEI TESTIMONI - CAT.' , '18' , '-18' , '4' , '5.50' , '5.5' , '0' , '5' , '94.05' ) 20/11/2023 10:13:45 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4057' 20/11/2023 10:13:45 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 ( '4057' , '10' , '190' , '' , 'CUCCHIARA' , 'SALVATORE' , 'VIA GIUSEPPE FAVA 21' , '' , '90045' , 'CINISI' , '' , '' , '3207849320' , '' , '' , NOW() , NOW() ) 20/11/2023 10:13:45 am >> UPDATE ps_customer SET email = 'salvogiugno58@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4057' 20/11/2023 10:13:51 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4057' 20/11/2023 10:13:51 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 ( '4057' , '10' , '190' , '' , 'CUCCHIARA' , 'SALVATORE' , 'VIA GIUSEPPE FAVA 21' , '' , '90045' , 'CINISI' , '' , '' , '3207849320' , '' , '' , NOW() , NOW() ) 20/11/2023 10:13:51 am >> UPDATE ps_customer SET email = 'salvogiugno58@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4057' 20/11/2023 10:19:25 am >> SELECT document_num FROM ps_document WHERE document_num = '131/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 10:19:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '131/A' , '2023-11-20' , 'A' , '292' , '0' , '4676365' , 'VIA IONIO 8/A 84091 BATTIPAGLIA' , '' , 'TOT. 805,00' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '790.80' , '790.80' , NOW() , NOW() ) 20/11/2023 10:19:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89033' 20/11/2023 10:19:25 am >> DELETE FROM ps_document_detail WHERE id_document = '89033' 20/11/2023 10:19:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '45' , '-45' , '4' , '4.5' , '4.5' , '0' , '' , '202.50' ) 20/11/2023 10:19:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '32' , '-32' , '4' , '4.5' , '4.5' , '0' , '0' , '144.00' ) 20/11/2023 10:19:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '14529' , 'PANE E VINO - SUSSIDIO' , '48' , '-48' , '4' , '4.5' , '4.5' , '0' , '0' , '216.00' ) 20/11/2023 10:19:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '14530' , 'PANE E VINO - GUIDA 3' , '1' , '-1' , '4' , '13.5' , '13.5' , '0' , '0' , '13.50' ) 20/11/2023 10:19:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '15' , '-15' , '4' , '4.5' , '4.5' , '0' , '0' , '67.50' ) 20/11/2023 10:19:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '1' , '-1' , '4' , '13.5' , '13.5' , '0' , '0' , '13.50' ) 20/11/2023 10:19:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '15' , '-15' , '4' , '4.5' , '4.5' , '0' , '0' , '67.50' ) 20/11/2023 10:19: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 ( '89033' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '20' , '-20' , '4' , '3.40' , '3.4' , '0' , '15' , '57.80' ) 20/11/2023 10:19: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 ( '89033' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '-2' , '4' , '5.00' , '5' , '0' , '15' , '8.50' ) 20/11/2023 10:22:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2689' AND id_document != '87131' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-31') 20/11/2023 10:22:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2689', document_date = '2023-08-31', 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 = '134.00', price_tax_excluded = '109.84', date_upd = NOW() WHERE id_document = '87131' 20/11/2023 10:22:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87131' 20/11/2023 10:22:25 am >> DELETE FROM ps_document_detail WHERE id_document = '87131' 20/11/2023 10:22:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87131' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 20/11/2023 10:22:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87131' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '64' , '52.459016393443' , '22' , '0' , '64.00' ) 20/11/2023 10:22:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87131' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '2' , '-2' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '20.00' ) 20/11/2023 11:01:51 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/11/2023 11:01:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21847' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 11:01:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21847' , '1' , '1' , '2' , NOW() , NOW() ) 20/11/2023 11:01:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21847' , '0' , '1' , '0' , '0' ) 20/11/2023 11:03:10 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788861081079' AND id_product != '21847' AND ean13 != '' 20/11/2023 11:03:10 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788861081079', date_upd = NOW() WHERE id_product = '21847' 20/11/2023 11:03:10 am >> UPDATE ps_product_lang SET name = 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO', description = '' WHERE id_product = '21847' 20/11/2023 11:03:10 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '21847' 20/11/2023 11:03:10 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '15', id_argoment_default = '25', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21847' 20/11/2023 11:03:10 am >> DELETE FROM ps_specific_price WHERE id_product = '21847' 20/11/2023 11:03:11 am >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '21847' 20/11/2023 11:03:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21848' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 11:03:11 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '21848' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21847' 20/11/2023 11:03:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21848' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21847' 20/11/2023 11:03:47 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 ( '33' , '2023000006332' , '2023-11-17' , '' , '0' , '107' , '4669100' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , '' , '6' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '91.93' , '90.50' , NOW() , NOW() ) 20/11/2023 11:03:47 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 = '89034' 20/11/2023 11:03:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89034' 20/11/2023 11:03:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89034' , '21463' , 'CALENDARIO DELLAVVENTO 2023' , '1' , '1' , '1' , '10.00' , '8.1967213114754' , '22' , '35' , '7.9300' ) 20/11/2023 11:03:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21463' AND id_supplier = '107' 20/11/2023 11:03:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21463' , '107' , '1' ) 20/11/2023 11:03:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89034' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '20' , '20' , '4' , '3.00' , '3' , '0' , '35' , '39.0000' ) 20/11/2023 11:03:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21847' AND id_supplier = '107' 20/11/2023 11:03:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21847' , '107' , '1' ) 20/11/2023 11:03:47 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89034' , '21074' , 'SACERDOZIO MINISTERO E VITA ' , '2' , '2' , '4' , '30.00' , '30' , '0' , '35' , '39.0000' ) 20/11/2023 11:03:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '21074' AND id_supplier = '107' 20/11/2023 11:03:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21074' , '107' , '1' ) 20/11/2023 11:12:23 am >> SELECT document_num FROM ps_document WHERE document_num = '278' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 11:12: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 ( '21' , '278' , '2023-11-20' , '' , '161' , '0' , '161' , 'VIA G. MAZZINI VICO III, 8 81047 MACERATA CAMPANIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '220.60' , '220.60' , NOW() , NOW() ) 20/11/2023 11:12: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 = '89035' 20/11/2023 11:12:23 am >> DELETE FROM ps_document_detail WHERE id_document = '89035' 20/11/2023 11:12:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89035' , '21697' , 'ORME SUL CUORE - A. ROMANO' , '5' , '-5' , '4' , '12.00' , '12' , '0' , '5' , '57.00' ) 20/11/2023 11:12:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89035' , '21828' , 'VANGELO DI GESU ' , '9' , '-9' , '4' , '3.10' , '3.1' , '0' , '5' , '26.51' ) 20/11/2023 11:12:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89035' , '21835' , 'DIDACHE ' , '5' , '-5' , '4' , '7.50' , '7.5' , '0' , '5' , '35.63' ) 20/11/2023 11:12:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89035' , '21834' , 'PAPIA ' , '6' , '-6' , '4' , '7.80' , '7.8' , '0' , '5' , '44.46' ) 20/11/2023 11:12:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89035' , '21847' , 'UNDICESIMO: SALVA LA TESTA! - P. PELLEGRINO' , '20' , '-20' , '4' , '3.00' , '3' , '0' , '5' , '57.00' ) 20/11/2023 11:12:24 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89035' , '' , 'SPESE DI SPEDIZIONE GRATIS' , '0' , '0' , '4' , '0' , '0' , '0' , '0' , '0.00' ) 20/11/2023 11:34:27 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6914' 20/11/2023 11:34:27 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 ( '6914' , '10' , '147' , 'PARROCCHIA SAN TEODORO MT.' , 'Fiozzo' , 'Antonio' , 'VIA MASCARO 9' , '' , '88046' , 'LAMEZIA TERME' , '' , '' , '3290118443' , '' , '' , NOW() , NOW() ) 20/11/2023 11:34:27 am >> UPDATE ps_customer SET email = 'antoniofiozzo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6914' 20/11/2023 11:37:32 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6914' 20/11/2023 11:37:32 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 ( '6914' , '10' , '167' , 'PARROCCHIA SAN TEODORO MT.' , 'Fiozzo' , 'Antonio' , 'VIA MASCARO 9' , '' , '88046' , 'SAN TEODORO - LAMEZIA TERME' , 'SPEDIONE: ROSSANA DICELLO - VIA VICO II SEGGIO 17 - SAN TEODORO - LAMEZIA TERME 88046 CATANZARO' , '' , '3290118443' , '' , '' , NOW() , NOW() ) 20/11/2023 11:37:32 am >> UPDATE ps_customer SET email = 'antoniofiozzo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6914' 20/11/2023 11:37:49 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6914' 20/11/2023 11:37:49 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 ( '6914' , '10' , '167' , 'PARROCCHIA SAN TEODORO MT.' , 'FIOZZO' , 'ANTONIO' , 'VIA MASCARO 9' , '' , '88046' , 'SAN TEODORO - LAMEZIA TERME' , 'SPEDIONE: ROSSANA DICELLO - VIA VICO II SEGGIO 17 - SAN TEODORO - LAMEZIA TERME 88046 CATANZARO' , '' , '3290118443' , '' , '' , NOW() , NOW() ) 20/11/2023 11:37:49 am >> UPDATE ps_customer SET email = 'antoniofiozzo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6914' 20/11/2023 11:37:59 am >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 11:37:59 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' , '107' , '2023-11-20' , '' , '6914' , '0' , '163357305' , 'VIA MASCARO 9 88046 LAMEZIA TERME' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '83.40' , '83.40' , NOW() , NOW() ) 20/11/2023 11:37:59 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 = '13753' 20/11/2023 11:37:59 am >> DELETE FROM ps_document_detail WHERE id_document = '13753' 20/11/2023 11:37:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13753' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '15' , '-15' , '4' , '2.00' , '2' , '0' , '15' , '25.50' ) 20/11/2023 11:37:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13753' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '2' , '-2' , '4' , '30.00' , '30' , '0' , '15' , '51.00' ) 20/11/2023 11:39:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3661' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 11:39:43 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' , '3661' , '2023-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.50' , '9.43' , NOW() , NOW() ) 20/11/2023 11:39:43 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 = '89036' 20/11/2023 11:39:43 am >> DELETE FROM ps_document_detail WHERE id_document = '89036' 20/11/2023 11:39:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89036' , '20182' , 'COPPIA TESTE DI ANGELO CM7 - AR06' , '2' , '-2' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '10.00' ) 20/11/2023 11:39:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89036' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 20/11/2023 11:47:22 am >> SELECT document_num FROM ps_document WHERE document_num = '3662' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 11:47:22 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' , '3662' , '2023-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 20/11/2023 11:47:22 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89037' 20/11/2023 11:47:22 am >> DELETE FROM ps_document_detail WHERE id_document = '89037' 20/11/2023 11:47:22 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89037' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 20/11/2023 11:54:26 am >> SELECT document_num FROM ps_document WHERE document_num = '101/A' AND id_document != '87613' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-10-06') 20/11/2023 11:54:26 am >> UPDATE ps_document SET id_document_type = '24', document_num = '101/A', document_date = '2023-10-06', document_letter = 'A', id_customer = '204', id_supplier = '', id_address = '4671483', address1 = 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO', address2 = '', note = 'ospedale s. leonardo - ', 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 = '321.70', price_tax_excluded = '272.66', date_upd = NOW() WHERE id_document = '87613' 20/11/2023 11:54: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 = '87613' 20/11/2023 11:54:26 am >> DELETE FROM ps_document_detail WHERE id_document = '87613' 20/11/2023 11:54: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 ( '87613' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 20/11/2023 11:54: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 ( '87613' , '9613' , 'SANTA TERESA DI LISIEUX' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 20/11/2023 11:54: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 ( '87613' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '6.00' ) 20/11/2023 11:54: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 ( '87613' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 20/11/2023 11:54: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 ( '87613' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 20/11/2023 11:54: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 ( '87613' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 20/11/2023 11:54: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 ( '87613' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '72.00' ) 20/11/2023 11:54: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 ( '87613' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 20/11/2023 11:54: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 ( '87613' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 20/11/2023 11:54: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 ( '87613' , '8246' , 'PREGATE SEMPRE SENZA STANCARVI MAI - 8144' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 20/11/2023 11:54: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 ( '87613' , '4991' , 'SAN PIO DA PIETRELCINA - 315' , '10' , '-10' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '35.00' ) 20/11/2023 11:54: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 ( '87613' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 20/11/2023 11:54: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 ( '87613' , '1914' , 'CERA DELLA LITURGIA' , '9' , '-9' , '1' , '4.90' , '4.016393442623' , '22' , '0' , '44.10' ) 20/11/2023 11:55:36 am >> SELECT document_num FROM ps_document WHERE document_num = '3663' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 11:55:36 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' , '3663' , '2023-11-20' , '' , '0' , '0' , '0' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '321.70' , '272.66' , NOW() , NOW() ) 20/11/2023 11:55:36 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89038' 20/11/2023 11:55:36 am >> DELETE FROM ps_document_detail WHERE id_document = '89038' 20/11/2023 11:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89038' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.5000' , '6.1475' , '22' , '0' , '7.50' ) 20/11/2023 11:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89038' , '9613' , 'SANTA TERESA DI LISIEUX' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 20/11/2023 11:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89038' , '16689' , 'OSTIA PAN DI CENA mm80' , '3' , '-3' , '3' , '2.0000' , '1.9231' , '4' , '0' , '6.00' ) 20/11/2023 11:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89038' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '5' , '-5' , '3' , '3.5000' , '3.3654' , '4' , '0' , '17.50' ) 20/11/2023 11:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89038' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672' , '22' , '0' , '51.00' ) 20/11/2023 11:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89038' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 20/11/2023 11:55:36 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89038' , '16834' , 'LITURGICO CARTA 8GG' , '24' , '-24' , '1' , '3.0000' , '2.459' , '22' , '0' , '72.00' ) 20/11/2023 11:55: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 ( '89038' , '8247' , 'PREGATE, PREGATE, PREGATE - 8100' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 20/11/2023 11:55: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 ( '89038' , '7271' , 'ORAZIONI IN SUFFRAGIO DELLE ANIME DEL PURGATORIO - 8477' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 20/11/2023 11:55: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 ( '89038' , '8246' , 'PREGATE SEMPRE SENZA STANCARVI MAI - 8144' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 20/11/2023 11:55: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 ( '89038' , '4991' , 'SAN PIO DA PIETRELCINA - 315' , '10' , '-10' , '1' , '3.5000' , '2.8689' , '22' , '0' , '35.00' ) 20/11/2023 11:55: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 ( '89038' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346' , '4' , '0' , '4.30' ) 20/11/2023 11:55: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 ( '89038' , '1914' , 'CERA DELLA LITURGIA' , '9' , '-9' , '1' , '4.9000' , '4.0164' , '22' , '0' , '44.10' ) 20/11/2023 11:57:39 am >> DELETE FROM ps_document WHERE id_document = '87613' 20/11/2023 11:57:39 am >> DELETE FROM ps_document_detail WHERE id_document = '87613' 20/11/2023 12:04:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '279' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 12:04:09 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '279' , '2023-11-20' , '' , '3356' , '0' , '4671990' , 'VIA SALVATORE DE RENZI, 26 84125 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '67.15' , '67.15' , NOW() , NOW() ) 20/11/2023 12:04:09 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89039' 20/11/2023 12:04:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '89039' 20/11/2023 12:04:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89039' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '10' , '-10' , '4' , '3.40' , '3.4' , '0' , '15' , '28.90' ) 20/11/2023 12:04:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89039' , '4154' , 'FESTA DEL PERDONO' , '10' , '-10' , '4' , '3.00' , '3' , '0' , '15' , '25.50' ) 20/11/2023 12:04:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89039' , '8408' , 'PRENDETE E MANGIATE' , '5' , '-5' , '4' , '3.00' , '3' , '0' , '15' , '12.75' ) 20/11/2023 12:10:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '132/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 12:10:21 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' , '132/A' , '2023-11-20' , 'A' , '204' , '0' , '4671483' , 'VIA ROBERTO IL GUISCARDO, 3 84121 SALERNO' , '' , 'SAN LEONARDO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.00' , '29.00' , NOW() , NOW() ) 20/11/2023 12:10:21 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 = '89040' 20/11/2023 12:10:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '89040' 20/11/2023 12:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89040' , '21809' , 'AMEN - GEN 2024' , '5' , '-5' , '4' , '2.90' , '2.9' , '0' , '0' , '14.50' ) 20/11/2023 12:10:21 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89040' , '21810' , 'AMEN - FEB 2024' , '5' , '-5' , '4' , '2.90' , '2.9' , '0' , '0' , '14.50' ) 20/11/2023 12:11:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2689' AND id_document != '87131' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-31') 20/11/2023 12:11:53 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2689', document_date = '2023-08-31', 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 = '134.00', price_tax_excluded = '109.84', date_upd = NOW() WHERE id_document = '87131' 20/11/2023 12:11: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 = '87131' 20/11/2023 12:11:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '87131' 20/11/2023 12:11: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 ( '87131' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 20/11/2023 12:11: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 ( '87131' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '46' , '-46' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '46.00' ) 20/11/2023 12:11: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 ( '87131' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 20/11/2023 12:11: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 ( '87131' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '18.00' ) 20/11/2023 12:12:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2689' AND id_document != '87131' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-08-31') 20/11/2023 12:12:33 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2689', document_date = '2023-08-31', 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 = '134.00', price_tax_excluded = '109.84', date_upd = NOW() WHERE id_document = '87131' 20/11/2023 12:12: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 = '87131' 20/11/2023 12:12:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '87131' 20/11/2023 12:12: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 ( '87131' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 20/11/2023 12:12: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 ( '87131' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '34' , '-34' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '34.00' ) 20/11/2023 12:12: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 ( '87131' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '2' , '-2' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '20.00' ) 20/11/2023 12:12: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 ( '87131' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '12' , '-12' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '18.00' ) 20/11/2023 12:12: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 ( '87131' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '4' , '-4' , '1' , '3' , '2.4590163934426' , '22' , '0' , '12.00' ) 20/11/2023 12:17:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3664' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 12:17:13 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' , '3664' , '2023-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.95' , '4.95' , NOW() , NOW() ) 20/11/2023 12:17:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89041' 20/11/2023 12:17:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '89041' 20/11/2023 12:17:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89041' , '16367' , 'TRE PORCELLINI' , '1' , '-1' , '4' , '0.99' , '0.99' , '0' , '0' , '0.99' ) 20/11/2023 12:17:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89041' , '16366' , 'BELLA ADDORMENTATA' , '1' , '-1' , '4' , '0.99' , '0.99' , '0' , '0' , '0.99' ) 20/11/2023 12:17:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89041' , '16368' , 'SIRENETTA' , '1' , '-1' , '4' , '0.99' , '0.99' , '0' , '0' , '0.99' ) 20/11/2023 12:17:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89041' , '16362' , 'BIANCANEVE E I SETTE NANI' , '1' , '-1' , '4' , '0.99' , '0.99' , '0' , '0' , '0.99' ) 20/11/2023 12:17:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89041' , '16369' , 'BRUTTO ANATROCCOLO' , '1' , '-1' , '4' , '0.99' , '0.99' , '0' , '0' , '0.99' ) 20/11/2023 12:31:50 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6914' 20/11/2023 12:31:50 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 ( '6914' , '10' , '167' , 'PARROCCHIA SAN TEODORO MT.' , 'FIOZZO' , 'ANTONIO' , 'VIA MASCARO 9' , '' , '88046' , 'SAN TEODORO - LAMEZIA TERME' , 'SPEDIONE: ROSSANA DICELLO - VIA VICO II SEGGIO 17 - SAN TEODORO - LAMEZIA TERME 88046 CATANZARO' , '' , '3290118443' , '' , '82050770799' , NOW() , NOW() ) 20/11/2023 12:31:50 pm >> UPDATE ps_customer SET email = 'antoniofiozzo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6914' 20/11/2023 12:32:17 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6914' 20/11/2023 12:32:17 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 ( '6914' , '10' , '167' , 'PARROCCHIA SAN TEODORO MT.' , 'FIOZZO' , 'ANTONIO' , 'VIA MARASCO 9' , '' , '88046' , 'SAN TEODORO - LAMEZIA TERME' , 'SPEDIONE: ROSSANA DICELLO - VIA VICO II SEGGIO 17 - SAN TEODORO - LAMEZIA TERME 88046 CATANZARO' , '' , '3290118443' , '' , '82050770799' , NOW() , NOW() ) 20/11/2023 12:32:17 pm >> UPDATE ps_customer SET email = 'antoniofiozzo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6914' 20/11/2023 12:33:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '13753' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 12:33:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '107', document_date = '2023-11-20', document_letter = '', id_customer = '6914', id_supplier = '0', id_address = '163357309', address1 = 'VIA MASCARO 9 88046 LAMEZIA TERME', address2 = '', note = '', price_shipping = '6.90', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '83.40', price_tax_excluded = '83.40', date_upd = NOW() WHERE id_document = '13753' 20/11/2023 12:33:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '13753' 20/11/2023 12:33:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '13753' 20/11/2023 12:33:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13753' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '15' , '-15' , '4' , '2.0000' , '2' , '0' , '15' , '25.50' ) 20/11/2023 12:33:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '13753' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '2' , '-2' , '4' , '30.0000' , '30' , '0' , '15' , '51.00' ) 20/11/2023 12:37:05 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6914' 20/11/2023 12:37:05 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 ( '6914' , '10' , '147' , 'PARROCCHIA SAN TEODORO MT.' , 'FIOZZO' , 'ANTONIO' , 'VIA MARASCO 9' , '' , '88046' , 'SAN TEODORO - LAMEZIA TERME' , 'SPEDIONE: ROSSANA DICELLO - VIA VICO II SEGGIO 17 - SAN TEODORO - LAMEZIA TERME 88046 CATANZARO' , '' , '3290118443' , '' , '82050770799' , NOW() , NOW() ) 20/11/2023 12:37:06 pm >> UPDATE ps_customer SET email = 'antoniofiozzo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6914' 20/11/2023 12:46:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PC240' AND id_product != '21848' AND ean13 != '' 20/11/2023 12:46:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'PC240', date_upd = NOW() WHERE id_product = '21848' 20/11/2023 12:46:30 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVI ACUTIS - PC240', description = '' WHERE id_product = '21848' 20/11/2023 12:46:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.639344262295082' WHERE id_product = '21848' 20/11/2023 12:46:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.639344262295082', id_tax_rules_group = '1', id_category_default = '151', 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 = '21848' 20/11/2023 12:46:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '21848' 20/11/2023 12:48:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846231599' AND id_product != '4915' AND ean13 != '' 20/11/2023 12:48:56 pm >> UPDATE ps_product SET id_supplier = '43', reference = '2013', ean13 = '8027846231599', date_upd = NOW() WHERE id_product = '4915' 20/11/2023 12:48:57 pm >> UPDATE ps_product_lang SET name = 'ICONA SU TELA LEGNO MADONNA NODI CM 22X16,5 - AN025MN', description = '' WHERE id_product = '4915' 20/11/2023 12:48:57 pm >> UPDATE ps_product SET wholesale_price = '11.99', on_sale = '0', price = '24.5902' WHERE id_product = '4915' 20/11/2023 12:48:57 pm >> UPDATE ps_product_shop SET wholesale_price = '11.99', price = '24.5902', id_tax_rules_group = '1', id_category_default = '151', 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 = '4915' 20/11/2023 12:48:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '4915' 20/11/2023 12:49:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846231599' AND id_product != '4915' AND ean13 != '' 20/11/2023 12:49:17 pm >> UPDATE ps_product SET id_supplier = '43', reference = '2013', ean13 = '8027846231599', date_upd = NOW() WHERE id_product = '4915' 20/11/2023 12:49:17 pm >> UPDATE ps_product_lang SET name = 'ICONA SU TELA LEGNO MADONNA NODI CM 22X16,5 - AN025MN', description = '' WHERE id_product = '4915' 20/11/2023 12:49:17 pm >> UPDATE ps_product SET wholesale_price = '11.99', on_sale = '0', price = '24.5902' WHERE id_product = '4915' 20/11/2023 12:49:17 pm >> UPDATE ps_product_shop SET wholesale_price = '11.99', price = '24.5902', id_tax_rules_group = '1', id_category_default = '151', 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 = '4915' 20/11/2023 12:49:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '4915' 20/11/2023 12:50:15 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 = '21848' 20/11/2023 12:50:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21849' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 12:50:15 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 '21849' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21848' 20/11/2023 12:50:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21849' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21848' 20/11/2023 12:51:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846182655' AND id_product != '21849' AND ean13 != '' 20/11/2023 12:51:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846182655', date_upd = NOW() WHERE id_product = '21849' 20/11/2023 12:51:32 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA ARGENTO SAN MICHELE - RA856', description = '' WHERE id_product = '21849' 20/11/2023 12:51:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '54.09836065573771' WHERE id_product = '21849' 20/11/2023 12:51:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '54.09836065573771', id_tax_rules_group = '1', id_category_default = '151', 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 = '21849' 20/11/2023 12:51:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '21849' 20/11/2023 12:52:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846182655' AND id_product != '21849' AND ean13 != '' 20/11/2023 12:52:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846182655', date_upd = NOW() WHERE id_product = '21849' 20/11/2023 12:52:03 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA ARGENTO SAN MICHELE - RA856', description = '' WHERE id_product = '21849' 20/11/2023 12:52:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '49.18032786885246' WHERE id_product = '21849' 20/11/2023 12:52:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '49.18032786885246', id_tax_rules_group = '1', id_category_default = '151', 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 = '21849' 20/11/2023 12:52:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '21849' 20/11/2023 12:53:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000440' AND id_product != '6342' AND ean13 != '' 20/11/2023 12:53:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '2017', ean13 = '000440', date_upd = NOW() WHERE id_product = '6342' 20/11/2023 12:53:41 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA S. BENEDETTO ARGENTO - RA633', description = '' WHERE id_product = '6342' 20/11/2023 12:53:41 pm >> UPDATE ps_product SET wholesale_price = '9.89', on_sale = '0', price = '23.770491803278688' WHERE id_product = '6342' 20/11/2023 12:53:41 pm >> UPDATE ps_product_shop SET wholesale_price = '9.89', price = '23.770491803278688', id_tax_rules_group = '1', id_category_default = '151', 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 = '6342' 20/11/2023 12:53:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '6342' 20/11/2023 12:54:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000440' AND id_product != '6342' AND ean13 != '' 20/11/2023 12:54:29 pm >> UPDATE ps_product SET id_supplier = '', reference = '2017', ean13 = '000440', date_upd = NOW() WHERE id_product = '6342' 20/11/2023 12:54:29 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA S. BENEDETTO ARGENTO - RA633', description = '' WHERE id_product = '6342' 20/11/2023 12:54:29 pm >> UPDATE ps_product SET wholesale_price = '9.89', on_sale = '0', price = '23.770491803278688' WHERE id_product = '6342' 20/11/2023 12:54:29 pm >> UPDATE ps_product_shop SET wholesale_price = '9.89', price = '23.770491803278688', id_tax_rules_group = '1', id_category_default = '151', 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 = '6342' 20/11/2023 12:54:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '6342' 20/11/2023 12:59:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '2429/2023' , '2023-11-17' , '2023' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '252.24' , '206.76' , NOW() , NOW() ) 20/11/2023 12:59:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89042' 20/11/2023 12:59:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '89042' 20/11/2023 12:59:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '50' , '50' , '1' , '0.87' , '0.71311475409836' , '22' , '10' , '47.7630' ) 20/11/2023 12:59:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21848' AND id_supplier = '43' 20/11/2023 12:59:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21848' , '43' , '1' ) 20/11/2023 12:59:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '4915' , 'ICONA SU TELA LEGNO MADONNA NODI CM 22X16,5 - AN025MN' , '1' , '1' , '1' , '12.62' , '10.344262295082' , '22' , '10' , '13.8568' ) 20/11/2023 12:59:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4915' AND id_supplier = '43' 20/11/2023 12:59:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4915' , '43' , '1' ) 20/11/2023 12:59:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21849' , 'MEDAGLIA ARGENTO SAN MICHELE - RA856' , '1' , '1' , '1' , '27.2' , '22.295081967213' , '22' , '10' , '29.8656' ) 20/11/2023 12:59:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21849' AND id_supplier = '43' 20/11/2023 12:59:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21849' , '43' , '1' ) 20/11/2023 12:59:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '6342' , 'MEDAGLIA S. BENEDETTO ARGENTO - RA633' , '1' , '1' , '1' , '13.75' , '11.270491803279' , '22' , '10' , '15.0975' ) 20/11/2023 12:59:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6342' AND id_supplier = '43' 20/11/2023 12:59:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6342' , '43' , '1' ) 20/11/2023 12:59:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '100' , '100' , '1' , '0.1386' , '0.11360655737705' , '22' , '10' , '15.2183' ) 20/11/2023 12:59:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16060' AND id_supplier = '43' 20/11/2023 12:59:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16060' , '43' , '1' ) 20/11/2023 12:59:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '17883' , 'CROCE MOGANO CORPO MET CM 28- 169M' , '10' , '10' , '1' , '5.94' , '4.8688524590164' , '22' , '10' , '65.2212' ) 20/11/2023 12:59:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17883' AND id_supplier = '43' 20/11/2023 12:59:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17883' , '43' , '1' ) 20/11/2023 12:59:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '17885' , 'CROCE FAGGIO CORPO MET CM 28 - 169' , '10' , '10' , '1' , '5.94' , '4.8688524590164' , '22' , '10' , '65.2212' ) 20/11/2023 12:59:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17885' AND id_supplier = '43' 20/11/2023 12:59:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17885' , '43' , '1' ) 20/11/2023 02:18:24 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 = '6342' 20/11/2023 02:18:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21850' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 02:18:24 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 '21850' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '6342' 20/11/2023 02:18:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21850' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '6342' 20/11/2023 02:19:45 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 = '6342' 20/11/2023 02:19:45 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21851' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 02:19:45 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 '21851' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '6342' 20/11/2023 02:19:45 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21851' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '6342' 20/11/2023 02:20:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000425' AND id_product != '21851' AND ean13 != '' 20/11/2023 02:20:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000425', date_upd = NOW() WHERE id_product = '21851' 20/11/2023 02:20:59 pm >> UPDATE ps_product_lang SET name = 'CORPO CRISTO', description = '' WHERE id_product = '21851' 20/11/2023 02:20:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14.754098360655737' WHERE id_product = '21851' 20/11/2023 02:20:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14.754098360655737', id_tax_rules_group = '1', id_category_default = '151', 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 = '21851' 20/11/2023 02:20:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '21851' 20/11/2023 02:24:10 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 = '21851' 20/11/2023 02:24:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21852' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 02:24:10 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 '21852' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21851' 20/11/2023 02:24:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21852' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21851' 20/11/2023 02:25:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846023507' AND id_product != '21852' AND ean13 != '' 20/11/2023 02:25:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846023507', date_upd = NOW() WHERE id_product = '21852' 20/11/2023 02:25:59 pm >> UPDATE ps_product_lang SET name = 'CROCE ULIVO CON BASE - CM 20 - PG035/B', description = '' WHERE id_product = '21852' 20/11/2023 02:25:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '30.327868852459016' WHERE id_product = '21852' 20/11/2023 02:25:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '30.327868852459016', id_tax_rules_group = '1', id_category_default = '151', 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 = '21852' 20/11/2023 02:25:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '21852' 20/11/2023 02:28:56 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 = '21852' 20/11/2023 02:28:56 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21853' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 02:28:56 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 '21853' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21852' 20/11/2023 02:28:56 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21853' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21852' 20/11/2023 02:30:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846227912' AND id_product != '21853' AND ean13 != '' 20/11/2023 02:30:16 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846227912', date_upd = NOW() WHERE id_product = '21853' 20/11/2023 02:30:16 pm >> UPDATE ps_product_lang SET name = 'CROCE MOGANO CON BASE - CLB263ARG ', description = '' WHERE id_product = '21853' 20/11/2023 02:30:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = 'NaN' WHERE id_product = '21853' 20/11/2023 02:30:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = 'NaN', id_tax_rules_group = '1', id_category_default = '151', 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 = '21853' 20/11/2023 02:30:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '21853' 20/11/2023 02:30:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846227912' AND id_product != '21853' AND ean13 != '' 20/11/2023 02:30:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846227912', date_upd = NOW() WHERE id_product = '21853' 20/11/2023 02:30:40 pm >> UPDATE ps_product_lang SET name = 'CROCE MOGANO CON BASE - CLB263ARG ', description = '' WHERE id_product = '21853' 20/11/2023 02:30:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26.639344262295083' WHERE id_product = '21853' 20/11/2023 02:30:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26.639344262295083', id_tax_rules_group = '1', id_category_default = '151', 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 = '21853' 20/11/2023 02:30:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '21853' 20/11/2023 02:31:58 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 = '21853' 20/11/2023 02:31:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21854' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 02:31:58 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 '21854' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21853' 20/11/2023 02:31:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21854' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21853' 20/11/2023 02:33:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846023569' AND id_product != '21854' AND ean13 != '' 20/11/2023 02:33:35 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846023569', date_upd = NOW() WHERE id_product = '21854' 20/11/2023 02:33:35 pm >> UPDATE ps_product_lang SET name = 'CROCIFISSO ULIVO CM 34 - PG038', description = '' WHERE id_product = '21854' 20/11/2023 02:33:35 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '39.34426229508197' WHERE id_product = '21854' 20/11/2023 02:33:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '39.34426229508197', id_tax_rules_group = '1', id_category_default = '151', 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 = '21854' 20/11/2023 02:33:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '21854' 20/11/2023 02:34:40 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/11/2023 02:34:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21855' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 02:34:40 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21855' , '1' , '1' , '2' , NOW() , NOW() ) 20/11/2023 02:34:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21855' , '0' , '1' , '0' , '0' ) 20/11/2023 02:36:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846278334' AND id_product != '21855' AND ean13 != '' 20/11/2023 02:36:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846278334', date_upd = NOW() WHERE id_product = '21855' 20/11/2023 02:36:41 pm >> UPDATE ps_product_lang SET name = 'CROCE S. BENEDETTO CON BASE CM 20 - PG399-BM.BI', description = '' WHERE id_product = '21855' 20/11/2023 02:36:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '37.704918032786885' WHERE id_product = '21855' 20/11/2023 02:36:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '37.704918032786885', id_tax_rules_group = '1', id_category_default = '151', 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 = '21855' 20/11/2023 02:36:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '21855' 20/11/2023 02:36:43 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 = '21855' 20/11/2023 02:36:43 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21856' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 02:36:43 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 '21856' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21855' 20/11/2023 02:36:43 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21856' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21855' 20/11/2023 02:38:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846279355' AND id_product != '21856' AND ean13 != '' 20/11/2023 02:38:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846279355', date_upd = NOW() WHERE id_product = '21856' 20/11/2023 02:38:49 pm >> UPDATE ps_product_lang SET name = 'CROCE S. BENEDETTO CON BASE CM 19 - PG599-BM.BLU', description = '' WHERE id_product = '21856' 20/11/2023 02:38:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.885245901639344' WHERE id_product = '21856' 20/11/2023 02:38:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.885245901639344', id_tax_rules_group = '1', id_category_default = '151', 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 = '21856' 20/11/2023 02:38:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '21856' 20/11/2023 02:38:50 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 = '21856' 20/11/2023 02:38:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21857' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 02:38:50 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 '21857' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21856' 20/11/2023 02:38:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21857' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21856' 20/11/2023 02:40:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846278679' AND id_product != '21857' AND ean13 != '' 20/11/2023 02:40:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846278679', date_upd = NOW() WHERE id_product = '21857' 20/11/2023 02:40:20 pm >> UPDATE ps_product_lang SET name = 'CROCE SAN BENEDETTO CM 19 - PG599.RSS', description = '' WHERE id_product = '21857' 20/11/2023 02:40:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26.229508196721312' WHERE id_product = '21857' 20/11/2023 02:40:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26.229508196721312', id_tax_rules_group = '1', id_category_default = '151', 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 = '21857' 20/11/2023 02:40:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '21857' 20/11/2023 02:40:44 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846279355' AND id_product != '21856' AND ean13 != '' 20/11/2023 02:40:44 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846279355', date_upd = NOW() WHERE id_product = '21856' 20/11/2023 02:40:44 pm >> UPDATE ps_product_lang SET name = 'CROCE S. BENEDETTO CON BASE CM 20 - PG599-BM.BLU', description = '' WHERE id_product = '21856' 20/11/2023 02:40:44 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.8852' WHERE id_product = '21856' 20/11/2023 02:40:44 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.8852', id_tax_rules_group = '1', id_category_default = '151', 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 = '21856' 20/11/2023 02:40:44 pm >> DELETE FROM ps_specific_price WHERE id_product = '21856' 20/11/2023 02:41:08 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 = '21857' 20/11/2023 02:41:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21858' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 02:41:08 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 '21858' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21857' 20/11/2023 02:41:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21858' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21857' 20/11/2023 02:43:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000469' AND id_product != '21858' AND ean13 != '' 20/11/2023 02:43:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '000469', date_upd = NOW() WHERE id_product = '21858' 20/11/2023 02:43:37 pm >> UPDATE ps_product_lang SET name = 'ANELLO S. LUCIA', description = '' WHERE id_product = '21858' 20/11/2023 02:43:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.4918032786885246' WHERE id_product = '21858' 20/11/2023 02:43:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.4918032786885246', id_tax_rules_group = '1', id_category_default = '151', 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 = '21858' 20/11/2023 02:43:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '21858' 20/11/2023 02:55:23 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/11/2023 02:55:23 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21859' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 02:55:23 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21859' , '1' , '1' , '2' , NOW() , NOW() ) 20/11/2023 02:55:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21859' , '0' , '1' , '0' , '0' ) 20/11/2023 02:57:04 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846293634' AND id_product != '21859' AND ean13 != '' 20/11/2023 02:57:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846293634', date_upd = NOW() WHERE id_product = '21859' 20/11/2023 02:57:04 pm >> UPDATE ps_product_lang SET name = 'NATIVITA\' - ST333-NT', description = '' WHERE id_product = '21859' 20/11/2023 02:57:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '53.278688524590166' WHERE id_product = '21859' 20/11/2023 02:57:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '53.278688524590166', id_tax_rules_group = '1', id_category_default = '151', 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 = '21859' 20/11/2023 02:57:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '21859' 20/11/2023 02:58:39 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 20/11/2023 02:58:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21860' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 02:58:40 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21860' , '1' , '1' , '2' , NOW() , NOW() ) 20/11/2023 02:58:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21860' , '0' , '1' , '0' , '0' ) 20/11/2023 03:17:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846293368' AND id_product != '21860' AND ean13 != '' 20/11/2023 03:17:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846293368', date_upd = NOW() WHERE id_product = '21860' 20/11/2023 03:17:00 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 10 - PKS10-C', description = '' WHERE id_product = '21860' 20/11/2023 03:17:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.737704918032787' WHERE id_product = '21860' 20/11/2023 03:17:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.737704918032787', id_tax_rules_group = '1', id_category_default = '151', 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 = '21860' 20/11/2023 03:17:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '21860' 20/11/2023 03:17:31 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 = '21860' 20/11/2023 03:17:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21861' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 03:17:31 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 '21861' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21860' 20/11/2023 03:17:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21861' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21860' 20/11/2023 03:18:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846293351' AND id_product != '21861' AND ean13 != '' 20/11/2023 03:18:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846293351', date_upd = NOW() WHERE id_product = '21861' 20/11/2023 03:18:20 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 7 - PKS07-C', description = '' WHERE id_product = '21861' 20/11/2023 03:18:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.278688524590164' WHERE id_product = '21861' 20/11/2023 03:18:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.278688524590164', id_tax_rules_group = '1', id_category_default = '151', 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 = '21861' 20/11/2023 03:18:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '21861' 20/11/2023 03:18:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846293351' AND id_product != '21861' AND ean13 != '' 20/11/2023 03:18:45 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846293351', date_upd = NOW() WHERE id_product = '21861' 20/11/2023 03:18:45 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 7 - PKS07-C', description = '' WHERE id_product = '21861' 20/11/2023 03:18:45 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3.278688524590164' WHERE id_product = '21861' 20/11/2023 03:18:45 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3.278688524590164', id_tax_rules_group = '1', id_category_default = '151', 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 = '21861' 20/11/2023 03:18:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '21861' 20/11/2023 03:18:47 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 = '21861' 20/11/2023 03:18:47 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21862' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 03:18:47 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 '21862' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21861' 20/11/2023 03:18:47 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21862' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21861' 20/11/2023 03:19:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846293375' AND id_product != '21862' AND ean13 != '' 20/11/2023 03:19:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846293375', date_upd = NOW() WHERE id_product = '21862' 20/11/2023 03:19:40 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 10 - PKS20-C', description = '' WHERE id_product = '21862' 20/11/2023 03:19:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22.13114754098361' WHERE id_product = '21862' 20/11/2023 03:19:40 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22.13114754098361', id_tax_rules_group = '1', id_category_default = '151', 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 = '21862' 20/11/2023 03:19:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '21862' 20/11/2023 03:20:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846293375' AND id_product != '21862' AND ean13 != '' 20/11/2023 03:20:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846293375', date_upd = NOW() WHERE id_product = '21862' 20/11/2023 03:20:10 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 10 - PKS20-C', description = '' WHERE id_product = '21862' 20/11/2023 03:20:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22.13114754098361' WHERE id_product = '21862' 20/11/2023 03:20:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22.13114754098361', id_tax_rules_group = '1', id_category_default = '151', 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 = '21862' 20/11/2023 03:20:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '21862' 20/11/2023 03:20:14 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 = '21862' 20/11/2023 03:20:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21863' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 03:20:14 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 '21863' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21862' 20/11/2023 03:20:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21863' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21862' 20/11/2023 03:21:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846293399' AND id_product != '21863' AND ean13 != '' 20/11/2023 03:21:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846293399', date_upd = NOW() WHERE id_product = '21863' 20/11/2023 03:21:32 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 30 - PKS30-C', description = '' WHERE id_product = '21863' 20/11/2023 03:21:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '43.442622950819676' WHERE id_product = '21863' 20/11/2023 03:21:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '43.442622950819676', id_tax_rules_group = '1', id_category_default = '151', 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 = '21863' 20/11/2023 03:21:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '21863' 20/11/2023 03:22:21 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846293399' AND id_product != '21863' AND ean13 != '' 20/11/2023 03:22:21 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846293399', date_upd = NOW() WHERE id_product = '21863' 20/11/2023 03:22:21 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 40 - PKS40-C', description = '' WHERE id_product = '21863' 20/11/2023 03:22:21 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '118.0327868852459' WHERE id_product = '21863' 20/11/2023 03:22:21 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '118.0327868852459', id_tax_rules_group = '1', id_category_default = '151', 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 = '21863' 20/11/2023 03:22:21 pm >> DELETE FROM ps_specific_price WHERE id_product = '21863' 20/11/2023 03:23:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846293399' AND id_product != '21863' AND ean13 != '' 20/11/2023 03:23:36 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846293399', date_upd = NOW() WHERE id_product = '21863' 20/11/2023 03:23:36 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 40 - PKS40-C', description = '' WHERE id_product = '21863' 20/11/2023 03:23:36 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '118.0327868852459' WHERE id_product = '21863' 20/11/2023 03:23:36 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '118.0327868852459', id_tax_rules_group = '1', id_category_default = '151', 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 = '21863' 20/11/2023 03:23:36 pm >> DELETE FROM ps_specific_price WHERE id_product = '21863' 20/11/2023 03:24:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '131/A' AND id_document != '89033' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 03:24:15 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '131/A', document_date = '2023-11-20', document_letter = 'A', id_customer = '292', id_supplier = '', id_address = '4676365', address1 = 'VIA IONIO 8/A 84091 BATTIPAGLIA', 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 = '790.80', price_tax_excluded = '790.80', date_upd = NOW() WHERE id_document = '89033' 20/11/2023 03:24:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89033' 20/11/2023 03:24:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '89033' 20/11/2023 03:24:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '6619' , 'MIA IMPRONTA È TUA - 1 QUADERNO' , '45' , '-45' , '4' , '4.5000' , '4.5' , '0' , '' , '202.50' ) 20/11/2023 03:24:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '12864' , 'IMPRONTE DI MISERICORDIA E DI PERDONO - SUSSIDIO' , '32' , '-32' , '4' , '4.5000' , '4.5' , '0' , '0' , '144.00' ) 20/11/2023 03:24:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '14529' , 'PANE E VINO - SUSSIDIO' , '48' , '-48' , '4' , '4.5000' , '4.5' , '0' , '0' , '216.00' ) 20/11/2023 03:24:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '14530' , 'PANE E VINO - GUIDA 3' , '1' , '-1' , '4' , '13.5000' , '13.5' , '0' , '0' , '13.50' ) 20/11/2023 03:24:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '15926' , 'COMUNITA: SEGNI DI BELLEZZA - 4 QUADERNO' , '15' , '-15' , '4' , '4.5000' , '4.5' , '0' , '0' , '67.50' ) 20/11/2023 03:24:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '15927' , 'COMUNITA’ SEGNI DI BELLEZZA - 4 GUIDA' , '1' , '-1' , '4' , '13.5000' , '13.5' , '0' , '0' , '13.50' ) 20/11/2023 03:24:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '18564' , 'CONNESSI CON GESU’ - AGENDUM 2' , '15' , '-15' , '4' , '4.5000' , '4.5' , '0' , '0' , '67.50' ) 20/11/2023 03:24:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '20' , '-20' , '4' , '3.4000' , '3.4' , '0' , '15' , '57.80' ) 20/11/2023 03:24:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89033' , '8514' , 'PRIMI PASSI CON GESÙ ANNO B - GUIDA' , '2' , '-2' , '4' , '5.0000' , '5' , '0' , '15' , '8.50' ) 20/11/2023 03:25:30 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 = '21863' 20/11/2023 03:25:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21864' , '1' , '' , 'nuovo-prodotto' ) 20/11/2023 03:25:30 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 '21864' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21863' 20/11/2023 03:25:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21864' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21863' 20/11/2023 03:26:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846293382' AND id_product != '21864' AND ean13 != '' 20/11/2023 03:26:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846293382', date_upd = NOW() WHERE id_product = '21864' 20/11/2023 03:26:59 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 30 - PKS30-C', description = '' WHERE id_product = '21864' 20/11/2023 03:26:59 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '43.442622950819676' WHERE id_product = '21864' 20/11/2023 03:26:59 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '43.442622950819676', id_tax_rules_group = '1', id_category_default = '151', 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 = '21864' 20/11/2023 03:26:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '21864' 20/11/2023 03:32:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846293375' AND id_product != '21862' AND ean13 != '' 20/11/2023 03:32:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846293375', date_upd = NOW() WHERE id_product = '21862' 20/11/2023 03:32:50 pm >> UPDATE ps_product_lang SET name = 'BAMBINELLO CM 20 - PKS20-C', description = '' WHERE id_product = '21862' 20/11/2023 03:32:50 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '22.1311' WHERE id_product = '21862' 20/11/2023 03:32:50 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '22.1311', id_tax_rules_group = '1', id_category_default = '151', 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 = '21862' 20/11/2023 03:32:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '21862' 20/11/2023 03:35:01 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846278334' AND id_product != '21855' AND ean13 != '' 20/11/2023 03:35:01 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846278334', date_upd = NOW() WHERE id_product = '21855' 20/11/2023 03:35:01 pm >> UPDATE ps_product_lang SET name = 'CROCE S. BENEDETTO CON BASE CM 20 - PG339-BM.BI', description = '' WHERE id_product = '21855' 20/11/2023 03:35:01 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '37.7049' WHERE id_product = '21855' 20/11/2023 03:35:01 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '37.7049', id_tax_rules_group = '1', id_category_default = '151', 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 = '21855' 20/11/2023 03:35:01 pm >> DELETE FROM ps_specific_price WHERE id_product = '21855' 20/11/2023 03:37:55 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '2429/2023', document_date = '2023-11-17', document_letter = '2023', id_customer = '0', id_supplier = '', id_address = '2638', address1 = 'VIA COSTABIANCA, 43 60025 LORETO', address2 = '', note = '', price_shipping = '21', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '797.27', price_tax_excluded = '653.50', date_upd = NOW() WHERE id_document = '89042' 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89042' 20/11/2023 03:37:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '89042' 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21848' , 'PORTACHIAVI ACUTIS - PC240' , '50' , '50' , '1' , '0.8700' , '0.71311475409836' , '22' , '10' , '47.76' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '4915' , 'ICONA SU TELA LEGNO MADONNA NODI CM 22X16,5 - AN025MN' , '1' , '1' , '1' , '12.6200' , '10.344262295082' , '22' , '10' , '13.86' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21849' , 'MEDAGLIA ARGENTO SAN MICHELE - RA856' , '1' , '1' , '1' , '27.2000' , '22.295081967213' , '22' , '10' , '29.87' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '6342' , 'MEDAGLIA S. BENEDETTO ARGENTO - RA633' , '1' , '1' , '1' , '13.7500' , '11.270491803279' , '22' , '10' , '15.10' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '16060' , 'MEDAGLIA S. ANNA - FM022' , '100' , '100' , '1' , '0.1386' , '0.11360655737705' , '22' , '10' , '15.22' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '17883' , 'CROCE MOGANO CORPO MET CM 28- 169M' , '10' , '10' , '1' , '5.9400' , '4.8688524590164' , '22' , '10' , '65.22' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '17885' , 'CROCE FAGGIO CORPO MET CM 28 - 169' , '10' , '10' , '1' , '5.9400' , '4.8688524590164' , '22' , '10' , '65.22' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '20964' , 'STATUA SAN MICHELE - ST322-SM' , '1' , '1' , '1' , '5.3' , '4.344262295082' , '22' , '10' , '5.8194' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21851' , 'CORPO CRISTO' , '1' , '1' , '1' , '7.38' , '6.0491803278689' , '22' , '10' , '8.1032' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '19720' , 'CROCE LEGNO MET. - CL247' , '1' , '1' , '1' , '10.01' , '8.2049180327869' , '22' , '10' , '10.9910' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21852' , 'CROCE ULIVO CON BASE - CM 20 - PG035/B' , '1' , '1' , '1' , '16.18' , '13.262295081967' , '22' , '10' , '17.7656' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21853' , 'CROCE MOGANO CON BASE - CLB263ARG ' , '1' , '1' , '1' , '14.3' , '11.72131147541' , '22' , '10' , '15.7014' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21854' , 'CROCIFISSO ULIVO CM 34 - PG038' , '1' , '1' , '1' , '20.13' , '16.5' , '22' , '10' , '22.1027' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21859' , 'NATIVITA\' - ST333-NT' , '1' , '1' , '1' , '28.5' , '23.360655737705' , '22' , '10' , '31.2930' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21861' , 'BAMBINELLO CM 7 - PKS07-C' , '60' , '60' , '1' , '1.7' , '1.3934426229508' , '22' , '10' , '111.9960' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21860' , 'BAMBINELLO CM 10 - PKS10-C' , '10' , '10' , '1' , '2.9' , '2.3770491803279' , '22' , '10' , '31.8420' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21862' , 'BAMBINELLO CM 20 - PKS20-C' , '3' , '3' , '1' , '12' , '9.8360655737705' , '22' , '10' , '39.5280' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21864' , 'BAMBINELLO CM 30 - PKS30-C' , '1' , '1' , '1' , '22' , '18.032786885246' , '22' , '10' , '24.1560' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21863' , 'BAMBINELLO CM 40 - PKS40-C' , '1' , '1' , '1' , '59' , '48.360655737705' , '22' , '10' , '64.7820' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21855' , 'CROCE S. BENEDETTO CON BASE CM 20 - PG339-BM.BI' , '1' , '1' , '1' , '19.36' , '15.868852459016' , '22' , '10' , '21.2573' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21857' , 'CROCE SAN BENEDETTO CM 19 - PG599.RSS' , '1' , '1' , '1' , '13.24' , '10.852459016393' , '22' , '10' , '14.5375' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21856' , 'CROCE S. BENEDETTO CON BASE CM 20 - PG599-BM.BLU' , '1' , '1' , '1' , '18.64' , '15.27868852459' , '22' , '10' , '20.4667' ) 20/11/2023 03:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89042' , '21858' , 'ANELLO S. LUCIA' , '300' , '300' , '1' , '0.24' , '0.19672131147541' , '22' , '10' , '79.0560' ) 20/11/2023 03:57:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '3665' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 03:57:17 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' , '3665' , '2023-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.00' , '21.31' , NOW() , NOW() ) 20/11/2023 03:57:17 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 = '89043' 20/11/2023 03:57:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89043' 20/11/2023 03:57: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 ( '89043' , '15774' , 'INCENSO NARJAN - 500G' , '1' , '-1' , '1' , '26.00' , '21.311475409836' , '22' , '0' , '26.00' ) 20/11/2023 04:00:00 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'GmcyM2ZdsHcjmmkF' , NOW() , NOW() ) 20/11/2023 04:00:00 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4058' , '1' ) 20/11/2023 04:00:00 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4058' , '2' ) 20/11/2023 04:00:00 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4058' , '3' ) 20/11/2023 04:01:08 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4058' 20/11/2023 04:01:08 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 ( '4058' , '10' , '130' , '' , 'CARBONARA' , 'MICHELE' , 'VIA MADONNA DELLE GRAZIE' , '' , '83051' , 'NUSCO' , '' , '' , '3208158471' , '' , '' , NOW() , NOW() ) 20/11/2023 04:01:08 pm >> UPDATE ps_customer SET email = 'mikecarb@hotmail.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4058' 20/11/2023 04:02:11 pm >> SELECT document_num FROM ps_document WHERE document_num = '280' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 04:02:11 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '280' , '2023-11-20' , '' , '4058' , '0' , '4679194' , 'VIA MADONNA DELLE GRAZIE 83051 NUSCO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '88.16' , '88.16' , NOW() , NOW() ) 20/11/2023 04:02:11 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89044' 20/11/2023 04:02:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89044' 20/11/2023 04:02:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89044' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '32' , '-32' , '4' , '2.40' , '2.4' , '0' , '5' , '72.96' ) 20/11/2023 04:02:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89044' , '8489' , 'PRIMA CONFESSIONE... - GUIDA' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 20/11/2023 04:08:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '48' AND id_document != '88971' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-11-15') 20/11/2023 04:08:14 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '48', document_date = '2023-11-15', document_letter = '', id_customer = '3000', id_supplier = '', id_address = '4669629', address1 = 'VIA DEI CASTANI, 116 00172 ROMA', address2 = '', note = 'EDIZIONI', 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 = '3435.00', price_tax_excluded = '3435.00', date_upd = NOW() WHERE id_document = '88971' 20/11/2023 04:08: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 = '88971' 20/11/2023 04:08:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '88971' 20/11/2023 04:08: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 ( '88971' , '2679' , 'CONOSCERE GESU\'' , '640' , '-640' , '4' , '3.5000' , '3.5' , '0' , '0' , '2240.00' ) 20/11/2023 04:08: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 ( '88971' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '45' , '-45' , '4' , '6.0000' , '6' , '0' , '0' , '270.00' ) 20/11/2023 04:08: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 ( '88971' , '21417' , 'VIENI, NON TARDARE SIGNORE, NOSTRA PACE!' , '175' , '-175' , '4' , '2.5000' , '2.5' , '0' , '0' , '437.50' ) 20/11/2023 04:08: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 ( '88971' , '21418' , 'CRISTO NOSTRA PACE - V. SALVORDI' , '75' , '-75' , '4' , '2.5000' , '2.5' , '0' , '0' , '187.50' ) 20/11/2023 04:08:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '88971' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '30' , '-30' , '4' , '10.0000' , '10' , '0' , '0' , '300.00' ) 20/11/2023 04:21:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '108' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 04:21: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 ( '21' , '108' , '2023-11-20' , '' , '3411' , '0' , '154022847' , 'VIA VITTORIO DE SICA 21 20153 MILANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '36.00' , '36.00' , NOW() , NOW() ) 20/11/2023 04:21: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 = '13754' 20/11/2023 04:21:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '13754' 20/11/2023 04:21: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 ( '13754' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '2' , '-2' , '4' , '18.00' , '18' , '0' , '0' , '36.00' ) 20/11/2023 04:30:01 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '336/23', document_date = '2023-11-14', document_letter = '23', id_customer = '0', id_supplier = '', id_address = '4671003', address1 = '', address2 = '', note = 'ins numero', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '56.75', price_tax_excluded = '56.75', date_upd = NOW() WHERE id_document = '89020' 20/11/2023 04:30:01 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89020' 20/11/2023 04:30:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '89020' 20/11/2023 04:30: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 ( '89020' , '9603' , 'SANTA RITA DA CASCIA - V. PERI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '21843' , 'SAN GIOVANNI DI DIO - J. REDRADO' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '19667' , 'SAN BERNARDO DI CHIARAVALLE - G. PESENTI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '4926' , 'IGNAZIO DI LOYOLA - F. OCCHETTA' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9454' , 'SAN GIOVANNI DELLA CROCE - G.PESENTI' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9399' , 'SAN CAMILLO DE LELLIS - F. RUFFINI' , '1' , '1' , '4' , '5.0000' , '5' , '0' , '50' , '2.50' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9429' , 'SAN FRANCESCO DI PAOLA - R. BENVENUTO' , '2' , '2' , '4' , '3.5000' , '3.5' , '0' , '50' , '3.50' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9420' , 'SAN FRANCESCO DASSISI' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '7385' , 'SAN PIO DA PIETRELCINA - L. DA FARA' , '2' , '2' , '4' , '5.0000' , '5' , '0' , '50' , '5.00' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9441' , 'SAN GERARDO MAIELLA' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '21844' , 'SETTE DONI DELLO SPIRITO SANTO' , '20' , '20' , '4' , '0.6000' , '0.6' , '0' , '50' , '6.00' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9513' , 'SAN SIMONE APOSTOLO - F. INNOCENTE' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9516' , 'SAN TOMMASO APOSTOLO - G. POLIDORO' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '9630' , 'SANTI FILIPPO E GIACOMO APOSTOLI - A. GOVERNALE' , '1' , '1' , '4' , '3.5000' , '3.5' , '0' , '50' , '1.75' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '21845' , 'VIENI SIGNORE GESU!' , '3' , '3' , '4' , '2.5000' , '2.5' , '0' , '50' , '3.75' ) 20/11/2023 04:30:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89020' , '21846' , 'AGENDINA VITA CRISTIANA 2024' , '3' , '3' , '4' , '7' , '7' , '0' , '50' , '10.5000' ) 20/11/2023 04:50:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3666' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 04:50:24 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' , '3666' , '2023-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.60' , '53.60' , NOW() , NOW() ) 20/11/2023 04:50:24 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89045' 20/11/2023 04:50:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '89045' 20/11/2023 04:50:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89045' , '21196' , 'CALENDARIO LITURGICO 2024' , '10' , '-10' , '4' , '0.50' , '0.5' , '0' , '0' , '5.00' ) 20/11/2023 04:50:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89045' , '21679' , 'LAUDATE DEUM - 8583' , '40' , '-40' , '4' , '1.00' , '1' , '0' , '5' , '38.00' ) 20/11/2023 04:50:24 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89045' , '18909' , 'NATIVITA CREA E GIOCA' , '1' , '-1' , '4' , '10.60' , '10.6' , '0' , '' , '10.60' ) 20/11/2023 04:55: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 ( '33' , '1091' , '2023-11-20' , '' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 20/11/2023 04:55: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 = '89046' 20/11/2023 04:55:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '89046' 20/11/2023 04:55: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 ( '89046' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '500' , '500' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 20/11/2023 04:55:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21799' AND id_supplier = '159' 20/11/2023 04:55:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21799' , '159' , '1' ) 20/11/2023 05:02:52 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3411' 20/11/2023 05:02:52 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 ( '3411' , '10' , '180' , '' , 'ZURLO' , 'EMANUELA' , 'VIA VITTORIO DE SICA 21' , '' , '20153' , 'MILANO' , 'SPEDIZIONE: VIA APPENNINI 139 20151 MILANO' , '' , '3664753715' , '' , '' , NOW() , NOW() ) 20/11/2023 05:02:52 pm >> UPDATE ps_customer SET email = 'emanu-z@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3411' 20/11/2023 05:37:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '108' AND id_document != '13754' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 05:37:05 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '108', document_date = '2023-11-20', document_letter = '', id_customer = '3411', id_supplier = '', id_address = '154022847', address1 = 'VIA VITTORIO DE SICA 21 20153 MILANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '54.00', price_tax_excluded = '54.00', date_upd = NOW() WHERE id_document = '13754' 20/11/2023 05:37: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 = '13754' 20/11/2023 05:37:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '13754' 20/11/2023 05:37: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 ( '13754' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '3' , '-3' , '4' , '18.0000' , '18' , '0' , '0' , '54.00' ) 20/11/2023 07:44:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3667' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-20') 20/11/2023 07:44:43 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' , '3667' , '2023-11-20' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '106.50' , '87.30' , NOW() , NOW() ) 20/11/2023 07:44:43 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 = '89047' 20/11/2023 07:44:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '89047' 20/11/2023 07:44:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89047' , '2164' , 'CLERGY BASIC EXTRA - ML - B&P' , '3' , '-3' , '1' , '35.5' , '29.098360655738' , '22' , '0' , '106.50' )