22/02/2024 08:40:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001971' AND id_product != '19435' AND ean13 != '' 22/02/2024 08:40:28 am >> UPDATE ps_product SET id_supplier = '160', reference = '', ean13 = '001971', date_upd = NOW() WHERE id_product = '19435' 22/02/2024 08:40:28 am >> UPDATE ps_product_lang SET name = 'STOLA - STO0M05', description = '' WHERE id_product = '19435' 22/02/2024 08:40:28 am >> UPDATE ps_product SET wholesale_price = '109.28', on_sale = '0', price = '276.2295081967213' WHERE id_product = '19435' 22/02/2024 08:40:28 am >> UPDATE ps_product_shop SET wholesale_price = '109.28', price = '276.2295081967213', id_tax_rules_group = '1', id_category_default = '494', 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 = '19435' 22/02/2024 08:40:28 am >> DELETE FROM ps_specific_price WHERE id_product = '19435' 22/02/2024 09:23:12 am >> SELECT document_num FROM ps_document WHERE document_num = '527' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 09:23:12 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '527' , '2024-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '7.21' , NOW() , NOW() ) 22/02/2024 09:23:12 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90452' 22/02/2024 09:23:12 am >> DELETE FROM ps_document_detail WHERE id_document = '90452' 22/02/2024 09:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90452' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 22/02/2024 09:23:12 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90452' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 22/02/2024 09:36:25 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '506/24' , '2024-02-20' , '24' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0.01' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '477.61' , '459.25' , NOW() , NOW() ) 22/02/2024 09:36:25 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90453' 22/02/2024 09:36:25 am >> DELETE FROM ps_document_detail WHERE id_document = '90453' 22/02/2024 09:36:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90453' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '5' , '5' , '3' , '4' , '3.8461538461538' , '4' , '3' , '20.1760' ) 22/02/2024 09:36:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '17711' AND id_supplier = '22' 22/02/2024 09:36:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17711' , '22' , '1' ) 22/02/2024 09:36:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90453' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '5' , '5' , '3' , '2.1' , '2.0192307692308' , '4' , '3' , '10.5924' ) 22/02/2024 09:36:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '19089' AND id_supplier = '22' 22/02/2024 09:36:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19089' , '22' , '1' ) 22/02/2024 09:36:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90453' , '18749' , 'OSTIA MAGNA 200mm - OM 200' , '3' , '3' , '3' , '4' , '3.8461538461538' , '4' , '3' , '12.1056' ) 22/02/2024 09:36:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '18749' AND id_supplier = '22' 22/02/2024 09:36:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18749' , '22' , '1' ) 22/02/2024 09:36:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90453' , '7311' , 'OSTIA SOTTILE 74MM' , '300' , '300' , '3' , '1.11' , '1.0673076923077' , '4' , '3' , '335.9304' ) 22/02/2024 09:36:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '22' 22/02/2024 09:36:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '22' , '1' ) 22/02/2024 09:36:25 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90453' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '50' , '50' , '3' , '1.9' , '1.8269230769231' , '4' , '0' , '98.8000' ) 22/02/2024 09:36:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '22' 22/02/2024 09:36:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '22' , '1' ) 22/02/2024 09:53:49 am >> SELECT document_num FROM ps_document WHERE document_num = '528' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 09:53: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' , '528' , '2024-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '57.00' , NOW() , NOW() ) 22/02/2024 09:53: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 = '90454' 22/02/2024 09:53:49 am >> DELETE FROM ps_document_detail WHERE id_document = '90454' 22/02/2024 09:53: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 ( '90454' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '12' , '-12' , '4' , '5.00' , '5' , '0' , '5' , '57.00' ) 22/02/2024 10:06:14 am >> SELECT document_num FROM ps_document WHERE document_num = '529' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 10:06:14 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' , '529' , '2024-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 22/02/2024 10:06:14 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 = '90455' 22/02/2024 10:06:14 am >> DELETE FROM ps_document_detail WHERE id_document = '90455' 22/02/2024 10:06:14 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 ( '90455' , '15746' , 'ADORIAMO IL SS SACRAMENTO - VOL 1 - 8958' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 22/02/2024 10:06:14 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 ( '90455' , '18635' , 'NASCOSTO IN UN PEZZETTO DI PANE - 8038' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 22/02/2024 10:19:40 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002120' AND id_product != '20791' AND ean13 != '' 22/02/2024 10:19:40 am >> UPDATE ps_product SET id_supplier = '175', reference = '', ean13 = '002120', date_upd = NOW() WHERE id_product = '20791' 22/02/2024 10:19:40 am >> UPDATE ps_product_lang SET name = 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ', description = '' WHERE id_product = '20791' 22/02/2024 10:19:40 am >> UPDATE ps_product SET wholesale_price = '7.13', on_sale = '0', price = '20.491803278688526' WHERE id_product = '20791' 22/02/2024 10:19:40 am >> UPDATE ps_product_shop SET wholesale_price = '7.13', price = '20.491803278688526', id_tax_rules_group = '1', id_category_default = '519', 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 = '20791' 22/02/2024 10:19:40 am >> DELETE FROM ps_specific_price WHERE id_product = '20791' 22/02/2024 10:33:36 am >> SELECT document_num FROM ps_document WHERE document_num = '530' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 10:33:36 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '530' , '2024-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '192.00' , '157.38' , NOW() , NOW() ) 22/02/2024 10:33: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 = '90456' 22/02/2024 10:33:37 am >> DELETE FROM ps_document_detail WHERE id_document = '90456' 22/02/2024 10:33: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 ( '90456' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '6' , '-6' , '1' , '22' , '18.032786885246' , '22' , '0' , '132.00' ) 22/02/2024 10:33: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 ( '90456' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '15' , '12.295081967213' , '22' , '0' , '60.00' ) 22/02/2024 11:53:39 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 22/02/2024 11:53:39 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22191' , '1' , '' , 'nuovo-prodotto' ) 22/02/2024 11:53:39 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22191' , '1' , '1' , '2' , NOW() , NOW() ) 22/02/2024 11:53:39 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22191' , '0' , '1' , '0' , '0' ) 22/02/2024 11:54:20 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608662' AND id_product != '22191' AND ean13 != '' 22/02/2024 11:54:20 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826608662', date_upd = NOW() WHERE id_product = '22191' 22/02/2024 11:54:20 am >> UPDATE ps_product_lang SET name = 'PREGARE CON I SALMI', description = '' WHERE id_product = '22191' 22/02/2024 11:54:20 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.5' WHERE id_product = '22191' 22/02/2024 11:54:20 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.5', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22191' 22/02/2024 11:54:20 am >> DELETE FROM ps_specific_price WHERE id_product = '22191' 22/02/2024 11:54:21 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 = '22191' 22/02/2024 11:54:21 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22192' , '1' , '' , 'nuovo-prodotto' ) 22/02/2024 11:54:21 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 '22192' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22191' 22/02/2024 11:54:21 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22192' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22191' 22/02/2024 11:55:46 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788826608679' AND id_product != '22192' AND ean13 != '' 22/02/2024 11:55:46 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788826608679', date_upd = NOW() WHERE id_product = '22192' 22/02/2024 11:55:46 am >> UPDATE ps_product_lang SET name = 'PREGHIERA DI GESU\'', description = '' WHERE id_product = '22192' 22/02/2024 11:55:46 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '8.5' WHERE id_product = '22192' 22/02/2024 11:55:46 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '8.5', id_tax_rules_group = '4', id_category_default = '104', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22192' 22/02/2024 11:55:46 am >> DELETE FROM ps_specific_price WHERE id_product = '22192' 22/02/2024 11:55:47 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 = '22192' 22/02/2024 11:55:48 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22193' , '1' , '' , 'nuovo-prodotto' ) 22/02/2024 11:55: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 '22193' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22192' 22/02/2024 11:55:48 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22193' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22192' 22/02/2024 11:58:01 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' , '2024-DL000611' , '2024-02-21' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.20' , '108.20' , NOW() , NOW() ) 22/02/2024 11:58:01 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 = '90457' 22/02/2024 11:58:01 am >> DELETE FROM ps_document_detail WHERE id_document = '90457' 22/02/2024 11:58:01 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 ( '90457' , '22191' , 'PREGARE CON I SALMI' , '10' , '10' , '4' , '8.50' , '8.5' , '0' , '45' , '46.7500' ) 22/02/2024 11:58:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '22191' AND id_supplier = '79' 22/02/2024 11:58:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22191' , '79' , '1' ) 22/02/2024 11:58:01 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 ( '90457' , '22192' , 'PREGHIERA DI GESU' , '10' , '10' , '4' , '8.50' , '8.5' , '0' , '45' , '46.7500' ) 22/02/2024 11:58:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '22192' AND id_supplier = '79' 22/02/2024 11:58:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22192' , '79' , '1' ) 22/02/2024 11:58:01 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 ( '90457' , '9017' , 'RITO DELLA PENITENZA' , '2' , '2' , '4' , '10.50' , '10.5' , '0' , '30' , '14.7000' ) 22/02/2024 11:58:01 am >> DELETE FROM ps_product_supplier WHERE id_product = '9017' AND id_supplier = '79' 22/02/2024 11:58:01 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9017' , '79' , '1' ) 22/02/2024 03:10:44 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '16/24', document_date = '2024-01-31', document_letter = '24', id_customer = '0', id_supplier = '0', id_address = '4671003', 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 = '3', id_causal = '0', price_tax_included = '48.00', price_tax_excluded = '48.00', date_upd = NOW() WHERE id_document = '90279' 22/02/2024 03:10:44 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 = '90279' 22/02/2024 03:10:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '90279' 22/02/2024 03:10: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 ( '90279' , '22118' , 'PIEGHEVOLE LA MEDAGLIA MIRACOLOSA' , '120' , '120' , '4' , '0.8000' , '0.8' , '0' , '50' , '48.00' ) 22/02/2024 03:11:00 pm >> UPDATE ps_document SET id_document_type = '31', document_num = '16/24', document_date = '2024-01-31', document_letter = '24', id_customer = '0', id_supplier = '17', id_address = '2612', 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 = '3', id_causal = '0', price_tax_included = '48.00', price_tax_excluded = '48.00', date_upd = NOW() WHERE id_document = '90279' 22/02/2024 03:11: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 = '90279' 22/02/2024 03:11:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '90279' 22/02/2024 03:11: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 ( '90279' , '22118' , 'PIEGHEVOLE LA MEDAGLIA MIRACOLOSA' , '120' , '120' , '4' , '0.8000' , '0.8' , '0' , '50' , '48.00' ) 22/02/2024 03:11:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22118' AND id_supplier = '17' 22/02/2024 03:11:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22118' , '17' , '1' ) 22/02/2024 03:13:04 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '116/24' , '2024-02-20' , '24' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '1665.00' , '1575.00' , NOW() , NOW() ) 22/02/2024 03:13:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90458' 22/02/2024 03:13:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '90458' 22/02/2024 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90458' , '22152' , 'A TE RICORRIAMO' , '2000' , '2000' , '3' , '0.525' , '0.50480769230769' , '4' , '0' , '1092.0000' ) 22/02/2024 03:13:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22152' AND id_supplier = '159' 22/02/2024 03:13:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22152' , '159' , '1' ) 22/02/2024 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90458' , '22151' , 'MA DIO LO HA RISUSCITATO' , '250' , '250' , '3' , '1.5' , '1.4423076923077' , '4' , '0' , '390.0000' ) 22/02/2024 03:13:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22151' AND id_supplier = '159' 22/02/2024 03:13:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22151' , '159' , '1' ) 22/02/2024 03:13:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90458' , '10133' , 'SPESE DI TRASPORTO' , '1' , '1' , '1' , '150' , '122.95081967213' , '22' , '0' , '183.0000' ) 22/02/2024 03:13:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '10133' AND id_supplier = '159' 22/02/2024 03:13:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10133' , '159' , '1' ) 22/02/2024 03:14:52 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '101/24' , '2024-02-16' , '24' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '2600.00' , '2500.00' , NOW() , NOW() ) 22/02/2024 03:14:52 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90459' 22/02/2024 03:14:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '90459' 22/02/2024 03:14:52 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90459' , '22153' , 'UNA VITA CONSUMATA NELL\'AMORE' , '3500' , '3500' , '3' , '0.714286' , '0.68681346153846' , '4' , '0' , '2600.0010' ) 22/02/2024 03:14:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22153' AND id_supplier = '159' 22/02/2024 03:14:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22153' , '159' , '1' ) 22/02/2024 03:17:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3/L' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 03:17:45 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 ( '23' , '3/L' , '2024-02-22' , 'L' , '3812' , '0' , '4678843' , 'LARGO PLEBISCITO 12 84121 SALERNO ' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '266.80' , '220.39' , NOW() , NOW() ) 22/02/2024 03:17:45 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 = '90460' 22/02/2024 03:17:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '90460' 22/02/2024 03:17:45 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 ( '90460' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.0000' , '1.9231' , '4' , '0' , '2.00' ) 22/02/2024 03:17:45 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 ( '90460' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '13.0000' , '10.6557' , '22' , '0' , '13.00' ) 22/02/2024 03:17:45 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 ( '90460' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9231' , '4' , '0' , '10.00' ) 22/02/2024 03:17:45 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 ( '90460' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.5902' , '22' , '0' , '30.00' ) 22/02/2024 03:17:45 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 ( '90460' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 22/02/2024 03:17:45 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 ( '90460' , '17161' , 'CARBONCINI NERI - CARNE' , '4' , '-4' , '1' , '12.0000' , '9.8361' , '22' , '0' , '48.00' ) 22/02/2024 03:17:45 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 ( '90460' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672' , '22' , '0' , '51.00' ) 22/02/2024 03:17:45 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 ( '90460' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8525' , '22' , '0' , '56.40' ) 22/02/2024 03:18:11 pm >> DELETE FROM ps_document WHERE id_document = '89900' 22/02/2024 03:18:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '89900' 22/02/2024 03:19:24 pm >> SELECT document_num FROM ps_document WHERE document_num = '3/L' AND id_document != '90460' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 03:19:24 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '3/L', document_date = '2024-02-22', document_letter = 'L', id_customer = '3812', id_supplier = '', id_address = '4678843', address1 = 'LARGO PLEBISCITO 12 84121 SALERNO ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '266.80', price_tax_excluded = '220.39', date_upd = NOW() WHERE id_document = '90460' 22/02/2024 03:19: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 = '90460' 22/02/2024 03:19:24 pm >> DELETE FROM ps_document_detail WHERE id_document = '90460' 22/02/2024 03:19: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 ( '90460' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 22/02/2024 03:19: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 ( '90460' , '1750' , 'CARTUCCIA TRASPARENTE DIAM. 3,2 - 454' , '1' , '-1' , '1' , '13.0000' , '10.655737704918' , '22' , '0' , '13.00' ) 22/02/2024 03:19: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 ( '90460' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 22/02/2024 03:19: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 ( '90460' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 22/02/2024 03:19: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 ( '90460' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/02/2024 03:19: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 ( '90460' , '17161' , 'CARBONCINI NERI - CARNE' , '4' , '-4' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '48.00' ) 22/02/2024 03:19: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 ( '90460' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 22/02/2024 03:19: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 ( '90460' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 22/02/2024 03:47:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '1/A' AND id_document != '89846' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-01-08') 22/02/2024 03:47:56 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '1/A', document_date = '2024-01-08', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 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 = '93.50', price_tax_excluded = '93.50', date_upd = NOW() WHERE id_document = '89846' 22/02/2024 03:47: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 = '89846' 22/02/2024 03:47:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '89846' 22/02/2024 03:47: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 ( '89846' , '22041' , 'SECONDO MARCO - P. RICCA' , '1' , '-1' , '4' , '25.0000' , '25' , '0' , '0' , '25.00' ) 22/02/2024 03:47: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 ( '89846' , '22107' , 'SIGNORE INSEGNACI A PREGARE - F. SHEEN' , '1' , '-1' , '4' , '16.0000' , '16' , '0' , '0' , '16.00' ) 22/02/2024 03:47: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 ( '89846' , '22108' , 'PERCHE CREDERE VOL.2 - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 22/02/2024 03:47: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 ( '89846' , '22068' , 'PAROLA E PREGHIERA - MAR 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/02/2024 03:47: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 ( '89846' , '22069' , 'PAROLA E PREGHIERA - APR 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/02/2024 03:47: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 ( '89846' , '22168' , 'AMEN - GIU. 2024' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/02/2024 03:47: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 ( '89846' , '22167' , 'AMEN - MAG. 2024' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 22/02/2024 03:47: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 ( '89846' , '22166' , 'PAROLA E PREGHIERA - MAG. 2024' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 22/02/2024 03:47: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 ( '89846' , '22169' , 'PIANTO DEL CRISTO - F. SHEEN' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 22/02/2024 04:36:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 04:36:16 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' , '531' , '2024-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '51.50' , '42.21' , NOW() , NOW() ) 22/02/2024 04:36:16 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 = '90461' 22/02/2024 04:36:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '90461' 22/02/2024 04:36:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90461' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '51.5' , '42.213114754098' , '22' , '0' , '51.50' ) 22/02/2024 04:47:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '47' AND id_document != '89825' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-01-05') 22/02/2024 04:47:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '47', document_date = '2024-01-05', 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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '89825' 22/02/2024 04:47:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89825' 22/02/2024 04:47:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89825' 22/02/2024 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89825' , '18220' , 'CATENA CON CROCE - NS020' , '5' , '-5' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '12.50' ) 22/02/2024 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89825' , '21101' , 'COLLANA CON ANGELO IN ACCIAIO - NS018' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 22/02/2024 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89825' , '20067' , 'CATENINA CON MED. SAN BENEDETTO - NS047' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 22/02/2024 04:47:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89825' , '1929' , 'CERCHIETTO CON FIORI LUSSO' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 22/02/2024 04:53:05 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '65' 22/02/2024 04:53:06 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '65' , '10' , '145' , '' , 'D\'ERRICO ' , 'GIUSEPPE' , 'VIA SAN MARCO 1' , '' , '81016' , 'CASTELLO DEL MATESE' , '' , '3891029585' , '' , '' , '' , NOW() , NOW() ) 22/02/2024 04:53:06 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '65' 22/02/2024 05:01:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '532' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 05:01: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' , '532' , '2024-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 22/02/2024 05:01: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 = '90462' 22/02/2024 05:01:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '90462' 22/02/2024 05:01: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 ( '90462' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 22/02/2024 05:03:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 05:03:26 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' , '533' , '2024-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.50' , '1.50' , NOW() , NOW() ) 22/02/2024 05:03: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 = '90463' 22/02/2024 05:03:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '90463' 22/02/2024 05:03: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 ( '90463' , '6962' , 'NELLA CASA DEL DEFUNTO' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 22/02/2024 05:23:22 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '65' 22/02/2024 05:23:22 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '65' , '10' , '145' , '' , 'D\'ERRICO ' , 'GIUSEPPE' , 'VIA SAN MARCO 1' , '' , '81016' , 'CASTELLO DEL MATESE' , '' , '3891029585' , '' , '' , '' , NOW() , NOW() ) 22/02/2024 05:23:22 pm >> UPDATE ps_customer SET email = 'giuseppederrico726@alice.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '65' 22/02/2024 05:49:30 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'rknq1i8PJcbkFRwG' , NOW() , NOW() ) 22/02/2024 05:49:30 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4088' , '1' ) 22/02/2024 05:49:30 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4088' , '2' ) 22/02/2024 05:49:30 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4088' , '3' ) 22/02/2024 06:15:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '9' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 06:15: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 ( '24' , '9' , '2024-02-22' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , 'RESA' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '9' , '233.30' , '233.30' , NOW() , NOW() ) 22/02/2024 06:15: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 = '90464' 22/02/2024 06:15:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '90464' 22/02/2024 06:15: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 ( '90464' , '21474' , 'QUESTA CASA E TUA PICCOLISSIMI - 3/5 ANNI' , '2' , '-2' , '4' , '16.50' , '16.5' , '0' , '0' , '33.00' ) 22/02/2024 06:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21474' AND id_supplier = '109' 22/02/2024 06:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21474' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '21471' , 'QUESTA CASA E TUA 2 - 9/11 ANNI' , '1' , '-1' , '4' , '16.50' , '16.5' , '0' , '0' , '16.50' ) 22/02/2024 06:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21471' AND id_supplier = '109' 22/02/2024 06:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21471' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '203' , 'ACCOMPAGNARE I MINISTRANTI' , '1' , '-1' , '4' , '6.90' , '6.9' , '0' , '0' , '6.90' ) 22/02/2024 06:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '203' AND id_supplier = '109' 22/02/2024 06:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '203' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '21771' , 'UNA VOCE CI GUIDA - 7/10 ANNI' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '0' , '4.00' ) 22/02/2024 06:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21771' AND id_supplier = '109' 22/02/2024 06:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21771' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '21912' , 'POETI ITALIANI' , '1' , '-1' , '4' , '19.00' , '19' , '0' , '0' , '19.00' ) 22/02/2024 06:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21912' AND id_supplier = '109' 22/02/2024 06:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21912' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '21472' , 'EFFETTO DOMINO - 15/18 ANNI' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 22/02/2024 06:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21472' AND id_supplier = '109' 22/02/2024 06:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21472' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '19836' , 'MISTERO MISTAGOGIA MISTICA - Y DE ANDIA' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '0' , '30.00' ) 22/02/2024 06:15:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19836' AND id_supplier = '109' 22/02/2024 06:15:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19836' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '19916' , 'VINO NUOVO IN OTRI NUOVI ANNO A - R. GIUE' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 22/02/2024 06:15:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19916' AND id_supplier = '109' 22/02/2024 06:15:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19916' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '21551' , 'PRIMA NASCITA E LA SECONDA - G. ANGELINI' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 22/02/2024 06:15:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21551' AND id_supplier = '109' 22/02/2024 06:15:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21551' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '19824' , 'DEMONOLOGIA E PRASSI ESORCISTICA - M. LANZA' , '1' , '-1' , '4' , '15.90' , '15.9' , '0' , '0' , '15.90' ) 22/02/2024 06:15:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19824' AND id_supplier = '109' 22/02/2024 06:15:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19824' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '19957' , 'ESERCIZI SPIRITUALI CON SAN PAOLO - B. SECONDIN' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 22/02/2024 06:15:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19957' AND id_supplier = '109' 22/02/2024 06:15:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19957' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '19451' , 'CHE COSA VUOI CHE IO FACCIA? - E. MANICARDI' , '1' , '-1' , '4' , '29.00' , '29' , '0' , '0' , '29.00' ) 22/02/2024 06:15:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19451' AND id_supplier = '109' 22/02/2024 06:15:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19451' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '21427' , 'WORK IN PROGRESS' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '0' , '7.00' ) 22/02/2024 06:15:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21427' AND id_supplier = '109' 22/02/2024 06:15:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21427' , '109' , '1' ) 22/02/2024 06:15: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 ( '90464' , '19200' , 'SANTI, INSIEME NELLAMORE - V. FORTINI' , '1' , '-1' , '4' , '13.00' , '13' , '0' , '0' , '13.00' ) 22/02/2024 06:15:13 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19200' AND id_supplier = '109' 22/02/2024 06:15:13 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19200' , '109' , '1' ) 22/02/2024 06:25:44 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'TM2X6FmSqoJ1MA5E' , NOW() , NOW() ) 22/02/2024 06:25:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4089' , '1' ) 22/02/2024 06:25:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4089' , '2' ) 22/02/2024 06:25:44 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4089' , '3' ) 22/02/2024 06:27:42 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4089' 22/02/2024 06:27:42 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '4089' , '10' , '160' , '' , 'SORRENTINO' , 'FABIO' , 'VIA G. DI BIASIO 214' , '' , '03043' , 'CASSINO' , '' , '' , '3286294797' , '' , '' , NOW() , NOW() ) 22/02/2024 06:27:42 pm >> UPDATE ps_customer SET email = 'fabio.sorrentino1976@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4089' 22/02/2024 06:28:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '38' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 06:28:26 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '38' , '2024-02-22' , '' , '4089' , '0' , '4679281' , 'VIA G. DI BIASIO 214 03043 CASSINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '97.90' , '97.90' , NOW() , NOW() ) 22/02/2024 06:28: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 = '90465' 22/02/2024 06:28:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '90465' 22/02/2024 06:28: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 ( '90465' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '20' , '-20' , '4' , '1.00' , '1' , '0' , '5' , '19.00' ) 22/02/2024 06:28: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 ( '90465' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '40' , '-40' , '4' , '2.00' , '2' , '0' , '5' , '76.00' ) 22/02/2024 06:28: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 ( '90465' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 22/02/2024 07:06:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '534' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 07:06:28 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' , '534' , '2024-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '38.00' , '31.15' , NOW() , NOW() ) 22/02/2024 07:06:28 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 = '90466' 22/02/2024 07:06:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '90466' 22/02/2024 07:06:28 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 ( '90466' , '18888' , 'SAN GIUSEPPE CM 31 - PB10150' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '0' , '38.00' ) 22/02/2024 07:22:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 07:22: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' , '535' , '2024-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '56.05' , '56.05' , NOW() , NOW() ) 22/02/2024 07:22: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 = '90467' 22/02/2024 07:22:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '90467' 22/02/2024 07:22: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 ( '90467' , '3528' , 'DIO VIVO E VERO - L. F. LADARIA' , '1' , '-1' , '4' , '59.00' , '59' , '0' , '5' , '56.05' ) 22/02/2024 07:25:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-22') 22/02/2024 07:25: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' , '536' , '2024-02-22' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '50.06' , NOW() , NOW() ) 22/02/2024 07:25: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 = '90468' 22/02/2024 07:25:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90468' 22/02/2024 07:25:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90468' , '20062' , 'BRACCIALE DECINA - BD018' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 22/02/2024 07:25:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90468' , '20072' , 'BRACCIALE - BC1759N' , '1' , '-1' , '1' , '2.00' , '1.6393442622951' , '22' , '0' , '2.00' ) 22/02/2024 07:25:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90468' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '6.20' , '5.0819672131148' , '22' , '0' , '6.20' ) 22/02/2024 07:25:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90468' , '2440' , 'COLORO IL MIO GESÙ' , '1' , '-1' , '4' , '4.90' , '4.9' , '0' , '0' , '4.90' ) 22/02/2024 07:25:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90468' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '44.9' , '36.803278688525' , '22' , '0' , '44.90' )