23/01/2025 09:43:51 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/01/2025 09:43:51 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23381' , '1' , '' , 'nuovo-prodotto' ) 23/01/2025 09:43:51 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '23381' , '1' , '1' , '2' , NOW() , NOW() ) 23/01/2025 09:43:51 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '23381' , '0' , '1' , '0' , '0' ) 23/01/2025 09:45:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8005D' AND id_product != '23381' AND ean13 != '' 23/01/2025 09:45:53 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8005D', date_upd = NOW() WHERE id_product = '23381' 23/01/2025 09:45:53 am >> UPDATE ps_product_lang SET name = 'STOLA DIACONALE MARIANA - 8005D', description = '' WHERE id_product = '23381' 23/01/2025 09:45:53 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '172.13114754098362' WHERE id_product = '23381' 23/01/2025 09:45:53 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '172.13114754098362', id_tax_rules_group = '1', id_category_default = '448', 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 = '23381' 23/01/2025 09:45:53 am >> DELETE FROM ps_specific_price WHERE id_product = '23381' 23/01/2025 09:45:54 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 = '23381' 23/01/2025 09:45:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '23382' , '1' , '' , 'nuovo-prodotto' ) 23/01/2025 09:45:54 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 '23382' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '23381' 23/01/2025 09:45:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '23382' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '23381' 23/01/2025 09:47:52 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001495' AND id_product != '16961' AND ean13 != '' 23/01/2025 09:47:52 am >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '001495', date_upd = NOW() WHERE id_product = '16961' 23/01/2025 09:47:52 am >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA - 5838/4', description = '' WHERE id_product = '16961' 23/01/2025 09:47:52 am >> UPDATE ps_product SET wholesale_price = '50.00', on_sale = '0', price = '102.45901639344262' WHERE id_product = '16961' 23/01/2025 09:47:52 am >> UPDATE ps_product_shop SET wholesale_price = '50.00', price = '102.45901639344262', id_tax_rules_group = '1', id_category_default = '448', 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 = '16961' 23/01/2025 09:47:52 am >> DELETE FROM ps_specific_price WHERE id_product = '16961' 23/01/2025 09:51: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 ( '33' , '7/2025' , '2025-01-21' , '2025' , '0' , '126' , '4669995' , 'VIA DELLE INDUSTRIE, 75 06083 BASTIA UMBRA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '536.80' , '440.00' , NOW() , NOW() ) 23/01/2025 09:51: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 = '95398' 23/01/2025 09:51:41 am >> DELETE FROM ps_document_detail WHERE id_document = '95398' 23/01/2025 09:51: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 ( '95398' , '16961' , 'SERVIZIO MESSA - 5838/4' , '2' , '2' , '1' , '50' , '40.983606557377' , '22' , '0' , '122.0000' ) 23/01/2025 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16961' AND id_supplier = '126' 23/01/2025 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16961' , '126' , '1' ) 23/01/2025 09:51: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 ( '95398' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '2' , '2' , '1' , '25' , '20.491803278689' , '22' , '0' , '61.0000' ) 23/01/2025 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '16958' AND id_supplier = '126' 23/01/2025 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16958' , '126' , '1' ) 23/01/2025 09:51: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 ( '95398' , '18239' , 'SERVIZIO MESSA - MARIANO M/L - 7051' , '2' , '2' , '1' , '25' , '20.491803278689' , '22' , '0' , '61.0000' ) 23/01/2025 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18239' AND id_supplier = '126' 23/01/2025 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18239' , '126' , '1' ) 23/01/2025 09:51: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 ( '95398' , '21420' , 'STOLA IN RASO IHS - 7871' , '1' , '1' , '1' , '75' , '61.475409836066' , '22' , '0' , '91.5000' ) 23/01/2025 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '21420' AND id_supplier = '126' 23/01/2025 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21420' , '126' , '1' ) 23/01/2025 09:51: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 ( '95398' , '18184' , 'STOLA RASO CON RICAMO UVA - 7877' , '1' , '1' , '1' , '75' , '61.475409836066' , '22' , '0' , '91.5000' ) 23/01/2025 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '18184' AND id_supplier = '126' 23/01/2025 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18184' , '126' , '1' ) 23/01/2025 09:51: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 ( '95398' , '23381' , 'STOLA DIACONALE MARIANA - 8005D' , '1' , '1' , '1' , '90' , '73.770491803279' , '22' , '0' , '109.8000' ) 23/01/2025 09:51:41 am >> DELETE FROM ps_product_supplier WHERE id_product = '23381' AND id_supplier = '126' 23/01/2025 09:51:41 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23381' , '126' , '1' ) 23/01/2025 09:57:52 am >> SELECT document_num FROM ps_document WHERE document_num = '200' AND id_document != '95358' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-20') 23/01/2025 09:57:52 am >> UPDATE ps_document SET id_document_type = '11', document_num = '200', document_date = '2025-01-20', 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 = '420.00', price_tax_excluded = '362.00', date_upd = NOW() WHERE id_document = '95358' 23/01/2025 09:57:52 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 = '95358' 23/01/2025 09:57:53 am >> DELETE FROM ps_document_detail WHERE id_document = '95358' 23/01/2025 09:57:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '30' , '-30' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '105.00' ) 23/01/2025 09:57:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '7311' , 'OSTIA SOTTILE 74MM' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 23/01/2025 09:57:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 23/01/2025 09:57:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 23/01/2025 09:57:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '1626' , 'CANDELE VOTIVE KG 10 - 13X26 - CIRCA 300 PZ' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 23/01/2025 09:57:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 23/01/2025 09:57:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95358' , '1425' , 'BUSTA 100 FLAMBEAUX IN CARTA - FLAM' , '3' , '-3' , '1' , '9.2000' , '7.5409836065574' , '22' , '0' , '27.60' ) 23/01/2025 09:58:16 am >> SELECT document_num FROM ps_document WHERE document_num = '4016' AND id_document != '94950' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-19') 23/01/2025 09:58:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4016', document_date = '2024-12-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '40.00', price_tax_excluded = '32.79', date_upd = NOW() WHERE id_document = '94950' 23/01/2025 09:58:16 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 = '94950' 23/01/2025 09:58:16 am >> DELETE FROM ps_document_detail WHERE id_document = '94950' 23/01/2025 09:58:16 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 ( '94950' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 23/01/2025 09:58:16 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 ( '94950' , '16333' , 'NATIVITA ALBERO VETRO CM 16' , '1' , '-1' , '1' , '5.0000' , '4.0983606557377' , '22' , '0' , '5.00' ) 23/01/2025 09:58:46 am >> SELECT document_num FROM ps_document WHERE document_num = '4149' AND id_document != '95108' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-30') 23/01/2025 09:58:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4149', document_date = '2024-12-30', 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 = '17.50', price_tax_excluded = '14.34', date_upd = NOW() WHERE id_document = '95108' 23/01/2025 09:58:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95108' 23/01/2025 09:58:46 am >> DELETE FROM ps_document_detail WHERE id_document = '95108' 23/01/2025 09:58:46 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95108' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 23/01/2025 09:59:03 am >> SELECT document_num FROM ps_document WHERE document_num = '4116' AND id_document != '95069' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-12-28') 23/01/2025 09:59:03 am >> UPDATE ps_document SET id_document_type = '11', document_num = '4116', document_date = '2024-12-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 = '26.00', price_tax_excluded = '21.31', date_upd = NOW() WHERE id_document = '95069' 23/01/2025 09:59:03 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 = '95069' 23/01/2025 09:59:03 am >> DELETE FROM ps_document_detail WHERE id_document = '95069' 23/01/2025 09:59:03 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 ( '95069' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 23/01/2025 09:59:03 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 ( '95069' , '1912' , 'CERA DELL\'EREMO - 415/B ' , '2' , '-2' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '12.00' ) 23/01/2025 09:59:16 am >> SELECT document_num FROM ps_document WHERE document_num = '116' AND id_document != '95246' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-11') 23/01/2025 09:59:16 am >> UPDATE ps_document SET id_document_type = '11', document_num = '116', document_date = '2025-01-11', 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 = '3.50', price_tax_excluded = '2.87', date_upd = NOW() WHERE id_document = '95246' 23/01/2025 09:59:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95246' 23/01/2025 09:59:17 am >> DELETE FROM ps_document_detail WHERE id_document = '95246' 23/01/2025 09:59:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95246' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '3.50' ) 23/01/2025 10:40:35 am >> SELECT ean13 FROM ps_product WHERE ean13 = '8005788038506' AND id_product != '10475' AND ean13 != '' 23/01/2025 10:40:35 am >> UPDATE ps_product SET id_supplier = '36', reference = '', ean13 = '8005788038506', date_upd = NOW() WHERE id_product = '10475' 23/01/2025 10:40:35 am >> UPDATE ps_product_lang SET name = 'TEALIGHTS X 50 ', description = '' WHERE id_product = '10475' 23/01/2025 10:40:35 am >> UPDATE ps_product SET wholesale_price = '1.41', on_sale = '0', price = '4.0163934426229515' WHERE id_product = '10475' 23/01/2025 10:40:35 am >> UPDATE ps_product_shop SET wholesale_price = '1.41', price = '4.0163934426229515', id_tax_rules_group = '1', id_category_default = '205', 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 = '10475' 23/01/2025 10:40:35 am >> DELETE FROM ps_specific_price WHERE id_product = '10475' 23/01/2025 10:40:52 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' , '79' , '2025-01-21' , '' , '0' , '36' , '2631' , 'VIA FRIZZONI,56 24048 TREVIOLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '6972.72' , '5715.35' , NOW() , NOW() ) 23/01/2025 10:40:52 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 = '95399' 23/01/2025 10:40:52 am >> DELETE FROM ps_document_detail WHERE id_document = '95399' 23/01/2025 10:40:52 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 ( '95399' , '1914' , 'CERA DELLA LITURGIA' , '1080' , '1080' , '1' , '2.2' , '1.8032786885246' , '22' , '3' , '2811.7584' ) 23/01/2025 10:40:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '36' 23/01/2025 10:40:52 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '36' , '1' ) 23/01/2025 10:40:52 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 ( '95399' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1440' , '1440' , '1' , '1.59' , '1.3032786885246' , '22' , '3' , '2709.5126' ) 23/01/2025 10:40:52 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '36' 23/01/2025 10:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '36' , '1' ) 23/01/2025 10:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '16796' , 'LUMINO 5B BIANCO' , '8064' , '8064' , '1' , '0.1' , '0.081967213114754' , '22' , '3' , '954.2938' ) 23/01/2025 10:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '16796' AND id_supplier = '36' 23/01/2025 10:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16796' , '36' , '1' ) 23/01/2025 10:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '6809' , 'MOCCOLO 60X165' , '32' , '32' , '1' , '1.92' , '1.5737704918033' , '22' , '3' , '72.7081' ) 23/01/2025 10:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '6809' AND id_supplier = '36' 23/01/2025 10:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6809' , '36' , '1' ) 23/01/2025 10:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '6810' , 'MOCCOLO 80X150' , '24' , '24' , '1' , '2.98' , '2.4426229508197' , '22' , '3' , '84.6368' ) 23/01/2025 10:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '6810' AND id_supplier = '36' 23/01/2025 10:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6810' , '36' , '1' ) 23/01/2025 10:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '21137' , 'MOCCOLO 70X200' , '32' , '32' , '1' , '2.98' , '2.4426229508197' , '22' , '3' , '112.8490' ) 23/01/2025 10:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '21137' AND id_supplier = '36' 23/01/2025 10:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21137' , '36' , '1' ) 23/01/2025 10:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '20029' , 'MOCCOLO 80X200' , '27' , '27' , '1' , '3.77' , '3.0901639344262' , '22' , '3' , '120.4583' ) 23/01/2025 10:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '20029' AND id_supplier = '36' 23/01/2025 10:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20029' , '36' , '1' ) 23/01/2025 10:40:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95399' , '10475' , 'TEALIGHTS X 50 ' , '36' , '36' , '1' , '2.5' , '2.0491803278689' , '22' , '3' , '106.5060' ) 23/01/2025 10:40:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '10475' AND id_supplier = '36' 23/01/2025 10:40:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10475' , '36' , '1' ) 23/01/2025 10:54:56 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' , '687511' , '2025-01-21' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '16' , '4' , '0' , '0' , '0' , '' , '12' , '0' , '525.20' , '525.20' , NOW() , NOW() ) 23/01/2025 10:54:56 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 = '95400' 23/01/2025 10:54:56 am >> DELETE FROM ps_document_detail WHERE id_document = '95400' 23/01/2025 10:54:56 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 ( '95400' , '23131' , 'TEMPO DEL PERDONO - F. CRISTOFARO' , '50' , '50' , '4' , '16.00' , '16' , '0' , '33+5' , '509.2000' ) 23/01/2025 10:54:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '23131' AND id_supplier = '7' 23/01/2025 10:54:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23131' , '7' , '1' ) 23/01/2025 10:57:15 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '687512' , '2025-01-21' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '1.61' , '4' , '0' , '0' , '0' , '' , '11' , '0' , '63.44' , '59.52' , NOW() , NOW() ) 23/01/2025 10:57:15 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95401' 23/01/2025 10:57:15 am >> DELETE FROM ps_document_detail WHERE id_document = '95401' 23/01/2025 10:57:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95401' , '23088' , 'CAMPANA DEL GIUBILEO' , '2' , '2' , '1' , '8.9' , '7.2950819672131' , '22' , '0' , '21.7160' ) 23/01/2025 10:57:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '23088' AND id_supplier = '7' 23/01/2025 10:57:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23088' , '7' , '1' ) 23/01/2025 10:57:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95401' , '23061' , 'PELLEGRINO IN CORSIA - G. MANGERI' , '1' , '1' , '4' , '14.00' , '14' , '0' , '33' , '9.3800' ) 23/01/2025 10:57:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '23061' AND id_supplier = '7' 23/01/2025 10:57:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23061' , '7' , '1' ) 23/01/2025 10:57:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95401' , '10430' , 'TABOR' , '1' , '1' , '4' , '17.90' , '17.9' , '0' , '30' , '12.5300' ) 23/01/2025 10:57:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '10430' AND id_supplier = '7' 23/01/2025 10:57:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '10430' , '7' , '1' ) 23/01/2025 10:57:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95401' , '23028' , 'SU E GIU SULLE SCALE PAZZE - GIOCO' , '1' , '1' , '4' , '22.00' , '22' , '0' , '30' , '15.4000' ) 23/01/2025 10:57:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '23028' AND id_supplier = '7' 23/01/2025 10:57:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23028' , '7' , '1' ) 23/01/2025 10:57:15 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95401' , '23265' , 'ROSARIO E NOVENA A MARIA CHE SCIOGLIE I NODI ' , '1' , '1' , '4' , '4.00' , '4' , '0' , '30' , '2.8000' ) 23/01/2025 10:57:15 am >> DELETE FROM ps_product_supplier WHERE id_product = '23265' AND id_supplier = '7' 23/01/2025 10:57:15 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '23265' , '7' , '1' ) 23/01/2025 11:24:28 am >> SELECT document_num FROM ps_document WHERE document_num = '10/A' AND id_document != '94115' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 23/01/2025 11:24:28 am >> UPDATE ps_document SET id_document_type = '24', document_num = '10/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '1213', id_supplier = '', id_address = '4679403', address1 = 'VIA CONVENTO 83025 MONTORO', address2 = '', note = 'DDT 119/A DEL 07/11/2024', 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 = '748.00', price_tax_excluded = '613.11', date_upd = NOW() WHERE id_document = '94115' 23/01/2025 11:24:28 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 = '94115' 23/01/2025 11:24:28 am >> DELETE FROM ps_document_detail WHERE id_document = '94115' 23/01/2025 11:24:28 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 ( '94115' , '20263' , 'PIZZO IHS UVA - PIZ0M420' , '4' , '-4' , '1' , '100.0000' , '81.967213114754' , '22' , '0' , '400.00' ) 23/01/2025 11:24:28 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 ( '94115' , '22739' , 'CASULA RIGHE - 65/002024CRO' , '1' , '-1' , '1' , '348.00' , '285.24590163934' , '22' , '0' , '348.00' ) 23/01/2025 11:25:49 am >> SELECT document_num FROM ps_document WHERE document_num = '234' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-23') 23/01/2025 11:25: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' , '234' , '2025-01-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '43.00' , '35.25' , NOW() , NOW() ) 23/01/2025 11:25: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 = '95402' 23/01/2025 11:25:49 am >> DELETE FROM ps_document_detail WHERE id_document = '95402' 23/01/2025 11:25: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 ( '95402' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 23/01/2025 11:25: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 ( '95402' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '1' , '-1' , '1' , '13.00' , '10.655737704918' , '22' , '0' , '13.00' ) 23/01/2025 11:30:59 am >> SELECT document_num FROM ps_document WHERE document_num = '235' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-23') 23/01/2025 11:30:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '235' , '2025-01-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '800.00' , '655.74' , NOW() , NOW() ) 23/01/2025 11:30:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '95403' 23/01/2025 11:30:59 am >> DELETE FROM ps_document_detail WHERE id_document = '95403' 23/01/2025 11:30:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95403' , '20955' , 'CASULA LANA RICAMO ORNATO IHS - 6847L' , '1' , '-1' , '1' , '800' , '655.73770491803' , '22' , '0' , '800.00' ) 23/01/2025 11:31:16 am >> SELECT document_num FROM ps_document WHERE document_num = '236' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-23') 23/01/2025 11:31:16 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' , '236' , '2025-01-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '350.00' , '286.89' , NOW() , NOW() ) 23/01/2025 11:31:16 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 = '95404' 23/01/2025 11:31:16 am >> DELETE FROM ps_document_detail WHERE id_document = '95404' 23/01/2025 11:31:16 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 ( '95404' , '22777' , 'CASULA - C2P712' , '1' , '-1' , '1' , '350' , '286.88524590164' , '22' , '0' , '350.00' ) 23/01/2025 11:56:20 am >> SELECT document_num FROM ps_document WHERE document_num = '237' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-23') 23/01/2025 11:56:20 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' , '237' , '2025-01-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '227.72' , '221.59' , NOW() , NOW() ) 23/01/2025 11:56:20 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 = '95405' 23/01/2025 11:56:20 am >> DELETE FROM ps_document_detail WHERE id_document = '95405' 23/01/2025 11:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95405' , '3256' , 'CUSTODIA LEZIONARIO ECON. DIPINTA - OGGETTI' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 23/01/2025 11:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95405' , '22854' , 'MESSALE FESTIVO 2025' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 23/01/2025 11:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95405' , '21655' , 'BENEDIZIONALE N. E. ' , '1' , '-1' , '4' , '40.00' , '40' , '0' , '5' , '38.00' ) 23/01/2025 11:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95405' , '17413' , 'PREGHIERE DEI FEDELI - T. O. ANNO PARI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 23/01/2025 11:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95405' , '16205' , 'PREGHIERE DEI FEDELI - TEMPO ORDINARIO ANNO II' , '1' , '-1' , '4' , '19.50' , '19.5' , '0' , '5' , '18.53' ) 23/01/2025 11:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95405' , '5763' , 'LEZIONARIO FERIALE ANNO DISPARI - TEMPO ORDINARIO' , '1' , '-1' , '4' , '60.00' , '60' , '0' , '5' , '57.00' ) 23/01/2025 11:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95405' , '23196' , 'DILEXIT NOS' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 23/01/2025 11:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95405' , '23313' , 'LITURGIA PENITENZIALE COMUNITARIA' , '1' , '-1' , '4' , '9.50' , '9.5' , '0' , '5' , '9.03' ) 23/01/2025 11:56:20 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95405' , '23256' , 'CELEBRIAMO MARIA - MESSALE MARIANO' , '1' , '-1' , '4' , '42.00' , '42' , '0' , '5' , '39.90' ) 23/01/2025 12:35:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '91/A' AND id_document != '87349' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-19') 23/01/2025 12:35:12 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '91/A', document_date = '2023-09-19', document_letter = 'A', id_customer = '3892', id_supplier = '', id_address = '4679228', address1 = 'OGLIARA 84100 OGLIARA', address2 = '', note = 'ACCONTO € 220, 00 - € 150+ €240+100', 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 = '3800.00', price_tax_excluded = '3114.75', date_upd = NOW() WHERE id_document = '87349' 23/01/2025 12:35: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 = '87349' 23/01/2025 12:35:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '87349' 23/01/2025 12:35: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 ( '87349' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '0' , '1' , '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 23/01/2025 12:35: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 ( '87349' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '0' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 23/01/2025 12:35: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 ( '87349' , '0' , 'PALLA MARIANA - 50/372' , '1' , '0' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 23/01/2025 12:35: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 ( '87349' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '0' , '1' , '305.0000' , '250' , '22' , '0' , '305.00' ) 23/01/2025 12:35: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 ( '87349' , '8166' , 'PORTACALICE - 18X35 - 726' , '1' , '0' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 23/01/2025 12:35: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 ( '87349' , '0' , 'PISSIDE 099PA' , '1' , '0' , '1' , '1600.0000' , '1311.4754098361' , '22' , '0' , '1600.00' ) 23/01/2025 12:35: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 ( '87349' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' , '0' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 23/01/2025 12:38:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '91/A' AND id_document != '87349' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-09-19') 23/01/2025 12:38:35 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '91/A', document_date = '2023-09-19', document_letter = 'A', id_customer = '3892', id_supplier = '', id_address = '4679228', address1 = 'OGLIARA 84100 OGLIARA', address2 = '', note = 'ACCONTO € 220, 00 - € 150+ €240+ € 100,00', 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 = '3800.00', price_tax_excluded = '3114.75', date_upd = NOW() WHERE id_document = '87349' 23/01/2025 12:38:35 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '87349' 23/01/2025 12:38:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '87349' 23/01/2025 12:38:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '20852' , 'CALICE OTTONE IN FUSIONE ARGENTATA - 099A' , '1' , '0' , '1' , '1495.0000' , '1225.4098360656' , '22' , '0' , '1495.00' ) 23/01/2025 12:38:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '19848' , 'PATENA CON GRECA CM 19 - 999/7 A' , '1' , '0' , '1' , '110.0000' , '90.16393442623' , '22' , '0' , '110.00' ) 23/01/2025 12:38:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '0' , 'PALLA MARIANA - 50/372' , '1' , '0' , '1' , '250.0000' , '204.91803278689' , '22' , '0' , '250.00' ) 23/01/2025 12:38:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '19709' , 'COMPLETO MESSA LINO - 30/108' , '1' , '0' , '1' , '305.0000' , '250' , '22' , '0' , '305.00' ) 23/01/2025 12:38:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '8166' , 'PORTACALICE - 18X35 - 726' , '1' , '0' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 23/01/2025 12:38:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '0' , 'PISSIDE 099PA' , '1' , '0' , '1' , '1600.0000' , '1311.4754098361' , '22' , '0' , '1600.00' ) 23/01/2025 12:38:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '87349' , '18349' , 'PORTACALICE - 18X28 - 720' , '1' , '0' , '1' , '20.0000' , '16.393442622951' , '22' , '0' , '20.00' ) 23/01/2025 12:39:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '13/A' AND id_document != '94912' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 23/01/2025 12:39:10 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '13/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2739', id_supplier = '', id_address = '4671014', address1 = 'VIA F. WENNER, 37 84080 PELLEZZANO', address2 = '', note = '**** già scaricati', 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 = '268.10', price_tax_excluded = '228.29', date_upd = NOW() WHERE id_document = '94912' 23/01/2025 12:39: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 = '94912' 23/01/2025 12:39:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '94912' 23/01/2025 12:39: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 ( '94912' , '22907' , 'AGENDINA 2025 - 40827' , '2' , '-2' , '1' , '7.0000' , '5.7377049180328' , '22' , '0' , '14.00' ) 23/01/2025 12:39: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 ( '94912' , '20156' , 'PALLA E STELLE CON CARTONCINO - 23' , '60' , '-60' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '120.00' ) 23/01/2025 12:39: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 ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 23/01/2025 12:39: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 ( '94912' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '7.90' ) 23/01/2025 12:39: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 ( '94912' , '23104' , 'SULLA TUA PAROLA - GEN/FEB 25' , '4' , '-4' , '4' , '5.0000' , '5' , '0' , '0' , '20.00' ) 23/01/2025 12:39: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 ( '94912' , '23169' , 'DILEXIT NOS ****' , '1' , '-1' , '4' , '2.2000' , '2.2' , '0' , '0' , '2.20' ) 23/01/2025 12:39: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 ( '94912' , '23341' , 'SPERA - PAPA FRANCESCO' , '1' , '-1' , '4' , '22.0000' , '22' , '0' , '0' , '22.00' ) 23/01/2025 12:39: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 ( '94912' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 23/01/2025 12:39: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 ( '94912' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '2' , '-2' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '78.00' ) 23/01/2025 02:38:40 pm >> UPDATE ps_document SET id_document_type = '31', document_num = 'G88', document_date = '2025-01-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '2626', address1 = 'ZONA IND.LE PIAN DI LAURA 56043 LORENZANA', address2 = '', note = '€ 270,00 da recuperare', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '1040.40', price_tax_excluded = '852.79', date_upd = NOW() WHERE id_document = '95323' 23/01/2025 02:38: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 = '95323' 23/01/2025 02:38:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '95323' 23/01/2025 02:38: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 ( '95323' , '15387' , 'VESTINA BATTESIMALE ' , '640' , '640' , '1' , '1.0300' , '0.84426229508197' , '22' , '3' , '780.10' ) 23/01/2025 02:38: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 ( '95323' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '20' , '20' , '1' , '3.7600' , '3.0819672131148' , '22' , '50+3' , '44.50' ) 23/01/2025 02:38: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 ( '95323' , '1375' , 'BRUCIAINCENSI LEGNO - BRUL' , '8' , '8' , '1' , '9.0500' , '7.4180327868852' , '22' , '50+3' , '42.84' ) 23/01/2025 02:38: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 ( '95323' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '200' , '200' , '1' , '1.4600' , '1.1967213114754' , '22' , '50+3' , '172.78' ) 23/01/2025 02:38: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 ( '95323' , '0' , 'ARROTONDAMENTO' , '1' , '1' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '0.18' ) 23/01/2025 03:43:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '11/A' AND id_document != '94256' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2025-01-02') 23/01/2025 03:43:23 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '11/A', document_date = '2025-01-02', document_letter = 'A', id_customer = '2332', id_supplier = '', id_address = '4679092', address1 = 'P.ZZA S. ROCCO 84088 SIANO', address2 = '', note = 'DDT 124/A DEL 14/11/2024 - acconto 05/12 € 260,00', 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 = '828.32', price_tax_excluded = '797.38', date_upd = NOW() WHERE id_document = '94256' 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '94256' 23/01/2025 03:43:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '94256' 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '2679' , 'CONOSCERE GESU\'' , '20' , '-20' , '4' , '3.5000' , '3.5' , '0' , '15' , '59.50' ) 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '30' , '-30' , '4' , '3.4000' , '3.4' , '0' , '15' , '86.70' ) 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4394' , 'GESÙ CI CHIAMA 1 - SCHEDE' , '48' , '-48' , '4' , '3.8000' , '3.8' , '0' , '15' , '155.04' ) 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4397' , 'GESÙ CI RIVELA IL PADRE 2 - SCHEDE' , '51' , '-51' , '4' , '3.8000' , '3.8' , '0' , '15' , '164.73' ) 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '25' , '-25' , '4' , '3.8000' , '3.8' , '0' , '15' , '80.75' ) 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '0' , 'natività campana ' , '1' , '-1' , '4' , '110.0000' , '110' , '0' , '0' , '110.00' ) 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '19071' , 'BAMBINELLO CM 32 - PB9941' , '1' , '-1' , '1' , '60.0000' , '49.180327868852' , '22' , '0' , '60.00' ) 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '6811' , 'MOCCOLO 80X200' , '4' , '-4' , '1' , '9.0000' , '7.3770491803279' , '22' , '0' , '36.00' ) 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '22354' , 'CROCE SACRAMENTI VARI - 646' , '30' , '-30' , '1' , '1.8000' , '1.4754098360656' , '22' , '0' , '54.00' ) 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '7.20' ) 23/01/2025 03:43:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '94256' , '17617' , 'IMMAGINI ISONZO X 100' , '4' , '-4' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '14.40' ) 23/01/2025 04:02:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '238' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-23') 23/01/2025 04:02: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' , '238' , '2025-01-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '13.46' , NOW() , NOW() ) 23/01/2025 04:02: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 = '95406' 23/01/2025 04:02:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '95406' 23/01/2025 04:02: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 ( '95406' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 23/01/2025 07:27:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '239' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2025-01-23') 23/01/2025 07:27:50 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' , '239' , '2025-01-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.00' , '171.00' , NOW() , NOW() ) 23/01/2025 07:27:50 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 = '95407' 23/01/2025 07:27:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '95407' 23/01/2025 07:27:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '95407' , '18703' , 'IN_SEGUENDO GESU A CAFARNAO' , '36' , '-36' , '4' , '5.00' , '5' , '0' , '5' , '171.00' ) 23/01/2025 09:26:50 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'MA2YIPBhmkz87sM0' , NOW() , NOW() ) 23/01/2025 09:26:51 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4157' , '1' ) 23/01/2025 09:26:51 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4157' , '2' ) 23/01/2025 09:26:51 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4157' , '3' )