28/05/2024 08:31:06 am >> SELECT document_num FROM ps_document WHERE document_num = '70/A' AND id_document != '92029' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-27') 28/05/2024 08:31:06 am >> UPDATE ps_document SET id_document_type = '24', document_num = '70/A', document_date = '2024-05-27', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '1592.70', price_tax_excluded = '1592.70', date_upd = NOW() WHERE id_document = '92029' 28/05/2024 08:31:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92029' 28/05/2024 08:31:06 am >> DELETE FROM ps_document_detail WHERE id_document = '92029' 28/05/2024 08:31:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '22654' , 'TAVOLETTA PERSONALIZZATA SAN ROCCO' , '123' , '-123' , '0' , '1.0000' , '1' , '' , '0' , '123.00' ) 28/05/2024 08:31:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '22653' , 'GIROCOLLO PERSONALIZZATO SAN ROCCO' , '60' , '-60' , '0' , '3.5000' , '3.5' , '' , '0' , '210.00' ) 28/05/2024 08:31:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '22655' , 'ROSARIO F.MADRE PERLA SAN ROCCO' , '250' , '-250' , '0' , '2.5000' , '2.5' , '' , '0' , '625.00' ) 28/05/2024 08:31:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '1312' , 'BRACCIALE DECINA' , '200' , '-200' , '0' , '1.1000' , '1.1' , '' , '0' , '220.00' ) 28/05/2024 08:31:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '22656' , 'PORTACHIAVI SAN ROCCO' , '100' , '-100' , '0' , '2.0000' , '2' , '' , '0' , '200.00' ) 28/05/2024 08:31:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '22657' , 'MAGNETE SAN ROCCO' , '113' , '-113' , '0' , '1.9000' , '1.9' , '' , '0' , '214.70' ) 28/05/2024 08:31:41 am >> SELECT document_num FROM ps_document WHERE document_num = '70/A' AND id_document != '92029' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-27') 28/05/2024 08:31:41 am >> UPDATE ps_document SET id_document_type = '24', document_num = '70/A', document_date = '2024-05-27', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', 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 = '1592.70', price_tax_excluded = '1305.49', date_upd = NOW() WHERE id_document = '92029' 28/05/2024 08:31:41 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 = '92029' 28/05/2024 08:31:41 am >> DELETE FROM ps_document_detail WHERE id_document = '92029' 28/05/2024 08:31:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '22654' , 'TAVOLETTA PERSONALIZZATA SAN ROCCO' , '123' , '-123' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '123.00' ) 28/05/2024 08:31:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '22653' , 'GIROCOLLO PERSONALIZZATO SAN ROCCO' , '60' , '-60' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '210.00' ) 28/05/2024 08:31:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '22655' , 'ROSARIO F.MADRE PERLA SAN ROCCO' , '250' , '-250' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '625.00' ) 28/05/2024 08:31:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '1312' , 'BRACCIALE DECINA' , '200' , '-200' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '220.00' ) 28/05/2024 08:31:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '22656' , 'PORTACHIAVI SAN ROCCO' , '100' , '-100' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '200.00' ) 28/05/2024 08:31:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92029' , '22657' , 'MAGNETE SAN ROCCO' , '113' , '-113' , '1' , '1.9000' , '1.5573770491803' , '22' , '0' , '214.70' ) 28/05/2024 09:44:32 am >> SELECT document_num FROM ps_document WHERE document_num = '1776' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 09:44:32 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1776' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '21.00' , '20.19' , NOW() , NOW() ) 28/05/2024 09:44:32 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92037' 28/05/2024 09:44:32 am >> DELETE FROM ps_document_detail WHERE id_document = '92037' 28/05/2024 09:44:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92037' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 28/05/2024 09:44:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92037' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 28/05/2024 09:44:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92037' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 28/05/2024 09:44:32 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92037' , '16164' , 'OSTIA TAGLIO CHIUSO' , '1' , '-1' , '3' , '2' , '1.9230769230769' , '4' , '0' , '2.00' ) 28/05/2024 10:44:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1777' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 10:44: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' , '1777' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '37.00' , '30.33' , NOW() , NOW() ) 28/05/2024 10:44: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 = '92038' 28/05/2024 10:44:00 am >> DELETE FROM ps_document_detail WHERE id_document = '92038' 28/05/2024 10:44: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 ( '92038' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '2' , '-2' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '28.00' ) 28/05/2024 10:44: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 ( '92038' , '7910' , 'PERGAMENE - 1A COMUNIONE MOD. A' , '18' , '-18' , '1' , '0.5' , '0.40983606557377' , '22' , '0' , '9.00' ) 28/05/2024 10:55:41 am >> SELECT document_num FROM ps_document WHERE document_num = '1778' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 10:55:41 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' , '1778' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.00' , '23.77' , NOW() , NOW() ) 28/05/2024 10:55:41 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 = '92039' 28/05/2024 10:55:41 am >> DELETE FROM ps_document_detail WHERE id_document = '92039' 28/05/2024 10:55:41 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92039' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '29' , '23.770491803279' , '22' , '0' , '29.00' ) 28/05/2024 11:16:55 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 28/05/2024 11:16:55 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22664' , '1' , '' , 'nuovo-prodotto' ) 28/05/2024 11:16:56 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22664' , '1' , '1' , '2' , NOW() , NOW() ) 28/05/2024 11:16:56 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22664' , '0' , '1' , '0' , '0' ) 28/05/2024 11:17:45 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254712900' AND id_product != '22664' AND ean13 != '' 28/05/2024 11:17:45 am >> UPDATE ps_product SET id_supplier = '', reference = '13/3', ean13 = '9791254712900', date_upd = NOW() WHERE id_product = '22664' 28/05/2024 11:17:45 am >> UPDATE ps_product_lang SET name = 'LAUDATE DOMINUM', description = '' WHERE id_product = '22664' 28/05/2024 11:17:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '26' WHERE id_product = '22664' 28/05/2024 11:17:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '26', id_tax_rules_group = '4', id_category_default = '259', id_argoment_default = '28', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22664' 28/05/2024 11:17:46 am >> DELETE FROM ps_specific_price WHERE id_product = '22664' 28/05/2024 11:17:46 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 = '22664' 28/05/2024 11:17:47 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22665' , '1' , '' , 'nuovo-prodotto' ) 28/05/2024 11:17:47 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 '22665' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22664' 28/05/2024 11:17:47 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22665' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22664' 28/05/2024 11:18:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713787' AND id_product != '22665' AND ean13 != '' 28/05/2024 11:18:40 am >> UPDATE ps_product SET id_supplier = '', reference = '1/3', ean13 = '9788832713787', date_upd = NOW() WHERE id_product = '22665' 28/05/2024 11:18:40 am >> UPDATE ps_product_lang SET name = 'DOMANDE CHE NON TI HO FATTO - FRATINI/SEGHEDONI', description = '' WHERE id_product = '22665' 28/05/2024 11:18:40 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '12' WHERE id_product = '22665' 28/05/2024 11:18:40 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '12', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '145', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22665' 28/05/2024 11:18:40 am >> DELETE FROM ps_specific_price WHERE id_product = '22665' 28/05/2024 11:18:41 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 = '22665' 28/05/2024 11:18:41 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22666' , '1' , '' , 'nuovo-prodotto' ) 28/05/2024 11:18:41 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 '22666' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22665' 28/05/2024 11:18:41 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22666' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22665' 28/05/2024 11:19:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788839410047' AND id_product != '22666' AND ean13 != '' 28/05/2024 11:19:28 am >> UPDATE ps_product SET id_supplier = '', reference = '11/4', ean13 = '9788839410047', date_upd = NOW() WHERE id_product = '22666' 28/05/2024 11:19:28 am >> UPDATE ps_product_lang SET name = 'DIECI COMANDAMENTI - M. COOGAN', description = '' WHERE id_product = '22666' 28/05/2024 11:19:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19' WHERE id_product = '22666' 28/05/2024 11:19:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19', id_tax_rules_group = '4', id_category_default = '118', id_argoment_default = '20', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22666' 28/05/2024 11:19:28 am >> DELETE FROM ps_specific_price WHERE id_product = '22666' 28/05/2024 11:19: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 = '22666' 28/05/2024 11:19:29 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22667' , '1' , '' , 'nuovo-prodotto' ) 28/05/2024 11:19: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 '22667' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22666' 28/05/2024 11:19:29 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22667' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22666' 28/05/2024 11:21:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '00151053' , '2024-05-27' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '85.24' , '85.24' , NOW() , NOW() ) 28/05/2024 11:21:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92040' 28/05/2024 11:21:37 am >> DELETE FROM ps_document_detail WHERE id_document = '92040' 28/05/2024 11:21:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92040' , '22664' , 'LAUDATE DOMINUM' , '1' , '1' , '4' , '26.00' , '26' , '0' , '35' , '16.9000' ) 28/05/2024 11:21:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '22664' AND id_supplier = '109' 28/05/2024 11:21:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22664' , '109' , '1' ) 28/05/2024 11:21:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92040' , '5778' , 'LEZIONARIO QUOTIDIANO 2' , '1' , '1' , '4' , '32.00' , '32' , '0' , '33' , '21.4400' ) 28/05/2024 11:21:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '5778' AND id_supplier = '109' 28/05/2024 11:21:37 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5778' , '109' , '1' ) 28/05/2024 11:21:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92040' , '5777' , 'LEZIONARIO QUOTIDIANO 1' , '1' , '1' , '4' , '35.00' , '35' , '0' , '33' , '23.4500' ) 28/05/2024 11:21:37 am >> DELETE FROM ps_product_supplier WHERE id_product = '5777' AND id_supplier = '109' 28/05/2024 11:21:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5777' , '109' , '1' ) 28/05/2024 11:21:38 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92040' , '5780' , 'LEZIONARIO QUOTIDIANO 4' , '1' , '1' , '4' , '35.00' , '35' , '0' , '33' , '23.4500' ) 28/05/2024 11:21:38 am >> DELETE FROM ps_product_supplier WHERE id_product = '5780' AND id_supplier = '109' 28/05/2024 11:21:38 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5780' , '109' , '1' ) 28/05/2024 11:21:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1779' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 11:21:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1779' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '4.50' , NOW() , NOW() ) 28/05/2024 11:21:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92041' 28/05/2024 11:21:49 am >> DELETE FROM ps_document_detail WHERE id_document = '92041' 28/05/2024 11:21:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92041' , '22512' , 'VIVE - AGGIUNTA CANTI' , '1' , '-1' , '4' , '4.50' , '4.5' , '0' , '0' , '4.50' ) 28/05/2024 11:28:09 am >> UPDATE ps_document SET id_document_type = '33', document_num = '00151053', document_date = '2024-05-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4669106', address1 = 'VIA G. VERDI, 8 20090 ASSAGO', 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 = '338.51', price_tax_excluded = '338.51', date_upd = NOW() WHERE id_document = '92040' 28/05/2024 11:28: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 = '92040' 28/05/2024 11:28:09 am >> DELETE FROM ps_document_detail WHERE id_document = '92040' 28/05/2024 11:28: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 ( '92040' , '22664' , 'LAUDATE DOMINUM' , '1' , '1' , '4' , '26.0000' , '26' , '0' , '35' , '16.90' ) 28/05/2024 11:28: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 ( '92040' , '5778' , 'LEZIONARIO QUOTIDIANO 2' , '1' , '1' , '4' , '32.0000' , '32' , '0' , '33' , '21.44' ) 28/05/2024 11:28: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 ( '92040' , '5777' , 'LEZIONARIO QUOTIDIANO 1' , '1' , '1' , '4' , '35.0000' , '35' , '0' , '33' , '23.45' ) 28/05/2024 11:28: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 ( '92040' , '5780' , 'LEZIONARIO QUOTIDIANO 4' , '1' , '1' , '4' , '35.0000' , '35' , '0' , '33' , '23.45' ) 28/05/2024 11:28: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 ( '92040' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '10' , '10' , '4' , '38.00' , '38' , '0' , '45' , '209.0000' ) 28/05/2024 11:28: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 ( '92040' , '5779' , 'LEZIONARIO QUOTIDIANO 3' , '1' , '1' , '4' , '36.00' , '36' , '0' , '33' , '24.1200' ) 28/05/2024 11:28: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 ( '92040' , '22665' , 'DOMANDE CHE NON TI HO FATTO - FRATINI/SEGHEDONI' , '1' , '1' , '4' , '12.00' , '12' , '0' , '35' , '7.8000' ) 28/05/2024 11:28: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 ( '92040' , '22666' , 'DIECI COMANDAMENTI - M. COOGAN' , '1' , '1' , '4' , '19.00' , '19' , '0' , '35' , '12.3500' ) 28/05/2024 11:49:42 am >> SELECT document_num FROM ps_document WHERE document_num = '1780' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 11:49:42 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' , '1780' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.80' , '12.95' , NOW() , NOW() ) 28/05/2024 11:49:42 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 = '92042' 28/05/2024 11:49:42 am >> DELETE FROM ps_document_detail WHERE id_document = '92042' 28/05/2024 11:49:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92042' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 28/05/2024 11:51:37 am >> SELECT document_num FROM ps_document WHERE document_num = '1781' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 11:51:37 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1781' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.70' , '145.53' , NOW() , NOW() ) 28/05/2024 11:51:37 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92043' 28/05/2024 11:51:37 am >> DELETE FROM ps_document_detail WHERE id_document = '92043' 28/05/2024 11:51:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92043' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '3' , '-3' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '10.50' ) 28/05/2024 11:51:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92043' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 28/05/2024 11:51:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92043' , '18748' , 'OSTIA MAGNA 125 - OM 125' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 28/05/2024 11:51:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92043' , '11389' , 'VINO ROSSO DOLCE - 103' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 28/05/2024 11:51:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92043' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 28/05/2024 11:51:37 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92043' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 28/05/2024 11:54:26 am >> SELECT document_num FROM ps_document WHERE document_num = '1782' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 11:54:26 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1782' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '71.20' , '60.46' , NOW() , NOW() ) 28/05/2024 11:54:26 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92044' 28/05/2024 11:54:26 am >> DELETE FROM ps_document_detail WHERE id_document = '92044' 28/05/2024 11:54:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92044' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 28/05/2024 11:54:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92044' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 28/05/2024 11:54:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92044' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 28/05/2024 11:54:26 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92044' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 28/05/2024 12:08:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '1783' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 12:08: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' , '1783' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.11' , '10.60' , NOW() , NOW() ) 28/05/2024 12:08: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 = '92045' 28/05/2024 12:08:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '92045' 28/05/2024 12:08: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 ( '92045' , '19560' , 'PERGAMENA COMUNIONE 17X25' , '12' , '-12' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '8.40' ) 28/05/2024 12:08: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 ( '92045' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 28/05/2024 12:21:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1777' AND id_document != '92038' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 12:21:56 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1777', document_date = '2024-05-28', 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 = '37.00', price_tax_excluded = '30.33', date_upd = NOW() WHERE id_document = '92038' 28/05/2024 12:21:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92038' 28/05/2024 12:21:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '92038' 28/05/2024 12:21:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92038' , '1370' , 'BROCCHETTE RICAMBIO PER ART. 523 - 500' , '2' , '-2' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '28.00' ) 28/05/2024 12:21:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92038' , '7915' , 'PERGAMENE - 1A COMUNIONE MOD. D' , '18' , '-18' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '9.00' ) 28/05/2024 12:22:58 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7914' 28/05/2024 12:22:58 pm >> UPDATE ps_stock_available SET quantity = quantity + '-41' WHERE id_product = '7914' 28/05/2024 12:23:06 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7915' 28/05/2024 12:23:06 pm >> UPDATE ps_stock_available SET quantity = quantity + '-30' WHERE id_product = '7915' 28/05/2024 12:24:06 pm >> UPDATE ps_product_shop SET minimal_quantity = '1', multiple_quantity = '1', available_date = '', date_upd = NOW() WHERE id_product = '7914' 28/05/2024 12:24:06 pm >> UPDATE ps_stock_available SET quantity = quantity + '41' WHERE id_product = '7914' 28/05/2024 12:32:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '1784' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 12:32:12 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1784' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.46' , '27.02' , NOW() , NOW() ) 28/05/2024 12:32:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92046' 28/05/2024 12:32:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '92046' 28/05/2024 12:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92046' , '22511' , 'VIVE - CD' , '1' , '-1' , '4' , '16.90' , '16.9' , '0' , '5' , '16.06' ) 28/05/2024 12:32:12 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92046' , '22513' , 'VIVE - SPARTITO' , '1' , '-1' , '3' , '12.00' , '11.538461538462' , '4' , '5' , '11.40' ) 28/05/2024 12:32:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '1785' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 12:32:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1785' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.00' , '37.50' , NOW() , NOW() ) 28/05/2024 12:32:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92047' 28/05/2024 12:32:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '92047' 28/05/2024 12:32:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92047' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 28/05/2024 12:32:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92047' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 28/05/2024 12:43:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '1319' AND id_document != '91472' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-04-27') 28/05/2024 12:43:27 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1319', document_date = '2024-04-27', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '91472' 28/05/2024 12:43:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91472' 28/05/2024 12:43:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '91472' 28/05/2024 12:43:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91472' , '20245' , 'FORMELLA CROCIFISSO 25X30' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 28/05/2024 04:00:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1786' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 04:00: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' , '1786' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '168.00' , '137.70' , NOW() , NOW() ) 28/05/2024 04:00: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 = '92048' 28/05/2024 04:00:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '92048' 28/05/2024 04:00: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 ( '92048' , '15403' , 'CROCE IN RESINA CM 9 - 3806/G052' , '48' , '-48' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '168.00' ) 28/05/2024 04:15:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 04:15: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 ( '11' , '1787' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.85' , NOW() , NOW() ) 28/05/2024 04:15: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 = '92049' 28/05/2024 04:15:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '92049' 28/05/2024 04:15: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 ( '92049' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 28/05/2024 04:20:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '91976' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-23') 28/05/2024 04:20:12 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '63/A', document_date = '2024-05-23', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '64.60', price_tax_excluded = '56.38', date_upd = NOW() WHERE id_document = '91976' 28/05/2024 04:20:12 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '91976' 28/05/2024 04:20:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '91976' 28/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91976' , '15097' , 'CORONA MATRIMONIO - ORO' , '1' , '-1' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '7.50' ) 28/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91976' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 28/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91976' , '7943' , 'PERGAMENE - OCCASIONI MOD. B' , '5' , '-5' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '2.50' ) 28/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91976' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '5' , '-5' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '3.00' ) 28/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91976' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '2' , '-2' , '1' , '12.2000' , '10' , '22' , '0' , '24.40' ) 28/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91976' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91976' , '18129' , 'TAU COLORATO - T56' , '2' , '-2' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '2.40' ) 28/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91976' , '18130' , 'TAU GRANDE CM 4 - T9' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91976' , '18131' , 'TAU MEDIO CM3 - T6' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91976' , '10456' , 'TAU ULIVO - PICCOLO - 738' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/05/2024 04:20:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '91976' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '3' , '-3' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '1.80' ) 28/05/2024 04:22:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '91976' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-05-23') 28/05/2024 04:22:00 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '63/A', document_date = '2024-05-23', document_letter = 'A', id_customer = '333', id_supplier = '', id_address = '4671072', address1 = 'P.ZZA S. MICHELE 84135 RUFOLI', 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 = '87.10', price_tax_excluded = '74.82', date_upd = NOW() WHERE id_document = '91976' 28/05/2024 04:22: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 = '91976' 28/05/2024 04:22:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '91976' 28/05/2024 04:22: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 ( '91976' , '15097' , 'CORONA MATRIMONIO - ORO' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 28/05/2024 04:22: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 ( '91976' , '22330' , 'LIFE - LA MIA STORIA - PAPA FRANCESCO' , '1' , '-1' , '4' , '19.0000' , '19' , '0' , '0' , '19.00' ) 28/05/2024 04:22: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 ( '91976' , '7943' , 'PERGAMENE - OCCASIONI MOD. B' , '5' , '-5' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '2.50' ) 28/05/2024 04:22: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 ( '91976' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '5' , '-5' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '3.00' ) 28/05/2024 04:22: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 ( '91976' , '19431' , 'PALLONCINO MAGNETE 12X15 - PM' , '2' , '-2' , '1' , '12.2000' , '10' , '22' , '0' , '24.40' ) 28/05/2024 04:22: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 ( '91976' , '17005' , 'BIGLIETTO AUGURALE medio' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/05/2024 04:22: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 ( '91976' , '18129' , 'TAU COLORATO - T56' , '2' , '-2' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '2.40' ) 28/05/2024 04:22: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 ( '91976' , '18130' , 'TAU GRANDE CM 4 - T9' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/05/2024 04:22: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 ( '91976' , '18131' , 'TAU MEDIO CM3 - T6' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/05/2024 04:22: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 ( '91976' , '10456' , 'TAU ULIVO - PICCOLO - 738' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 28/05/2024 04:22: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 ( '91976' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '3' , '-3' , '1' , '0.6000' , '0.49180327868852' , '22' , '0' , '1.80' ) 28/05/2024 04:22: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 ( '91976' , '15096' , 'CORONA MATRIMONIO - ARG ' , '1' , '-1' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '7.50' ) 28/05/2024 06:30:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1788' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-05-28') 28/05/2024 06:30:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1788' , '2024-05-28' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 28/05/2024 06:30:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92050' 28/05/2024 06:30:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '92050' 28/05/2024 06:30: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 ( '92050' , '18617' , 'MEDAGLIA MIRACOLOSA - OV22/M' , '200' , '-200' , '1' , '0.25' , '0.20491803278689' , '22' , '0' , '50.00' )