31/01/2023 08:28:50 am >> SELECT document_num FROM ps_document WHERE document_num = '170' AND id_document != '79361' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-16') 31/01/2023 08:28:50 am >> UPDATE ps_document SET id_document_type = '11', document_num = '170', document_date = '2023-01-16', 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 = '39.00', price_tax_excluded = '39.00', date_upd = NOW() WHERE id_document = '79361' 31/01/2023 08:28: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 = '79361' 31/01/2023 08:28:50 am >> DELETE FROM ps_document_detail WHERE id_document = '79361' 31/01/2023 08:28: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 ( '79361' , '17488' , 'STELLA IL CAMMINO IL BAMBINO - L. EPICOCO' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 31/01/2023 08:28: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 ( '79361' , '17966' , 'DEI VIZI E DELLE VIRTU - PAPA FRANCESCO' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '5' , '15.20' ) 31/01/2023 08:28: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 ( '79361' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '5' , '0.95' ) 31/01/2023 08:28: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 ( '79361' , '15939' , 'AMORE CHE DECIDE - L. EPICOCO' , '1' , '-1' , '4' , '8.6' , '8.6' , '0' , '0' , '8.60' ) 31/01/2023 08:29:26 am >> SELECT document_num FROM ps_document WHERE document_num = '257' AND id_document != '80511' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-24') 31/01/2023 08:29:26 am >> UPDATE ps_document SET id_document_type = '11', document_num = '257', document_date = '2023-01-24', 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 = '77.48', price_tax_excluded = '71.53', date_upd = NOW() WHERE id_document = '80511' 31/01/2023 08:29: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 = '80511' 31/01/2023 08:29:26 am >> DELETE FROM ps_document_detail WHERE id_document = '80511' 31/01/2023 08:29: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 ( '80511' , '10484' , 'TECA ALTA IHS' , '1' , '-1' , '1' , '26.0000' , '21.311475409836' , '22' , '0' , '26.00' ) 31/01/2023 08:29: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 ( '80511' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '7.00' ) 31/01/2023 08:29: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 ( '80511' , '19157' , 'COMUNIONE AGLI INFERMI - N.E.' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '0' , '2.00' ) 31/01/2023 08:29: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 ( '80511' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/01/2023 08:29: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 ( '80511' , '17763' , 'MADONNA MI E CARA - M. MASINI' , '1' , '-1' , '4' , '13.0000' , '13' , '0' , '5' , '12.35' ) 31/01/2023 08:29: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 ( '80511' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 31/01/2023 08:29: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 ( '80511' , '18528' , 'CON GESU VERSO IL CALVARIO - P. G. VALSECCHI' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 31/01/2023 08:29: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 ( '80511' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 31/01/2023 08:29: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 ( '80511' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.88' , '3.88' , '0' , '0' , '3.88' ) 31/01/2023 08:29:55 am >> SELECT document_num FROM ps_document WHERE document_num = '267' AND id_document != '80526' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-25') 31/01/2023 08:29:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '267', document_date = '2023-01-25', 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 = '42.00', price_tax_excluded = '39.30', date_upd = NOW() WHERE id_document = '80526' 31/01/2023 08:29:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80526' 31/01/2023 08:29:55 am >> DELETE FROM ps_document_detail WHERE id_document = '80526' 31/01/2023 08:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80526' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '1.9000' , '1.9' , '0' , '0' , '9.50' ) 31/01/2023 08:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80526' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '15.00' ) 31/01/2023 08:29:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80526' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '17.5' , '17.5' , '0' , '0' , '17.50' ) 31/01/2023 08:31:17 am >> SELECT document_num FROM ps_document WHERE document_num = '242' AND id_document != '80490' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-24') 31/01/2023 08:31:17 am >> UPDATE ps_document SET id_document_type = '11', document_num = '242', document_date = '2023-01-24', 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 = '570.00', price_tax_excluded = '478.81', date_upd = NOW() WHERE id_document = '80490' 31/01/2023 08:31: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 = '80490' 31/01/2023 08:31:17 am >> DELETE FROM ps_document_detail WHERE id_document = '80490' 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '1914' , 'CERA DELLA LITURGIA' , '46' , '-46' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '207.00' ) 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '14000' , 'GALATEO IN CHIESA' , '1' , '-1' , '4' , '0.9800' , '0.98' , '0' , '0' , '0.98' ) 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '14001' , 'PAROLE GESTI SILENZI DELLA MESSA - C. MAGNOLI' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '20528' , 'AMEN - MAR 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '20440' , 'AMEN - FEB. 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '19102' , 'CARBONCINI MM 40' , '1' , '-1' , '1' , '9.9300' , '8.1393442622951' , '22' , '0' , '9.93' ) 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '19771' , 'ROSARIO ARGENTO/EMATITE' , '1' , '-1' , '1' , '25.3000' , '20.737704918033' , '22' , '0' , '25.30' ) 31/01/2023 08:31:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80490' , '19659' , 'CASULA POLIESTERE - 65/18355' , '1' , '-1' , '1' , '250' , '204.91803278689' , '22' , '0' , '250.00' ) 31/01/2023 08:33:21 am >> SELECT document_num FROM ps_document WHERE document_num = '141' AND id_document != '78812' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-13') 31/01/2023 08:33:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '141', document_date = '2023-01-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 = '500.00', price_tax_excluded = '409.84', date_upd = NOW() WHERE id_document = '78812' 31/01/2023 08:33:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '78812' 31/01/2023 08:33:21 am >> DELETE FROM ps_document_detail WHERE id_document = '78812' 31/01/2023 08:33:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '78812' , '19797' , 'CASULA RIGOLETTO 3 CROCI - 640' , '1' , '-1' , '1' , '500' , '409.83606557377' , '22' , '0' , '500.00' ) 31/01/2023 08:34:09 am >> SELECT document_num FROM ps_document WHERE document_num = '153' AND id_document != '78828' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-14') 31/01/2023 08:34:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '153', document_date = '2023-01-14', 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 = '370.00', price_tax_excluded = '303.28', date_upd = NOW() WHERE id_document = '78828' 31/01/2023 08:34: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 = '78828' 31/01/2023 08:34:09 am >> DELETE FROM ps_document_detail WHERE id_document = '78828' 31/01/2023 08:34: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 ( '78828' , '13160' , 'CASULA MOD. CRISTOGRAMMA - cs12271' , '1' , '-1' , '1' , '370' , '303.27868852459' , '22' , '0' , '370.00' ) 31/01/2023 09:00:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001169' AND id_product != '15356' AND ean13 != '' 31/01/2023 09:00:46 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001169', date_upd = NOW() WHERE id_product = '15356' 31/01/2023 09:00:46 am >> UPDATE ps_product_lang SET name = 'AMPOLLE ABBRACCIO DORATE - 1511', description = '' WHERE id_product = '15356' 31/01/2023 09:00:46 am >> UPDATE ps_product SET wholesale_price = '38.48', on_sale = '0', price = '80.32786885245902' WHERE id_product = '15356' 31/01/2023 09:00:46 am >> UPDATE ps_product_shop SET wholesale_price = '38.48', price = '80.32786885245902', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15356' 31/01/2023 09:00:46 am >> DELETE FROM ps_specific_price WHERE id_product = '15356' 31/01/2023 09:02:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001908' AND id_product != '19108' AND ean13 != '' 31/01/2023 09:02:49 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '001908', date_upd = NOW() WHERE id_product = '19108' 31/01/2023 09:02:49 am >> UPDATE ps_product_lang SET name = 'PORTATECA COMPLETA - 947', description = '' WHERE id_product = '19108' 31/01/2023 09:02:49 am >> UPDATE ps_product SET wholesale_price = '17.10', on_sale = '0', price = '39.34426229508197' WHERE id_product = '19108' 31/01/2023 09:02:49 am >> UPDATE ps_product_shop SET wholesale_price = '17.10', price = '39.34426229508197', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19108' 31/01/2023 09:02:49 am >> DELETE FROM ps_specific_price WHERE id_product = '19108' 31/01/2023 09:06:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000043' AND id_product != '1596' AND ean13 != '' 31/01/2023 09:06:47 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000043', date_upd = NOW() WHERE id_product = '1596' 31/01/2023 09:06:47 am >> UPDATE ps_product_lang SET name = 'CAMPANELLO 4 SUONI - 629', description = '' WHERE id_product = '1596' 31/01/2023 09:06:47 am >> UPDATE ps_product SET wholesale_price = '23.56', on_sale = '0', price = '57.37704918032787' WHERE id_product = '1596' 31/01/2023 09:06:47 am >> UPDATE ps_product_shop SET wholesale_price = '23.56', price = '57.37704918032787', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '1596' 31/01/2023 09:06:47 am >> DELETE FROM ps_specific_price WHERE id_product = '1596' 31/01/2023 09:07:54 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000129' AND id_product != '15114' AND ean13 != '' 31/01/2023 09:07:54 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '000129', date_upd = NOW() WHERE id_product = '15114' 31/01/2023 09:07:54 am >> UPDATE ps_product_lang SET name = 'BOCCIA VETRO TRASPARENTE - 489', description = '' WHERE id_product = '15114' 31/01/2023 09:07:54 am >> UPDATE ps_product SET wholesale_price = '14.25', on_sale = '0', price = '32.37704918032787' WHERE id_product = '15114' 31/01/2023 09:07:54 am >> UPDATE ps_product_shop SET wholesale_price = '14.25', price = '32.37704918032787', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15114' 31/01/2023 09:07:54 am >> DELETE FROM ps_specific_price WHERE id_product = '15114' 31/01/2023 09:13:33 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000452' AND id_product != '8938' AND ean13 != '' 31/01/2023 09:13:33 am >> UPDATE ps_product SET id_supplier = '', reference = '2013', ean13 = '000452', date_upd = NOW() WHERE id_product = '8938' 31/01/2023 09:13:33 am >> UPDATE ps_product_lang SET name = 'RICAMBIO VETRO PER ART. 1045/1046/675 - 90 - OGGETTI', description = '' WHERE id_product = '8938' 31/01/2023 09:13:33 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7.786885245901639' WHERE id_product = '8938' 31/01/2023 09:13:33 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7.786885245901639', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8938' 31/01/2023 09:13:33 am >> DELETE FROM ps_specific_price WHERE id_product = '8938' 31/01/2023 09:17:32 am >> SELECT ean13 FROM ps_product WHERE ean13 = '000754' AND id_product != '7736' AND ean13 != '' 31/01/2023 09:17:32 am >> UPDATE ps_product SET id_supplier = '12', reference = '2015', ean13 = '000754', date_upd = NOW() WHERE id_product = '7736' 31/01/2023 09:17:32 am >> UPDATE ps_product_lang SET name = 'PATENA OTTONE DECORATA - 900/S', description = '' WHERE id_product = '7736' 31/01/2023 09:17:32 am >> UPDATE ps_product SET wholesale_price = '18.05', on_sale = '0', price = '41.80327868852459' WHERE id_product = '7736' 31/01/2023 09:17:32 am >> UPDATE ps_product_shop SET wholesale_price = '18.05', price = '41.80327868852459', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '7736' 31/01/2023 09:17:32 am >> DELETE FROM ps_specific_price WHERE id_product = '7736' 31/01/2023 09:18:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000007763' AND id_product != '17986' AND ean13 != '' 31/01/2023 09:18:22 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000007763', date_upd = NOW() WHERE id_product = '17986' 31/01/2023 09:18:22 am >> UPDATE ps_product_lang SET name = 'PATENA 15,5 - 1900', description = '' WHERE id_product = '17986' 31/01/2023 09:18:22 am >> UPDATE ps_product SET wholesale_price = '18.05', on_sale = '0', price = '41.80327868852459' WHERE id_product = '17986' 31/01/2023 09:18:22 am >> UPDATE ps_product_shop SET wholesale_price = '18.05', price = '41.80327868852459', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '17986' 31/01/2023 09:18:22 am >> DELETE FROM ps_specific_price WHERE id_product = '17986' 31/01/2023 09:19:34 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000019162' AND id_product != '15351' AND ean13 != '' 31/01/2023 09:19:34 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000019162', date_upd = NOW() WHERE id_product = '15351' 31/01/2023 09:19:34 am >> UPDATE ps_product_lang SET name = 'PORTATECA a bustina - 928', description = '' WHERE id_product = '15351' 31/01/2023 09:19:34 am >> UPDATE ps_product SET wholesale_price = '19.95', on_sale = '0', price = '45.90163934426229' WHERE id_product = '15351' 31/01/2023 09:19:34 am >> UPDATE ps_product_shop SET wholesale_price = '19.95', price = '45.90163934426229', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15351' 31/01/2023 09:19:34 am >> DELETE FROM ps_specific_price WHERE id_product = '15351' 31/01/2023 09:20:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000019162' AND id_product != '15351' AND ean13 != '' 31/01/2023 09:20:01 am >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000019162', date_upd = NOW() WHERE id_product = '15351' 31/01/2023 09:20:01 am >> UPDATE ps_product_lang SET name = 'PORTATECA A BUSTINA - 928', description = '' WHERE id_product = '15351' 31/01/2023 09:20:01 am >> UPDATE ps_product SET wholesale_price = '19.95', on_sale = '0', price = '45.9016' WHERE id_product = '15351' 31/01/2023 09:20:01 am >> UPDATE ps_product_shop SET wholesale_price = '19.95', price = '45.9016', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15351' 31/01/2023 09:20:01 am >> DELETE FROM ps_specific_price WHERE id_product = '15351' 31/01/2023 09:21:09 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/01/2023 09:21:09 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20686' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 09:21:09 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20686' , '1' , '1' , '2' , NOW() , NOW() ) 31/01/2023 09:21:09 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20686' , '0' , '1' , '0' , '0' ) 31/01/2023 09:22:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000015157' AND id_product != '20686' AND ean13 != '' 31/01/2023 09:22:26 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000015157', date_upd = NOW() WHERE id_product = '20686' 31/01/2023 09:22:26 am >> UPDATE ps_product_lang SET name = 'CAMPANELLO A 3 SUONI - 628', description = '' WHERE id_product = '20686' 31/01/2023 09:22:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '52.459016393442624' WHERE id_product = '20686' 31/01/2023 09:22:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '52.459016393442624', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20686' 31/01/2023 09:22:26 am >> DELETE FROM ps_specific_price WHERE id_product = '20686' 31/01/2023 09:23: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 ( '31' , '174' , '2023-01-24' , '' , '0' , '12' , '2607' , 'VIA NAZIONALE NORD, 4 - LAGARO 40035 CASTIGLIONE DEI PEPOLI' , '' , '' , '11.025' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '419.68' , '344.00' , NOW() , NOW() ) 31/01/2023 09:23: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 = '80597' 31/01/2023 09:23:19 am >> DELETE FROM ps_document_detail WHERE id_document = '80597' 31/01/2023 09:23: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 ( '80597' , '15356' , 'AMPOLLE ABBRACCIO DORATE - 1511' , '1' , '1' , '1' , '40.5' , '33.196721311475' , '22' , '5' , '46.9395' ) 31/01/2023 09:23:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '15356' AND id_supplier = '12' 31/01/2023 09:23:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15356' , '12' , '1' ) 31/01/2023 09:23: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 ( '80597' , '19108' , 'PORTATECA COMPLETA - 947' , '2' , '2' , '1' , '20' , '16.393442622951' , '22' , '5' , '46.3600' ) 31/01/2023 09:23:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '19108' AND id_supplier = '12' 31/01/2023 09:23:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19108' , '12' , '1' ) 31/01/2023 09:23: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 ( '80597' , '1596' , 'CAMPANELLO 4 SUONI - 629' , '1' , '1' , '1' , '29.5' , '24.180327868852' , '22' , '5' , '34.1905' ) 31/01/2023 09:23:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '1596' AND id_supplier = '12' 31/01/2023 09:23:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1596' , '12' , '1' ) 31/01/2023 09:23:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80597' , '15114' , 'BOCCIA VETRO TRASPARENTE - 489' , '1' , '1' , '1' , '16.5' , '13.524590163934' , '22' , '5' , '19.1235' ) 31/01/2023 09:23:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '15114' AND id_supplier = '12' 31/01/2023 09:23:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15114' , '12' , '1' ) 31/01/2023 09:23:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80597' , '795' , 'ASTUCCIO A 3 OLI SANTI IN ALLUMINIO - 1958' , '2' , '2' , '1' , '30' , '24.590163934426' , '22' , '5' , '69.5400' ) 31/01/2023 09:23:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '795' AND id_supplier = '12' 31/01/2023 09:23:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '795' , '12' , '1' ) 31/01/2023 09:23:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80597' , '782' , 'ASPERGES PER SECCHIELLO - 701' , '1' , '1' , '1' , '21.5' , '17.622950819672' , '22' , '5' , '24.9185' ) 31/01/2023 09:23:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '782' AND id_supplier = '12' 31/01/2023 09:23:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '782' , '12' , '1' ) 31/01/2023 09:23:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80597' , '8938' , 'RICAMBIO VETRO PER ART. 1045/1046/675 - 90 - OGGETTI' , '4' , '4' , '1' , '4' , '3.2786885245902' , '22' , '5' , '18.5440' ) 31/01/2023 09:23:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '8938' AND id_supplier = '12' 31/01/2023 09:23:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8938' , '12' , '1' ) 31/01/2023 09:23:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80597' , '7735' , 'PATENA OTTONE - DIAM. 14 - 900' , '2' , '2' , '1' , '17.5' , '14.344262295082' , '22' , '5' , '40.5650' ) 31/01/2023 09:23:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '7735' AND id_supplier = '12' 31/01/2023 09:23:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7735' , '12' , '1' ) 31/01/2023 09:23:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80597' , '7736' , 'PATENA OTTONE DECORATA - 900/S' , '1' , '1' , '1' , '21' , '17.213114754098' , '22' , '5' , '24.3390' ) 31/01/2023 09:23:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '7736' AND id_supplier = '12' 31/01/2023 09:23:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7736' , '12' , '1' ) 31/01/2023 09:23:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80597' , '17986' , 'PATENA 15,5 - 1900' , '1' , '1' , '1' , '21' , '17.213114754098' , '22' , '5' , '24.3390' ) 31/01/2023 09:23:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '17986' AND id_supplier = '12' 31/01/2023 09:23:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17986' , '12' , '1' ) 31/01/2023 09:23:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80597' , '15351' , 'PORTATECA A BUSTINA - 928' , '1' , '1' , '1' , '23' , '18.852459016393' , '22' , '5' , '26.6570' ) 31/01/2023 09:23:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '15351' AND id_supplier = '12' 31/01/2023 09:23:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15351' , '12' , '1' ) 31/01/2023 09:23:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80597' , '20686' , 'CAMPANELLO A 3 SUONI - 628' , '1' , '1' , '1' , '26.5' , '21.72131147541' , '22' , '5' , '30.7135' ) 31/01/2023 09:23:20 am >> DELETE FROM ps_product_supplier WHERE id_product = '20686' AND id_supplier = '12' 31/01/2023 09:23:20 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20686' , '12' , '1' ) 31/01/2023 09:36:38 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8002358008198' AND id_product != '1631' AND ean13 != '' 31/01/2023 09:36:38 am >> UPDATE ps_product SET id_supplier = '31', reference = '', ean13 = '8002358008198', date_upd = NOW() WHERE id_product = '1631' 31/01/2023 09:36:38 am >> UPDATE ps_product_lang SET name = 'CANDELINE NON GOCCIOLANTI ', description = '' WHERE id_product = '1631' 31/01/2023 09:36:39 am >> UPDATE ps_product SET wholesale_price = '12.60', on_sale = '0', price = '23.770491803278688' WHERE id_product = '1631' 31/01/2023 09:36:39 am >> UPDATE ps_product_shop SET wholesale_price = '12.60', price = '23.770491803278688', id_tax_rules_group = '1', id_category_default = '169', 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 = '1631' 31/01/2023 09:36:39 am >> DELETE FROM ps_specific_price WHERE id_product = '1631' 31/01/2023 09:36:55 am >> SELECT document_num FROM ps_document WHERE document_num = '324' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 09:36:55 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' , '324' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 31/01/2023 09:36:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80598' 31/01/2023 09:36:55 am >> DELETE FROM ps_document_detail WHERE id_document = '80598' 31/01/2023 09:36:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80598' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '55.00' ) 31/01/2023 09:37:15 am >> SELECT document_num FROM ps_document WHERE document_num = '325' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 09:37:15 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' , '325' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '55.00' , '45.08' , NOW() , NOW() ) 31/01/2023 09:37:15 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 = '80599' 31/01/2023 09:37:15 am >> DELETE FROM ps_document_detail WHERE id_document = '80599' 31/01/2023 09:37:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80599' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '55.00' ) 31/01/2023 09:38:12 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '905' 31/01/2023 09:38:13 am >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '905' , '10' , '210' , 'PARROCCHIA S. AGNESE' , 'CASSO' , 'P. ANTONIO ' , 'VIA MAGGIORE, 1' , '' , '84081' , 'SAVA DI BARONISSI' , '' , '' , '' , '' , '80005150653' , NOW() , NOW() ) 31/01/2023 09:38:13 am >> UPDATE ps_customer SET email = 'antbasso71@hotmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '905' 31/01/2023 09:38:30 am >> DELETE FROM ps_document WHERE id_document = '80595' 31/01/2023 09:38:30 am >> DELETE FROM ps_document_detail WHERE id_document = '80595' 31/01/2023 09:44:50 am >> SELECT document_num FROM ps_document WHERE document_num = '326' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 09:44:51 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' , '326' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.50' , '21.87' , NOW() , NOW() ) 31/01/2023 09:44:51 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 = '80600' 31/01/2023 09:44:51 am >> DELETE FROM ps_document_detail WHERE id_document = '80600' 31/01/2023 09:44:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80600' , '20472' , 'CAMMINARE NELLA LUCE - L. MONTI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 31/01/2023 09:44:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80600' , '15735' , 'LOURDES - 119' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 31/01/2023 09:53:44 am >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 31/01/2023 09:53:44 am >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '174' , '1' ) 31/01/2023 09:53:44 am >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '174' , '1' ) 31/01/2023 09:53:44 am >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '174' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 31/01/2023 09:55:51 am >> UPDATE ps_address SET id_state = '', lastname = 'ASSOCIAZIONE EDITRICE PUNTO FAMIGLIA', address1 = 'VIA ADRIANA 18', address2 = '', postcode = '84012', dni = '', vat_number = '04889400653', city = 'ANGRI', phone = '081940613', phone_mobile = '3664340040', date_upd = NOW() WHERE id_supplier = '174' 31/01/2023 09:55:51 am >> UPDATE ps_supplier SET email = 'segreteria.amministrativa@puntofamiglia.net', name = 'ASSOCIAZIONE EDITRICE PUNTO FAMIGLIA', date_upd = NOW() WHERE id_supplier = '174' 31/01/2023 09:55:51 am >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '174' 31/01/2023 09:55:59 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/01/2023 09:55:59 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20687' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 09:55:59 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20687' , '1' , '1' , '2' , NOW() , NOW() ) 31/01/2023 09:55:59 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20687' , '0' , '1' , '0' , '0' ) 31/01/2023 09:56:55 am >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 31/01/2023 09:56:55 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '517' , '1' ) 31/01/2023 09:56:55 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '517' , '2' ) 31/01/2023 09:56:55 am >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '517' , '3' ) 31/01/2023 09:56:55 am >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '517' , '1' , 'PUNTO FAMIGLIA' , LOWER('PUNTO-FAMIGLIA') ) 31/01/2023 09:56:55 am >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '517' , '1' , '0' ) 31/01/2023 09:58:04 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072612' AND id_product != '20687' AND ean13 != '' 31/01/2023 09:58:04 am >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788899072612', date_upd = NOW() WHERE id_product = '20687' 31/01/2023 09:58:04 am >> UPDATE ps_product_lang SET name = 'NON HO CHE L\'OGGI PENSIERI TERASA DI LISIEUX - S. LONGOBARDI', description = '' WHERE id_product = '20687' 31/01/2023 09:58:04 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20687' 31/01/2023 09:58:04 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20687' 31/01/2023 09:58:04 am >> DELETE FROM ps_specific_price WHERE id_product = '20687' 31/01/2023 09:59:06 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072612' AND id_product != '20687' AND ean13 != '' 31/01/2023 09:59:06 am >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788899072612', date_upd = NOW() WHERE id_product = '20687' 31/01/2023 09:59:06 am >> UPDATE ps_product_lang SET name = 'NON HO CHE L\'OGGI PENSIERI TERASA DI LISIEUX - S. LONGOBARDI', description = '' WHERE id_product = '20687' 31/01/2023 09:59:06 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20687' 31/01/2023 09:59:06 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20687' 31/01/2023 09:59:06 am >> DELETE FROM ps_specific_price WHERE id_product = '20687' 31/01/2023 09:59:46 am >> SELECT document_num FROM ps_document WHERE document_num = '327' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 09:59:46 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' , '327' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 31/01/2023 09:59:46 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 = '80601' 31/01/2023 09:59:46 am >> DELETE FROM ps_document_detail WHERE id_document = '80601' 31/01/2023 09:59:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80601' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '18' , '18' , '0' , '0' , '18.00' ) 31/01/2023 10:00:15 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072612' AND id_product != '20687' AND ean13 != '' 31/01/2023 10:00:15 am >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788899072612', date_upd = NOW() WHERE id_product = '20687' 31/01/2023 10:00:15 am >> UPDATE ps_product_lang SET name = 'NON HO CHE L\'OGGI PENSIERI TERASA DI LISIEUX - S. LONGOBARDI', description = '' WHERE id_product = '20687' 31/01/2023 10:00:15 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20687' 31/01/2023 10:00:15 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20687' 31/01/2023 10:00:15 am >> DELETE FROM ps_specific_price WHERE id_product = '20687' 31/01/2023 10:00:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072612' AND id_product != '20687' AND ean13 != '' 31/01/2023 10:00:42 am >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788899072612', date_upd = NOW() WHERE id_product = '20687' 31/01/2023 10:00:42 am >> UPDATE ps_product_lang SET name = 'NON HO CHE L\'OGGI PENSIERI TERASA DI LISIEUX - S. LONGOBARDI', description = '' WHERE id_product = '20687' 31/01/2023 10:00:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20687' 31/01/2023 10:00:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20687' 31/01/2023 10:00:42 am >> DELETE FROM ps_specific_price WHERE id_product = '20687' 31/01/2023 10:00:43 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 = '20687' 31/01/2023 10:00:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20688' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:00:43 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 '20688' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20687' 31/01/2023 10:00:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20688' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20687' 31/01/2023 10:01:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072575' AND id_product != '20688' AND ean13 != '' 31/01/2023 10:01:41 am >> UPDATE ps_product SET id_supplier = '', reference = '6/2', ean13 = '9788899072575', date_upd = NOW() WHERE id_product = '20688' 31/01/2023 10:01:41 am >> UPDATE ps_product_lang SET name = 'LEONIA MARTIN - D. MENVIELLE', description = '' WHERE id_product = '20688' 31/01/2023 10:01:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '20688' 31/01/2023 10:01:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20688' 31/01/2023 10:01:41 am >> DELETE FROM ps_specific_price WHERE id_product = '20688' 31/01/2023 10:01:43 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 = '20688' 31/01/2023 10:01:43 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20689' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:01:43 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 '20689' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20688' 31/01/2023 10:01:43 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20689' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20688' 31/01/2023 10:02:42 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072032' AND id_product != '20689' AND ean13 != '' 31/01/2023 10:02:42 am >> UPDATE ps_product SET id_supplier = '', reference = '6/3', ean13 = '9788899072032', date_upd = NOW() WHERE id_product = '20689' 31/01/2023 10:02:42 am >> UPDATE ps_product_lang SET name = 'PER IL TUO SOLO AMORE -TERESA DI LISIEUX - J. FAU', description = '' WHERE id_product = '20689' 31/01/2023 10:02:42 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20689' 31/01/2023 10:02:42 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20689' 31/01/2023 10:02:42 am >> DELETE FROM ps_specific_price WHERE id_product = '20689' 31/01/2023 10:02:44 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 = '20689' 31/01/2023 10:02:44 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20690' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:02:44 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 '20690' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20689' 31/01/2023 10:02:44 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20690' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20689' 31/01/2023 10:04:37 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072797' AND id_product != '20690' AND ean13 != '' 31/01/2023 10:04:37 am >> UPDATE ps_product SET id_supplier = '', reference = 'GONDOLA 1', ean13 = '9788899072797', date_upd = NOW() WHERE id_product = '20690' 31/01/2023 10:04:37 am >> UPDATE ps_product_lang SET name = 'CARLO ACUTIS APOSTOLO DEI MILLENNIALS - V. RIZZO', description = '' WHERE id_product = '20690' 31/01/2023 10:04:37 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '20690' 31/01/2023 10:04:37 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20690' 31/01/2023 10:04:37 am >> DELETE FROM ps_specific_price WHERE id_product = '20690' 31/01/2023 10:04:57 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/01/2023 10:04:57 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20691' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:04:57 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20691' , '1' , '1' , '2' , NOW() , NOW() ) 31/01/2023 10:04:57 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20691' , '0' , '1' , '0' , '0' ) 31/01/2023 10:05:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788890578014' AND id_product != '20691' AND ean13 != '' 31/01/2023 10:05:47 am >> UPDATE ps_product SET id_supplier = '', reference = '6/2', ean13 = '9788890578014', date_upd = NOW() WHERE id_product = '20691' 31/01/2023 10:05:47 am >> UPDATE ps_product_lang SET name = 'LUIGI E ZELIA MARTIN - J. CLAPIER', description = '' WHERE id_product = '20691' 31/01/2023 10:05:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '16' WHERE id_product = '20691' 31/01/2023 10:05:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '16', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '71', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20691' 31/01/2023 10:05:47 am >> DELETE FROM ps_specific_price WHERE id_product = '20691' 31/01/2023 10:05:48 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 = '20691' 31/01/2023 10:05:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20692' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:05:48 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 '20692' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20691' 31/01/2023 10:05:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20692' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20691' 31/01/2023 10:07:01 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072124' AND id_product != '20692' AND ean13 != '' 31/01/2023 10:07:01 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788899072124', date_upd = NOW() WHERE id_product = '20692' 31/01/2023 10:07:01 am >> UPDATE ps_product_lang SET name = 'COME ACCOMPAGNARE I FIDANZATI - S. LONGOBARDI', description = '' WHERE id_product = '20692' 31/01/2023 10:07:01 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '20692' 31/01/2023 10:07:01 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20692' 31/01/2023 10:07:01 am >> DELETE FROM ps_specific_price WHERE id_product = '20692' 31/01/2023 10:07:02 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 = '20692' 31/01/2023 10:07:02 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20693' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:07:02 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 '20693' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20692' 31/01/2023 10:07:02 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20693' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20692' 31/01/2023 10:08:49 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072322' AND id_product != '20693' AND ean13 != '' 31/01/2023 10:08:49 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788899072322', date_upd = NOW() WHERE id_product = '20693' 31/01/2023 10:08:49 am >> UPDATE ps_product_lang SET name = 'TROVA LA PERLA PREZIOSA - G. ABBAGNARA', description = '' WHERE id_product = '20693' 31/01/2023 10:08:49 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '20693' 31/01/2023 10:08:49 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20693' 31/01/2023 10:08:49 am >> DELETE FROM ps_specific_price WHERE id_product = '20693' 31/01/2023 10:08:50 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 = '20693' 31/01/2023 10:08:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20694' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:08:50 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 '20694' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20693' 31/01/2023 10:08:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20694' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20693' 31/01/2023 10:09:41 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788890578083' AND id_product != '20694' AND ean13 != '' 31/01/2023 10:09:41 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788890578083', date_upd = NOW() WHERE id_product = '20694' 31/01/2023 10:09:41 am >> UPDATE ps_product_lang SET name = 'COSTRUIRE LA CASA SULLA ROCCIA - K. WOJTYLA', description = '' WHERE id_product = '20694' 31/01/2023 10:09:41 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '7' WHERE id_product = '20694' 31/01/2023 10:09:41 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '7', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20694' 31/01/2023 10:09:41 am >> DELETE FROM ps_specific_price WHERE id_product = '20694' 31/01/2023 10:09:42 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 = '20694' 31/01/2023 10:09:42 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20695' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:09:42 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 '20695' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20694' 31/01/2023 10:09:42 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20695' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20694' 31/01/2023 10:10:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072025' AND id_product != '20695' AND ean13 != '' 31/01/2023 10:10:13 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788899072025', date_upd = NOW() WHERE id_product = '20695' 31/01/2023 10:10:13 am >> UPDATE ps_product_lang SET name = 'VENITE ALLE NOZZE - S. LONGOBARDI', description = '' WHERE id_product = '20695' 31/01/2023 10:10:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5' WHERE id_product = '20695' 31/01/2023 10:10:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20695' 31/01/2023 10:10:13 am >> DELETE FROM ps_specific_price WHERE id_product = '20695' 31/01/2023 10:10:15 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 = '20695' 31/01/2023 10:10:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20696' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:10:15 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 '20696' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20695' 31/01/2023 10:10:15 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20696' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20695' 31/01/2023 10:10:47 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072926' AND id_product != '20696' AND ean13 != '' 31/01/2023 10:10:47 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788899072926', date_upd = NOW() WHERE id_product = '20696' 31/01/2023 10:10:47 am >> UPDATE ps_product_lang SET name = 'NOSTRE NOZZE ', description = '' WHERE id_product = '20696' 31/01/2023 10:10:47 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.9' WHERE id_product = '20696' 31/01/2023 10:10:47 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.9', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20696' 31/01/2023 10:10:47 am >> DELETE FROM ps_specific_price WHERE id_product = '20696' 31/01/2023 10:10:50 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 = '20696' 31/01/2023 10:10:50 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20697' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:10:50 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 '20697' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20696' 31/01/2023 10:10:50 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20697' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20696' 31/01/2023 10:11:26 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072940' AND id_product != '20697' AND ean13 != '' 31/01/2023 10:11:26 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788899072940', date_upd = NOW() WHERE id_product = '20697' 31/01/2023 10:11:26 am >> UPDATE ps_product_lang SET name = 'VOGLIO DONARMI COMPLETAMENTE A TE - C. GALATOLO', description = '' WHERE id_product = '20697' 31/01/2023 10:11:26 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20697' 31/01/2023 10:11:26 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20697' 31/01/2023 10:11:26 am >> DELETE FROM ps_specific_price WHERE id_product = '20697' 31/01/2023 10:11:29 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 = '20697' 31/01/2023 10:11:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20698' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:11:29 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 '20698' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20697' 31/01/2023 10:11:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20698' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20697' 31/01/2023 10:12:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072131' AND id_product != '20698' AND ean13 != '' 31/01/2023 10:12:20 am >> UPDATE ps_product SET id_supplier = '', reference = '1/4', ean13 = '9788899072131', date_upd = NOW() WHERE id_product = '20698' 31/01/2023 10:12:20 am >> UPDATE ps_product_lang SET name = 'DIARIO DI BORDO - S. LONGOBARDI', description = '' WHERE id_product = '20698' 31/01/2023 10:12:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '5.9' WHERE id_product = '20698' 31/01/2023 10:12:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '5.9', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20698' 31/01/2023 10:12:20 am >> DELETE FROM ps_specific_price WHERE id_product = '20698' 31/01/2023 10:12:22 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 = '20698' 31/01/2023 10:12:22 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20699' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:12:22 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 '20699' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20698' 31/01/2023 10:12:22 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20699' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20698' 31/01/2023 10:13:09 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072551' AND id_product != '20699' AND ean13 != '' 31/01/2023 10:13:09 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788899072551', date_upd = NOW() WHERE id_product = '20699' 31/01/2023 10:13:09 am >> UPDATE ps_product_lang SET name = 'VOI SIETE L\'ADESSO DI DIO - IPPOLITO/ABBAGNARA', description = '' WHERE id_product = '20699' 31/01/2023 10:13:09 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '20699' 31/01/2023 10:13:09 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20699' 31/01/2023 10:13:09 am >> DELETE FROM ps_specific_price WHERE id_product = '20699' 31/01/2023 10:13: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 = '20699' 31/01/2023 10:13:11 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20700' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:13: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 '20700' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20699' 31/01/2023 10:13:11 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20700' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20699' 31/01/2023 10:14:12 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072605' AND id_product != '20700' AND ean13 != '' 31/01/2023 10:14:12 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '9788899072605', date_upd = NOW() WHERE id_product = '20700' 31/01/2023 10:14:12 am >> UPDATE ps_product_lang SET name = 'AMORE, SESSO E VERGINITA\' - C. GALATOLO', description = '' WHERE id_product = '20700' 31/01/2023 10:14:12 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '20700' 31/01/2023 10:14:12 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '58', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20700' 31/01/2023 10:14:12 am >> DELETE FROM ps_specific_price WHERE id_product = '20700' 31/01/2023 10:14:13 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 = '20700' 31/01/2023 10:14:13 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20701' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:14:13 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 '20701' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20700' 31/01/2023 10:14:13 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20701' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20700' 31/01/2023 10:15:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '23_01_004' AND id_product != '20701' AND ean13 != '' 31/01/2023 10:15:22 am >> UPDATE ps_product SET id_supplier = '', reference = '2/4', ean13 = '23_01_004', date_upd = NOW() WHERE id_product = '20701' 31/01/2023 10:15:22 am >> UPDATE ps_product_lang SET name = 'CI SPOSIAMO COMPRENDERE LA POTENZA', description = '' WHERE id_product = '20701' 31/01/2023 10:15:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.5' WHERE id_product = '20701' 31/01/2023 10:15:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.5', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '134', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20701' 31/01/2023 10:15:22 am >> DELETE FROM ps_specific_price WHERE id_product = '20701' 31/01/2023 10:15:23 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 = '20701' 31/01/2023 10:15:23 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20702' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 10:15:23 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 '20702' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20701' 31/01/2023 10:15:23 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20702' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20701' 31/01/2023 10:24:22 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899072933' AND id_product != '20702' AND ean13 != '' 31/01/2023 10:24:22 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788899072933', date_upd = NOW() WHERE id_product = '20702' 31/01/2023 10:24:22 am >> UPDATE ps_product_lang SET name = 'CHI CERCATE - CALENDARIO QUARESIMA', description = '' WHERE id_product = '20702' 31/01/2023 10:24:22 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '3' WHERE id_product = '20702' 31/01/2023 10:24:22 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '3', id_tax_rules_group = '4', id_category_default = '517', id_argoment_default = '50', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '20702' 31/01/2023 10:24:22 am >> DELETE FROM ps_specific_price WHERE id_product = '20702' 31/01/2023 10:25:34 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' , '1966' , '2023-01-24' , '' , '0' , '174' , '4678466' , 'VIA ADRIANA 18 84012 ANGRI' , '' , 'CONTO DEPOSITO' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '169.19' , '169.19' , NOW() , NOW() ) 31/01/2023 10:25:34 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 = '80602' 31/01/2023 10:25:34 am >> DELETE FROM ps_document_detail WHERE id_document = '80602' 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20687' , 'NON HO CHE LOGGI PENSIERI TERASA DI LISIEUX - S. LONGOBARDI' , '3' , '3' , '4' , '16.00' , '16' , '0' , '30' , '33.6000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20687' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20687' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20688' , 'LEONIA MARTIN - D. MENVIELLE' , '3' , '3' , '4' , '4.90' , '4.9' , '0' , '100' , '0.0000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20688' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20688' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20689' , 'PER IL TUO SOLO AMORE -TERESA DI LISIEUX - J. FAU' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20689' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20689' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20691' , 'LUIGI E ZELIA MARTIN - J. CLAPIER' , '1' , '1' , '4' , '16.00' , '16' , '0' , '30' , '11.2000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20691' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20691' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20692' , 'COME ACCOMPAGNARE I FIDANZATI - S. LONGOBARDI' , '2' , '2' , '4' , '19.00' , '19' , '0' , '30' , '26.6000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20692' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20692' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20695' , 'VENITE ALLE NOZZE - S. LONGOBARDI' , '1' , '1' , '4' , '5.00' , '5' , '0' , '30' , '3.5000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20695' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20695' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20690' , 'CARLO ACUTIS APOSTOLO DEI MILLENNIALS - V. RIZZO' , '1' , '1' , '4' , '12.00' , '12' , '0' , '30' , '8.4000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20690' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20690' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20697' , 'VOGLIO DONARMI COMPLETAMENTE A TE - C. GALATOLO' , '2' , '2' , '4' , '10.00' , '10' , '0' , '30' , '14.0000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20697' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20697' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20700' , 'AMORE, SESSO E VERGINITA - C. GALATOLO' , '1' , '1' , '4' , '10.00' , '10' , '0' , '30' , '7.0000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20700' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20700' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20693' , 'TROVA LA PERLA PREZIOSA - G. ABBAGNARA' , '2' , '2' , '4' , '7.00' , '7' , '0' , '30' , '9.8000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20693' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20693' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20699' , 'VOI SIETE LADESSO DI DIO - IPPOLITO/ABBAGNARA' , '2' , '2' , '4' , '15.00' , '15' , '0' , '30' , '21.0000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20699' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20699' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20696' , 'NOSTRE NOZZE ' , '2' , '2' , '4' , '4.90' , '4.9' , '0' , '30' , '6.8600' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20696' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20696' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20694' , 'COSTRUIRE LA CASA SULLA ROCCIA - K. WOJTYLA' , '2' , '2' , '4' , '7.00' , '7' , '0' , '30' , '9.8000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20694' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20694' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20701' , 'CI SPOSIAMO COMPRENDERE LA POTENZA' , '2' , '2' , '4' , '4.50' , '4.5' , '0' , '30' , '6.3000' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20701' AND id_supplier = '174' 31/01/2023 10:25:34 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20701' , '174' , '1' ) 31/01/2023 10:25:34 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20698' , 'DIARIO DI BORDO - S. LONGOBARDI' , '1' , '1' , '4' , '5.90' , '5.9' , '0' , '30' , '4.1300' ) 31/01/2023 10:25:34 am >> DELETE FROM ps_product_supplier WHERE id_product = '20698' AND id_supplier = '174' 31/01/2023 10:25:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20698' , '174' , '1' ) 31/01/2023 10:25:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80602' , '20702' , 'CHI CERCATE - CALENDARIO QUARESIMA' , '1' , '1' , '4' , '3.00' , '3' , '0' , '100' , '0.0000' ) 31/01/2023 10:25:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '20702' AND id_supplier = '174' 31/01/2023 10:25:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20702' , '174' , '1' ) 31/01/2023 10:28:00 am >> SELECT document_num FROM ps_document WHERE document_num = '328' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 10:28:00 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' , '328' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '12.30' , NOW() , NOW() ) 31/01/2023 10:28:00 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 = '80603' 31/01/2023 10:28:00 am >> DELETE FROM ps_document_detail WHERE id_document = '80603' 31/01/2023 10:28:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80603' , '18339' , 'CROCE SAN BENEDETTO -CZ10NIK - VARI COLORI' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 31/01/2023 10:28:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80603' , '15088' , 'QUADRETTO EFFETTO PIETRA - MIRACOLOSA - 2952' , '1' , '-1' , '1' , '4.00' , '3.2786885245902' , '22' , '0' , '4.00' ) 31/01/2023 10:38:49 am >> SELECT document_num FROM ps_document WHERE document_num = '23' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 10:38: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 ( '21' , '23' , '2023-01-31' , '' , '4003' , '0' , '4678647' , 'VIA C. BATTISTI, 11 , 11 38037 PREDAZZO ' , '' , '' , '' , '0' , '0' , '0' , '0' , '' , '9' , '0' , '57.20' , '57.20' , NOW() , NOW() ) 31/01/2023 10:38: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 = '81115' 31/01/2023 10:38:50 am >> DELETE FROM ps_document_detail WHERE id_document = '81115' 31/01/2023 10:38: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 ( '81115' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '26' , '-26' , '4' , '2.3180' , '2.318' , '0' , '5' , '57.20' ) 31/01/2023 10:43:45 am >> UPDATE ps_orders SET current_state = '4', delivery_date = '2023-01-31' WHERE id_order = '416' 31/01/2023 10:43:45 am >> DELETE FROM ps_document WHERE document_num = '416' AND id_document_type = '28' 31/01/2023 10:44:52 am >> SELECT document_num FROM ps_document WHERE document_num = '23' AND id_document != '81115' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 10:44:52 am >> UPDATE ps_document SET id_document_type = '21', document_num = '23', document_date = '2023-01-31', document_letter = '', id_customer = '4003', id_supplier = '', id_address = '4678647', address1 = 'VIA C. BATTISTI, 11 , 11 38037 PREDAZZO ', address2 = '', note = '', price_shipping = '5', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '51.93', price_tax_excluded = '51.93', date_upd = NOW() WHERE id_document = '81115' 31/01/2023 10:44:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81115' 31/01/2023 10:44:53 am >> DELETE FROM ps_document_detail WHERE id_document = '81115' 31/01/2023 10:44:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81115' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '26' , '-26' , '4' , '1.9' , '1.9' , '0' , '5' , '46.93' ) 31/01/2023 10:57:31 am >> SELECT document_num FROM ps_document WHERE document_num = '329' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 10:57:31 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' , '329' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.67' , '40.67' , NOW() , NOW() ) 31/01/2023 10:57:31 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81116' 31/01/2023 10:57:31 am >> DELETE FROM ps_document_detail WHERE id_document = '81116' 31/01/2023 10:57:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81116' , '11103' , 'VANGELO E ATTI DEGLI APOSTOLI - TASC.' , '20' , '-20' , '4' , '1.60' , '1.6' , '0' , '5' , '30.40' ) 31/01/2023 10:57:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81116' , '19376' , 'INCONTRARE IL CROCIFISSO - T. HALIK' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 31/01/2023 10:57:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81116' , '20528' , 'AMEN - MAR 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/01/2023 10:57:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81116' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 31/01/2023 10:57:53 am >> SELECT document_num FROM ps_document WHERE document_num = '330' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 10:57:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '330' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 31/01/2023 10:57:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81117' 31/01/2023 10:57:53 am >> DELETE FROM ps_document_detail WHERE id_document = '81117' 31/01/2023 10:57:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81117' , '20527' , 'AMEN - APR 23' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 31/01/2023 10:57:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81117' , '20528' , 'AMEN - MAR 23' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 31/01/2023 11:08:46 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 ( '32' , '2023FV000103' , '2023-01-31' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '26' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '811.16' , '811.16' , NOW() , NOW() ) 31/01/2023 11:08:46 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 = '81118' 31/01/2023 11:08:46 am >> DELETE FROM ps_document_detail WHERE id_document = '81118' 31/01/2023 11:08:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '20620' , 'OMELIE DI PENTLING' , '2' , '0' , '4' , '12.0000' , '12' , '0' , '45' , '13.20' ) 31/01/2023 11:08:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '20620' AND id_supplier = '79' 31/01/2023 11:08:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20620' , '79' , '1' ) 31/01/2023 11:08:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '4430' , 'GESÙ DI NAZARET: DALLINGRESSO IN GERUSALEMME... - BENEDETTO XVI' , '1' , '0' , '4' , '20.0000' , '20' , '0' , '45' , '11.00' ) 31/01/2023 11:08:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '4430' AND id_supplier = '79' 31/01/2023 11:08:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4430' , '79' , '1' ) 31/01/2023 11:08:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '5966' , 'LUCE DEL MONDO - BENEDETTO XVI ' , '1' , '0' , '4' , '19.5000' , '19.5' , '0' , '45' , '10.73' ) 31/01/2023 11:08:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '5966' AND id_supplier = '79' 31/01/2023 11:08:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5966' , '79' , '1' ) 31/01/2023 11:08:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '3385' , 'DEUS CARITAS EST' , '1' , '0' , '4' , '3.5000' , '3.5' , '0' , '45' , '1.93' ) 31/01/2023 11:08:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '3385' AND id_supplier = '79' 31/01/2023 11:08:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3385' , '79' , '1' ) 31/01/2023 11:08:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '10119' , 'SPE SALVI' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '1.10' ) 31/01/2023 11:08:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '10119' AND id_supplier = '79' 31/01/2023 11:08:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10119' , '79' , '1' ) 31/01/2023 11:08:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '1727' , 'CARITAS IN VERITATE' , '1' , '0' , '4' , '2.0000' , '2' , '0' , '45' , '1.10' ) 31/01/2023 11:08:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '1727' AND id_supplier = '79' 31/01/2023 11:08:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1727' , '79' , '1' ) 31/01/2023 11:08: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 ( '81118' , '13132' , 'IDEA DI RIVELAZIONE - OPERA OMNIA - RATZINGER' , '1' , '0' , '4' , '75.0000' , '75' , '0' , '45' , '41.25' ) 31/01/2023 11:08:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '13132' AND id_supplier = '79' 31/01/2023 11:08:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13132' , '79' , '1' ) 31/01/2023 11:08: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 ( '81118' , '20621' , 'ANNUNCIATORI DELLA PAROLA... - OPERA OMNIA - RATZINGER' , '1' , '0' , '4' , '55.0000' , '55' , '0' , '45' , '30.25' ) 31/01/2023 11:08:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '20621' AND id_supplier = '79' 31/01/2023 11:08:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20621' , '79' , '1' ) 31/01/2023 11:08: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 ( '81118' , '13309' , 'INSEGNAMENTO DEL CONCILIO - OPERA OMNIA - RATZINGER' , '1' , '0' , '4' , '60.0000' , '60' , '0' , '45' , '33.00' ) 31/01/2023 11:08:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '13309' AND id_supplier = '79' 31/01/2023 11:08:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13309' , '79' , '1' ) 31/01/2023 11:08: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 ( '81118' , '16137' , 'INSEGNAMENTO DEL CONCILIO VATICANO II - OPERA OMNIA - RATZINGER' , '1' , '0' , '4' , '85.0000' , '85' , '0' , '45' , '46.75' ) 31/01/2023 11:08:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '16137' AND id_supplier = '79' 31/01/2023 11:08:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16137' , '79' , '1' ) 31/01/2023 11:08: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 ( '81118' , '19123' , 'CHIESA SEGNO TRA I POPOLI - OPERA OMNIA VIII/1- J. RATZINGER' , '1' , '0' , '4' , '90.0000' , '90' , '0' , '45' , '49.50' ) 31/01/2023 11:08:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '19123' AND id_supplier = '79' 31/01/2023 11:08:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19123' , '79' , '1' ) 31/01/2023 11:08: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 ( '81118' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '5' , '0' , '4' , '13.0000' , '13' , '0' , '45' , '35.75' ) 31/01/2023 11:08:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '20625' AND id_supplier = '79' 31/01/2023 11:08:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20625' , '79' , '1' ) 31/01/2023 11:08: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 ( '81118' , '9514' , 'SAN TARCISIO' , '1' , '0' , '4' , '6.0000' , '6' , '0' , '45' , '3.30' ) 31/01/2023 11:08:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '9514' AND id_supplier = '79' 31/01/2023 11:08:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9514' , '79' , '1' ) 31/01/2023 11:08: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 ( '81118' , '2549' , 'COMUNICAZIONE E MISSIONE' , '1' , '0' , '4' , '10.0000' , '10' , '0' , '35' , '6.50' ) 31/01/2023 11:08:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '2549' AND id_supplier = '79' 31/01/2023 11:08:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2549' , '79' , '1' ) 31/01/2023 11:08: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 ( '81118' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '2' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '154.00' ) 31/01/2023 11:08:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 31/01/2023 11:08:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 31/01/2023 11:08: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 ( '81118' , '5759' , 'LEZIONARIO DOMENICALE E FESTIVO - ANNO A' , '2' , '0' , '4' , '60.0000' , '60' , '0' , '30' , '84.00' ) 31/01/2023 11:08:47 am >> DELETE FROM ps_product_supplier WHERE id_product = '5759' AND id_supplier = '79' 31/01/2023 11:08:47 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5759' , '79' , '1' ) 31/01/2023 11:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '4427' , 'GESÙ DI NAZARET LA FIGURA E IL MESSAGGIO - J. RATZINGER - BENEDETTO XV' , '1' , '0' , '4' , '55.0000' , '55' , '0' , '45' , '30.25' ) 31/01/2023 11:08:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '4427' AND id_supplier = '79' 31/01/2023 11:08:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4427' , '79' , '1' ) 31/01/2023 11:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '19123' , 'CHIESA SEGNO TRA I POPOLI - OPERA OMNIA - RATZINGER' , '1' , '0' , '4' , '90.0000' , '90' , '0' , '45' , '49.50' ) 31/01/2023 11:08:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '19123' AND id_supplier = '79' 31/01/2023 11:08:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19123' , '79' , '1' ) 31/01/2023 11:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '16137' , 'INSEGNAMENTO DEL CONCILIO VATICANO II - OPERA OMNIA - RATZINGER' , '1' , '0' , '4' , '85.0000' , '85' , '0' , '45' , '46.75' ) 31/01/2023 11:08:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '16137' AND id_supplier = '79' 31/01/2023 11:08:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16137' , '79' , '1' ) 31/01/2023 11:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '1' , '0' , '4' , '110.0000' , '110' , '0' , '30' , '77.00' ) 31/01/2023 11:08:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 31/01/2023 11:08:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 31/01/2023 11:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '20620' , 'OMELIE DI PENTLING' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '45' , '6.60' ) 31/01/2023 11:08:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '20620' AND id_supplier = '79' 31/01/2023 11:08:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20620' , '79' , '1' ) 31/01/2023 11:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '20625' , 'DIO E SEMPRE NUOVO - RATZINGER' , '3' , '0' , '4' , '13.0000' , '13' , '0' , '45' , '21.45' ) 31/01/2023 11:08:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '20625' AND id_supplier = '79' 31/01/2023 11:08:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20625' , '79' , '1' ) 31/01/2023 11:08:48 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81118' , '4427' , 'GESÙ DI NAZARET LA FIGURA E IL MESSAGGIO - OPERA OMNIA - RATZINGER' , '1' , '0' , '4' , '55.0000' , '55' , '0' , '45' , '30.25' ) 31/01/2023 11:08:48 am >> DELETE FROM ps_product_supplier WHERE id_product = '4427' AND id_supplier = '79' 31/01/2023 11:08:48 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4427' , '79' , '1' ) 31/01/2023 11:49:18 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/01/2023 11:49:18 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20703' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 11:49:18 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20703' , '1' , '1' , '2' , NOW() , NOW() ) 31/01/2023 11:49:18 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20703' , '0' , '1' , '0' , '0' ) 31/01/2023 11:54:08 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002114' AND id_product != '20703' AND ean13 != '' 31/01/2023 11:54:08 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002114', date_upd = NOW() WHERE id_product = '20703' 31/01/2023 11:54:08 am >> UPDATE ps_product_lang SET name = 'QUADRETTO 30X15 - POSTO TRANQUILLO', description = '' WHERE id_product = '20703' 31/01/2023 11:54:08 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '20703' 31/01/2023 11:54:08 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '192', 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 = '20703' 31/01/2023 11:54:08 am >> DELETE FROM ps_specific_price WHERE id_product = '20703' 31/01/2023 11:54:25 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/01/2023 11:54:25 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20704' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 11:54:25 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20704' , '1' , '1' , '2' , NOW() , NOW() ) 31/01/2023 11:54:25 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20704' , '0' , '1' , '0' , '0' ) 31/01/2023 11:55: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 ( '31' , '33' , '2023-01-27' , '' , '0' , '13' , '2608' , 'VIA ECCE HOMO, 15 37054 NOGARA' , '' , '' , '16' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '417.96' , '342.59' , NOW() , NOW() ) 31/01/2023 11:55: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 = '81119' 31/01/2023 11:55:19 am >> DELETE FROM ps_document_detail WHERE id_document = '81119' 31/01/2023 11:55: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 ( '81119' , '20245' , 'FORMELLA CROCIFISSO 25X30' , '4' , '4' , '1' , '25.5' , '20.901639344262' , '22' , '19' , '100.7964' ) 31/01/2023 11:55:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '20245' AND id_supplier = '13' 31/01/2023 11:55:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20245' , '13' , '1' ) 31/01/2023 11:55: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 ( '81119' , '18561' , 'FORMELLA SAGOMATA 26X26 - TENERO ABBRACCIO 1025130' , '3' , '3' , '1' , '37' , '30.327868852459' , '22' , '19' , '109.6902' ) 31/01/2023 11:55:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '18561' AND id_supplier = '13' 31/01/2023 11:55:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18561' , '13' , '1' ) 31/01/2023 11:55: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 ( '81119' , '16864' , 'CROCIFISSO SAGOMATO 40X25 - 104062' , '2' , '2' , '1' , '59' , '48.360655737705' , '22' , '19' , '116.6076' ) 31/01/2023 11:55:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '16864' AND id_supplier = '13' 31/01/2023 11:55:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16864' , '13' , '1' ) 31/01/2023 11:55: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 ( '81119' , '20703' , 'QUADRETTO 30X15 - POSTO TRANQUILLO' , '4' , '4' , '1' , '17' , '13.934426229508' , '22' , '14' , '71.3456' ) 31/01/2023 11:55:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '20703' AND id_supplier = '13' 31/01/2023 11:55:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20703' , '13' , '1' ) 31/01/2023 12:09:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '331' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 12:09:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '331' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '373.00' , '305.74' , NOW() , NOW() ) 31/01/2023 12:09:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81120' 31/01/2023 12:09:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '81120' 31/01/2023 12:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81120' , '9395' , 'SAN BIAGIO VESCOVO - 28 ' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 31/01/2023 12:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81120' , '19247' , 'CROCE LUCE CM 16' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 31/01/2023 12:09:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81120' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '350' , '286.88524590164' , '22' , '0' , '350.00' ) 31/01/2023 12:14:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '331' AND id_document != '81120' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 12:14:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '331', document_date = '2023-01-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 = '373.00', price_tax_excluded = '305.74', date_upd = NOW() WHERE id_document = '81120' 31/01/2023 12:14:07 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 = '81120' 31/01/2023 12:14:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '81120' 31/01/2023 12:14:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81120' , '9395' , 'SAN BIAGIO VESCOVO - 28 ' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 31/01/2023 12:14:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81120' , '19247' , 'CROCE LUCE CM 16' , '1' , '-1' , '1' , '16.0000' , '13.114754098361' , '22' , '0' , '16.00' ) 31/01/2023 12:14:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81120' , '19972' , 'CALICE - ART. 570' , '1' , '-1' , '1' , '350' , '286.88524590164' , '22' , '0' , '350.00' ) 31/01/2023 12:49:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '332' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 12:49:10 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' , '332' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '104.00' , '99.52' , NOW() , NOW() ) 31/01/2023 12:49:10 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 = '81121' 31/01/2023 12:49:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '81121' 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '1.73' , '1.6634615384615' , '4' , '0' , '1.73' ) 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '893' , 'AVVENTO LECTIO BREVIS' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '19376' , 'INCONTRARE IL CROCIFISSO - T. HALIK' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '20675' , 'SULLA VIA DELLA CROCE CON PAPA FRANCESCO' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '20661' , 'LASCIATI AMARE - P. CURTAZ' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '20630' , 'NIENTALTRO CHE LA VERITA - G. GANSWEIN' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '8725' , 'QUARESIMA LECTIO BREVIS' , '1' , '-1' , '4' , '13.50' , '13.5' , '0' , '5' , '12.83' ) 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '6894' , 'NATALE LECTIO BREVIS' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 31/01/2023 12:49:10 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81121' , '10532' , 'TEMPO PASQUALE - LECTIO BREVIS - TEMPO DI PASQUA' , '1' , '-1' , '4' , '13.50' , '13.5' , '0' , '5' , '12.83' ) 31/01/2023 12:50:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '333' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 12:50: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 ( '11' , '333' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '38.19' , NOW() , NOW() ) 31/01/2023 12:50: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 = '81122' 31/01/2023 12:50:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '81122' 31/01/2023 12:50: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 ( '81122' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '6' , '-6' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '21.00' ) 31/01/2023 12:50: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 ( '81122' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '2.3' , '2.3' , '0' , '0' , '13.80' ) 31/01/2023 12:50: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 ( '81122' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '6' , '-6' , '4' , '0.70' , '0.7' , '0' , '0' , '4.20' ) 31/01/2023 12:50:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '334' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 12:50:42 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '334' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.00' , '61.48' , NOW() , NOW() ) 31/01/2023 12:50:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81123' 31/01/2023 12:50:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '81123' 31/01/2023 12:50:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81123' , '19794' , 'STOLA IN MICHELANGELO - 672' , '1' , '-1' , '1' , '75' , '61.475409836066' , '22' , '0' , '75.00' ) 31/01/2023 12:54:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '335' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 12:54: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' , '335' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 31/01/2023 12:54: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 = '81124' 31/01/2023 12:54:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '81124' 31/01/2023 12:54:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81124' , '11388' , 'VINO NUOVO IN OTRI NUOVI - ANNO A - M. PERRONI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 31/01/2023 02:26:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002114' AND id_product != '20703' AND ean13 != '' 31/01/2023 02:26:11 pm >> UPDATE ps_product SET id_supplier = '13', reference = '', ean13 = '002114', date_upd = NOW() WHERE id_product = '20703' 31/01/2023 02:26:11 pm >> UPDATE ps_product_lang SET name = 'QUADRETTO 30X15 - POSTO TRANQUILLO', description = '' WHERE id_product = '20703' 31/01/2023 02:26:12 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '32.37704918032787' WHERE id_product = '20703' 31/01/2023 02:26:12 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '32.37704918032787', id_tax_rules_group = '1', id_category_default = '192', 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 = '20703' 31/01/2023 02:26:12 pm >> DELETE FROM ps_specific_price WHERE id_product = '20703' 31/01/2023 03:11:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002115' AND id_product != '20704' AND ean13 != '' 31/01/2023 03:11:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002115', date_upd = NOW() WHERE id_product = '20704' 31/01/2023 03:11:00 pm >> UPDATE ps_product_lang SET name = 'QUADRO 63X35', description = '' WHERE id_product = '20704' 31/01/2023 03:11:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '72.54098360655738' WHERE id_product = '20704' 31/01/2023 03:11:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '72.54098360655738', id_tax_rules_group = '1', id_category_default = '276', 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 = '20704' 31/01/2023 03:11:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '20704' 31/01/2023 03:11:50 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 31/01/2023 03:11:50 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20705' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 03:11:50 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '20705' , '1' , '1' , '2' , NOW() , NOW() ) 31/01/2023 03:11:50 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '20705' , '0' , '1' , '0' , '0' ) 31/01/2023 03:12:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002116' AND id_product != '20705' AND ean13 != '' 31/01/2023 03:12:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002116', date_upd = NOW() WHERE id_product = '20705' 31/01/2023 03:12:17 pm >> UPDATE ps_product_lang SET name = 'CANDELA CUBO', description = '' WHERE id_product = '20705' 31/01/2023 03:12:17 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.065573770491804' WHERE id_product = '20705' 31/01/2023 03:12:17 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.065573770491804', id_tax_rules_group = '1', id_category_default = '276', 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 = '20705' 31/01/2023 03:12:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '20705' 31/01/2023 03:12:20 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 = '20705' 31/01/2023 03:12:20 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20706' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 03:12:20 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 '20706' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20705' 31/01/2023 03:12:20 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20706' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20705' 31/01/2023 03:27:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821594052' AND id_product != '3216' AND ean13 != '' 31/01/2023 03:27:27 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/5', ean13 = '9788821594052', date_upd = NOW() WHERE id_product = '3216' 31/01/2023 03:27:27 pm >> UPDATE ps_product_lang SET name = 'CUORE - E. DE AMICIS', description = '' WHERE id_product = '3216' 31/01/2023 03:27:27 pm >> UPDATE ps_product SET wholesale_price = '6.44', on_sale = '0', price = '9.9000' WHERE id_product = '3216' 31/01/2023 03:27:27 pm >> UPDATE ps_product_shop SET wholesale_price = '6.44', price = '9.9000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '90', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '3216' 31/01/2023 03:27:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '3216' 31/01/2023 03:27:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788821546594' AND id_product != '12706' AND ean13 != '' 31/01/2023 03:27:40 pm >> UPDATE ps_product SET id_supplier = '7', reference = '5/5', ean13 = '9788821546594', date_upd = NOW() WHERE id_product = '12706' 31/01/2023 03:27:40 pm >> UPDATE ps_product_lang SET name = 'PINOCCHIO', description = '' WHERE id_product = '12706' 31/01/2023 03:27:40 pm >> UPDATE ps_product SET wholesale_price = '5.20', on_sale = '0', price = '8.0000' WHERE id_product = '12706' 31/01/2023 03:27:40 pm >> UPDATE ps_product_shop SET wholesale_price = '5.20', price = '8.0000', id_tax_rules_group = '4', id_category_default = '30', id_argoment_default = '90', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '12706' 31/01/2023 03:27:40 pm >> DELETE FROM ps_specific_price WHERE id_product = '12706' 31/01/2023 03:53:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002117' AND id_product != '20706' AND ean13 != '' 31/01/2023 03:53:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002117', date_upd = NOW() WHERE id_product = '20706' 31/01/2023 03:53:08 pm >> UPDATE ps_product_lang SET name = 'ANGELO PENDENTE - AM', description = '' WHERE id_product = '20706' 31/01/2023 03:53:08 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '11.311475409836067' WHERE id_product = '20706' 31/01/2023 03:53:08 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '11.311475409836067', id_tax_rules_group = '1', id_category_default = '276', 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 = '20706' 31/01/2023 03:53:08 pm >> DELETE FROM ps_specific_price WHERE id_product = '20706' 31/01/2023 03:53:09 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 = '20706' 31/01/2023 03:53:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20707' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 03:53:09 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 '20707' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20706' 31/01/2023 03:53:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20707' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20706' 31/01/2023 03:55:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002118' AND id_product != '20707' AND ean13 != '' 31/01/2023 03:55:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002118', date_upd = NOW() WHERE id_product = '20707' 31/01/2023 03:55:02 pm >> UPDATE ps_product_lang SET name = 'LUME LEGNO', description = '' WHERE id_product = '20707' 31/01/2023 03:55:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '24.508196721311474' WHERE id_product = '20707' 31/01/2023 03:55:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '24.508196721311474', id_tax_rules_group = '1', id_category_default = '276', 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 = '20707' 31/01/2023 03:55:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '20707' 31/01/2023 03:55:03 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 = '20707' 31/01/2023 03:55:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '20708' , '1' , '' , 'nuovo-prodotto' ) 31/01/2023 03:55:03 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 '20708' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '20707' 31/01/2023 03:55:03 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '20708' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '20707' 31/01/2023 03:57:00 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' , '55/2023' , '2023-01-27' , '2023' , '0' , '50' , '2645' , 'VIA P. G. SEMERIA, 19 70014 CONVERSANO' , '' , '' , '10' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '484.95' , '397.50' , NOW() , NOW() ) 31/01/2023 03:57:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81125' 31/01/2023 03:57:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '81125' 31/01/2023 03:57:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81125' , '20705' , 'CANDELA CUBO' , '13' , '13' , '1' , '11' , '9.016393442623' , '22' , '50' , '87.2300' ) 31/01/2023 03:57:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20705' AND id_supplier = '50' 31/01/2023 03:57:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20705' , '50' , '1' ) 31/01/2023 03:57:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81125' , '20706' , 'ANGELO PENDENTE - AM' , '8' , '8' , '1' , '10' , '8.1967213114754' , '22' , '50' , '48.8000' ) 31/01/2023 03:57:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20706' AND id_supplier = '50' 31/01/2023 03:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20706' , '50' , '1' ) 31/01/2023 03:57: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 ( '81125' , '20707' , 'LUME LEGNO' , '3' , '3' , '1' , '24' , '19.672131147541' , '22' , '50' , '43.9200' ) 31/01/2023 03:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20707' AND id_supplier = '50' 31/01/2023 03:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20707' , '50' , '1' ) 31/01/2023 03:57: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 ( '81125' , '20704' , 'QUADRO 63X35' , '8' , '8' , '1' , '60' , '49.180327868852' , '22' , '50' , '292.8000' ) 31/01/2023 03:57:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20704' AND id_supplier = '50' 31/01/2023 03:57:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20704' , '50' , '1' ) 31/01/2023 03:59:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '336' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 03:59:40 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '336' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.55' , '27.55' , NOW() , NOW() ) 31/01/2023 03:59:40 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81126' 31/01/2023 03:59:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '81126' 31/01/2023 03:59:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81126' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '5' , '12.35' ) 31/01/2023 03:59:40 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81126' , '13432' , 'ARTE DI RICOMINCIARE - F. ROSINI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 31/01/2023 04:35:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839932143' AND id_product != '10532' AND ean13 != '' 31/01/2023 04:35:56 pm >> UPDATE ps_product SET id_supplier = '7', reference = '11/3', ean13 = '9788839932143', date_upd = NOW() WHERE id_product = '10532' 31/01/2023 04:35:56 pm >> UPDATE ps_product_lang SET name = 'TEMPO PASQUALE - LECTIO BREVIS ', description = '' WHERE id_product = '10532' 31/01/2023 04:35:56 pm >> UPDATE ps_product SET wholesale_price = '9.45', on_sale = '0', price = '13.5000' WHERE id_product = '10532' 31/01/2023 04:35:56 pm >> UPDATE ps_product_shop SET wholesale_price = '9.45', price = '13.5000', id_tax_rules_group = '4', id_category_default = '111', id_argoment_default = '16', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '10532' 31/01/2023 04:35:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '10532' 31/01/2023 04:36:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '329' AND id_document != '81116' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 04:36:51 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '329', document_date = '2023-01-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 = '40.67', price_tax_excluded = '40.67', date_upd = NOW() WHERE id_document = '81116' 31/01/2023 04:36:51 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81116' 31/01/2023 04:36:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '81116' 31/01/2023 04:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81116' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '30.4' , '30.4' , '0' , '0' , '30.40' ) 31/01/2023 04:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81116' , '19376' , 'INCONTRARE IL CROCIFISSO - T. HALIK' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 31/01/2023 04:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81116' , '20528' , 'AMEN - MAR 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 31/01/2023 04:36:51 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81116' , '20527' , 'AMEN - APR 23' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '5' , '3.71' ) 31/01/2023 04:48:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '337' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 04:48:36 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' , '337' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.90' , '26.15' , NOW() , NOW() ) 31/01/2023 04:48:36 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 = '81127' 31/01/2023 04:48:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '81127' 31/01/2023 04:48:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81127' , '19151' , 'CERONI S.S. T60 - CARTA BIANCO' , '2' , '-2' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '7.00' ) 31/01/2023 04:48:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81127' , '1951' , 'CERONI S.S. T60 - CARTA ROSSO' , '1' , '-1' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '3.50' ) 31/01/2023 04:48:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81127' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '1' , '-1' , '1' , '17.90' , '14.672131147541' , '22' , '0' , '17.90' ) 31/01/2023 04:48:36 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81127' , '9395' , 'SAN BIAGIO VESCOVO - 28 ' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 31/01/2023 04:51:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '12/23' , '2023-01-31' , '23' , '0' , '145' , '4670978' , 'VIA TORQUATO TASSO 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '400.40' , '385.00' , NOW() , NOW() ) 31/01/2023 04:51:47 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 = '81128' 31/01/2023 04:51:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '81128' 31/01/2023 04:51:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81128' , '20640' , 'GESU, MOSSO A COMPASSIONE' , '500' , '0' , '3' , '0.55' , '0.52884615384615' , '4' , '0' , '286.0000' ) 31/01/2023 04:51:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20640' AND id_supplier = '145' 31/01/2023 04:51:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20640' , '145' , '1' ) 31/01/2023 04:51:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81128' , '20640' , 'GESU, MOSSO A COMPASSIONE' , '200' , '0' , '3' , '0.55' , '0.52884615384615' , '4' , '0' , '114.4000' ) 31/01/2023 04:51:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20640' AND id_supplier = '145' 31/01/2023 04:51:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20640' , '145' , '1' ) 31/01/2023 04:52:06 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '27', document_date = '2023-01-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670978', address1 = 'VIA TORQUATO TASSO 10 24020 GORLE', 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 = '114.40', price_tax_excluded = '110.00', date_upd = NOW() WHERE id_document = '80495' 31/01/2023 04:52:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80495' 31/01/2023 04:52:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '80495' 31/01/2023 04:52:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80495' , '20640' , 'GESU, MOSSO A COMPASSIONE' , '200' , '200' , '3' , '0.55' , '0.52884615384615' , '4' , '0' , '114.4000' ) 31/01/2023 04:52:26 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '26', document_date = '2023-01-24', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4670978', address1 = 'VIA TORQUATO TASSO 10 24020 GORLE', address2 = '', note = 'INVIATE A BYBLOS', 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 = '286.00', price_tax_excluded = '275.00', date_upd = NOW() WHERE id_document = '80496' 31/01/2023 04:52:26 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '80496' 31/01/2023 04:52:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '80496' 31/01/2023 04:52:26 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '80496' , '20640' , 'GESU, MOSSO A COMPASSIONE' , '500' , '500' , '3' , '0.55' , '0.52884615384615' , '4' , '0' , '286.0000' ) 31/01/2023 05:17:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '15/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 05:17: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 ( '24' , '15/A' , '2023-01-31' , 'A' , '3029' , '0' , '4669124' , 'VIA G. AMENDOLA, 94 84084 PENTA DI FISCIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '399.10' , '330.43' , NOW() , NOW() ) 31/01/2023 05:17: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 = '81129' 31/01/2023 05:17:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '81129' 31/01/2023 05:17: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 ( '81129' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 31/01/2023 05:17: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 ( '81129' , '5229' , 'INCENSO PONTIFICAL' , '2' , '-2' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '48.00' ) 31/01/2023 05:17: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 ( '81129' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '60' , '-60' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '198.00' ) 31/01/2023 05:17: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 ( '81129' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 31/01/2023 05:17: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 ( '81129' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 31/01/2023 05:17: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 ( '81129' , '' , 'OSTIE' , '3' , '-3' , '4' , '2.3' , '2.3' , '0' , '0' , '6.90' ) 31/01/2023 05:17: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 ( '81129' , '' , 'PARTICOLE' , '3' , '-3' , '4' , '3.8' , '3.8' , '0' , '0' , '11.40' ) 31/01/2023 05:18:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '338' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 05:18:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '338' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '48.00' , '39.34' , NOW() , NOW() ) 31/01/2023 05:18:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81130' 31/01/2023 05:18:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '81130' 31/01/2023 05:18:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81130' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8' , '6.5573770491803' , '22' , '0' , '48.00' ) 31/01/2023 05:22:58 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '1026' , '2023-01-31' , '' , '0' , '105' , '4668972' , 'VIA NUOVA DELLE BRECCE, 214 80147 NAPOLI' , '' , '' , '5.9' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '60.50' , '60.50' , NOW() , NOW() ) 31/01/2023 05:22:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81131' 31/01/2023 05:22:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '81131' 31/01/2023 05:22:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81131' , '14802' , 'MESSA SPIEGATA AI RAGAZZI - G. ZACCARIA' , '2' , '2' , '4' , '9.00' , '9' , '0' , '30' , '12.6000' ) 31/01/2023 05:22:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14802' AND id_supplier = '105' 31/01/2023 05:22:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14802' , '105' , '1' ) 31/01/2023 05:22:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81131' , '20642' , 'CHE COSE IL CRISTIANESIMO - BENEDETTO XVI' , '3' , '3' , '4' , '20.00' , '20' , '0' , '30' , '42.0000' ) 31/01/2023 05:22:58 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20642' AND id_supplier = '105' 31/01/2023 05:22:58 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20642' , '105' , '1' ) 31/01/2023 05:28:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '339' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 05:28:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '339' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.60' , '13.60' , NOW() , NOW() ) 31/01/2023 05:28: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 = '81132' 31/01/2023 05:28:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '81132' 31/01/2023 05:28: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 ( '81132' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '6.8' , '6.8' , '0' , '0' , '13.60' ) 31/01/2023 06:35:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '340' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 06:35:19 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' , '340' , '2023-01-31' , '' , '357' , '0' , '4676034' , 'VIA TORRIONE 84100 SALERNO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '96.71' , '86.79' , NOW() , NOW() ) 31/01/2023 06:35:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81133' 31/01/2023 06:35:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '81133' 31/01/2023 06:35: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 ( '81133' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5' , '22.540983606557' , '22' , '0' , '55.00' ) 31/01/2023 06:35: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 ( '81133' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/01/2023 06:35: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 ( '81133' , '16936' , 'FILOTEA' , '1' , '-1' , '4' , '8.9000' , '8.9' , '0' , '5' , '8.46' ) 31/01/2023 06:35: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 ( '81133' , '4185' , 'FILOTEA - S. FRANCESCO DI SALES - 8240' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 31/01/2023 06:35: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 ( '81133' , '20630' , 'NIENT\'ALTRO CHE LA VERITA\' - G. GANSWEIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 31/01/2023 06:36:55 pm >> DELETE FROM ps_document WHERE id_document = '80540' 31/01/2023 06:36:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '80540' 31/01/2023 06:36:58 pm >> DELETE FROM ps_document WHERE id_document = '80441' 31/01/2023 06:36:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '80441' 31/01/2023 07:13:24 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '27', document_date = '2023-01-17', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669556', address1 = 'VIA XXV APRILE, 17 24050 GRASSOBBIO', 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 = '147.13', price_tax_excluded = '120.60', date_upd = NOW() WHERE id_document = '80509' 31/01/2023 07:13: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 = '80509' 31/01/2023 07:13:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '80509' 31/01/2023 07:13: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 ( '80509' , '18881' , 'STOLA POLIESTERE - PST020' , '8' , '8' , '1' , '8.2' , '6.7213114754098' , '22' , '0' , '80.0320' ) 31/01/2023 07:13: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 ( '80509' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '10' , '10' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '67.1000' ) 31/01/2023 07:14:02 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '32' , '42-1C2' , '2023-01-30' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '147.13' , '120.60' , NOW() , NOW() ) 31/01/2023 07:14:02 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 = '81134' 31/01/2023 07:14:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '81134' 31/01/2023 07:14: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 ( '81134' , '18881' , 'STOLA POLIESTERE - PST020' , '8' , '0' , '1' , '8.2000' , '6.7213' , '22' , '0' , '80.03' ) 31/01/2023 07:14:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18881' AND id_supplier = '122' 31/01/2023 07:14:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18881' , '122' , '1' ) 31/01/2023 07:14: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 ( '81134' , '18128' , 'PETTORINA PER COLLETTI DOPPI - AEPE02N00' , '10' , '0' , '1' , '5.5000' , '4.5082' , '22' , '0' , '67.10' ) 31/01/2023 07:14:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18128' AND id_supplier = '122' 31/01/2023 07:14:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18128' , '122' , '1' ) 31/01/2023 07:14:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '340' AND id_document != '81133' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 07:14:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '340', document_date = '2023-01-31', document_letter = '', id_customer = '', id_supplier = '', id_address = '', address1 = 'VIA TORRIONE 84100 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '96.71', price_tax_excluded = '86.79', date_upd = NOW() WHERE id_document = '81133' 31/01/2023 07:14:23 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 = '81133' 31/01/2023 07:14:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '81133' 31/01/2023 07:14:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81133' , '1631' , 'CANDELINE NON GOCCIOLANTI ' , '2' , '-2' , '1' , '27.5000' , '22.540983606557' , '22' , '0' , '55.00' ) 31/01/2023 07:14:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81133' , '19158' , 'SETTIMANA SANTA - N.E.' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 31/01/2023 07:14:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81133' , '16936' , 'FILOTEA' , '1' , '-1' , '4' , '8.9000' , '8.9' , '0' , '5' , '8.46' ) 31/01/2023 07:14:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81133' , '4185' , 'FILOTEA - S. FRANCESCO DI SALES - 8240' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 31/01/2023 07:14:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81133' , '20630' , 'NIENT\'ALTRO CHE LA VERITA\' - G. GANSWEIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 31/01/2023 07:51:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '341' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-01-31') 31/01/2023 07:52:00 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' , '341' , '2023-01-31' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 31/01/2023 07:52:00 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '81135' 31/01/2023 07:52:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '81135' 31/01/2023 07:52:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81135' , '20275' , 'SULLA TUA PAROLA GEN/FEB 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 31/01/2023 07:52:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '81135' , '20592' , 'SULLA TUA PAROLA MAR/APR 23 - 515' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' )