14/03/2023 09:27:29 am >> SELECT document_num FROM ps_document WHERE document_num = '5/A' AND id_document != '78795' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-12') 14/03/2023 09:27:29 am >> UPDATE ps_document SET id_document_type = '24', document_num = '5/A', document_date = '2023-01-12', document_letter = 'A', id_customer = '1148', id_supplier = '', id_address = '1148', address1 = 'P.ZZA GIOVANNI PAOLO II, 4 84080 COPERCHIA', 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 = '230.28', price_tax_excluded = '230.28', date_upd = NOW() WHERE id_document = '78795' 14/03/2023 09:27:30 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 = '78795' 14/03/2023 09:27:30 am >> DELETE FROM ps_document_detail WHERE id_document = '78795' 14/03/2023 09:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20150' , 'MANUALE PER APPRENDISTI GENITORI - P. PELLEGRINO' , '3' , '-3' , '4' , '14.8000' , '14.8' , '0' , '5' , '42.18' ) 14/03/2023 09:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 14/03/2023 09:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 14/03/2023 09:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 14/03/2023 09:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2073' , 'CINQUE LINGUAGGI DELLAMORE DEI BAMBINI - PER GENITORI E EDUCATORI' , '4' , '-4' , '4' , '13.0000' , '13' , '0' , '5' , '49.40' ) 14/03/2023 09:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '3219' , 'CUORE DEI 5 LINGUAGGI DELLAMORE - G. CHAPMAN' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 14/03/2023 09:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2074' , 'CINQUE LINGUAGGI DELLAMORE DI DIO - PER GENITORI E EDUCATORI' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 14/03/2023 09:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2070' , 'CINQUE LINGUAGGI DEL PERDONO - G. CHAPMAN' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 14/03/2023 09:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '2072' , 'CINQUE LINGUAGGI DELLAMORE CON GLI ADOLESCENTI - PER GENITORI E EDUCA' , '2' , '-2' , '4' , '13.0000' , '13' , '0' , '5' , '24.70' ) 14/03/2023 09:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '2' , '-2' , '4' , '9.0000' , '9' , '0' , '5' , '17.10' ) 14/03/2023 09:27:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78795' , '20804' , 'AFFIDABILI STORIE DI DONNE - L. M. EPICOCO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 14/03/2023 09:33:30 am >> SELECT document_num FROM ps_document WHERE document_num = '833' AND id_document != '82287' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-13') 14/03/2023 09:33:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '833', document_date = '2023-03-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '27.80', price_tax_excluded = '25.90', date_upd = NOW() WHERE id_document = '82287' 14/03/2023 09:33:30 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 = '82287' 14/03/2023 09:33:30 am >> DELETE FROM ps_document_detail WHERE id_document = '82287' 14/03/2023 09:33:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '17.50' ) 14/03/2023 09:33:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 14/03/2023 09:33:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 14/03/2023 09:33:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82287' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.8' , '5.5737704918033' , '22' , '0' , '6.80' ) 14/03/2023 10:27:49 am >> SELECT document_num FROM ps_document WHERE document_num = '834' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 10:27:50 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' , '834' , '2023-03-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '215.00' , '176.23' , NOW() , NOW() ) 14/03/2023 10:27:50 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 = '82288' 14/03/2023 10:27:50 am >> DELETE FROM ps_document_detail WHERE id_document = '82288' 14/03/2023 10:27:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82288' , '16512' , 'SAN GIUSEPPE CM 60' , '1' , '-1' , '1' , '215.00' , '176.22950819672' , '22' , '0' , '215.00' ) 14/03/2023 10:30:37 am >> DELETE FROM ps_document WHERE id_document = '81232' 14/03/2023 10:30:38 am >> DELETE FROM ps_document_detail WHERE id_document = '81232' 14/03/2023 10:39:07 am >> SELECT document_num FROM ps_document WHERE document_num = '34/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 10:39:07 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' , '34/A' , '2023-03-14' , 'A' , '1656' , '0' , '4677544' , 'VIA NAZIONALE 84060 OMIGNANO SCALO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '637.50' , '522.54' , NOW() , NOW() ) 14/03/2023 10:39:07 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82289' 14/03/2023 10:39:07 am >> DELETE FROM ps_document_detail WHERE id_document = '82289' 14/03/2023 10:39:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82289' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '2' , '-2' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '90.00' ) 14/03/2023 10:39:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82289' , '16730' , 'TUNICA AVORIO BORDO ORO - AETA03B05' , '8' , '-8' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '440.00' ) 14/03/2023 10:39:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82289' , '15481' , 'CROCE IHS - 2389/CZ' , '27' , '-27' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '67.50' ) 14/03/2023 10:39:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82289' , '18223' , 'CORONA MISSIONARIA - R102' , '40' , '-40' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '40.00' ) 14/03/2023 10:49:19 am >> SELECT document_num FROM ps_document WHERE document_num = '835' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 10:49:19 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '835' , '2023-03-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '352.00' , '301.54' , NOW() , NOW() ) 14/03/2023 10:49:19 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82290' 14/03/2023 10:49:19 am >> DELETE FROM ps_document_detail WHERE id_document = '82290' 14/03/2023 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82290' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '260' , '213.11475409836' , '22' , '0' , '260.00' ) 14/03/2023 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82290' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 14/03/2023 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82290' , '15332' , 'GRANI PER CERO' , '1' , '-1' , '1' , '12.8' , '10.491803278689' , '22' , '0' , '12.80' ) 14/03/2023 10:49:19 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82290' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '2' , '-2' , '4' , '38.00' , '38' , '0' , '5' , '72.20' ) 14/03/2023 10:55:49 am >> SELECT document_num FROM ps_document WHERE document_num = '836' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 10:55:49 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' , '836' , '2023-03-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 14/03/2023 10:55:49 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 = '82291' 14/03/2023 10:55:49 am >> DELETE FROM ps_document_detail WHERE id_document = '82291' 14/03/2023 10:55:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82291' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4.75' , '4.75' , '0' , '0' , '4.75' ) 14/03/2023 11:02:09 am >> SELECT document_num FROM ps_document WHERE document_num = '837' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 11:02:09 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '837' , '2023-03-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.00' , '45.90' , NOW() , NOW() ) 14/03/2023 11:02:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82292' 14/03/2023 11:02:09 am >> DELETE FROM ps_document_detail WHERE id_document = '82292' 14/03/2023 11:02:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82292' , '14994' , 'PIZZO TOMBOLO ORO MEZZO FINO' , '4' , '-4' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '34.00' ) 14/03/2023 11:02:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82292' , '923' , 'BALZA RICAMATA CM 9,6 - VIOLA - KOM/030 - OGGETTI' , '1' , '-1' , '1' , '22.00' , '18.032786885246' , '22' , '0' , '22.00' ) 14/03/2023 11:04:18 am >> DELETE FROM ps_document WHERE id_document = '75559' 14/03/2023 11:04:18 am >> DELETE FROM ps_document_detail WHERE id_document = '75559' 14/03/2023 11:40:11 am >> SELECT document_num FROM ps_document WHERE document_num = '838' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 11:40:11 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '838' , '2023-03-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '170.00' , '148.36' , NOW() , NOW() ) 14/03/2023 11:40:11 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82293' 14/03/2023 11:40:11 am >> DELETE FROM ps_document_detail WHERE id_document = '82293' 14/03/2023 11:40:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82293' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '50' , '50' , '0' , '0' , '50.00' ) 14/03/2023 11:40:11 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82293' , '13805' , 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024' , '12' , '-12' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '120.00' ) 14/03/2023 12:21:52 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400296990' AND id_product != '15399' AND ean13 != '' 14/03/2023 12:21:52 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400296990', date_upd = NOW() WHERE id_product = '15399' 14/03/2023 12:21:52 pm >> UPDATE ps_product_lang SET name = 'CONF. CARTONCINO SIMBOLO MADRE PERLA CONFESSIONE - 1907/J44', description = '' WHERE id_product = '15399' 14/03/2023 12:21:52 pm >> UPDATE ps_product SET wholesale_price = '0.90', on_sale = '0', price = '2.459016393442623' WHERE id_product = '15399' 14/03/2023 12:21:52 pm >> UPDATE ps_product_shop SET wholesale_price = '0.90', price = '2.459016393442623', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15399' 14/03/2023 12:21:52 pm >> DELETE FROM ps_specific_price WHERE id_product = '15399' 14/03/2023 12:24:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400266580' AND id_product != '13799' AND ean13 != '' 14/03/2023 12:24:25 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400266580', date_upd = NOW() WHERE id_product = '13799' 14/03/2023 12:24:25 pm >> UPDATE ps_product_lang SET name = 'CROCETTA CONFESSIONE - 2370/J44', description = '' WHERE id_product = '13799' 14/03/2023 12:24:25 pm >> UPDATE ps_product SET wholesale_price = '0.90', on_sale = '0', price = '2.377049180327869' WHERE id_product = '13799' 14/03/2023 12:24:25 pm >> UPDATE ps_product_shop SET wholesale_price = '0.90', price = '2.377049180327869', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13799' 14/03/2023 12:24:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '13799' 14/03/2023 12:24:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400297072' AND id_product != '18318' AND ean13 != '' 14/03/2023 12:24:56 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400297072', date_upd = NOW() WHERE id_product = '18318' 14/03/2023 12:24:56 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE BRACCIALE MULTICOLORE COMUNIONE - 2377/K0001', description = '' WHERE id_product = '18318' 14/03/2023 12:24:56 pm >> UPDATE ps_product SET wholesale_price = '0.96', on_sale = '0', price = '2.2131147540983607' WHERE id_product = '18318' 14/03/2023 12:24:56 pm >> UPDATE ps_product_shop SET wholesale_price = '0.96', price = '2.2131147540983607', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18318' 14/03/2023 12:24:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '18318' 14/03/2023 12:26:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400297010' AND id_product != '19311' AND ean13 != '' 14/03/2023 12:26:34 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400297010', date_upd = NOW() WHERE id_product = '19311' 14/03/2023 12:26:35 pm >> UPDATE ps_product_lang SET name = 'BRACCIALE MADREPERLA COMUNIONE - 1906/K126', description = '' WHERE id_product = '19311' 14/03/2023 12:26:35 pm >> UPDATE ps_product SET wholesale_price = '1.02', on_sale = '0', price = '2.2950819672131146' WHERE id_product = '19311' 14/03/2023 12:26:35 pm >> UPDATE ps_product_shop SET wholesale_price = '1.02', price = '2.2950819672131146', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19311' 14/03/2023 12:26:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '19311' 14/03/2023 12:28:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400312232' AND id_product != '19315' AND ean13 != '' 14/03/2023 12:28:29 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400312232', date_upd = NOW() WHERE id_product = '19315' 14/03/2023 12:28:29 pm >> UPDATE ps_product_lang SET name = 'SCATOLINA METALLO CON CORONCINA COMUNIONE - 1016/K209', description = '' WHERE id_product = '19315' 14/03/2023 12:28:29 pm >> UPDATE ps_product SET wholesale_price = '1.13', on_sale = '0', price = '2.459016393442623' WHERE id_product = '19315' 14/03/2023 12:28:29 pm >> UPDATE ps_product_shop SET wholesale_price = '1.13', price = '2.459016393442623', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19315' 14/03/2023 12:28:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '19315' 14/03/2023 12:28:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400312218' AND id_product != '19316' AND ean13 != '' 14/03/2023 12:28:42 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400312218', date_upd = NOW() WHERE id_product = '19316' 14/03/2023 12:28:42 pm >> UPDATE ps_product_lang SET name = 'SCATOLINA METALLO CON CORONCINA CONFESSIONE - 1016/K159', description = '' WHERE id_product = '19316' 14/03/2023 12:28:42 pm >> UPDATE ps_product SET wholesale_price = '1.13', on_sale = '0', price = '2.459016393442623' WHERE id_product = '19316' 14/03/2023 12:28:42 pm >> UPDATE ps_product_shop SET wholesale_price = '1.13', price = '2.459016393442623', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19316' 14/03/2023 12:28:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '19316' 14/03/2023 12:30:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400325379' AND id_product != '19312' AND ean13 != '' 14/03/2023 12:30:11 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400325379', date_upd = NOW() WHERE id_product = '19312' 14/03/2023 12:30:11 pm >> UPDATE ps_product_lang SET name = 'PORTACHIAVE COMUNIONE - 1828/K25', description = '' WHERE id_product = '19312' 14/03/2023 12:30:11 pm >> UPDATE ps_product SET wholesale_price = '1.00', on_sale = '0', price = '2.2131147540983607' WHERE id_product = '19312' 14/03/2023 12:30:11 pm >> UPDATE ps_product_shop SET wholesale_price = '1.00', price = '2.2131147540983607', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19312' 14/03/2023 12:30:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '19312' 14/03/2023 12:31:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400325966' AND id_product != '19310' AND ean13 != '' 14/03/2023 12:31:42 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400325966', date_upd = NOW() WHERE id_product = '19310' 14/03/2023 12:31:42 pm >> UPDATE ps_product_lang SET name = 'SACCHETTO CON CORONCINA E SEGNALIBRO - 1315/K182', description = '' WHERE id_product = '19310' 14/03/2023 12:31:42 pm >> UPDATE ps_product SET wholesale_price = '1.10', on_sale = '0', price = '2.459016393442623' WHERE id_product = '19310' 14/03/2023 12:31:42 pm >> UPDATE ps_product_shop SET wholesale_price = '1.10', price = '2.459016393442623', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19310' 14/03/2023 12:31:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '19310' 14/03/2023 12:35:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400171310' AND id_product != '2655' AND ean13 != '' 14/03/2023 12:35:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '2016', ean13 = '8058400171310', date_upd = NOW() WHERE id_product = '2655' 14/03/2023 12:35:38 pm >> UPDATE ps_product_lang SET name = 'CONFEZIONE CARTONCINO CONFESSIONE- 2331-J44', description = '' WHERE id_product = '2655' 14/03/2023 12:35:38 pm >> UPDATE ps_product SET wholesale_price = '0.90', on_sale = '0', price = '2.0491803278688523' WHERE id_product = '2655' 14/03/2023 12:35:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.90', price = '2.0491803278688523', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '2655' 14/03/2023 12:35:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '2655' 14/03/2023 12:36:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400207613' AND id_product != '13544' AND ean13 != '' 14/03/2023 12:36:54 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400207613', date_upd = NOW() WHERE id_product = '13544' 14/03/2023 12:36:54 pm >> UPDATE ps_product_lang SET name = 'SCATOLINA CORONCINA CONFESSIONE - 2361/J10', description = '' WHERE id_product = '13544' 14/03/2023 12:36:54 pm >> UPDATE ps_product SET wholesale_price = '1.25', on_sale = '0', price = '2.7049180327868854' WHERE id_product = '13544' 14/03/2023 12:36:54 pm >> UPDATE ps_product_shop SET wholesale_price = '1.25', price = '2.7049180327868854', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13544' 14/03/2023 12:36:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '13544' 14/03/2023 02:58:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001409' AND id_product != '16570' AND ean13 != '' 14/03/2023 02:58:42 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001409', date_upd = NOW() WHERE id_product = '16570' 14/03/2023 02:58:42 pm >> UPDATE ps_product_lang SET name = 'CLERGY COTONE EXTRA ML - C02', description = '' WHERE id_product = '16570' 14/03/2023 02:58:42 pm >> UPDATE ps_product SET wholesale_price = '17.67', on_sale = '0', price = '35.24590163934426' WHERE id_product = '16570' 14/03/2023 02:58:42 pm >> UPDATE ps_product_shop SET wholesale_price = '17.67', price = '35.24590163934426', id_tax_rules_group = '1', id_category_default = '462', 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 = '16570' 14/03/2023 02:58:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '16570' 14/03/2023 02:59:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001951' AND id_product != '19395' AND ean13 != '' 14/03/2023 02:59:05 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001951', date_upd = NOW() WHERE id_product = '19395' 14/03/2023 02:59:05 pm >> UPDATE ps_product_lang SET name = 'CLERGY MISTO COTONE ML - C01', description = '' WHERE id_product = '19395' 14/03/2023 02:59:05 pm >> UPDATE ps_product SET wholesale_price = '15.11', on_sale = '0', price = '30.327868852459016' WHERE id_product = '19395' 14/03/2023 02:59:05 pm >> UPDATE ps_product_shop SET wholesale_price = '15.11', price = '30.327868852459016', id_tax_rules_group = '1', id_category_default = '462', 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 = '19395' 14/03/2023 02:59:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '19395' 14/03/2023 02:59:25 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001952' AND id_product != '19396' AND ean13 != '' 14/03/2023 02:59:25 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001952', date_upd = NOW() WHERE id_product = '19396' 14/03/2023 02:59:25 pm >> UPDATE ps_product_lang SET name = 'CLERGY MISTO COTONE MM - C01', description = '' WHERE id_product = '19396' 14/03/2023 02:59:25 pm >> UPDATE ps_product SET wholesale_price = '14.82', on_sale = '0', price = '29.918032786885245' WHERE id_product = '19396' 14/03/2023 02:59:25 pm >> UPDATE ps_product_shop SET wholesale_price = '14.82', price = '29.918032786885245', id_tax_rules_group = '1', id_category_default = '462', 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 = '19396' 14/03/2023 02:59:25 pm >> DELETE FROM ps_specific_price WHERE id_product = '19396' 14/03/2023 02:59:42 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001953' AND id_product != '19397' AND ean13 != '' 14/03/2023 02:59:43 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001953', date_upd = NOW() WHERE id_product = '19397' 14/03/2023 02:59:43 pm >> UPDATE ps_product_lang SET name = 'CLERGY COTONE 100% ML - C02', description = '' WHERE id_product = '19397' 14/03/2023 02:59:43 pm >> UPDATE ps_product SET wholesale_price = '16.63', on_sale = '0', price = '32.78688524590164' WHERE id_product = '19397' 14/03/2023 02:59:43 pm >> UPDATE ps_product_shop SET wholesale_price = '16.63', price = '32.78688524590164', id_tax_rules_group = '1', id_category_default = '462', 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 = '19397' 14/03/2023 02:59:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '19397' 14/03/2023 03:00:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001954' AND id_product != '19398' AND ean13 != '' 14/03/2023 03:00:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001954', date_upd = NOW() WHERE id_product = '19398' 14/03/2023 03:00:00 pm >> UPDATE ps_product_lang SET name = 'CLERGY COTONE 100% MM - C02', description = '' WHERE id_product = '19398' 14/03/2023 03:00:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '31.9672131147541' WHERE id_product = '19398' 14/03/2023 03:00:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '31.9672131147541', id_tax_rules_group = '1', id_category_default = '462', 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 = '19398' 14/03/2023 03:00:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '19398' 14/03/2023 03:03:12 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001409' AND id_product != '16570' AND ean13 != '' 14/03/2023 03:03:13 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001409', date_upd = NOW() WHERE id_product = '16570' 14/03/2023 03:03:13 pm >> UPDATE ps_product_lang SET name = 'CLERGY COTONE EXTRA ML - C02', description = '' WHERE id_product = '16570' 14/03/2023 03:03:13 pm >> UPDATE ps_product SET wholesale_price = '17.67', on_sale = '0', price = '35.16393442622951' WHERE id_product = '16570' 14/03/2023 03:03:13 pm >> UPDATE ps_product_shop SET wholesale_price = '17.67', price = '35.16393442622951', id_tax_rules_group = '1', id_category_default = '462', 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 = '16570' 14/03/2023 03:03:13 pm >> DELETE FROM ps_specific_price WHERE id_product = '16570' 14/03/2023 03:05:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001653' AND id_product != '19606' AND ean13 != '' 14/03/2023 03:05:58 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001653', date_upd = NOW() WHERE id_product = '19606' 14/03/2023 03:05:58 pm >> UPDATE ps_product_lang SET name = 'CAMICIA SOTTOTALARE MISTO COTONE- C15', description = '' WHERE id_product = '19606' 14/03/2023 03:05:58 pm >> UPDATE ps_product SET wholesale_price = '16.91', on_sale = '0', price = '31.9672131147541' WHERE id_product = '19606' 14/03/2023 03:05:58 pm >> UPDATE ps_product_shop SET wholesale_price = '16.91', price = '31.9672131147541', id_tax_rules_group = '1', id_category_default = '462', 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 = '19606' 14/03/2023 03:05:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '19606' 14/03/2023 03:08:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001410' AND id_product != '19607' AND ean13 != '' 14/03/2023 03:08:02 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001410', date_upd = NOW() WHERE id_product = '19607' 14/03/2023 03:08:02 pm >> UPDATE ps_product_lang SET name = 'CLERGY F/F ML ', description = '' WHERE id_product = '19607' 14/03/2023 03:08:02 pm >> UPDATE ps_product SET wholesale_price = '16.82', on_sale = '0', price = '32.704918032786885' WHERE id_product = '19607' 14/03/2023 03:08:02 pm >> UPDATE ps_product_shop SET wholesale_price = '16.82', price = '32.704918032786885', id_tax_rules_group = '1', id_category_default = '462', 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 = '19607' 14/03/2023 03:08:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '19607' 14/03/2023 03:10:15 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001440' AND id_product != '16657' AND ean13 != '' 14/03/2023 03:10:15 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001440', date_upd = NOW() WHERE id_product = '16657' 14/03/2023 03:10:15 pm >> UPDATE ps_product_lang SET name = 'CLERGY JEANS - ML ', description = '' WHERE id_product = '16657' 14/03/2023 03:10:15 pm >> UPDATE ps_product SET wholesale_price = '22.40', on_sale = '0', price = '50.81967213114754' WHERE id_product = '16657' 14/03/2023 03:10:15 pm >> UPDATE ps_product_shop SET wholesale_price = '22.40', price = '50.81967213114754', id_tax_rules_group = '1', id_category_default = '462', 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 = '16657' 14/03/2023 03:10:15 pm >> DELETE FROM ps_specific_price WHERE id_product = '16657' 14/03/2023 03:12:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001327' AND id_product != '16461' AND ean13 != '' 14/03/2023 03:12:10 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001327', date_upd = NOW() WHERE id_product = '16461' 14/03/2023 03:12:10 pm >> UPDATE ps_product_lang SET name = 'CLERGY NIDO D\'APE ML - C 22', description = '' WHERE id_product = '16461' 14/03/2023 03:12:10 pm >> UPDATE ps_product SET wholesale_price = '23.66', on_sale = '0', price = '47.540983606557376' WHERE id_product = '16461' 14/03/2023 03:12:10 pm >> UPDATE ps_product_shop SET wholesale_price = '23.66', price = '47.540983606557376', id_tax_rules_group = '1', id_category_default = '462', 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 = '16461' 14/03/2023 03:12:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '16461' 14/03/2023 03:14:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001506' AND id_product != '17037' AND ean13 != '' 14/03/2023 03:14:27 pm >> UPDATE ps_product SET id_supplier = '137', reference = '', ean13 = '001506', date_upd = NOW() WHERE id_product = '17037' 14/03/2023 03:14:27 pm >> UPDATE ps_product_lang SET name = 'CLERGY M/LINO MM ', description = '' WHERE id_product = '17037' 14/03/2023 03:14:27 pm >> UPDATE ps_product SET wholesale_price = '26.79', on_sale = '0', price = '53.278688524590166' WHERE id_product = '17037' 14/03/2023 03:14:27 pm >> UPDATE ps_product_shop SET wholesale_price = '26.79', price = '53.278688524590166', id_tax_rules_group = '1', id_category_default = '462', 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 = '17037' 14/03/2023 03:14:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '17037' 14/03/2023 03:15:50 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001837' AND id_product != '18962' AND ean13 != '' 14/03/2023 03:15:50 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001837', date_upd = NOW() WHERE id_product = '18962' 14/03/2023 03:15:50 pm >> UPDATE ps_product_lang SET name = 'POLO MISTO VISCOSA ML ', description = '' WHERE id_product = '18962' 14/03/2023 03:15:50 pm >> UPDATE ps_product SET wholesale_price = '21.60', on_sale = '0', price = '42.622950819672134' WHERE id_product = '18962' 14/03/2023 03:15:50 pm >> UPDATE ps_product_shop SET wholesale_price = '21.60', price = '42.622950819672134', id_tax_rules_group = '1', id_category_default = '462', 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 = '18962' 14/03/2023 03:15:50 pm >> DELETE FROM ps_specific_price WHERE id_product = '18962' 14/03/2023 03:38:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001427' AND id_product != '16588' AND ean13 != '' 14/03/2023 03:38:56 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '001427', date_upd = NOW() WHERE id_product = '16588' 14/03/2023 03:38:56 pm >> UPDATE ps_product_lang SET name = 'CLERGY DIAGONALE MISTO ML - C06', description = '' WHERE id_product = '16588' 14/03/2023 03:38:56 pm >> UPDATE ps_product SET wholesale_price = '15.11', on_sale = '0', price = '38.44262295081967' WHERE id_product = '16588' 14/03/2023 03:38:56 pm >> UPDATE ps_product_shop SET wholesale_price = '15.11', price = '38.44262295081967', id_tax_rules_group = '1', id_category_default = '462', 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 = '16588' 14/03/2023 03:38:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '16588' 14/03/2023 04:30:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000851' AND id_product != '8082' AND ean13 != '' 14/03/2023 04:30:54 pm >> UPDATE ps_product SET id_supplier = '77', reference = '2016', ean13 = '000851', date_upd = NOW() WHERE id_product = '8082' 14/03/2023 04:30:54 pm >> UPDATE ps_product_lang SET name = 'POLO LIMITED ', description = '' WHERE id_product = '8082' 14/03/2023 04:30:54 pm >> UPDATE ps_product SET wholesale_price = '12.00', on_sale = '0', price = '25.40983606557377' WHERE id_product = '8082' 14/03/2023 04:30:54 pm >> UPDATE ps_product_shop SET wholesale_price = '12.00', price = '25.40983606557377', id_tax_rules_group = '1', id_category_default = '253', 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 = '8082' 14/03/2023 04:30:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '8082' 14/03/2023 04:31:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000327' AND id_product != '8147' AND ean13 != '' 14/03/2023 04:31:10 pm >> UPDATE ps_product SET id_supplier = '77', reference = '2013', ean13 = '000327', date_upd = NOW() WHERE id_product = '8147' 14/03/2023 04:31:10 pm >> UPDATE ps_product_lang SET name = 'POLO BASIC', description = '' WHERE id_product = '8147' 14/03/2023 04:31:10 pm >> UPDATE ps_product SET wholesale_price = '10.50', on_sale = '0', price = '23.770491803278688' WHERE id_product = '8147' 14/03/2023 04:31:10 pm >> UPDATE ps_product_shop SET wholesale_price = '10.50', price = '23.770491803278688', id_tax_rules_group = '1', id_category_default = '253', 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 = '8147' 14/03/2023 04:31:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '8147' 14/03/2023 04:31:54 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000853' AND id_product != '8079' AND ean13 != '' 14/03/2023 04:31:54 pm >> UPDATE ps_product SET id_supplier = '', reference = '2016', ean13 = '000853', date_upd = NOW() WHERE id_product = '8079' 14/03/2023 04:31:54 pm >> UPDATE ps_product_lang SET name = 'POLO LIMITED EXTRA', description = '' WHERE id_product = '8079' 14/03/2023 04:31:54 pm >> UPDATE ps_product SET wholesale_price = '13.10', on_sale = '0', price = '27.868852459016395' WHERE id_product = '8079' 14/03/2023 04:31:54 pm >> UPDATE ps_product_shop SET wholesale_price = '13.10', price = '27.868852459016395', id_tax_rules_group = '1', id_category_default = '253', 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 = '8079' 14/03/2023 04:31:54 pm >> DELETE FROM ps_specific_price WHERE id_product = '8079' 14/03/2023 04:49:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400269550' AND id_product != '13805' AND ean13 != '' 14/03/2023 04:49:35 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400269550', date_upd = NOW() WHERE id_product = '13805' 14/03/2023 04:49:35 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024', description = '' WHERE id_product = '13805' 14/03/2023 04:49:35 pm >> UPDATE ps_product SET wholesale_price = '3.65', on_sale = '0', price = '9.754098360655739' WHERE id_product = '13805' 14/03/2023 04:49:35 pm >> UPDATE ps_product_shop SET wholesale_price = '3.65', price = '9.754098360655739', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13805' 14/03/2023 04:49:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '13805' 14/03/2023 04:50:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400269550' AND id_product != '13805' AND ean13 != '' 14/03/2023 04:50:08 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400269550', date_upd = NOW() WHERE id_product = '13805' 14/03/2023 04:50:09 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO 10X10 ALBERO DELLA VITA - 2974/F0024', description = '' WHERE id_product = '13805' 14/03/2023 04:50:09 pm >> UPDATE ps_product SET wholesale_price = '3.65', on_sale = '0', price = '9.754098360655739' WHERE id_product = '13805' 14/03/2023 04:50:09 pm >> UPDATE ps_product_shop SET wholesale_price = '3.65', price = '9.754098360655739', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '13805' 14/03/2023 04:50:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '13805' 14/03/2023 04:50:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400283617' AND id_product != '15704' AND ean13 != '' 14/03/2023 04:50:34 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400283617', date_upd = NOW() WHERE id_product = '15704' 14/03/2023 04:50:34 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO 10X10 ALBERO DELLA VITA - 2980/F0024', description = '' WHERE id_product = '15704' 14/03/2023 04:50:34 pm >> UPDATE ps_product SET wholesale_price = '3.90', on_sale = '0', price = '10.245901639344263' WHERE id_product = '15704' 14/03/2023 04:50:34 pm >> UPDATE ps_product_shop SET wholesale_price = '3.90', price = '10.245901639344263', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15704' 14/03/2023 04:50:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '15704' 14/03/2023 04:56:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8058400308648' AND id_product != '16508' AND ean13 != '' 14/03/2023 04:56:20 pm >> UPDATE ps_product SET id_supplier = '28', reference = '', ean13 = '8058400308648', date_upd = NOW() WHERE id_product = '16508' 14/03/2023 04:56:20 pm >> UPDATE ps_product_lang SET name = 'ANGELO BIANCO IN RESINA CAMPANA - 4218', description = '' WHERE id_product = '16508' 14/03/2023 04:56:20 pm >> UPDATE ps_product SET wholesale_price = '1.95', on_sale = '0', price = '4.918032786885246' WHERE id_product = '16508' 14/03/2023 04:56:20 pm >> UPDATE ps_product_shop SET wholesale_price = '1.95', price = '4.918032786885246', id_tax_rules_group = '1', id_category_default = '95', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '16508' 14/03/2023 04:56:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '16508' 14/03/2023 05:03:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '839' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 05:03:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '839' , '2023-03-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '133.00' , '133.00' , NOW() , NOW() ) 14/03/2023 05:03:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82294' 14/03/2023 05:03:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '82294' 14/03/2023 05:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82294' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 14/03/2023 05:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82294' , '5888' , 'LITURGIA DELLE ORE - VOL. II - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 14/03/2023 05:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82294' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 14/03/2023 05:03:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82294' , '5890' , 'LITURGIA DELLE ORE - VOL. IV - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 14/03/2023 05:09:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '840' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 05:09:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '840' , '2023-03-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.50' , '3.50' , NOW() , NOW() ) 14/03/2023 05:09:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82295' 14/03/2023 05:09:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '82295' 14/03/2023 05:09:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82295' , '9441' , 'SAN GERARDO MAIELLA' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 14/03/2023 05:25:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002122' AND id_product != '13079' AND ean13 != '' 14/03/2023 05:25:09 pm >> UPDATE ps_product SET id_supplier = '5', reference = '', ean13 = '002122', date_upd = NOW() WHERE id_product = '13079' 14/03/2023 05:25:09 pm >> UPDATE ps_product_lang SET name = 'COPPIA CANDELIERI IN LEGNO - 033', description = '' WHERE id_product = '13079' 14/03/2023 05:25:09 pm >> UPDATE ps_product SET wholesale_price = '19.40', on_sale = '0', price = '45.0820' WHERE id_product = '13079' 14/03/2023 05:25:09 pm >> UPDATE ps_product_shop SET wholesale_price = '19.40', price = '45.0820', id_tax_rules_group = '1', id_category_default = '194', 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 = '13079' 14/03/2023 05:25:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '13079' 14/03/2023 05:26:22 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 14/03/2023 05:26:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20841' , '1' , '' , 'nuovo-prodotto' ) 14/03/2023 05:26:23 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20841' , '1' , '1' , '2' , NOW() , NOW() ) 14/03/2023 05:26:23 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20841' , '0' , '1' , '0' , '0' ) 14/03/2023 05:27:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002123' AND id_product != '20841' AND ean13 != '' 14/03/2023 05:27:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002123', date_upd = NOW() WHERE id_product = '20841' 14/03/2023 05:27:11 pm >> UPDATE ps_product_lang SET name = 'COPPIA CANDELIERI FOGLIA ORO - 034', description = '' WHERE id_product = '20841' 14/03/2023 05:27:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '63.9344262295082' WHERE id_product = '20841' 14/03/2023 05:27:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '63.9344262295082', id_tax_rules_group = '1', id_category_default = '194', 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 = '20841' 14/03/2023 05:27:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '20841' 14/03/2023 05:28:06 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002123' AND id_product != '20841' AND ean13 != '' 14/03/2023 05:28:06 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002123', date_upd = NOW() WHERE id_product = '20841' 14/03/2023 05:28:06 pm >> UPDATE ps_product_lang SET name = 'COPPIA CANDELIERI FOGLIA ORO - 034', description = '' WHERE id_product = '20841' 14/03/2023 05:28:06 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '63.9344262295082' WHERE id_product = '20841' 14/03/2023 05:28:06 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '63.9344262295082', id_tax_rules_group = '1', id_category_default = '194', 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 = '20841' 14/03/2023 05:28:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '20841' 14/03/2023 05:28:07 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 = '20841' 14/03/2023 05:28:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20842' , '1' , '' , 'nuovo-prodotto' ) 14/03/2023 05:28:07 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 '20842' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20841' 14/03/2023 05:28:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20842' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20841' 14/03/2023 05:29: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 ( '31' , '90' , '2023-03-13' , '' , '0' , '5' , '2600' , 'VIA DEL MANDORLO, 52 70022 ALTAMURA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '140.82' , '115.43' , NOW() , NOW() ) 14/03/2023 05:29: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 = '82296' 14/03/2023 05:29:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '82296' 14/03/2023 05:29: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 ( '82296' , '13078' , 'LEGGIO IN LEGNO - 043' , '1' , '1' , '1' , '47' , '38.524590163934' , '22' , '3' , '55.6198' ) 14/03/2023 05:29:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13078' AND id_supplier = '5' 14/03/2023 05:29:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13078' , '5' , '1' ) 14/03/2023 05:29: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 ( '82296' , '13079' , 'COPPIA CANDELIERI IN LEGNO - 033' , '2' , '2' , '1' , '20' , '16.393442622951' , '22' , '3' , '47.3360' ) 14/03/2023 05:29:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13079' AND id_supplier = '5' 14/03/2023 05:29:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13079' , '5' , '1' ) 14/03/2023 05:29: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 ( '82296' , '20841' , 'COPPIA CANDELIERI FOGLIA ORO - 034' , '1' , '1' , '1' , '32' , '26.229508196721' , '22' , '3' , '37.8688' ) 14/03/2023 05:29:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20841' AND id_supplier = '5' 14/03/2023 05:29:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20841' , '5' , '1' ) 14/03/2023 06:05:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '841' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 06:05:12 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' , '841' , '2023-03-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 14/03/2023 06:05:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82297' 14/03/2023 06:05:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '82297' 14/03/2023 06:05:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82297' , '11688' , 'CORONA ROSARIO MISERICORDIOSO - 740' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 14/03/2023 06:05:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82297' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 14/03/2023 06:05:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82297' , '18213' , 'BRACCIALE CROCI COLORATO - BC569' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 14/03/2023 06:20:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '842' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 06:20:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '842' , '2023-03-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '6.15' , NOW() , NOW() ) 14/03/2023 06:20:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82298' 14/03/2023 06:20:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '82298' 14/03/2023 06:20:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82298' , '19150' , 'MOCCOLO 70X200' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 14/03/2023 07:17:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '843' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 07:17:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '843' , '2023-03-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.40' , '13.39' , NOW() , NOW() ) 14/03/2023 07:17:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82299' 14/03/2023 07:17:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '82299' 14/03/2023 07:17:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82299' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '4' , '-4' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '6.00' ) 14/03/2023 07:17:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82299' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '20' , '-20' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '4.00' ) 14/03/2023 07:17:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82299' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 14/03/2023 07:17:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82299' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 14/03/2023 08:00:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '844' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-03-14') 14/03/2023 08:00:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '844' , '2023-03-14' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '950.00' , '778.69' , NOW() , NOW() ) 14/03/2023 08:00:59 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '82300' 14/03/2023 08:00:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '82300' 14/03/2023 08:00:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82300' , '19905' , 'MOZZETTA ' , '1' , '-1' , '1' , '290' , '237.70491803279' , '22' , '0' , '290.00' ) 14/03/2023 08:00:59 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '82300' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '660' , '540.98360655738' , '22' , '0' , '660.00' )