21/06/2023 09:09:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2128' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 09:09:35 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' , '2128' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '131.15' , NOW() , NOW() ) 21/06/2023 09:09:35 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 = '86436' 21/06/2023 09:09:35 am >> DELETE FROM ps_document_detail WHERE id_document = '86436' 21/06/2023 09:09:35 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86436' , '18184' , 'STOLA RASO CON RICAMO UVA - 7877' , '1' , '-1' , '1' , '160' , '131.14754098361' , '22' , '0' , '160.00' ) 21/06/2023 09:46:42 am >> SELECT document_num FROM ps_document WHERE document_num = '2129' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 09:46:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2129' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '41.48' , NOW() , NOW() ) 21/06/2023 09:46:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86437' 21/06/2023 09:46:42 am >> DELETE FROM ps_document_detail WHERE id_document = '86437' 21/06/2023 09:46:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86437' , '1936' , 'CERETTI DIAM 26X700 ART. 400' , '10' , '-10' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '35.00' ) 21/06/2023 09:46:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86437' , '10184' , 'SS. PIETRO E PAOLO - 83' , '2' , '-2' , '1' , '3.75' , '3.0737704918033' , '22' , '0' , '7.50' ) 21/06/2023 09:46:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86437' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '1' , '-1' , '3' , '3.5' , '3.3653846153846' , '4' , '0' , '3.50' ) 21/06/2023 09:46:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86437' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '2' , '1.6393442622951' , '22' , '0' , '4.00' ) 21/06/2023 09:50:10 am >> DELETE FROM ps_product WHERE id_product = '2399' 21/06/2023 09:50:10 am >> DELETE FROM ps_product_shop WHERE id_product = '2399' 21/06/2023 09:50:11 am >> DELETE FROM ps_product_lang WHERE id_product = '2399' 21/06/2023 09:50:11 am >> DELETE FROM ps_stock_available WHERE id_product = '2399' 21/06/2023 09:50:26 am >> DELETE FROM ps_product WHERE id_product = '11838' 21/06/2023 09:50:26 am >> DELETE FROM ps_product_shop WHERE id_product = '11838' 21/06/2023 09:50:26 am >> DELETE FROM ps_product_lang WHERE id_product = '11838' 21/06/2023 09:50:26 am >> DELETE FROM ps_stock_available WHERE id_product = '11838' 21/06/2023 09:50:30 am >> DELETE FROM ps_product WHERE id_product = '9755' 21/06/2023 09:50:30 am >> DELETE FROM ps_product_shop WHERE id_product = '9755' 21/06/2023 09:50:30 am >> DELETE FROM ps_product_lang WHERE id_product = '9755' 21/06/2023 09:50:30 am >> DELETE FROM ps_stock_available WHERE id_product = '9755' 21/06/2023 09:50:55 am >> DELETE FROM ps_product WHERE id_product = '10761' 21/06/2023 09:50:55 am >> DELETE FROM ps_product_shop WHERE id_product = '10761' 21/06/2023 09:50:55 am >> DELETE FROM ps_product_lang WHERE id_product = '10761' 21/06/2023 09:50:55 am >> DELETE FROM ps_stock_available WHERE id_product = '10761' 21/06/2023 10:37:06 am >> SELECT document_num FROM ps_document WHERE document_num = '2130' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 10:37:06 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' , '2130' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.88' , '19.44' , NOW() , NOW() ) 21/06/2023 10:37:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86438' 21/06/2023 10:37:06 am >> DELETE FROM ps_document_detail WHERE id_document = '86438' 21/06/2023 10:37:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86438' , '13504' , 'SACRAMENTO DELLA RICONCILIAZIONE RAGAZZI' , '10' , '-10' , '1' , '0.30' , '0.24590163934426' , '22' , '0' , '3.00' ) 21/06/2023 10:37:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86438' , '13505' , 'CELEBRIAMO IL SACRAMENTO DEL PERDONO' , '10' , '-10' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '5.00' ) 21/06/2023 10:37:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86438' , '8400' , 'PREGO CON I SALMI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '5' , '1.43' ) 21/06/2023 10:37:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86438' , '15020' , 'PREGARE OGNI GIORNO' , '3' , '-3' , '4' , '1.00' , '1' , '0' , '5' , '2.85' ) 21/06/2023 10:37:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86438' , '6629' , 'MIA PREGHIERA' , '10' , '-10' , '4' , '0.90' , '0.9' , '0' , '5' , '8.60' ) 21/06/2023 10:40:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2131' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 10:40: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' , '2131' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '750.00' , '614.75' , NOW() , NOW() ) 21/06/2023 10:40: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 = '86439' 21/06/2023 10:40:14 am >> DELETE FROM ps_document_detail WHERE id_document = '86439' 21/06/2023 10:40: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 ( '86439' , '16040' , 'STOLA ROMANA S/MOIRE - 7336S' , '1' , '-1' , '1' , '375' , '307.37704918033' , '22' , '0' , '375.00' ) 21/06/2023 10:40: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 ( '86439' , '18560' , 'STOLA ROMANA S/MOIRE - 7289S' , '1' , '-1' , '1' , '375' , '307.37704918033' , '22' , '0' , '375.00' ) 21/06/2023 10:41:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2132' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 10:41:24 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' , '2132' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.40' , '61.06' , NOW() , NOW() ) 21/06/2023 10:41:24 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 = '86440' 21/06/2023 10:41:24 am >> DELETE FROM ps_document_detail WHERE id_document = '86440' 21/06/2023 10:41:24 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 ( '86440' , '20110' , 'BRACE LEGNA SOFFIO - DOTTI/ALDEGANI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 21/06/2023 10:41:24 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 ( '86440' , '2336' , 'CLERGY GRIGIO MM - MISTO 44 ' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '15' , '31.45' ) 21/06/2023 10:41:24 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 ( '86440' , '2296' , 'CLERGY GRIGIO CHIARO MM - MISTO 44' , '1' , '-1' , '1' , '37' , '30.327868852459' , '22' , '15' , '31.45' ) 21/06/2023 10:42:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2133' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 10:42:27 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' , '2133' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 21/06/2023 10:42:27 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 = '86441' 21/06/2023 10:42:27 am >> DELETE FROM ps_document_detail WHERE id_document = '86441' 21/06/2023 10:42:27 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 ( '86441' , '14362' , 'CAMICE SVASATO - 434/TPA' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 21/06/2023 10:42:27 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 ( '86441' , '8082' , 'POLO LIMITED ' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 21/06/2023 10:47:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2134' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 10:47:21 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' , '2134' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '79.90' , '68.83' , NOW() , NOW() ) 21/06/2023 10:47:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86442' 21/06/2023 10:47:21 am >> DELETE FROM ps_document_detail WHERE id_document = '86442' 21/06/2023 10:47:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86442' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 21/06/2023 10:47:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86442' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 21/06/2023 10:47:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86442' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 21/06/2023 10:49:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2135' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 10:49: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' , '2135' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '111.15' , '111.15' , NOW() , NOW() ) 21/06/2023 10:49: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 = '86443' 21/06/2023 10:49:14 am >> DELETE FROM ps_document_detail WHERE id_document = '86443' 21/06/2023 10:49: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 ( '86443' , '5596' , 'LECTIO DIVINA OGNI GIORNO - 6' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 21/06/2023 10:49: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 ( '86443' , '5597' , 'LECTIO DIVINA OGNI GIORNO - 7' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 21/06/2023 10:49: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 ( '86443' , '5598' , 'LECTIO DIVINA OGNI GIORNO - 8' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 21/06/2023 10:49: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 ( '86443' , '5599' , 'LECTIO DIVINA OGNI GIORNO - 9' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 21/06/2023 10:49: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 ( '86443' , '5584' , 'LECTIO DIVINA OGNI GIORNO - 10' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 21/06/2023 10:49: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 ( '86443' , '5591' , 'LECTIO DIVINA OGNI GIORNO - 17' , '1' , '-1' , '4' , '23.00' , '23' , '0' , '5' , '21.85' ) 21/06/2023 10:58:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2136' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 10:58: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' , '2136' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '120.00' , '98.36' , NOW() , NOW() ) 21/06/2023 10:58: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 = '86444' 21/06/2023 10:58:59 am >> DELETE FROM ps_document_detail WHERE id_document = '86444' 21/06/2023 10:58: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 ( '86444' , '1544' , 'CAMICE RAGLAN - CM 150 - ART.54' , '1' , '-1' , '1' , '58.00' , '47.540983606557' , '22' , '0' , '58.00' ) 21/06/2023 10:58: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 ( '86444' , '17534' , 'CINGOLO - CING05' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 21/06/2023 10:59:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86444' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 21/06/2023 11:02:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2137' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 11:02:57 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' , '2137' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.95' , '18.03' , NOW() , NOW() ) 21/06/2023 11:02:57 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 = '86445' 21/06/2023 11:02:57 am >> DELETE FROM ps_document_detail WHERE id_document = '86445' 21/06/2023 11:02:57 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 ( '86445' , '19312' , 'PORTACHIAVE COMUNIONE - 1828/K25' , '6' , '-6' , '1' , '2.70' , '2.2131147540984' , '22' , '0' , '16.20' ) 21/06/2023 11:02:57 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 ( '86445' , '9690' , 'SCAPOLARE DEL CARMELO - 8339' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 21/06/2023 11:03:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2136' AND id_document != '86444' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 11:03:59 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2136', document_date = '2023-06-21', 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 = '120.00', price_tax_excluded = '98.36', date_upd = NOW() WHERE id_document = '86444' 21/06/2023 11:03: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 = '86444' 21/06/2023 11:03:59 am >> DELETE FROM ps_document_detail WHERE id_document = '86444' 21/06/2023 11:03: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 ( '86444' , '1544' , 'CAMICE RAGLAN - CM 150 - ART.54' , '1' , '-1' , '1' , '58.0000' , '47.540983606557' , '22' , '0' , '58.00' ) 21/06/2023 11:03: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 ( '86444' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '13' , '10.655737704918' , '22' , '0' , '13.00' ) 21/06/2023 11:03: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 ( '86444' , '18682' , 'CLERGY ROMANO ML - C17' , '1' , '-1' , '1' , '49.0000' , '40.16393442623' , '22' , '0' , '49.00' ) 21/06/2023 12:01:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2138' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 12:01:00 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2138' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '77.50' , '63.52' , NOW() , NOW() ) 21/06/2023 12:01: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 = '86446' 21/06/2023 12:01:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '86446' 21/06/2023 12:01: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 ( '86446' , '21084' , 'BRACCIALE ARG. DIAMANTATO - 1835' , '1' , '-1' , '1' , '24.50' , '20.081967213115' , '22' , '0' , '24.50' ) 21/06/2023 12:01: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 ( '86446' , '21177' , 'BRACCIALE ARG. EMATITE - 1623CAV' , '1' , '-1' , '1' , '21.00' , '17.213114754098' , '22' , '0' , '21.00' ) 21/06/2023 12:01: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 ( '86446' , '19772' , 'BRACCIALE ARGENTO/EMATITE - 1374CAV' , '1' , '-1' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '20.00' ) 21/06/2023 12:01:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86446' , '579' , 'ANELLO FEDINA IN ARG. 925 - M043/020' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 21/06/2023 12:02:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '2139' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 12:02:01 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' , '2139' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '108.00' , '88.52' , NOW() , NOW() ) 21/06/2023 12:02:01 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 = '86447' 21/06/2023 12:02:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '86447' 21/06/2023 12:02:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86447' , '8935' , 'RICAMBIO PER TORCIA NIKEL - DIAM. 4 - 32' , '2' , '-2' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '78.00' ) 21/06/2023 12:02:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86447' , '16409' , 'RICAMBIO VETRO - 32/V' , '2' , '-2' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '30.00' ) 21/06/2023 12:08:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2140' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 12:08:23 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' , '2140' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '72.20' , '72.20' , NOW() , NOW() ) 21/06/2023 12:08: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 = '86448' 21/06/2023 12:08:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '86448' 21/06/2023 12:08: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 ( '86448' , '1144' , 'BIBBIA DI GERUSALEMME - TELATA' , '2' , '-2' , '4' , '38.00' , '38' , '0' , '5' , '72.20' ) 21/06/2023 12:18:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2141' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 12:18: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 ( '11' , '2141' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 21/06/2023 12:18: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 = '86449' 21/06/2023 12:18:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '86449' 21/06/2023 12:18: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 ( '86449' , '2097' , 'CIPOLLINA MANGIAFUMO - 1057' , '3' , '-3' , '1' , '6.00' , '4.9180327868852' , '22' , '0' , '18.00' ) 21/06/2023 12:18: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 ( '86449' , '13751' , 'TUNICA SVASATA AVORIO - 191 TPA' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 21/06/2023 12:18: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 ( '86449' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '72' , '59.016393442623' , '22' , '0' , '72.00' ) 21/06/2023 12:29:43 pm >> DELETE FROM ps_document WHERE id_document = '85765' 21/06/2023 12:29:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '85765' 21/06/2023 12:30:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '2117' AND id_document != '86425' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-20') 21/06/2023 12:30:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2117', document_date = '2023-06-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA DALMAZIA 6 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 = '0', id_causal = '0', price_tax_included = '165.40', price_tax_excluded = '136.84', date_upd = NOW() WHERE id_document = '86425' 21/06/2023 12:30:58 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86425' 21/06/2023 12:30:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '86425' 21/06/2023 12:30:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86425' , '11384' , 'VINO BIANCO DOLCE - 102' , '5' , '-5' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '42.50' ) 21/06/2023 12:30:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86425' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '10' , '-10' , '4' , '0.7000' , '0.7' , '0' , '0' , '7.00' ) 21/06/2023 12:30:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86425' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 21/06/2023 12:30:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86425' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 21/06/2023 12:30:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86425' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '8' , '6.5573770491803' , '22' , '0' , '8.00' ) 21/06/2023 12:30:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86425' , '21132' , 'CLERGY F/F MC - C03' , '1' , '-1' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '39.50' ) 21/06/2023 12:32:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '1946' AND id_document != '85698' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-05') 21/06/2023 12:32:13 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1946', document_date = '2023-06-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 = '90.00', price_tax_excluded = '73.77', date_upd = NOW() WHERE id_document = '85698' 21/06/2023 12:32:13 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 = '85698' 21/06/2023 12:32:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '85698' 21/06/2023 12:32: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 ( '85698' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 21/06/2023 12:32: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 ( '85698' , '21132' , 'CLERGY F/F MC - C03' , '2' , '-2' , '1' , '39.50' , '32.377049180328' , '22' , '0' , '79.00' ) 21/06/2023 12:42:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2142' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 12:42: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' , '2142' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 21/06/2023 12:42: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 = '86450' 21/06/2023 12:42:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '86450' 21/06/2023 12:42: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 ( '86450' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 21/06/2023 12:47:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2143' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 12:47:22 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' , '2143' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '26.80' , '22.65' , NOW() , NOW() ) 21/06/2023 12:47:22 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 = '86451' 21/06/2023 12:47:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '86451' 21/06/2023 12:47:22 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 ( '86451' , '9486' , 'S. MICHELE ARC. BABY - 023 SMK/9 BB' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 21/06/2023 12:47:22 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 ( '86451' , '16125' , 'MARIA CHE SCIOGLIE I NODI BABY - MSN9-BB' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 21/06/2023 12:47:22 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 ( '86451' , '9473' , 'SAN LUIGI GONZAGA - G. ARLEDLER' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 21/06/2023 12:55:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '2144' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 12:55:44 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' , '2144' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '160.00' , '131.15' , NOW() , NOW() ) 21/06/2023 12:55: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 = '86452' 21/06/2023 12:55:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '86452' 21/06/2023 12:55: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 ( '86452' , '19605' , 'CLERGY SU MISURA - COCOCLER' , '4' , '-4' , '1' , '40' , '32.786885245902' , '22' , '0' , '160.00' ) 21/06/2023 02:52:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000242' AND id_product != '8935' AND ean13 != '' 21/06/2023 02:52:35 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000242', date_upd = NOW() WHERE id_product = '8935' 21/06/2023 02:52:35 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO TORCIA NIKEL - DIAM. 4 - 32', description = '' WHERE id_product = '8935' 21/06/2023 02:52:35 pm >> UPDATE ps_product SET wholesale_price = '17.58', on_sale = '0', price = '31.9672' WHERE id_product = '8935' 21/06/2023 02:52:35 pm >> UPDATE ps_product_shop SET wholesale_price = '17.58', price = '31.9672', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8935' 21/06/2023 02:52:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '8935' 21/06/2023 02:53:17 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000010657' AND id_product != '15767' AND ean13 != '' 21/06/2023 02:53:17 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000010657', date_upd = NOW() WHERE id_product = '15767' 21/06/2023 02:53:17 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO PER TORCIA NIKEL - DIAM. 5 - 34', description = '' WHERE id_product = '15767' 21/06/2023 02:53:17 pm >> UPDATE ps_product SET wholesale_price = '15.77', on_sale = '0', price = '32.7869' WHERE id_product = '15767' 21/06/2023 02:53:17 pm >> UPDATE ps_product_shop SET wholesale_price = '15.77', price = '32.7869', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15767' 21/06/2023 02:53:17 pm >> DELETE FROM ps_specific_price WHERE id_product = '15767' 21/06/2023 02:53:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000010787' AND id_product != '15768' AND ean13 != '' 21/06/2023 02:53:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000010787', date_upd = NOW() WHERE id_product = '15768' 21/06/2023 02:53:43 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO PER TORCIA ORO DIAM. 5 - 35', description = '' WHERE id_product = '15768' 21/06/2023 02:53:43 pm >> UPDATE ps_product SET wholesale_price = '16.34', on_sale = '0', price = '35.2459' WHERE id_product = '15768' 21/06/2023 02:53:43 pm >> UPDATE ps_product_shop SET wholesale_price = '16.34', price = '35.2459', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15768' 21/06/2023 02:53:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '15768' 21/06/2023 02:54:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000773' AND id_product != '8936' AND ean13 != '' 21/06/2023 02:54:57 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2017', ean13 = '000773', date_upd = NOW() WHERE id_product = '8936' 21/06/2023 02:54:57 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33', description = '' WHERE id_product = '8936' 21/06/2023 02:54:57 pm >> UPDATE ps_product SET wholesale_price = '17.10', on_sale = '0', price = '36.0656' WHERE id_product = '8936' 21/06/2023 02:54:57 pm >> UPDATE ps_product_shop SET wholesale_price = '17.10', price = '36.0656', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8936' 21/06/2023 02:54:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '8936' 21/06/2023 02:57:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000010657' AND id_product != '15767' AND ean13 != '' 21/06/2023 02:57:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000010657', date_upd = NOW() WHERE id_product = '15767' 21/06/2023 02:57:47 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO PER TORCIA NIKEL - DIAM. 5 - 34', description = '' WHERE id_product = '15767' 21/06/2023 02:57:47 pm >> UPDATE ps_product SET wholesale_price = '15.77', on_sale = '0', price = '36.0655737704918' WHERE id_product = '15767' 21/06/2023 02:57:47 pm >> UPDATE ps_product_shop SET wholesale_price = '15.77', price = '36.0655737704918', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15767' 21/06/2023 02:57:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '15767' 21/06/2023 02:58:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000010657' AND id_product != '15767' AND ean13 != '' 21/06/2023 02:58:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000010657', date_upd = NOW() WHERE id_product = '15767' 21/06/2023 02:58:09 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO PER TORCIA NIKEL - DIAM. 5 - 34', description = '' WHERE id_product = '15767' 21/06/2023 02:58:09 pm >> UPDATE ps_product SET wholesale_price = '15.77', on_sale = '0', price = '36.0655737704918' WHERE id_product = '15767' 21/06/2023 02:58:09 pm >> UPDATE ps_product_shop SET wholesale_price = '15.77', price = '36.0655737704918', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15767' 21/06/2023 02:58:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '15767' 21/06/2023 03:01:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000010787' AND id_product != '15768' AND ean13 != '' 21/06/2023 03:01:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000010787', date_upd = NOW() WHERE id_product = '15768' 21/06/2023 03:01:14 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO PER TORCIA ORO DIAM. 5 - 35', description = '' WHERE id_product = '15768' 21/06/2023 03:01:14 pm >> UPDATE ps_product SET wholesale_price = '16.34', on_sale = '0', price = '37.704918032786885' WHERE id_product = '15768' 21/06/2023 03:01:14 pm >> UPDATE ps_product_shop SET wholesale_price = '16.34', price = '37.704918032786885', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15768' 21/06/2023 03:01:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '15768' 21/06/2023 03:01:55 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000242' AND id_product != '8935' AND ean13 != '' 21/06/2023 03:01:55 pm >> UPDATE ps_product SET id_supplier = '12', reference = '2013', ean13 = '000242', date_upd = NOW() WHERE id_product = '8935' 21/06/2023 03:01:55 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO PER TORCIA NIKEL - DIAM. 4 - 32', description = '' WHERE id_product = '8935' 21/06/2023 03:01:55 pm >> UPDATE ps_product SET wholesale_price = '17.58', on_sale = '0', price = '31.9672' WHERE id_product = '8935' 21/06/2023 03:01:55 pm >> UPDATE ps_product_shop SET wholesale_price = '17.58', price = '31.9672', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '8935' 21/06/2023 03:01:55 pm >> DELETE FROM ps_specific_price WHERE id_product = '8935' 21/06/2023 03:25:27 pm >> SELECT document_num FROM ps_document WHERE document_num = '2145' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 03:25:27 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2145' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.50' , '10.25' , NOW() , NOW() ) 21/06/2023 03:25:27 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86453' 21/06/2023 03:25:27 pm >> DELETE FROM ps_document_detail WHERE id_document = '86453' 21/06/2023 03:25:27 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86453' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '12.50' , '10.245901639344' , '22' , '0' , '12.50' ) 21/06/2023 03:31:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2146' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 03:31:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2146' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.13' , NOW() , NOW() ) 21/06/2023 03:31:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86454' 21/06/2023 03:31:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '86454' 21/06/2023 03:31:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86454' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 21/06/2023 04:22:51 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571382' AND id_product != '135' AND ean13 != '' 21/06/2023 04:22:51 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788899571382', date_upd = NOW() WHERE id_product = '135' 21/06/2023 04:22:51 pm >> UPDATE ps_product_lang SET name = 'LIBRO AGENDA CATTOLICO 2024', description = '' WHERE id_product = '135' 21/06/2023 04:22:51 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '135' 21/06/2023 04:22:51 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '448', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '135' 21/06/2023 04:22:51 pm >> DELETE FROM ps_specific_price WHERE id_product = '135' 21/06/2023 04:39:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2147' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 04:39:03 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' , '2147' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '87.70' , NOW() , NOW() ) 21/06/2023 04:39:03 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 = '86455' 21/06/2023 04:39:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '86455' 21/06/2023 04:39:03 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 ( '86455' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 21/06/2023 04:39:03 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 ( '86455' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 21/06/2023 04:39:03 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 ( '86455' , '14330' , '100 GIORNI CON LO SPIRITO' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 21/06/2023 04:39:03 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 ( '86455' , '6546' , 'MESSAGGIO DI TENEREZZA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 21/06/2023 04:39:03 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 ( '86455' , '15744' , 'GESU BENEDICI LA NOSTRA FAMIGLIA' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 21/06/2023 04:39:03 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 ( '86455' , '18760' , 'BRACCIALE ARG - 1819' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 21/06/2023 04:39:03 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 ( '86455' , '18762' , 'BRACCIALE ARG. - 1568' , '1' , '-1' , '1' , '32.37' , '26.532786885246' , '22' , '0' , '32.37' ) 21/06/2023 04:39:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571382' AND id_product != '135' AND ean13 != '' 21/06/2023 04:39:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788899571382', date_upd = NOW() WHERE id_product = '135' 21/06/2023 04:39:46 pm >> UPDATE ps_product_lang SET name = 'LIBRO AGENDA CATTOLICO 2024', description = '' WHERE id_product = '135' 21/06/2023 04:39:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18' WHERE id_product = '135' 21/06/2023 04:39:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '448', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '135' 21/06/2023 04:39:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '135' 21/06/2023 04:42: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 ( '33' , '275' , '2023-06-19' , '' , '0' , '127' , '4670269' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 21/06/2023 04:42: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 = '11340' 21/06/2023 04:42:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '11340' 21/06/2023 04:42: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 ( '11340' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '500' , '500' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 21/06/2023 04:42:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '135' AND id_supplier = '127' 21/06/2023 04:42:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '135' , '127' , '1' ) 21/06/2023 04:42: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 ( '33' , '274' , '2023-06-19' , '' , '0' , '127' , '4670269' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , 'INVIATI A BYBLOS' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '0.00' , '0.00' , NOW() , NOW() ) 21/06/2023 04:42: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 = '11341' 21/06/2023 04:42:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '11341' 21/06/2023 04:42: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 ( '11341' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '500' , '500' , '4' , '0' , '0' , '0' , '0' , '0.0000' ) 21/06/2023 04:42:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '135' AND id_supplier = '127' 21/06/2023 04:42:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '135' , '127' , '1' ) 21/06/2023 04:43: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 ( '32' , '136/23' , '2023-06-20' , '23' , '0' , '127' , '4670269' , 'VIA TORQUATO TASSO, 10 24020 GORLE' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5148.00' , '4950.00' , NOW() , NOW() ) 21/06/2023 04:43: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 = '11342' 21/06/2023 04:43:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '11342' 21/06/2023 04:43: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 ( '11342' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '500' , '0' , '3' , '4.95' , '4.7596153846154' , '4' , '0' , '2574.0000' ) 21/06/2023 04:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '135' AND id_supplier = '127' 21/06/2023 04:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '135' , '127' , '1' ) 21/06/2023 04:43: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 ( '11342' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '500' , '0' , '3' , '4.95' , '4.7596153846154' , '4' , '0' , '2574.0000' ) 21/06/2023 04:43:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '135' AND id_supplier = '127' 21/06/2023 04:43:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '135' , '127' , '1' ) 21/06/2023 04:44:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '11' AND id_document != '' AND id_document_type LIKE '24' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 04:44: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 ( '24' , '11' , '2023-06-21' , '' , '3000' , '0' , '4669629' , 'VIA DEI CASTANI, 116 00172 ROMA' , '' , 'INVIATI DA VELAR' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9000.00' , '9000.00' , NOW() , NOW() ) 21/06/2023 04:44: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 = '11343' 21/06/2023 04:44:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '11343' 21/06/2023 04:44: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 ( '11343' , '135' , 'LIBRO AGENDA CATTOLICO 2024' , '500' , '-500' , '4' , '18.00' , '18' , '0' , '0' , '9000.00' ) 21/06/2023 04:57:05 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' , '23FP00619' , '2023-06-15' , '' , '0' , '63' , '2658' , 'P.ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '238.00' , '238.00' , NOW() , NOW() ) 21/06/2023 04:57:05 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 = '86456' 21/06/2023 04:57:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '86456' 21/06/2023 04:57:05 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 ( '86456' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '425' , '425' , '4' , '0.56' , '0.56' , '0' , '0' , '238.0000' ) 21/06/2023 04:57:05 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '63' 21/06/2023 04:57:05 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '63' , '1' ) 21/06/2023 05:16:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2148' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 05:16:29 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2148' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 21/06/2023 05:16:29 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86457' 21/06/2023 05:16:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '86457' 21/06/2023 05:16:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86457' , '20537' , 'VESTINA BATTESIMALE - 101TCB' , '2' , '-2' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '9.00' ) 21/06/2023 05:16:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86457' , '7202' , 'ARTICOLI RELIGIOSI' , '2' , '-2' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '5.00' ) 21/06/2023 06:32:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2149' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 06:32:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2149' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 21/06/2023 06:32:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86458' 21/06/2023 06:32:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '86458' 21/06/2023 06:32:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86458' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 21/06/2023 07:42:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2150' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-21') 21/06/2023 07:42:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2150' , '2023-06-21' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.70' , '5.49' , NOW() , NOW() ) 21/06/2023 07:42:38 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86459' 21/06/2023 07:42:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '86459' 21/06/2023 07:42:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86459' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '2.2' , '1.8032786885246' , '22' , '0' , '2.20' ) 21/06/2023 07:42:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86459' , '18215' , 'BRACCIALE DECINA VARI COL. - BC752' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 21/06/2023 07:42:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86459' , '16986' , 'QUADRETTO SMUSSATO 7X10 SACRO CUORE' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' )