23/11/2023 09:18:29 am >> SELECT document_num FROM ps_document WHERE document_num = '3694' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 09:18:29 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' , '3694' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.50' , '13.52' , NOW() , NOW() ) 23/11/2023 09:18: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 = '89092' 23/11/2023 09:18:29 am >> DELETE FROM ps_document_detail WHERE id_document = '89092' 23/11/2023 09:18:29 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 ( '89092' , '19749' , 'INCENSO MATTHAEUS ' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/11/2023 09:18:29 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 ( '89092' , '4697' , 'GLORIA MISCELA 25G - GLORE' , '3' , '-3' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '4.50' ) 23/11/2023 09:22:15 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/11/2023 09:22:15 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21900' , '1' , '' , 'nuovo-prodotto' ) 23/11/2023 09:22:15 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21900' , '1' , '1' , '2' , NOW() , NOW() ) 23/11/2023 09:22:16 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21900' , '0' , '1' , '0' , '0' ) 23/11/2023 09:23:29 am >> SELECT ean13 FROM ps_product WHERE ean13 = '9788884048868' AND id_product != '21900' AND ean13 != '' 23/11/2023 09:23:29 am >> UPDATE ps_product SET id_supplier = '', reference = 'ESPOSITORE SHALOM', ean13 = '9788884048868', date_upd = NOW() WHERE id_product = '21900' 23/11/2023 09:23:29 am >> UPDATE ps_product_lang SET name = 'ATTESA DI DIO - 8559', description = '' WHERE id_product = '21900' 23/11/2023 09:23:29 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '1.5' WHERE id_product = '21900' 23/11/2023 09:23:29 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '1.5', id_tax_rules_group = '4', id_category_default = '106', id_argoment_default = '', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '21900' 23/11/2023 09:23:29 am >> DELETE FROM ps_specific_price WHERE id_product = '21900' 23/11/2023 09:28:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '18734/00/2023' , '2023-11-21' , '00' , '0' , '38' , '2633' , 'VIA GALVANI, 1 60020 CAMERATA PICENA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '127.82' , '118.13' , NOW() , NOW() ) 23/11/2023 09:28:43 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 = '89093' 23/11/2023 09:28:43 am >> DELETE FROM ps_document_detail WHERE id_document = '89093' 23/11/2023 09:28:43 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 ( '89093' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '10' , '10' , '4' , '5.00' , '5' , '0' , '40' , '30.0000' ) 23/11/2023 09:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '21778' AND id_supplier = '38' 23/11/2023 09:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21778' , '38' , '1' ) 23/11/2023 09:28:44 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 ( '89093' , '21490' , 'CALENDARIO LITURGICO 2024 - 8478' , '30' , '30' , '4' , '1.00' , '1' , '0' , '40' , '18.0000' ) 23/11/2023 09:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '21490' AND id_supplier = '38' 23/11/2023 09:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21490' , '38' , '1' ) 23/11/2023 09:28:44 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 ( '89093' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '5' , '5' , '4' , '3.00' , '3' , '0' , '40' , '9.0000' ) 23/11/2023 09:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '7109' AND id_supplier = '38' 23/11/2023 09:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7109' , '38' , '1' ) 23/11/2023 09:28:44 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 ( '89093' , '21900' , 'ATTESA DI DIO - 8559' , '3' , '3' , '4' , '1.50' , '1.5' , '0' , '40' , '2.7000' ) 23/11/2023 09:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '21900' AND id_supplier = '38' 23/11/2023 09:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21900' , '38' , '1' ) 23/11/2023 09:28:44 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 ( '89093' , '11281' , 'VI PARLO DI ME - S. GEMMA GALGANI - 8581' , '1' , '1' , '4' , '12.00' , '12' , '0' , '40' , '7.2000' ) 23/11/2023 09:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '11281' AND id_supplier = '38' 23/11/2023 09:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11281' , '38' , '1' ) 23/11/2023 09:28:44 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 ( '89093' , '6323' , 'MEDAGLIA MIRACOLOSA E CATERINA LABOURÈ - 8814' , '1' , '1' , '4' , '7.00' , '7' , '0' , '40' , '4.2000' ) 23/11/2023 09:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '6323' AND id_supplier = '38' 23/11/2023 09:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6323' , '38' , '1' ) 23/11/2023 09:28:44 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 ( '89093' , '9690' , 'SCAPOLARE DEL CARMELO - 8339' , '1' , '1' , '4' , '5.00' , '5' , '0' , '40' , '3.0000' ) 23/11/2023 09:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '9690' AND id_supplier = '38' 23/11/2023 09:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9690' , '38' , '1' ) 23/11/2023 09:28:44 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 ( '89093' , '21838' , 'CARTOLINA CARLO ACUTIS' , '50' , '50' , '1' , '0.12295' , '0.10077868852459' , '22' , '40' , '4.5000' ) 23/11/2023 09:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '21838' AND id_supplier = '38' 23/11/2023 09:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21838' , '38' , '1' ) 23/11/2023 09:28:44 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 ( '89093' , '21653' , 'AGENDA DEVOZIONALE 2024' , '7' , '7' , '1' , '8.20' , '6.7213114754098' , '22' , '40' , '42.0168' ) 23/11/2023 09:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '21653' AND id_supplier = '38' 23/11/2023 09:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21653' , '38' , '1' ) 23/11/2023 09:28:44 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 ( '89093' , '21652' , 'AGENDA LITURGICO PASTORALE 2024' , '1' , '1' , '1' , '9.84' , '8.0655737704918' , '22' , '40' , '7.2029' ) 23/11/2023 09:28:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '21652' AND id_supplier = '38' 23/11/2023 09:28:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21652' , '38' , '1' ) 23/11/2023 09:35:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3695' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 09:35:51 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' , '3695' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '49.00' , '40.16' , NOW() , NOW() ) 23/11/2023 09:35:51 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 = '89094' 23/11/2023 09:35:51 am >> DELETE FROM ps_document_detail WHERE id_document = '89094' 23/11/2023 09:35:51 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 ( '89094' , '780' , 'ASPERGES MAXI CON CUSTODIA - 700' , '1' , '-1' , '1' , '49.00' , '40.16393442623' , '22' , '0' , '49.00' ) 23/11/2023 09:45:48 am >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'Oi9xD4UEjoanNwWw' , NOW() , NOW() ) 23/11/2023 09:45:48 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4059' , '1' ) 23/11/2023 09:45:49 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4059' , '2' ) 23/11/2023 09:45:49 am >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4059' , '3' ) 23/11/2023 09:47:53 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4059' 23/11/2023 09:47:53 am >> 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 ( '4059' , '10' , '149' , 'PARR. SS. REDENTORE' , 'PEDRANA' , 'DON NATALINO' , 'PIAZZA TOLOMEO GALLIO 3' , '' , '22012' , 'CERNOBBIO' , '' , '031511487' , '3356444343' , '' , '95059180133' , NOW() , NOW() ) 23/11/2023 09:47:53 am >> UPDATE ps_customer SET email = 'donnatalino3@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4059' 23/11/2023 09:48:53 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4059' 23/11/2023 09:48:53 am >> 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 ( '4059' , '10' , '149' , 'PARR. SS. REDENTORE' , 'PEDRANA' , 'DON NATALINO' , 'PIAZZA TOLOMEO GALLIO 3' , '' , '22012' , 'CERNOBBIO' , '' , '031511487' , '3356444343' , '' , '95059180133' , NOW() , NOW() ) 23/11/2023 09:48:53 am >> UPDATE ps_customer SET email = 'donnatalino3@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4059' 23/11/2023 09:57:07 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 ( '32' , '582/23' , '2023-11-20' , '23' , '0' , '159' , '4673403' , 'VIA PANNOSE 45 83025 MONTORO' , '' , '' , '0.00' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '465.92' , '448.00' , NOW() , NOW() ) 23/11/2023 09:57:07 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 = '89095' 23/11/2023 09:57:07 am >> DELETE FROM ps_document_detail WHERE id_document = '89095' 23/11/2023 09:57:07 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 ( '89095' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '100' , '0' , '3' , '4.48' , '4.3076923076923' , '4' , '0' , '465.9200' ) 23/11/2023 09:57:07 am >> DELETE FROM ps_product_supplier WHERE id_product = '21799' AND id_supplier = '159' 23/11/2023 09:57:07 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21799' , '159' , '1' ) 23/11/2023 09:57:30 am >> UPDATE ps_document SET id_document_type = '33', document_num = '1091', document_date = '2023-11-20', document_letter = '', id_customer = '0', id_supplier = '', id_address = '4673403', address1 = 'VIA PANNOSE 45 83025 MONTORO', address2 = '', note = 'cons. 500', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '89046' 23/11/2023 09:57:30 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 = '89046' 23/11/2023 09:57:31 am >> DELETE FROM ps_document_detail WHERE id_document = '89046' 23/11/2023 09:57:31 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 ( '89046' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '100' , '100' , '4' , '0.0000' , '0' , '0' , '0' , '0.0000' ) 23/11/2023 10:11:24 am >> SELECT document_num FROM ps_document WHERE document_num = '284' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 10:11: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 ( '21' , '284' , '2023-11-23' , '' , '4059' , '0' , '4679198' , 'PIAZZA TOLOMEO GALLIO 3 22012 CERNOBBIO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '476.00' , '476.00' , NOW() , NOW() ) 23/11/2023 10:11: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 = '89096' 23/11/2023 10:11:24 am >> DELETE FROM ps_document_detail WHERE id_document = '89096' 23/11/2023 10:11: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 ( '89096' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '200' , '-200' , '4' , '2.80' , '2.8' , '0' , '15' , '476.00' ) 23/11/2023 10:12:02 am >> SELECT document_num FROM ps_document WHERE document_num = '3696' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 10:12:02 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' , '3696' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.40' , '11.40' , NOW() , NOW() ) 23/11/2023 10:12:02 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 = '89097' 23/11/2023 10:12:02 am >> DELETE FROM ps_document_detail WHERE id_document = '89097' 23/11/2023 10:12:02 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 ( '89097' , '21780' , 'FRATELLINO' , '1' , '-1' , '4' , '12.00' , '12' , '0' , '5' , '11.40' ) 23/11/2023 10:17:28 am >> SELECT document_num FROM ps_document WHERE document_num = '284' AND id_document != '89096' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 10:17:28 am >> UPDATE ps_document SET id_document_type = '21', document_num = '284', document_date = '2023-11-23', document_letter = '', id_customer = '4059', id_supplier = '', id_address = '4679198', address1 = 'PIAZZA TOLOMEO GALLIO 3 22012 CERNOBBIO', 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 = '476.00', price_tax_excluded = '476.00', date_upd = NOW() WHERE id_document = '89096' 23/11/2023 10:17:28 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89096' 23/11/2023 10:17:28 am >> DELETE FROM ps_document_detail WHERE id_document = '89096' 23/11/2023 10:17:28 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89096' , '20952' , 'VANGELO E ATTI DEGLI APOSTOLI - ragazzi' , '200' , '-200' , '4' , '2.8000' , '2.8' , '0' , '15' , '476.00' ) 23/11/2023 10:53:53 am >> SELECT document_num FROM ps_document WHERE document_num = '136/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 10:53:53 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 ( '24' , '136/A' , '2023-11-23' , 'A' , '3030' , '0' , '4671709' , 'VIA SAN FELICE IN FELLINE, 10 84134 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.60' , '150.60' , NOW() , NOW() ) 23/11/2023 10:53:53 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 = '89098' 23/11/2023 10:53:53 am >> DELETE FROM ps_document_detail WHERE id_document = '89098' 23/11/2023 10:53:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89098' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '960' , '-960' , '4' , '0.04' , '0.04' , '0' , '0' , '38.40' ) 23/11/2023 10:53:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89098' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '80' , '-80' , '4' , '0.04' , '0.04' , '0' , '0' , '3.20' ) 23/11/2023 10:53:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89098' , '' , 'CUSCINO' , '1' , '-1' , '4' , '22' , '22' , '0' , '0' , '22.00' ) 23/11/2023 10:53:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89098' , '19072' , 'BAMBINELLO CON AUREOLA CM 37 - PB9257' , '1' , '-1' , '0' , '87.00' , '87' , '' , '0' , '87.00' ) 23/11/2023 10:58:50 am >> SELECT document_num FROM ps_document WHERE document_num = '285' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 10:58:50 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' , '285' , '2023-11-23' , '' , '2823' , '0' , '4672634' , 'VIA ROMA, 1 83028 SERINO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '55.93' , '55.93' , NOW() , NOW() ) 23/11/2023 10:58:50 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 = '89099' 23/11/2023 10:58:50 am >> DELETE FROM ps_document_detail WHERE id_document = '89099' 23/11/2023 10:58:50 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 ( '89099' , '8408' , 'PRENDETE E MANGIATE' , '8' , '-8' , '4' , '3.00' , '3' , '0' , '15' , '20.40' ) 23/11/2023 10:58:50 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 ( '89099' , '4154' , 'FESTA DEL PERDONO' , '9' , '-9' , '4' , '3.00' , '3' , '0' , '15' , '22.95' ) 23/11/2023 10:58:50 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 ( '89099' , '8488' , 'PRIMA CONFESSIONE E MESSA PRIMA COMUNIONE' , '2' , '-2' , '4' , '2.40' , '2.4' , '0' , '15' , '4.08' ) 23/11/2023 10:58:50 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 ( '89099' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 23/11/2023 10:58:50 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 ( '89099' , '4155' , 'FESTA DEL PERDONO - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '15' , '4.25' ) 23/11/2023 10:59:51 am >> SELECT document_num FROM ps_document WHERE document_num = '3697' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 10:59:51 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' , '3697' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '75.05' , '73.85' , NOW() , NOW() ) 23/11/2023 10:59:51 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 = '89100' 23/11/2023 10:59:51 am >> DELETE FROM ps_document_detail WHERE id_document = '89100' 23/11/2023 10:59:51 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 ( '89100' , '12819' , 'REGISTRO DEL CATECHISTA ' , '7' , '-7' , '1' , '1.00' , '0.81967213114754' , '22' , '5' , '6.65' ) 23/11/2023 10:59:51 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 ( '89100' , '8599' , 'IO SONO CON VOI 2 - MAGNIFICAT' , '9' , '-9' , '4' , '3.00' , '3' , '0' , '5' , '25.65' ) 23/11/2023 10:59:51 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 ( '89100' , '8602' , 'VENITE CON ME 1 - MAGNIFICAT' , '9' , '-9' , '4' , '3.00' , '3' , '0' , '5' , '25.65' ) 23/11/2023 10:59:51 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 ( '89100' , '8603' , 'VENITE CON ME 2 - MAGNIFICAT' , '6' , '-6' , '4' , '3.00' , '3' , '0' , '5' , '17.10' ) 23/11/2023 11:01:27 am >> SELECT document_num FROM ps_document WHERE document_num = '3698' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 11:01: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' , '3698' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.25' , '17.53' , NOW() , NOW() ) 23/11/2023 11:01: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 = '89101' 23/11/2023 11:01:27 am >> DELETE FROM ps_document_detail WHERE id_document = '89101' 23/11/2023 11:01: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 ( '89101' , '941' , 'BAMBINO CM 5 - CARNE - PX' , '10' , '-10' , '1' , '0.40' , '0.32786885245902' , '22' , '0' , '4.00' ) 23/11/2023 11:01: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 ( '89101' , '21778' , 'SULLA TUA PAROLA - GEN/FEB 2024' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 23/11/2023 11:02:06 am >> SELECT document_num FROM ps_document WHERE document_num = '3699' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 11:02: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' , '3699' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.00' , '63.93' , NOW() , NOW() ) 23/11/2023 11:02: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 = '89102' 23/11/2023 11:02:06 am >> DELETE FROM ps_document_detail WHERE id_document = '89102' 23/11/2023 11:02: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 ( '89102' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 23/11/2023 11:02: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 ( '89102' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '20' , '-20' , '1' , '1.40' , '1.1475409836066' , '22' , '0' , '28.00' ) 23/11/2023 11:15:04 am >> SELECT document_num FROM ps_document WHERE document_num = '3700' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 11:15: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' , '3700' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '250.00' , '204.92' , NOW() , NOW() ) 23/11/2023 11:15: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 = '89103' 23/11/2023 11:15:04 am >> DELETE FROM ps_document_detail WHERE id_document = '89103' 23/11/2023 11:15: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 ( '89103' , '20273' , 'CASULA IHS - 220' , '1' , '-1' , '1' , '70.00' , '57.377049180328' , '22' , '0' , '70.00' ) 23/11/2023 11:15:05 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 ( '89103' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '180' , '147.54098360656' , '22' , '0' , '180.00' ) 23/11/2023 11:17:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3701' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 11:17:17 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' , '3701' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '53.65' , '52.03' , NOW() , NOW() ) 23/11/2023 11:17:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89104' 23/11/2023 11:17:17 am >> DELETE FROM ps_document_detail WHERE id_document = '89104' 23/11/2023 11:17:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89104' , '21755' , 'PAROLA DI DIO OGNI GIORNO 2024 - V. PAGLIA' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 23/11/2023 11:17:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89104' , '21665' , 'GRIDIAMO IL VANGELO - A. COMASTRI' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '5' , '23.75' ) 23/11/2023 11:17:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89104' , '6322' , 'MEDAGLIA MIRACOLOSA BAGNO ORO 24KT MM22 - 064022MI ' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 23/11/2023 11:20:17 am >> SELECT document_num FROM ps_document WHERE document_num = '3702' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 11:20:17 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' , '3702' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.75' , '16.30' , NOW() , NOW() ) 23/11/2023 11:20:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89105' 23/11/2023 11:20:17 am >> DELETE FROM ps_document_detail WHERE id_document = '89105' 23/11/2023 11:20:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89105' , '21896' , '365 GIORNI CON L. PICCARETA' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 23/11/2023 11:20:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89105' , '14772' , 'BRACCIALE SAN BENEDETTO 4 COLORI - 0818/3' , '1' , '-1' , '1' , '2.50' , '2.0491803278689' , '22' , '0' , '2.50' ) 23/11/2023 11:32:47 am >> SELECT document_num FROM ps_document WHERE document_num = '3703' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 11:32:47 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' , '3703' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '8.20' , NOW() , NOW() ) 23/11/2023 11:32:47 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 = '89106' 23/11/2023 11:32:47 am >> DELETE FROM ps_document_detail WHERE id_document = '89106' 23/11/2023 11:32:47 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 ( '89106' , '21653' , 'AGENDA DEVOZIONALE 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 23/11/2023 12:04:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '286' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 12:04: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 ( '21' , '286' , '2023-11-23' , '' , '2320' , '0' , '4677538' , 'VIA CONVENTO, 12 75011 ACCETTURA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '28.80' , '28.80' , NOW() , NOW() ) 23/11/2023 12:04: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 = '89107' 23/11/2023 12:04:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '89107' 23/11/2023 12:04: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 ( '89107' , '5457' , 'IO SONO CON VOI 1 PARTE' , '10' , '-10' , '4' , '2.80' , '2.8' , '0' , '15' , '23.80' ) 23/11/2023 12:19:17 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' , '181942' , '2023-11-21' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '18.50' , '18.50' , NOW() , NOW() ) 23/11/2023 12:19: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 = '89108' 23/11/2023 12:19:17 pm >> DELETE FROM ps_document_detail WHERE id_document = '89108' 23/11/2023 12:19: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 ( '89108' , '4149' , 'FENOMENO RELIGIOSO' , '1' , '1' , '4' , '18.50' , '18.5' , '0' , '0' , '18.50' ) 23/11/2023 12:19:17 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4149' AND id_supplier = '109' 23/11/2023 12:19:17 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4149' , '109' , '1' ) 23/11/2023 12:34:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3704' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 12:34:49 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' , '3704' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 23/11/2023 12:34:49 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 = '89109' 23/11/2023 12:34:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '89109' 23/11/2023 12:34:49 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 ( '89109' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '4' , '-4' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '14.00' ) 23/11/2023 02:13:45 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'BSnBpWeMFuyw2aUY' , NOW() , NOW() ) 23/11/2023 02:13:45 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4060' , '1' ) 23/11/2023 02:13:46 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4060' , '2' ) 23/11/2023 02:13:46 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '4060' , '3' ) 23/11/2023 02:14:01 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 23/11/2023 02:14:01 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21901' , '1' , '' , 'nuovo-prodotto' ) 23/11/2023 02:14:01 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21901' , '1' , '1' , '2' , NOW() , NOW() ) 23/11/2023 02:14:01 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21901' , '0' , '1' , '0' , '0' ) 23/11/2023 02:15:44 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4060' 23/11/2023 02:15:44 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 ( '4060' , '10' , '229' , 'PARROCCHIA DI CADEGLIOPPI' , '' , '' , 'PIAZZA DONATORI DI SANGUE 1' , '' , '37050' , 'CADEGLIOPPI DI OPPEANO ' , '' , '' , '' , '' , '' , NOW() , NOW() ) 23/11/2023 02:15:44 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4060' 23/11/2023 02:17:17 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4060' 23/11/2023 02:17:17 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 ( '4060' , '10' , '229' , 'PARROCCHIA DI CADEGLIOPPI' , 'MANARA' , 'DON FILIPPO' , 'PIAZZA DONATORI DI SANGUE 1' , '' , '37050' , 'CADEGLIOPPI DI OPPEANO ' , '' , '' , '349 0871619' , '' , '' , NOW() , NOW() ) 23/11/2023 02:17:17 pm >> UPDATE ps_customer SET email = 'donfilippomanara@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4060' 23/11/2023 02:17:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '287' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 02:17:54 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' , '287' , '2023-11-23' , '' , '4060' , '0' , '4679200' , 'PIAZZA DONATORI DI SANGUE 1 37050 CADEGLIOPPI DI OPPEANO ' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '20.96' , '20.96' , NOW() , NOW() ) 23/11/2023 02:17:54 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 = '89110' 23/11/2023 02:17:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '89110' 23/11/2023 02:17:54 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 ( '89110' , '11192' , 'VENITE CON ME 2 PARTE' , '6' , '-6' , '4' , '2.80' , '2.8' , '0' , '5' , '15.96' ) 23/11/2023 02:19:01 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4060' 23/11/2023 02:19:01 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 ( '4060' , '10' , '229' , 'PARROCCHIA DI CADEGLIOPPI' , 'MANARA' , 'DON FILIPPO' , 'PIAZZA DONATORI DI SANGUE 1' , '' , '37050' , 'CADEGLIOPPI DI OPPEANO ' , '' , '' , '349 0871619' , '' , '' , NOW() , NOW() ) 23/11/2023 02:19:01 pm >> UPDATE ps_customer SET email = 'donfilippomanara@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4060' 23/11/2023 02:58:33 pm >> INSERT INTO ps_supplier ( name , email , `date_add` , `date_upd` ) VALUES ( '' , '' , NOW() , NOW() ) 23/11/2023 02:58:33 pm >> INSERT INTO ps_supplier_shop ( id_supplier , id_shop ) VALUES ( '185' , '1' ) 23/11/2023 02:58:33 pm >> INSERT INTO ps_supplier_lang ( id_supplier , id_lang ) VALUES ( '185' , '1' ) 23/11/2023 02:58:33 pm >> INSERT INTO ps_address ( id_supplier , id_country , id_state , alias , lastname , firstname , address1 , city , date_add , date_upd ) VALUES ( '185' , '10' , '0' , '' , '' , '' , '' , '' , NOW() , NOW() ) 23/11/2023 03:00:50 pm >> UPDATE ps_address SET id_state = '173', lastname = 'CASA D\'ARTE PROF. LANDO LANDI', address1 = 'VIALE C. CASTRACANI TRAV 4 N. 131', address2 = '', postcode = '55100', dni = 'LNDGNC53A22E715H', vat_number = '00256150467', city = 'LUCCA', phone = '0583467467', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '185' 23/11/2023 03:00:50 pm >> UPDATE ps_supplier SET email = 'giulland@tin.it', name = 'CASA D\'ARTE PROF. LANDO LANDI', date_upd = NOW() WHERE id_supplier = '185' 23/11/2023 03:00:50 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '185' 23/11/2023 03:01:12 pm >> INSERT INTO ps_category ( id_parent , `date_add` , `date_upd` , level_depth ) VALUES ( '4' , NOW() , NOW() , '3' ) 23/11/2023 03:01:12 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '529' , '1' ) 23/11/2023 03:01:12 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '529' , '2' ) 23/11/2023 03:01:12 pm >> INSERT INTO ps_category_group ( id_category , id_group ) VALUES ( '529' , '3' ) 23/11/2023 03:01:12 pm >> INSERT INTO ps_category_lang ( id_category , id_lang , name , link_rewrite ) VALUES ( '529' , '1' , 'LANDO LANDI' , LOWER('LANDO-LANDI') ) 23/11/2023 03:01:12 pm >> INSERT INTO ps_category_shop ( id_category , id_shop , position ) VALUES ( '529' , '1' , '0' ) 23/11/2023 03:04:29 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002208' AND id_product != '21901' AND ean13 != '' 23/11/2023 03:04:29 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002208', date_upd = NOW() WHERE id_product = '21901' 23/11/2023 03:04:29 pm >> UPDATE ps_product_lang SET name = 'BAMBINO SDRAIATO OCCHI CRIST. CM 46 - 7/46', description = '' WHERE id_product = '21901' 23/11/2023 03:04:29 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '367.21311475409834' WHERE id_product = '21901' 23/11/2023 03:04:29 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '367.21311475409834', id_tax_rules_group = '1', id_category_default = '529', 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 = '21901' 23/11/2023 03:04:29 pm >> DELETE FROM ps_specific_price WHERE id_product = '21901' 23/11/2023 03:04:30 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 = '21901' 23/11/2023 03:04:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21902' , '1' , '' , 'nuovo-prodotto' ) 23/11/2023 03:04:30 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 '21902' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21901' 23/11/2023 03:04:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21902' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21901' 23/11/2023 03:06:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002209' AND id_product != '21902' AND ean13 != '' 23/11/2023 03:06:04 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002209', date_upd = NOW() WHERE id_product = '21902' 23/11/2023 03:06:04 pm >> UPDATE ps_product_lang SET name = 'BAMBINO OCCHI DIPINTI CM 30 - 30/PL', description = '' WHERE id_product = '21902' 23/11/2023 03:06:04 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '127.04918032786885' WHERE id_product = '21902' 23/11/2023 03:06:04 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '127.04918032786885', id_tax_rules_group = '1', id_category_default = '529', 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 = '21902' 23/11/2023 03:06:04 pm >> DELETE FROM ps_specific_price WHERE id_product = '21902' 23/11/2023 03:06:04 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 = '21902' 23/11/2023 03:06:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21903' , '1' , '' , 'nuovo-prodotto' ) 23/11/2023 03:06:04 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 '21903' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21902' 23/11/2023 03:06:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21903' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21902' 23/11/2023 03:07:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002210' AND id_product != '21903' AND ean13 != '' 23/11/2023 03:07:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002210', date_upd = NOW() WHERE id_product = '21903' 23/11/2023 03:07:49 pm >> UPDATE ps_product_lang SET name = 'BAMBINO BETLEMME CM 50 - 50/B', description = '' WHERE id_product = '21903' 23/11/2023 03:07:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '449.1803278688525' WHERE id_product = '21903' 23/11/2023 03:07:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '449.1803278688525', id_tax_rules_group = '1', id_category_default = '529', 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 = '21903' 23/11/2023 03:07:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '21903' 23/11/2023 03:07:52 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 = '21903' 23/11/2023 03:07:52 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21904' , '1' , '' , 'nuovo-prodotto' ) 23/11/2023 03:07:52 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 '21904' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21903' 23/11/2023 03:07:52 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21904' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21903' 23/11/2023 03:09:28 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002211' AND id_product != '21904' AND ean13 != '' 23/11/2023 03:09:28 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002211', date_upd = NOW() WHERE id_product = '21904' 23/11/2023 03:09:28 pm >> UPDATE ps_product_lang SET name = 'BAMBINO BAROCCO 800 NAPOLETANO CM 50 - 50/N', description = '' WHERE id_product = '21904' 23/11/2023 03:09:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '463.11475409836066' WHERE id_product = '21904' 23/11/2023 03:09:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '463.11475409836066', id_tax_rules_group = '1', id_category_default = '529', 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 = '21904' 23/11/2023 03:09:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '21904' 23/11/2023 03:09:29 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 = '21904' 23/11/2023 03:09:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21905' , '1' , '' , 'nuovo-prodotto' ) 23/11/2023 03:09:30 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 '21905' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21904' 23/11/2023 03:09:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21905' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21904' 23/11/2023 03:09:49 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002210' AND id_product != '21903' AND ean13 != '' 23/11/2023 03:09:49 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002210', date_upd = NOW() WHERE id_product = '21903' 23/11/2023 03:09:49 pm >> UPDATE ps_product_lang SET name = 'BAMBINO BETLEMME CM 50 - 50/B', description = '' WHERE id_product = '21903' 23/11/2023 03:09:49 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '441.8032786885246' WHERE id_product = '21903' 23/11/2023 03:09:49 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '441.8032786885246', id_tax_rules_group = '1', id_category_default = '529', 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 = '21903' 23/11/2023 03:09:49 pm >> DELETE FROM ps_specific_price WHERE id_product = '21903' 23/11/2023 03:13:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '3705' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 03:13:31 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' , '3705' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '350.00' , '286.89' , NOW() , NOW() ) 23/11/2023 03:13:31 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 = '89111' 23/11/2023 03:13:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '89111' 23/11/2023 03:13:31 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 ( '89111' , '21691' , 'PENDENTE FF 10X11' , '35' , '-35' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '350.00' ) 23/11/2023 03:18:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '3706' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 03:18: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 ( '11' , '3706' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 23/11/2023 03:18: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 = '89112' 23/11/2023 03:18:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '89112' 23/11/2023 03:18: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 ( '89112' , '12917' , 'CONFEZIONE CON ANGELO IN LEGNO - P499' , '4' , '-4' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '14.00' ) 23/11/2023 03:27:40 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002212' AND id_product != '21905' AND ean13 != '' 23/11/2023 03:27:40 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002212', date_upd = NOW() WHERE id_product = '21905' 23/11/2023 03:27:40 pm >> UPDATE ps_product_lang SET name = 'CROCIFISSO CON CROCE - 59/55', description = '' WHERE id_product = '21905' 23/11/2023 03:27:40 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '151.63934426229508' WHERE id_product = '21905' 23/11/2023 03:27:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '151.63934426229508', id_tax_rules_group = '1', id_category_default = '529', 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 = '21905' 23/11/2023 03:27:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '21905' 23/11/2023 03:45:09 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' , '61/2023' , '2023-11-23' , '2023' , '0' , '185' , '4679202' , 'VIALE C. CASTRACANI TRAV 4 N. 131 55100 LUCCA' , '' , '' , '50' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '1031.88' , '845.80' , NOW() , NOW() ) 23/11/2023 03:45:09 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 = '89113' 23/11/2023 03:45:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '89113' 23/11/2023 03:45:09 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 ( '89113' , '21901' , 'BAMBINO SDRAIATO OCCHI CRIST. CM 46 - 7/46' , '1' , '1' , '1' , '190.58' , '156.2131147541' , '22' , '0' , '232.5076' ) 23/11/2023 03:45:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21901' AND id_supplier = '185' 23/11/2023 03:45:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21901' , '185' , '1' ) 23/11/2023 03:45:09 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 ( '89113' , '21902' , 'BAMBINO OCCHI DIPINTI CM 30 - 30/PL' , '1' , '1' , '1' , '63.53' , '52.073770491803' , '22' , '0' , '77.5066' ) 23/11/2023 03:45:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21902' AND id_supplier = '185' 23/11/2023 03:45:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21902' , '185' , '1' ) 23/11/2023 03:45:09 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 ( '89113' , '21903' , 'BAMBINO BETLEMME CM 50 - 50/B' , '1' , '1' , '1' , '228.69' , '187.45081967213' , '22' , '0' , '279.0018' ) 23/11/2023 03:45:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21903' AND id_supplier = '185' 23/11/2023 03:45:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21903' , '185' , '1' ) 23/11/2023 03:45:09 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 ( '89113' , '21904' , 'BAMBINO BAROCCO 800 NAPOLETANO CM 50 - 50/N' , '1' , '1' , '1' , '236.78' , '194.08196721311' , '22' , '0' , '288.8716' ) 23/11/2023 03:45:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21904' AND id_supplier = '185' 23/11/2023 03:45:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21904' , '185' , '1' ) 23/11/2023 03:45:09 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 ( '89113' , '21905' , 'CROCIFISSO CON CROCE - 59/55' , '1' , '1' , '1' , '76.22' , '62.475409836066' , '22' , '0' , '92.9884' ) 23/11/2023 03:45:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21905' AND id_supplier = '185' 23/11/2023 03:45:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21905' , '185' , '1' ) 23/11/2023 04:00:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3707' AND id_document != '' AND id_document_type LIKE '12' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 04:00: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 ( '11' , '3707' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '7.79' , NOW() , NOW() ) 23/11/2023 04:00: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 = '89114' 23/11/2023 04:00:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '89114' 23/11/2023 04:00: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 ( '89114' , '21653' , 'AGENDA DEVOZIONALE 2024' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '5' , '9.50' ) 23/11/2023 04:08:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '3708' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 04:08: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' , '3708' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.00' , '92.81' , NOW() , NOW() ) 23/11/2023 04:08: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 = '89115' 23/11/2023 04:08:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '89115' 23/11/2023 04:08: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 ( '89115' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.04' , '0.04' , '0' , '0' , '25.60' ) 23/11/2023 04:08: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 ( '89115' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '4' , '-4' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '8.00' ) 23/11/2023 04:08: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 ( '89115' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.90' , '5.655737704918' , '22' , '0' , '13.80' ) 23/11/2023 04:08: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 ( '89115' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 23/11/2023 04:08: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 ( '89115' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '7.00' ) 23/11/2023 04:08: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 ( '89115' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '0' , '12.00' ) 23/11/2023 04:08: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 ( '89115' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '22.8' , '18.688524590164' , '22' , '0' , '22.80' ) 23/11/2023 04:13:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '3709' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 04:13: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' , '3709' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '29.00' , '23.77' , NOW() , NOW() ) 23/11/2023 04:13: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 = '89116' 23/11/2023 04:13:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '89116' 23/11/2023 04:13: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 ( '89116' , '20707' , 'LUME LEGNO' , '1' , '-1' , '1' , '29' , '23.770491803279' , '22' , '0' , '29.00' ) 23/11/2023 04:15:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3710' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 04:15: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 ( '11' , '3710' , '2023-11-23' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.90' , '7.30' , NOW() , NOW() ) 23/11/2023 04:15: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 = '89117' 23/11/2023 04:15:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '89117' 23/11/2023 04:15: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 ( '89117' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '8.90' , '7.2950819672131' , '22' , '0' , '8.90' ) 23/11/2023 05:41:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '109' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-23') 23/11/2023 05:41:48 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' , '109' , '2023-11-23' , '' , '6526' , '0' , '9339192' , 'CORSO VITTORIO EMANUELE, 198 85058 VIETRI DI POTENZA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.00' , '6.00' , NOW() , NOW() ) 23/11/2023 05:41:48 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 = '13755' 23/11/2023 05:41:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '13755' 23/11/2023 05: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 ( '13755' , '17' , 'LA FEDE NELLO ZAINETTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '0' , '6.00' ) 23/11/2023 05:42:25 pm >> DELETE FROM ps_document WHERE id_document = '13755' 23/11/2023 05:42:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '13755' 23/11/2023 05:43:44 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '4060' 23/11/2023 05:43:44 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 ( '4060' , '10' , '229' , 'PARROCCHIA DI CADEGLIOPPI' , 'MANARA' , 'DON FILIPPO' , 'PIAZZA DONATORI DI SANGUE 1' , '' , '37050' , 'CADEGLIOPPI DI OPPEANO ' , '' , '' , '349 0871619' , '' , '' , NOW() , NOW() ) 23/11/2023 05:43:44 pm >> UPDATE ps_customer SET email = 'donfilippomanara@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '4060' 23/11/2023 06:06:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '498' AND id_document != '81335' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-02-13') 23/11/2023 06:06:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '498', document_date = '2023-02-13', 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 = '135.00', price_tax_excluded = '110.66', date_upd = NOW() WHERE id_document = '81335' 23/11/2023 06:06: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 = '81335' 23/11/2023 06:06:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '81335' 23/11/2023 06:06: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 ( '81335' , '14578' , 'CAMICE GOTICO - MISTO LANA LEGGERO - 328' , '1' , '-1' , '1' , '135' , '110.65573770492' , '22' , '0' , '135.00' )