16/05/2022 08:26:45 am >> SELECT document_num FROM ps_document WHERE document_num = '1527' AND id_document != '57267' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-14') 16/05/2022 08:26:45 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1527', document_date = '2022-05-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '151.80', price_tax_excluded = '126.47', date_upd = NOW() WHERE id_document = '57267' 16/05/2022 08:26:45 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 = '57267' 16/05/2022 08:26:45 am >> DELETE FROM ps_document_detail WHERE id_document = '57267' 16/05/2022 08:26:45 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 ( '57267' , '16252' , 'CUORE PENDENTE' , '6' , '-6' , '1' , '12.20' , '10' , '22' , '0' , '73.20' ) 16/05/2022 08:26:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16252' AND id_supplier = '' 16/05/2022 08:26:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16252' , '' , '1' ) 16/05/2022 08:26:45 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 ( '57267' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '3' , '-3' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '10.50' ) 16/05/2022 08:26:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 16/05/2022 08:26:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 16/05/2022 08:26:45 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 ( '57267' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '1.90' ) 16/05/2022 08:26:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 16/05/2022 08:26:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 16/05/2022 08:26:45 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 ( '57267' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '2.00' ) 16/05/2022 08:26:45 am >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 16/05/2022 08:26:45 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 16/05/2022 08:26:45 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 ( '57267' , '15400' , 'CONF. CARTONCINO SIMBOLO MADRE PERLA CRESIMA - 1907/J44' , '1' , '-1' , '1' , '2.2000' , '1.8032786885246' , '22' , '0' , '2.20' ) 16/05/2022 08:26:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '15400' AND id_supplier = '' 16/05/2022 08:26:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15400' , '' , '1' ) 16/05/2022 08:26: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 ( '57267' , '18247' , 'CLERGY JEANS NIDO DAPE MM - M' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 16/05/2022 08:26:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '18247' AND id_supplier = '' 16/05/2022 08:26:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18247' , '' , '1' ) 16/05/2022 08:26: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 ( '57267' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '22.0000' , '18.032786885246' , '22' , '0' , '22.00' ) 16/05/2022 08:26:46 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 16/05/2022 08:26:46 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 16/05/2022 09:17:58 am >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '50074' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-01-12') 16/05/2022 09:17:58 am >> UPDATE ps_document SET id_document_type = '24', document_num = '2/A', document_date = '2022-01-12', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '79.80', price_tax_excluded = '79.80', date_upd = NOW() WHERE id_document = '50074' 16/05/2022 09:17:58 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 = '50074' 16/05/2022 09:17:58 am >> DELETE FROM ps_document_detail WHERE id_document = '50074' 16/05/2022 09:17:58 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 ( '50074' , '19517' , 'PAROLA E PREGHIERA - LUG 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 16/05/2022 09:17:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19517' AND id_supplier = '' 16/05/2022 09:17:58 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19517' , '' , '1' ) 16/05/2022 09:17:58 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 ( '50074' , '19467' , 'SULLA TUA PAROLA - LUG AGO 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 16/05/2022 09:17:58 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 16/05/2022 09:17:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 16/05/2022 09:17: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 ( '50074' , '19498' , 'VANGELI' , '1' , '-1' , '4' , '69.00' , '69' , '0' , '0' , '69.00' ) 16/05/2022 09:17:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '19498' AND id_supplier = '' 16/05/2022 09:17:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19498' , '' , '1' ) 16/05/2022 10:17:03 am >> SELECT document_num FROM ps_document WHERE document_num = '1536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 10:17:03 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' , '1536' , '2022-05-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.50' , '6.97' , NOW() , NOW() ) 16/05/2022 10:17: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 = '57276' 16/05/2022 10:17:03 am >> DELETE FROM ps_document_detail WHERE id_document = '57276' 16/05/2022 10:17: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 ( '57276' , '11045' , 'VANGELO COPERTINA IN PELLE' , '1' , '-1' , '1' , '7.00' , '5.7377049180328' , '22' , '0' , '7.00' ) 16/05/2022 10:17:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '11045' AND id_supplier = '' 16/05/2022 10:17:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11045' , '' , '1' ) 16/05/2022 10:17: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 ( '57276' , '1737' , 'CARTA DI IDENTITÀ - RP66' , '1' , '-1' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '1.50' ) 16/05/2022 10:17:03 am >> DELETE FROM ps_product_supplier WHERE id_product = '1737' AND id_supplier = '' 16/05/2022 10:17:03 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1737' , '' , '1' ) 16/05/2022 10:20:20 am >> SELECT document_num FROM ps_document WHERE document_num = '83' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 10:20: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 ( '21' , '83' , '2022-05-16' , '' , '3883' , '0' , '4674281' , 'Via Maggiore Pietro Toselli 94 , 94 73043 Copertino ' , '' , '' , '' , '0' , '0' , '0' , '0' , '' , '6' , '0' , '77.95' , '77.95' , NOW() , NOW() ) 16/05/2022 10:20: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 = '57788' 16/05/2022 10:20:20 am >> DELETE FROM ps_document_detail WHERE id_document = '57788' 16/05/2022 10:20: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 ( '57788' , '12818' , 'LIBRO DELLE PRIME COMUNIONI' , '1' , '-1' , '4' , '38.0030' , '38.003' , '0' , '5' , '36.10' ) 16/05/2022 10:20: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 ( '57788' , '12819' , 'REGISTRO DEL CATECHISTA ' , '21' , '-21' , '0' , '1.0004' , '1.0004' , '' , '5' , '19.95' ) 16/05/2022 10:20: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 ( '57788' , '12849' , 'LIBRO DELLE SS. MESSE' , '1' , '-1' , '0' , '19.9958' , '19.9958' , '' , '5' , '19.00' ) 16/05/2022 10:20: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 ( '57788' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 16/05/2022 10:24:56 am >> SELECT document_num FROM ps_document WHERE document_num = '1436' AND id_document != '56644' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-06') 16/05/2022 10:24:56 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1436', document_date = '2022-05-06', 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 = '46.00', price_tax_excluded = '37.70', date_upd = NOW() WHERE id_document = '56644' 16/05/2022 10:24: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 = '56644' 16/05/2022 10:24:56 am >> DELETE FROM ps_document_detail WHERE id_document = '56644' 16/05/2022 10:24: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 ( '56644' , '13563' , 'CORONCINA IN STOFFA CON FIORI - 3312' , '1' , '-1' , '1' , '8.0000' , '6.5573770491803' , '22' , '0' , '8.00' ) 16/05/2022 10:24:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '13563' AND id_supplier = '' 16/05/2022 10:24:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13563' , '' , '1' ) 16/05/2022 10:24: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 ( '56644' , '18254' , 'CLERGY BLU NIDO DAPE MM - XL' , '1' , '-1' , '1' , '38' , '31.147540983607' , '22' , '0' , '38.00' ) 16/05/2022 10:24:56 am >> DELETE FROM ps_product_supplier WHERE id_product = '18254' AND id_supplier = '' 16/05/2022 10:24:56 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18254' , '' , '1' ) 16/05/2022 10:35:29 am >> SELECT document_num FROM ps_document WHERE document_num = '1383' AND id_document != '56574' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-03') 16/05/2022 10:35:29 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1383', document_date = '2022-05-03', 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 = '3', id_causal = '0', price_tax_included = '1000.00', price_tax_excluded = '819.67', date_upd = NOW() WHERE id_document = '56574' 16/05/2022 10:35:29 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 = '56574' 16/05/2022 10:35:29 am >> DELETE FROM ps_document_detail WHERE id_document = '56574' 16/05/2022 10:35:30 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 ( '56574' , '18789' , 'CASULA ACETATO VISCOSA - 65/020628CRO' , '1' , '-1' , '1' , '800.0000' , '655.73770491803' , '22' , '0' , '800.00' ) 16/05/2022 10:35:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '18789' AND id_supplier = '' 16/05/2022 10:35:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18789' , '' , '1' ) 16/05/2022 10:35:30 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 ( '56574' , '15732' , 'CASULA 3 CR. - 207' , '1' , '-1' , '1' , '200' , '163.93442622951' , '22' , '0' , '200.00' ) 16/05/2022 10:35:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '15732' AND id_supplier = '' 16/05/2022 10:35:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15732' , '' , '1' ) 16/05/2022 10:52:48 am >> SELECT document_num FROM ps_document WHERE document_num = '1537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 10:52:48 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' , '1537' , '2022-05-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.75' , '8.03' , NOW() , NOW() ) 16/05/2022 10:52:48 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 = '57789' 16/05/2022 10:52:48 am >> DELETE FROM ps_document_detail WHERE id_document = '57789' 16/05/2022 10:52: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 ( '57789' , '19467' , 'SULLA TUA PAROLA - LUG AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/05/2022 10:52:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 16/05/2022 10:52:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 16/05/2022 10:52: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 ( '57789' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 16/05/2022 10:52:49 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 16/05/2022 10:52:49 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 16/05/2022 10:57:09 am >> SELECT document_num FROM ps_document WHERE document_num = '690' AND id_document != '52655' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-03-08') 16/05/2022 10:57:09 am >> UPDATE ps_document SET id_document_type = '11', document_num = '690', document_date = '2022-03-08', 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 = '121.80', price_tax_excluded = '105.06', date_upd = NOW() WHERE id_document = '52655' 16/05/2022 10:57:09 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '52655' 16/05/2022 10:57:09 am >> DELETE FROM ps_document_detail WHERE id_document = '52655' 16/05/2022 10:57:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52655' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '3.3000' , '3.1730769230769' , '4' , '0' , '3.30' ) 16/05/2022 10:57:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 16/05/2022 10:57:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 16/05/2022 10:57:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52655' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '1.5000' , '1.4423076923077' , '4' , '0' , '4.50' ) 16/05/2022 10:57:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 16/05/2022 10:57:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 16/05/2022 10:57:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52655' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '2.9000' , '2.7884615384615' , '4' , '0' , '29.00' ) 16/05/2022 10:57:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 16/05/2022 10:57:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 16/05/2022 10:57:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52655' , '18129' , 'TAU COLORATO - T56' , '60' , '-60' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '72.00' ) 16/05/2022 10:57:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '18129' AND id_supplier = '' 16/05/2022 10:57:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18129' , '' , '1' ) 16/05/2022 10:57:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52655' , '2097' , 'CIPOLLINA MANGIAFUMO - 1057' , '1' , '-1' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '6.00' ) 16/05/2022 10:57:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '2097' AND id_supplier = '' 16/05/2022 10:57:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2097' , '' , '1' ) 16/05/2022 10:57:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '52655' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 16/05/2022 10:57:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '11757' AND id_supplier = '' 16/05/2022 10:57:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11757' , '' , '1' ) 16/05/2022 11:24:00 am >> SELECT document_num FROM ps_document WHERE document_num = '1538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 11:24:00 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1538' , '2022-05-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '4.10' , NOW() , NOW() ) 16/05/2022 11:24:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57790' 16/05/2022 11:24:00 am >> DELETE FROM ps_document_detail WHERE id_document = '57790' 16/05/2022 11:24: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 ( '57790' , '15481' , 'CROCE IHS - 2389/CZ' , '2' , '-2' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '5.00' ) 16/05/2022 11:24:00 am >> DELETE FROM ps_product_supplier WHERE id_product = '15481' AND id_supplier = '' 16/05/2022 11:24:00 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15481' , '' , '1' ) 16/05/2022 11:36:21 am >> SELECT document_num FROM ps_document WHERE document_num = '1539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 11:36: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' , '1539' , '2022-05-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '97.50' , '79.92' , NOW() , NOW() ) 16/05/2022 11:36: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 = '57791' 16/05/2022 11:36:21 am >> DELETE FROM ps_document_detail WHERE id_document = '57791' 16/05/2022 11:36: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 ( '57791' , '15085' , 'BRACCIALE DECINA COLORATA - BC506' , '50' , '-50' , '1' , '1.20' , '0.98360655737705' , '22' , '0' , '60.00' ) 16/05/2022 11:36:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '15085' AND id_supplier = '' 16/05/2022 11:36:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15085' , '' , '1' ) 16/05/2022 11:36: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 ( '57791' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '25' , '-25' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '12.50' ) 16/05/2022 11:36:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 16/05/2022 11:36:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 16/05/2022 11:36: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 ( '57791' , '7917' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. B' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '25.00' ) 16/05/2022 11:36:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '7917' AND id_supplier = '' 16/05/2022 11:36:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7917' , '' , '1' ) 16/05/2022 11:51:04 am >> SELECT document_num FROM ps_document WHERE document_num = '1540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 11:51:04 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' , '1540' , '2022-05-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.84' , '10.84' , NOW() , NOW() ) 16/05/2022 11:51:04 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 = '57792' 16/05/2022 11:51:04 am >> DELETE FROM ps_document_detail WHERE id_document = '57792' 16/05/2022 11:51:04 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 ( '57792' , '6088' , 'MADRE SPERANZA - V.SALVOLDI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '5' , '3.33' ) 16/05/2022 11:51:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '6088' AND id_supplier = '' 16/05/2022 11:51:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6088' , '' , '1' ) 16/05/2022 11:51:04 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 ( '57792' , '18549' , 'AMORE CANTA IN SILENZIO - D. TUROLDO' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 16/05/2022 11:51:04 am >> DELETE FROM ps_product_supplier WHERE id_product = '18549' AND id_supplier = '' 16/05/2022 11:51:04 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18549' , '' , '1' ) 16/05/2022 12:04:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '37/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 12:04:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '37/A' , '2022-05-16' , 'A' , '3712' , '0' , '4671443' , 'VIA DALMAZIA 6 84121 SALERNO' , '' , 'ACCONTO € 4,00' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.80' , '17.12' , NOW() , NOW() ) 16/05/2022 12:04:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57793' 16/05/2022 12:04:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '57793' 16/05/2022 12:04:19 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 ( '57793' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '3.80' ) 16/05/2022 12:04:19 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 ( '57793' , '7673' , 'PARTICOLE MM38' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 16/05/2022 12:06:10 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/05/2022 12:06:10 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19558' , '1' , '' , 'nuovo-prodotto' ) 16/05/2022 12:06:10 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19558' , '1' , '1' , '2' , NOW() , NOW() ) 16/05/2022 12:06:10 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19558' , '0' , '1' , '0' , '0' ) 16/05/2022 12:07:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'PC23OR' AND id_product != '19558' AND ean13 != '' 16/05/2022 12:07:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'PC23OR', date_upd = NOW() WHERE id_product = '19558' 16/05/2022 12:07:03 pm >> UPDATE ps_product_lang SET name = 'PORTACERO - PC23OR', description = '' WHERE id_product = '19558' 16/05/2022 12:07:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '391.8032786885246' WHERE id_product = '19558' 16/05/2022 12:07:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '391.8032786885246', id_tax_rules_group = '1', id_category_default = '474', 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 = '19558' 16/05/2022 12:07:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '19558' 16/05/2022 12:07:06 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19558' 16/05/2022 12:07:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19559' , '1' , '' , 'nuovo-prodotto' ) 16/05/2022 12:07:06 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19559' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19558' 16/05/2022 12:07:06 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19559' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19558' 16/05/2022 12:07:32 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' , '31/2022' , '2022-05-16' , '2022' , '0' , '147' , '4671058' , 'VIA NICOLA FIORENTINO, 57 80026 CASORIA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '239.12' , '196.00' , NOW() , NOW() ) 16/05/2022 12:07:32 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 = '57794' 16/05/2022 12:07:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '57794' 16/05/2022 12:07:32 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 ( '57794' , '19558' , 'PORTACERO - PC23OR' , '1' , '1' , '1' , '392' , '321.31147540984' , '22' , '50' , '239.1200' ) 16/05/2022 12:07:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19558' AND id_supplier = '147' 16/05/2022 12:07:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19558' , '147' , '1' ) 16/05/2022 12:26:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '84' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 12:26:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '84' , '2022-05-16' , '' , '3455' , '0' , '4672079' , 'C. DA SANTA DOMENICA, SNC 84031 AULETTA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '7' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 16/05/2022 12:26:41 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 = '57795' 16/05/2022 12:26:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '57795' 16/05/2022 12:26:41 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 ( '57795' , '18131' , 'TAU MEDIO CM3 - T6' , '14' , '-14' , '0' , '1.00' , '1' , '' , '0' , '14.00' ) 16/05/2022 12:52:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '1541' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 12:52:39 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' , '1541' , '2022-05-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.50' , '10.50' , NOW() , NOW() ) 16/05/2022 12:52:39 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 = '57796' 16/05/2022 12:52:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '57796' 16/05/2022 12:52: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 ( '57796' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '10.5' , '10.5' , '0' , '0' , '10.50' ) 16/05/2022 12:52:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 16/05/2022 12:52:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 16/05/2022 02:36:42 pm >> SELECT document_num FROM ps_document WHERE document_num = '1523' AND id_document != '57263' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-14') 16/05/2022 02:36:42 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1523', document_date = '2022-05-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.36', price_tax_excluded = '10.29', date_upd = NOW() WHERE id_document = '57263' 16/05/2022 02:36:42 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57263' 16/05/2022 02:36:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '57263' 16/05/2022 02:36:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57263' , '19292' , 'PRIMA COMUNIONE' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '5' , '2.76' ) 16/05/2022 02:36:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19292' AND id_supplier = '' 16/05/2022 02:36:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19292' , '' , '1' ) 16/05/2022 02:36:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57263' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 16/05/2022 02:36:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 16/05/2022 02:36:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 16/05/2022 02:36:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57263' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 16/05/2022 02:36:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8408' AND id_supplier = '' 16/05/2022 02:36:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8408' , '' , '1' ) 16/05/2022 02:36:42 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57263' , '4154' , 'FESTA DEL PERDONO' , '1' , '-1' , '4' , '3.0000' , '3' , '0' , '5' , '2.85' ) 16/05/2022 02:36:42 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4154' AND id_supplier = '' 16/05/2022 02:36:42 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4154' , '' , '1' ) 16/05/2022 02:37:17 pm >> SELECT document_num FROM ps_document WHERE document_num = '1525' AND id_document != '57265' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-14') 16/05/2022 02:37:17 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1525', document_date = '2022-05-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '1.50', price_tax_excluded = '1.23', date_upd = NOW() WHERE id_document = '57265' 16/05/2022 02:37:17 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57265' 16/05/2022 02:37:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '57265' 16/05/2022 02:37:17 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57265' , '15335' , 'CANDELA VOTIVA 20X40 DECORATA' , '1' , '-1' , '1' , '1.5' , '1.2295081967213' , '22' , '0' , '1.50' ) 16/05/2022 02:37:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15335' AND id_supplier = '' 16/05/2022 02:37:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15335' , '' , '1' ) 16/05/2022 02:38:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001935' AND id_product != '19231' AND ean13 != '' 16/05/2022 02:38:19 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '001935', date_upd = NOW() WHERE id_product = '19231' 16/05/2022 02:38:19 pm >> UPDATE ps_product_lang SET name = 'CARD CARLO ACUTIS - RN93', description = '' WHERE id_product = '19231' 16/05/2022 02:38:19 pm >> UPDATE ps_product SET wholesale_price = '0.36', on_sale = '0', price = '0.8197' WHERE id_product = '19231' 16/05/2022 02:38:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.36', price = '0.8197', id_tax_rules_group = '1', id_category_default = '151', 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 = '19231' 16/05/2022 02:38:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '19231' 16/05/2022 04:41:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '1542' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 04:41:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1542' , '2022-05-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '93.61' , '82.88' , NOW() , NOW() ) 16/05/2022 04:41:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57797' 16/05/2022 04:41:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '57797' 16/05/2022 04:41:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57797' , '15494' , 'CROCE AVORIO SMALTATA h 20' , '1' , '-1' , '1' , '15.00' , '12.295081967213' , '22' , '0' , '15.00' ) 16/05/2022 04:41:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15494' AND id_supplier = '' 16/05/2022 04:41:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15494' , '' , '1' ) 16/05/2022 04:41:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57797' , '17997' , 'AUSILIATRICE - 023 AUX/13' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 16/05/2022 04:41:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17997' AND id_supplier = '' 16/05/2022 04:41:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17997' , '' , '1' ) 16/05/2022 04:41:48 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 ( '57797' , '4915' , 'ICONA SU TELA LEGNO MADONNA NODI CM 22X16,5 - AN025 ' , '1' , '-1' , '1' , '24.00' , '19.672131147541' , '22' , '0' , '24.00' ) 16/05/2022 04:41:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4915' AND id_supplier = '' 16/05/2022 04:41:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4915' , '' , '1' ) 16/05/2022 04:41:48 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 ( '57797' , '3631' , 'DON BOSCO - T. BOSCO' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 16/05/2022 04:41:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3631' AND id_supplier = '' 16/05/2022 04:41:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3631' , '' , '1' ) 16/05/2022 04:41:48 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 ( '57797' , '19130' , 'E IL DISCEPOLO SI FECE CARNE - C. SOLMONESE' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 16/05/2022 04:41:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19130' AND id_supplier = '' 16/05/2022 04:41:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19130' , '' , '1' ) 16/05/2022 04:41:48 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 ( '57797' , '5305' , 'INNI PER LASSEMBLEA LITURGICA - F. RAMPI' , '1' , '-1' , '4' , '19.90' , '19.9' , '0' , '5' , '18.91' ) 16/05/2022 04:41:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5305' AND id_supplier = '' 16/05/2022 04:41:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5305' , '' , '1' ) 16/05/2022 04:41:48 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 ( '57797' , '13355' , 'ROSARIO CRISTALLO VARI COLORI - 07777' , '1' , '-1' , '1' , '11.50' , '9.4262295081967' , '22' , '0' , '11.50' ) 16/05/2022 04:41:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13355' AND id_supplier = '' 16/05/2022 04:41:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13355' , '' , '1' ) 16/05/2022 04:53:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788801055191' AND id_product != '5305' AND ean13 != '' 16/05/2022 04:53:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '8/3', ean13 = '9788801055191', date_upd = NOW() WHERE id_product = '5305' 16/05/2022 04:53:38 pm >> UPDATE ps_product_lang SET name = 'INNI PER L\'ASSEMBLEA LITURGICA - F. RAMPI', description = '' WHERE id_product = '5305' 16/05/2022 04:53:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '19.9000' WHERE id_product = '5305' 16/05/2022 04:53:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '19.9000', id_tax_rules_group = '4', id_category_default = '19', id_argoment_default = '66', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '5305' 16/05/2022 04:53:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '5305' 16/05/2022 05:21:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '1543' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 05:21:30 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1543' , '2022-05-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.00' , '9.84' , NOW() , NOW() ) 16/05/2022 05:21:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57798' 16/05/2022 05:21:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '57798' 16/05/2022 05:21:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57798' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '12' , '9.8360655737705' , '22' , '0' , '12.00' ) 16/05/2022 05:21:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 16/05/2022 05:21:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 16/05/2022 05:30:09 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3883' 16/05/2022 05:30:09 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3883' , '10' , '169' , 'Parrocchia Sacro Cuore di Gesù' , 'Aluisi' , 'Sandro' , 'Via Maggiore Pietro Toselli 94 ' , '' , '73043' , 'Copertino' , '' , '' , '3294007172' , '' , '93000610753' , NOW() , NOW() ) 16/05/2022 05:30:09 pm >> UPDATE ps_customer SET email = 'sacrocuorecopertino2017@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '3883' 16/05/2022 06:23:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '1544' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 06:23:15 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1544' , '2022-05-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.75' , '41.64' , NOW() , NOW() ) 16/05/2022 06:23:15 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57799' 16/05/2022 06:23:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '57799' 16/05/2022 06:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57799' , '15529' , 'TUNICA 2 PIEGONI COLLO RISV. - PTA002B00' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 16/05/2022 06:23:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15529' AND id_supplier = '' 16/05/2022 06:23:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15529' , '' , '1' ) 16/05/2022 06:23:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57799' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/05/2022 06:23:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 16/05/2022 06:23:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 16/05/2022 06:25:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '1545' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 06:25:35 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' , '1545' , '2022-05-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 16/05/2022 06:25: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 = '57800' 16/05/2022 06:25:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '57800' 16/05/2022 06:25: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 ( '57800' , '19299' , 'SULLA TUA PAROLA - MAG/GIU 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 16/05/2022 06:25:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19299' AND id_supplier = '' 16/05/2022 06:25:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19299' , '' , '1' ) 16/05/2022 06:27:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1546' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-16') 16/05/2022 06:27:10 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '1546' , '2022-05-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.50' , '7.35' , NOW() , NOW() ) 16/05/2022 06:27: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 = '57801' 16/05/2022 06:27:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '57801' 16/05/2022 06:27: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 ( '57801' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '4.00' ) 16/05/2022 06:27:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 16/05/2022 06:27:10 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 16/05/2022 06:27: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 ( '57801' , '4681' , 'GIUSEPPE MOSCATI' , '1' , '-1' , '4' , '3.50' , '3.5' , '0' , '0' , '3.50' ) 16/05/2022 06:27:10 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4681' AND id_supplier = '' 16/05/2022 06:27:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4681' , '' , '1' )