29/11/2023 09:39:43 am >> SELECT document_num FROM ps_document WHERE document_num = '3784' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 09:39: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 ( '11' , '3784' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.30' , '4.13' , NOW() , NOW() ) 29/11/2023 09:39: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 = '89210' 29/11/2023 09:39:43 am >> DELETE FROM ps_document_detail WHERE id_document = '89210' 29/11/2023 09:39: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 ( '89210' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 29/11/2023 09:53:32 am >> SELECT document_num FROM ps_document WHERE document_num = '3785' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 09:53:32 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' , '3785' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '22.00' , '19.94' , NOW() , NOW() ) 29/11/2023 09:53:32 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 = '89211' 29/11/2023 09:53:32 am >> DELETE FROM ps_document_detail WHERE id_document = '89211' 29/11/2023 09:53:32 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 ( '89211' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 29/11/2023 09:53:32 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 ( '89211' , '21663' , 'CORAGGIO DI UNA DONNA ' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/11/2023 09:53:32 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 ( '89211' , '21737' , 'NOVENA ALLIMMACOLATA - BENEDETTO XVI' , '2' , '-2' , '4' , '1.50' , '1.5' , '0' , '0' , '3.00' ) 29/11/2023 09:53:32 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 ( '89211' , '21652' , 'AGENDA LITURGICO PASTORALE 2024' , '1' , '-1' , '1' , '12.00' , '9.8360655737705' , '22' , '5' , '11.40' ) 29/11/2023 10:06:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3786' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 10:06:46 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' , '3786' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 29/11/2023 10:06:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89212' 29/11/2023 10:06:46 am >> DELETE FROM ps_document_detail WHERE id_document = '89212' 29/11/2023 10:06: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 ( '89212' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 29/11/2023 10:17:46 am >> SELECT document_num FROM ps_document WHERE document_num = '3787' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 10:17:46 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' , '3787' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '39.30' , '35.55' , NOW() , NOW() ) 29/11/2023 10:17:46 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89213' 29/11/2023 10:17:46 am >> DELETE FROM ps_document_detail WHERE id_document = '89213' 29/11/2023 10:17: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 ( '89213' , '20433' , 'PARTICOLA MORREALE 38MM - PTC38S' , '5' , '-5' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '17.50' ) 29/11/2023 10:17: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 ( '89213' , '7311' , 'OSTIA SOTTILE 74MM' , '3' , '-3' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '6.00' ) 29/11/2023 10:17: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 ( '89213' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '15.80' ) 29/11/2023 11:30:01 am >> SELECT document_num FROM ps_document WHERE document_num = '3788' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 11:30:01 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3788' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.95' , '4.95' , NOW() , NOW() ) 29/11/2023 11:30:01 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89214' 29/11/2023 11:30:01 am >> DELETE FROM ps_document_detail WHERE id_document = '89214' 29/11/2023 11:30:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89214' , '21069' , 'MARIA ROSA MISTICA - 8093' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 29/11/2023 11:30:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89214' , '15866' , 'PICCOLA CORONA DELLA SANTA VERGINE - 8939' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 29/11/2023 11:30:01 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89214' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '0.6' , '0.6' , '0' , '0' , '0.60' ) 29/11/2023 11:44:41 am >> SELECT document_num FROM ps_document WHERE document_num = '3789' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 11:44:42 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3789' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.79' , '20.79' , NOW() , NOW() ) 29/11/2023 11:44:42 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89215' 29/11/2023 11:44:42 am >> DELETE FROM ps_document_detail WHERE id_document = '89215' 29/11/2023 11:44:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89215' , '10712' , 'TRATTATO DELLA VERA DEVOZIONE A MARIA - 8113' , '1' , '-1' , '4' , '9.00' , '9' , '0' , '5' , '8.55' ) 29/11/2023 11:44:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89215' , '21578' , 'CERCATE E TROVERETE ' , '1' , '-1' , '4' , '3.80' , '3.8' , '0' , '5' , '3.61' ) 29/11/2023 11:44:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89215' , '21737' , 'NOVENA ALLIMMACOLATA - BENEDETTO XVI' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 29/11/2023 11:44:42 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89215' , '17359' , 'SGUARDO DI UN AMORE CHE E DONO' , '1' , '-1' , '4' , '7.50' , '7.5' , '0' , '5' , '7.13' ) 29/11/2023 11:56:44 am >> SELECT document_num FROM ps_document WHERE document_num = '3790' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 11:56:44 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' , '3790' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 29/11/2023 11:56:44 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 = '89216' 29/11/2023 11:56:44 am >> DELETE FROM ps_document_detail WHERE id_document = '89216' 29/11/2023 11:56: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 ( '89216' , '21884' , 'ASCOLTARLO ERA RIMANERE - ANNO B - E. RONCHI' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 29/11/2023 12:16:20 pm >> 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-29') 29/11/2023 12:16:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '136/A' , '2023-11-29' , 'A' , '189' , '0' , '4679063' , 'VIA NAZIONALE APPIA, 128 81022 CASAGIOVE' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '89.32' , '89.32' , NOW() , NOW() ) 29/11/2023 12:16:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89217' 29/11/2023 12:16:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '89217' 29/11/2023 12:16:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89217' , '8510' , 'PRIMI PASSI CON GESÙ - ANNO B' , '20' , '-20' , '4' , '3.40' , '3.4' , '0' , '38' , '42.16' ) 29/11/2023 12:16:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89217' , '8511' , 'PRIMI PASSI CON GESÙ - ANNO C' , '20' , '-20' , '4' , '3.40' , '3.4' , '0' , '38' , '42.16' ) 29/11/2023 12:20:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '3791' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 12:20:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3791' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '13.11' , NOW() , NOW() ) 29/11/2023 12:20:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89218' 29/11/2023 12:20:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '89218' 29/11/2023 12:20:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89218' , '16793' , 'SOPRACULLA 9X13' , '1' , '-1' , '1' , '16.00' , '13.114754098361' , '22' , '0' , '16.00' ) 29/11/2023 12:34:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001306' AND id_product != '16374' AND ean13 != '' 29/11/2023 12:34:39 pm >> UPDATE ps_product SET id_supplier = '122', reference = '', ean13 = '001306', date_upd = NOW() WHERE id_product = '16374' 29/11/2023 12:34:39 pm >> UPDATE ps_product_lang SET name = 'CASULA ROSA', description = '' WHERE id_product = '16374' 29/11/2023 12:34:39 pm >> UPDATE ps_product SET wholesale_price = '27.50', on_sale = '0', price = '67.21311475409836' WHERE id_product = '16374' 29/11/2023 12:34:39 pm >> UPDATE ps_product_shop SET wholesale_price = '27.50', price = '67.21311475409836', id_tax_rules_group = '1', id_category_default = '440', 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 = '16374' 29/11/2023 12:34:39 pm >> DELETE FROM ps_specific_price WHERE id_product = '16374' 29/11/2023 12:35:14 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 29/11/2023 12:35:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21916' , '1' , '' , 'nuovo-prodotto' ) 29/11/2023 12:35:14 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21916' , '1' , '1' , '2' , NOW() , NOW() ) 29/11/2023 12:35:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21916' , '0' , '1' , '0' , '0' ) 29/11/2023 12:35:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'CUNC01' AND id_product != '21916' AND ean13 != '' 29/11/2023 12:35:58 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'CUNC01', date_upd = NOW() WHERE id_product = '21916' 29/11/2023 12:35:58 pm >> UPDATE ps_product_lang SET name = 'TOVAGLIA D\'ALTARE MORELLO', description = '' WHERE id_product = '21916' 29/11/2023 12:35:58 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '114.75409836065575' WHERE id_product = '21916' 29/11/2023 12:35:58 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '114.75409836065575', id_tax_rules_group = '1', id_category_default = '440', 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 = '21916' 29/11/2023 12:35:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '21916' 29/11/2023 12:36: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 ( '33' , '1053' , '2023-11-28' , '' , '0' , '122' , '4669556' , 'VIA XXV APRILE, 17 24050 GRASSOBBIO' , '' , '' , '14' , '1' , '0' , '0' , '0' , '' , '3' , '0' , '186.05' , '152.50' , NOW() , NOW() ) 29/11/2023 12:36: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 = '89219' 29/11/2023 12:36:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '89219' 29/11/2023 12:36: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 ( '89219' , '16374' , 'CASULA ROSA' , '1' , '1' , '1' , '33.5' , '27.459016393443' , '22' , '0' , '40.8700' ) 29/11/2023 12:36:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16374' AND id_supplier = '122' 29/11/2023 12:36:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16374' , '122' , '1' ) 29/11/2023 12:36: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 ( '89219' , '18880' , 'COPRILEGGIO MORELLO' , '2' , '2' , '1' , '25' , '20.491803278689' , '22' , '0' , '61.0000' ) 29/11/2023 12:36:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18880' AND id_supplier = '122' 29/11/2023 12:36:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18880' , '122' , '1' ) 29/11/2023 12:36: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 ( '89219' , '21916' , 'TOVAGLIA DALTARE MORELLO' , '1' , '1' , '1' , '55' , '45.081967213115' , '22' , '0' , '67.1000' ) 29/11/2023 12:36:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21916' AND id_supplier = '122' 29/11/2023 12:36:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21916' , '122' , '1' ) 29/11/2023 03:05:08 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' , '1311' , '2023-11-27' , '' , '0' , '157' , '4673300' , '10 AGIAS ANNIS STR 17778 ATHENS - GRECIA' , '' , 'mancano 12 carboncini 40mm' , '126' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1412.50' , '1412.50' , NOW() , NOW() ) 29/11/2023 03:05:08 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 = '89220' 29/11/2023 03:05:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '89220' 29/11/2023 03:05:08 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 ( '89220' , '19099' , 'INCENSO A' , '8' , '8' , '0' , '19' , '19' , '' , '0' , '152.0000' ) 29/11/2023 03:05:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19099' AND id_supplier = '157' 29/11/2023 03:05:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19099' , '157' , '1' ) 29/11/2023 03:05:08 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 ( '89220' , '19818' , 'INCENSO NATURALE 3A KG 1' , '20' , '20' , '0' , '6.6' , '6.6' , '' , '0' , '132.0000' ) 29/11/2023 03:05:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '157' 29/11/2023 03:05:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '157' , '1' ) 29/11/2023 03:05:08 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 ( '89220' , '19102' , 'CARBONCINI MM 40' , '36' , '36' , '0' , '4' , '4' , '' , '0' , '144.0000' ) 29/11/2023 03:05:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19102' AND id_supplier = '157' 29/11/2023 03:05:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19102' , '157' , '1' ) 29/11/2023 03:05:08 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 ( '89220' , '1710' , 'CARBONCINI PER TURIBOLO BIANCHI - PZ 120' , '60' , '60' , '0' , '3' , '3' , '' , '0' , '180.0000' ) 29/11/2023 03:05:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1710' AND id_supplier = '157' 29/11/2023 03:05:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1710' , '157' , '1' ) 29/11/2023 03:05:08 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 ( '89220' , '19106' , 'FRAGRANZA NARDO' , '25' , '25' , '0' , '2.9' , '2.9' , '' , '0' , '72.5000' ) 29/11/2023 03:05:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19106' AND id_supplier = '157' 29/11/2023 03:05:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19106' , '157' , '1' ) 29/11/2023 03:05:08 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 ( '89220' , '19104' , 'LUMINELLI A OLIO' , '100' , '100' , '0' , '0.12' , '0.12' , '' , '0' , '12.0000' ) 29/11/2023 03:05:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19104' AND id_supplier = '157' 29/11/2023 03:05:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19104' , '157' , '1' ) 29/11/2023 03:05:08 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 ( '89220' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '66' , '66' , '0' , '9' , '9' , '' , '0' , '594.0000' ) 29/11/2023 03:05:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '157' 29/11/2023 03:05:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '157' , '1' ) 29/11/2023 03:18:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '3792' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 03:18: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' , '3792' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '325.00' , '266.39' , NOW() , NOW() ) 29/11/2023 03:18: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 = '89221' 29/11/2023 03:18:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '89221' 29/11/2023 03:18: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 ( '89221' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 29/11/2023 03:18: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 ( '89221' , '21916' , 'TOVAGLIA D\'ALTARE MORELLO' , '1' , '-1' , '1' , '138.6' , '113.60655737705' , '22' , '0' , '138.60' ) 29/11/2023 03:18: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 ( '89221' , '18880' , 'COPRILEGGIO MORELLO' , '2' , '-2' , '1' , '65.00' , '53.27868852459' , '22' , '0' , '130.00' ) 29/11/2023 03:50:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '110' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 03:50:33 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' , '110' , '2023-11-29' , '' , '6914' , '0' , '163357310' , 'VIA MARASCO 9 88046 SAN TEODORO - LAMEZIA TERME' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '49.40' , '49.40' , NOW() , NOW() ) 29/11/2023 03:50:33 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 = '13757' 29/11/2023 03:50:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '13757' 29/11/2023 03:50:33 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 ( '13757' , '132' , 'MINISTRANTI IERI, OGGI, DOMANI' , '20' , '-20' , '4' , '2.50' , '2.5' , '0' , '15' , '42.50' ) 29/11/2023 04:08:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '3793' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 04:08:57 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' , '3793' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.85' , NOW() , NOW() ) 29/11/2023 04:08:57 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 = '89222' 29/11/2023 04:08:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '89222' 29/11/2023 04:08:57 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 ( '89222' , '20429' , 'OSTIA SENZA TOSTATURA MORREALE - OS25' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 29/11/2023 04:22:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '3794' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 04:22:59 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' , '3794' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 29/11/2023 04:22:59 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 = '89223' 29/11/2023 04:22:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '89223' 29/11/2023 04:22:59 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 ( '89223' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 29/11/2023 04:29:05 pm >> SELECT document_num FROM ps_document WHERE document_num = '3795' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 04:29: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' , '3795' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '134.00' , '117.64' , NOW() , NOW() ) 29/11/2023 04:29: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 = '89224' 29/11/2023 04:29:05 pm >> DELETE FROM ps_document_detail WHERE id_document = '89224' 29/11/2023 04:29: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 ( '89224' , '16405' , 'CASULA MORELLO' , '1' , '-1' , '1' , '79.00' , '64.754098360656' , '22' , '0' , '79.00' ) 29/11/2023 04:29: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 ( '89224' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 29/11/2023 04:29: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 ( '89224' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '10' , '-10' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '35.00' ) 29/11/2023 04:30:43 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '6914' 29/11/2023 04:30:43 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 ( '6914' , '10' , '147' , 'PARROCCHIA SAN TEODORO MT.' , 'FIOZZO' , 'ANTONIO' , 'VIA MARASCO 9' , '' , '88046' , 'SAN TEODORO - LAMEZIA TERME' , 'SPEDIONE: ROSSANA DICELLO - VIA VICO II SEGGIO 17 - SAN TEODORO - LAMEZIA TERME 88046 CATANZARO' , '' , '3290118443' , '' , '82050770799' , NOW() , NOW() ) 29/11/2023 04:30:43 pm >> UPDATE ps_customer SET email = 'antoniofiozzo@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '6914' 29/11/2023 04:41:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '3796' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 04:41:45 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3796' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.60' , '9.60' , NOW() , NOW() ) 29/11/2023 04:41: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 = '89225' 29/11/2023 04:41:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '89225' 29/11/2023 04:41: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 ( '89225' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '240' , '-240' , '4' , '0.04' , '0.04' , '0' , '0' , '9.60' ) 29/11/2023 04:53:09 pm >> SELECT document_num FROM ps_document WHERE document_num = '3797' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 04:53: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 ( '11' , '3797' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.00' , '24.59' , NOW() , NOW() ) 29/11/2023 04:53: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 = '89226' 29/11/2023 04:53:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '89226' 29/11/2023 04:53: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 ( '89226' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '16' , '13.114754098361' , '22' , '0' , '16.00' ) 29/11/2023 04:53: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 ( '89226' , '15801' , 'ARGENTO A PESO' , '1' , '-1' , '1' , '14' , '11.475409836066' , '22' , '0' , '14.00' ) 29/11/2023 04:55:59 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '1458' 29/11/2023 04:55:59 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 ( '1458' , '10' , '210' , '' , 'D\'ANDRETTA ' , 'ANNA RITA' , 'VIA SILENTINA 7' , '' , '84045' , 'ALTAVILLA SILENTINA' , '' , '3385401414' , '' , '' , '' , NOW() , NOW() ) 29/11/2023 04:55:59 pm >> UPDATE ps_customer SET email = 'annarita.d_andretta@libero.it', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '1458' 29/11/2023 04:57:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '299' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 04:57: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' , '299' , '2023-11-29' , '' , '1458' , '0' , '4679206' , 'VIA SILENTINA 7 84045 ALTAVILLA SILENTINA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '27.67' , '27.67' , NOW() , NOW() ) 29/11/2023 04:57: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 = '89227' 29/11/2023 04:57:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '89227' 29/11/2023 04:57:55 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 ( '89227' , '106' , 'A MESSA SALTANDO DI GIOIA - GUIDA' , '1' , '-1' , '4' , '5.16' , '5.16' , '0' , '5' , '4.90' ) 29/11/2023 04:57:55 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 ( '89227' , '107' , 'A MESSA SALTANDO DI GIOIA?' , '1' , '-1' , '4' , '6.20' , '6.2' , '0' , '5' , '5.89' ) 29/11/2023 04:57:55 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 ( '89227' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 29/11/2023 04:57:55 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 ( '89227' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/11/2023 04:57:55 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 ( '89227' , '8855' , 'REGISTRO DEL CATECHISTA' , '6' , '-6' , '0' , '0.75' , '0.75' , '' , '5' , '4.28' ) 29/11/2023 05:11:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '3798' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 05:11: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 ( '11' , '3798' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '20.21' , NOW() , NOW() ) 29/11/2023 05:11: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 = '89228' 29/11/2023 05:11:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '89228' 29/11/2023 05:11: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 ( '89228' , '17617' , 'IMMAGINI ISONZO X 100' , '6' , '-6' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '21.00' ) 29/11/2023 05:11: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 ( '89228' , '7109' , 'NOVENA ALLIMMACOLATA CONCEZIONE - 8520' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 29/11/2023 05:15:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '3799' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 05:15:13 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' , '3799' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 29/11/2023 05:15:13 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89229' 29/11/2023 05:15:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '89229' 29/11/2023 05:15:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89229' , '19150' , 'MOCCOLO 70X200' , '8' , '-8' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '60.00' ) 29/11/2023 05:30:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '3708' AND id_document != '89115' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 29/11/2023 05:30:22 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3708', document_date = '2023-11-23', 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 = '112.00', price_tax_excluded = '99.54', date_upd = NOW() WHERE id_document = '89115' 29/11/2023 05:30:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89115' 29/11/2023 05:30:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '89115' 29/11/2023 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89115' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.0400' , '0.04' , '0' , '0' , '25.60' ) 29/11/2023 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89115' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 29/11/2023 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89115' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.9000' , '5.655737704918' , '22' , '0' , '13.80' ) 29/11/2023 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89115' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '15.80' ) 29/11/2023 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89115' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 29/11/2023 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89115' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 29/11/2023 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89115' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '22.8000' , '18.688524590164' , '22' , '0' , '22.80' ) 29/11/2023 05:30:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89115' , '17523' , 'OSTIA PER CELIACI 25 PZ' , '1' , '-1' , '3' , '7' , '6.7307692307692' , '4' , '0' , '7.00' ) 29/11/2023 05:30:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '3708' AND id_document != '89115' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-23') 29/11/2023 05:30:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3708', document_date = '2023-11-23', 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 = '105.00', price_tax_excluded = '92.81', date_upd = NOW() WHERE id_document = '89115' 29/11/2023 05:30: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 = '89115' 29/11/2023 05:30:42 pm >> DELETE FROM ps_document_detail WHERE id_document = '89115' 29/11/2023 05:30: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 ( '89115' , '11858' , 'FOGLIETTI LA DOMENICA - LER' , '640' , '-640' , '4' , '0.0400' , '0.04' , '0' , '0' , '25.60' ) 29/11/2023 05:30: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 ( '89115' , '20428' , 'OSTIA TAGLIO CHIUSO 72MM - OTC25' , '4' , '-4' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '8.00' ) 29/11/2023 05:30: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 ( '89115' , '11756' , 'VINO BIANCO SECCO - 14%' , '2' , '-2' , '1' , '6.9000' , '5.655737704918' , '22' , '0' , '13.80' ) 29/11/2023 05:30: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 ( '89115' , '11757' , 'VINO LIQUOROSO DOLCE - 16%' , '2' , '-2' , '1' , '7.9000' , '6.4754098360656' , '22' , '0' , '15.80' ) 29/11/2023 05:30: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 ( '89115' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 29/11/2023 05:30: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 ( '89115' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '22.8000' , '18.688524590164' , '22' , '0' , '22.80' ) 29/11/2023 05:30: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 ( '89115' , '17523' , 'OSTIA PER CELIACI 25 PZ' , '1' , '-1' , '3' , '7.0000' , '6.7307692307692' , '4' , '0' , '7.00' ) 29/11/2023 05:31:07 pm >> SELECT document_num FROM ps_document WHERE document_num = '3452' AND id_document != '88723' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-04') 29/11/2023 05:31:07 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '3452', document_date = '2023-11-04', 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 = '48.81', price_tax_excluded = '48.54', date_upd = NOW() WHERE id_document = '88723' 29/11/2023 05:31:08 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 = '88723' 29/11/2023 05:31:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '88723' 29/11/2023 05:31:08 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 ( '88723' , '18176' , 'ANTIQUUM MINISTERIUM ' , '15' , '-15' , '4' , '1.0000' , '1' , '0' , '5' , '14.25' ) 29/11/2023 05:31:08 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 ( '88723' , '21476' , 'QUESTA CASA E TUA 3 - 12/14 ANNI' , '1' , '-1' , '4' , '16.5000' , '16.5' , '0' , '5' , '15.68' ) 29/11/2023 05:31:08 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 ( '88723' , '21475' , 'EFFETTO DOMINO GUIDA GIOVANI - 15/18 ANNI' , '1' , '-1' , '4' , '12.5000' , '12.5' , '0' , '5' , '11.88' ) 29/11/2023 05:31:08 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 ( '88723' , '17523' , 'OSTIA PER CELIACI 25 PZ' , '1' , '-1' , '3' , '7' , '6.7307692307692' , '4' , '0' , '7.00' ) 29/11/2023 05:35:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2048' AND id_document != '85826' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-13') 29/11/2023 05:35:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2048', document_date = '2023-06-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 = '140.00', price_tax_excluded = '114.75', date_upd = NOW() WHERE id_document = '85826' 29/11/2023 05:35:57 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 = '85826' 29/11/2023 05:35:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '85826' 29/11/2023 05:35:57 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 ( '85826' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '40' , '32.786885245902' , '22' , '0' , '40.00' ) 29/11/2023 05:35:57 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 ( '85826' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 29/11/2023 05:35:57 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 ( '85826' , '13342' , 'PRESEPE CON LED - 8575/01' , '3' , '-3' , '1' , '15' , '12.295081967213' , '22' , '0' , '45.00' ) 29/11/2023 07:16:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '3800' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-11-29') 29/11/2023 07:16:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '3800' , '2023-11-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.00' , '30.75' , NOW() , NOW() ) 29/11/2023 07:16:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '89230' 29/11/2023 07:16:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '89230' 29/11/2023 07:16:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89230' , '6809' , 'MOCCOLO 60X165' , '4' , '-4' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '18.00' ) 29/11/2023 07:16:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '89230' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '16' , '16' , '0' , '0' , '16.00' )