02/09/2024 08:47:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2306' AND id_document != '92669' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-19') 02/09/2024 08:47:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2306', document_date = '2024-07-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '134.80', price_tax_excluded = '115.17', date_upd = NOW() WHERE id_document = '92669' 02/09/2024 08:47:55 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 = '92669' 02/09/2024 08:47:55 am >> DELETE FROM ps_document_detail WHERE id_document = '92669' 02/09/2024 08:47:55 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 ( '92669' , '16689' , 'OSTIA PAN DI CENA mm80' , '6' , '-6' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '12.00' ) 02/09/2024 08:47:55 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 ( '92669' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '6' , '-6' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '21.00' ) 02/09/2024 08:47:55 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 ( '92669' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5000' , '6.9672131147541' , '22' , '0' , '51.00' ) 02/09/2024 08:47:55 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 ( '92669' , '19107' , 'INCENSO GRANI 3A - BUSTA' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 02/09/2024 08:47:55 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 ( '92669' , '11805' , 'TECA IHS - 823' , '1' , '-1' , '1' , '20.8' , '17.049180327869' , '22' , '0' , '20.80' ) 02/09/2024 08:49:00 am >> SELECT document_num FROM ps_document WHERE document_num = '2466' AND id_document != '92872' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-26') 02/09/2024 08:49:00 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2466', document_date = '2024-08-26', 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 = '111.30', price_tax_excluded = '92.83', date_upd = NOW() WHERE id_document = '92872' 02/09/2024 08:49:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92872' 02/09/2024 08:49:00 am >> DELETE FROM ps_document_detail WHERE id_document = '92872' 02/09/2024 08:49:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92872' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '2.7' , '2.5961538461538' , '4' , '0' , '2.70' ) 02/09/2024 08:49:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92872' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.3000' , '4.1346153846154' , '4' , '0' , '4.30' ) 02/09/2024 08:49:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92872' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.0000' , '8.1967213114754' , '22' , '0' , '10.00' ) 02/09/2024 08:49:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92872' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '90.00' ) 02/09/2024 08:49:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92872' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 02/09/2024 08:49:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2377' AND id_document != '92759' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 02/09/2024 08:49:55 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2377', document_date = '2024-07-29', 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 = '35.90', price_tax_excluded = '33.88', date_upd = NOW() WHERE id_document = '92759' 02/09/2024 08:49:55 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 = '92759' 02/09/2024 08:49:55 am >> DELETE FROM ps_document_detail WHERE id_document = '92759' 02/09/2024 08:49:55 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 ( '92759' , '17276' , 'CONFEZIONE COLLANINA CON MIRACOLOSA E STRASS - 1911' , '2' , '-2' , '1' , '4.6000' , '3.7704918032787' , '22' , '0' , '9.20' ) 02/09/2024 08:49:55 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 ( '92759' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '0.95' , '0.95' , '0' , '0' , '0.95' ) 02/09/2024 08:49:55 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 ( '92759' , '21097' , 'BRACCIALE DECINA - BC1768N' , '1' , '-1' , '1' , '2.0000' , '1.6393442622951' , '22' , '0' , '2.00' ) 02/09/2024 08:49:55 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 ( '92759' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '5' , '-5' , '4' , '5' , '5' , '0' , '5' , '23.75' ) 02/09/2024 09:18:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2520' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 09:18: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' , '2520' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 02/09/2024 09:18: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 = '92932' 02/09/2024 09:18:17 am >> DELETE FROM ps_document_detail WHERE id_document = '92932' 02/09/2024 09:18: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 ( '92932' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/09/2024 10:12:01 am >> SELECT document_num FROM ps_document WHERE document_num = '2521' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 10:12: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' , '2521' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '131.40' , '109.12' , NOW() , NOW() ) 02/09/2024 10:12: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 = '92933' 02/09/2024 10:12:01 am >> DELETE FROM ps_document_detail WHERE id_document = '92933' 02/09/2024 10:12: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 ( '92933' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '56.40' ) 02/09/2024 10:12: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 ( '92933' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '8.5' , '6.9672131147541' , '22' , '0' , '51.00' ) 02/09/2024 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 ( '92933' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 02/09/2024 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 ( '92933' , '7202' , 'ARTICOLI RELIGIOSI' , '4' , '-4' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '14.00' ) 02/09/2024 10:46:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2522' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 10:46:13 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' , '2522' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.60' , '8.27' , NOW() , NOW() ) 02/09/2024 10:46:13 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 = '92934' 02/09/2024 10:46:13 am >> DELETE FROM ps_document_detail WHERE id_document = '92934' 02/09/2024 10:46:13 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 ( '92934' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '8.60' ) 02/09/2024 10:57:32 am >> SELECT document_num FROM ps_document WHERE document_num = '2523' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 10:57: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' , '2523' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.71' , '3.71' , NOW() , NOW() ) 02/09/2024 10:57: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 = '92935' 02/09/2024 10:57:32 am >> DELETE FROM ps_document_detail WHERE id_document = '92935' 02/09/2024 10:57: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 ( '92935' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 02/09/2024 11:09:08 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' , '2226/24' , '2024-08-29' , '24' , '0' , '22' , '2617' , 'C.DA GIOPPO, 11 89040 CIRELLA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '216.06' , '207.75' , NOW() , NOW() ) 02/09/2024 11:09:08 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 = '92936' 02/09/2024 11:09:08 am >> DELETE FROM ps_document_detail WHERE id_document = '92936' 02/09/2024 11:09:08 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 ( '92936' , '19089' , 'OSTIA MAGNA 150 - OM 150' , '3' , '3' , '3' , '2.1' , '2.0192307692308' , '4' , '3' , '6.3554' ) 02/09/2024 11:09:08 am >> DELETE FROM ps_product_supplier WHERE id_product = '19089' AND id_supplier = '22' 02/09/2024 11:09:08 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19089' , '22' , '1' ) 02/09/2024 11:09:08 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 ( '92936' , '17711' , 'OSTIA MAGNA CM 18 - OM 180' , '3' , '3' , '3' , '4' , '3.8461538461538' , '4' , '3' , '12.1056' ) 02/09/2024 11:09:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '17711' AND id_supplier = '22' 02/09/2024 11:09:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17711' , '22' , '1' ) 02/09/2024 11:09:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92936' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '100' , '100' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '197.6000' ) 02/09/2024 11:09:09 am >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '22' 02/09/2024 11:09:09 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '22' , '1' ) 02/09/2024 11:20:37 am >> SELECT document_num FROM ps_document WHERE document_num = '2524' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 11:20:37 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' , '2524' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.00' , '7.38' , NOW() , NOW() ) 02/09/2024 11:20:37 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 = '92937' 02/09/2024 11:20:37 am >> DELETE FROM ps_document_detail WHERE id_document = '92937' 02/09/2024 11:20:37 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 ( '92937' , '22409' , 'PIASTRELLA COMUNIONE - 1302/K212' , '1' , '-1' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '9.00' ) 02/09/2024 11:21:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2525' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 11:21:30 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' , '2525' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.00' , '31.00' , NOW() , NOW() ) 02/09/2024 11:21: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 = '92938' 02/09/2024 11:21:30 am >> DELETE FROM ps_document_detail WHERE id_document = '92938' 02/09/2024 11:21:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92938' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '3.5' , '3.5' , '0' , '0' , '21.00' ) 02/09/2024 11:21:30 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92938' , '11151' , 'LIBRI' , '5' , '-5' , '4' , '2' , '2' , '0' , '0' , '10.00' ) 02/09/2024 11:41:19 am >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '238' 02/09/2024 11:41:19 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 ( '238' , '10' , '179' , 'ISTITUTO ANCELLE RIPARATRICE' , 'CARLONI' , 'SUOR NUNZIATINA' , 'VIA MONS A. CELONA 1' , '' , '98121' , 'MESSINA' , '' , '09049026' , '' , '' , '' , NOW() , NOW() ) 02/09/2024 11:41:19 am >> UPDATE ps_customer SET email = 'istituto654@gmail.com', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '238' 02/09/2024 11:42:06 am >> SELECT document_num FROM ps_document WHERE document_num = '106' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 11:42: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 ( '21' , '106' , '2024-09-02' , '' , '238' , '0' , '4679342' , 'VIA MONS A. CELONA 1 98121 MESSINA' , '' , '' , '5' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '20.20' , '20.20' , NOW() , NOW() ) 02/09/2024 11:42: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 = '92939' 02/09/2024 11:42:06 am >> DELETE FROM ps_document_detail WHERE id_document = '92939' 02/09/2024 11:42: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 ( '92939' , '11183' , 'VENITE CON ME - GUIDA' , '2' , '-2' , '4' , '8.00' , '8' , '0' , '5' , '15.20' ) 02/09/2024 11:46:46 am >> SELECT document_num FROM ps_document WHERE document_num = '2526' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 11:46: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' , '2526' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '145.00' , '128.00' , NOW() , NOW() ) 02/09/2024 11:46: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 = '92940' 02/09/2024 11:46:46 am >> DELETE FROM ps_document_detail WHERE id_document = '92940' 02/09/2024 11:46: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 ( '92940' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 02/09/2024 11:46: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 ( '92940' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '20.00' ) 02/09/2024 11:46: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 ( '92940' , '11151' , 'LIBRI' , '10' , '-10' , '4' , '3.5' , '3.5' , '0' , '0' , '35.00' ) 02/09/2024 11:50:04 am >> SELECT document_num FROM ps_document WHERE document_num = '2527' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 11:50: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' , '2527' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.28' , '8.28' , NOW() , NOW() ) 02/09/2024 11:50: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 = '92941' 02/09/2024 11:50:04 am >> DELETE FROM ps_document_detail WHERE id_document = '92941' 02/09/2024 11:50: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 ( '92941' , '22717' , 'PAROLA E PREGHIERA - SETT 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 02/09/2024 11:50: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 ( '92941' , '22825' , 'PAROLA E PREGHIERA - NOV 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 02/09/2024 11:50: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 ( '92941' , '22768' , 'PAROLA E PREGHIERA - OTT 24' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 02/09/2024 11:56:02 am >> SELECT document_num FROM ps_document WHERE document_num = '2228' AND id_document != '92579' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-09') 02/09/2024 11:56:02 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2228', document_date = '2024-07-09', 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 = '32.00', price_tax_excluded = '26.23', date_upd = NOW() WHERE id_document = '92579' 02/09/2024 11:56: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 = '92579' 02/09/2024 11:56:02 am >> DELETE FROM ps_document_detail WHERE id_document = '92579' 02/09/2024 11:56: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 ( '92579' , '21042' , 'AMITTO MISTO LANA - 60/3111' , '1' , '-1' , '1' , '32' , '26.229508196721' , '22' , '0' , '32.00' ) 02/09/2024 11:57:24 am >> SELECT document_num FROM ps_document WHERE document_num = '2370' AND id_document != '92752' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-29') 02/09/2024 11:57:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2370', document_date = '2024-07-29', 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 = '255.00', price_tax_excluded = '212.79', date_upd = NOW() WHERE id_document = '92752' 02/09/2024 11:57:25 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 = '92752' 02/09/2024 11:57:25 am >> DELETE FROM ps_document_detail WHERE id_document = '92752' 02/09/2024 11:57:25 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 ( '92752' , '8147' , 'POLO BASIC' , '2' , '-2' , '1' , '27.0000' , '22.131147540984' , '22' , '0' , '54.00' ) 02/09/2024 11:57:25 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 ( '92752' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 02/09/2024 11:57:25 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 ( '92752' , '14354' , 'CAMICE BENEDETTINO LINO - 3010' , '1' , '-1' , '1' , '140.1000' , '114.83606557377' , '22' , '0' , '140.10' ) 02/09/2024 11:57:25 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 ( '92752' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.9' , '1.9' , '0' , '0' , '1.90' ) 02/09/2024 11:57:25 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 ( '92752' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 02/09/2024 11:57:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2462' AND id_document != '92867' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-08-26') 02/09/2024 11:57:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2462', document_date = '2024-08-26', 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 = '133.00', price_tax_excluded = '133.00', date_upd = NOW() WHERE id_document = '92867' 02/09/2024 11:57: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 = '92867' 02/09/2024 11:57:51 am >> DELETE FROM ps_document_detail WHERE id_document = '92867' 02/09/2024 11:57: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 ( '92867' , '21508' , 'LITURGIA DELLE ORE VOL. II N.E.' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 02/09/2024 11:57: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 ( '92867' , '5889' , 'LITURGIA DELLE ORE - VOL. III - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 02/09/2024 11:57: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 ( '92867' , '21509' , 'LITURGIA DELLE ORE VOL. IV N.E.' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '5' , '33.25' ) 02/09/2024 11:57: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 ( '92867' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '14.25' , '14.25' , '0' , '0' , '14.25' ) 02/09/2024 11:57: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 ( '92867' , '21614' , 'RITO DEL BATTESIMO DEI BAMBINI N.E.' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 02/09/2024 12:01:36 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , '95DmJxvHn9JuwWEe' , NOW() , NOW() ) 02/09/2024 12:01:36 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7105' , '1' ) 02/09/2024 12:01:36 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7105' , '2' ) 02/09/2024 12:01:36 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '7105' , '3' ) 02/09/2024 12:03:55 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7105' 02/09/2024 12:03:56 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 ( '7105' , '10' , '229' , 'UN VILLAGGIO PER CRESCERE APS' , '' , '' , 'VIA SAN PIETRO MARTIRE 5' , '' , '37026' , 'PESCANTINA' , '' , '' , '' , '' , '93286880237' , NOW() , NOW() ) 02/09/2024 12:03:56 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7105' 02/09/2024 12:04:16 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7105' 02/09/2024 12:04:16 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 ( '7105' , '10' , '229' , 'UN VILLAGGIO PER CRESCERE APS' , '' , '' , 'VIA SAN PIETRO MARTIRE 5' , '' , '37026' , 'PESCANTINA' , 'SPEDIRE A CRISTINA VALDAN' , '' , '' , '' , '93286880237' , NOW() , NOW() ) 02/09/2024 12:04:16 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7105' 02/09/2024 12:04:35 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '7105' 02/09/2024 12:04:35 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 ( '7105' , '10' , '229' , 'UN VILLAGGIO PER CRESCERE APS' , '' , '' , 'VIA SAN PIETRO MARTIRE 5' , '' , '37026' , 'PESCANTINA' , 'SPEDIRE A CRISTINA VALDAN' , '' , '' , '' , '93286880237' , NOW() , NOW() ) 02/09/2024 12:04:35 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = '', date_upd = NOW() WHERE id_customer = '7105' 02/09/2024 12:05:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '29' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 12:05: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 ( '21' , '29' , '2024-09-02' , '' , '7105' , '0' , '177359040' , 'VIA SAN PIETRO MARTIRE 5 37026 PESCANTINA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '83.40' , '83.40' , NOW() , NOW() ) 02/09/2024 12:05: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 = '14743' 02/09/2024 12:05:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '14743' 02/09/2024 12:05: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 ( '14743' , '57' , 'ALBUM + BUSTINA AMICO GESÙ' , '30' , '-30' , '4' , '2.00' , '2' , '0' , '15' , '51.00' ) 02/09/2024 12:05: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 ( '14743' , '58' , 'SCATOLA FIGURINE AMICO GESÙ - 60 BUSTINE' , '1' , '-1' , '4' , '30.00' , '30' , '0' , '15' , '25.50' ) 02/09/2024 12:06:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '30' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 12:06: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' , '30' , '2024-09-02' , '' , '7104' , '0' , '177359037' , 'VIA DELL\\\'ADIGE 26 37020 VALARGNE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 02/09/2024 12:06: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 = '14744' 02/09/2024 12:06:10 pm >> DELETE FROM ps_document_detail WHERE id_document = '14744' 02/09/2024 12:06: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 ( '14744' , '15' , 'LA BIBBIA: GENESI ALBUM+FIGURINE' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '5' , '14.25' ) 02/09/2024 12:11:30 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 02/09/2024 12:11:30 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22827' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 12:11:30 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22827' , '1' , '1' , '2' , NOW() , NOW() ) 02/09/2024 12:11:30 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22827' , '0' , '1' , '0' , '0' ) 02/09/2024 12:13:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'art.20-02' AND id_product != '22827' AND ean13 != '' 02/09/2024 12:13:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'art.20-02', date_upd = NOW() WHERE id_product = '22827' 02/09/2024 12:13:38 pm >> UPDATE ps_product_lang SET name = 'CAMICE MISTO LANA - 20/02', description = '' WHERE id_product = '22827' 02/09/2024 12:13:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '534.4262295081967' WHERE id_product = '22827' 02/09/2024 12:13:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '534.4262295081967', id_tax_rules_group = '1', id_category_default = '450', 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 = '22827' 02/09/2024 12:13:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '22827' 02/09/2024 12:14:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'art.20-02' AND id_product != '22827' AND ean13 != '' 02/09/2024 12:14:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'art.20-02', date_upd = NOW() WHERE id_product = '22827' 02/09/2024 12:14:27 pm >> UPDATE ps_product_lang SET name = 'CAMICE MISTO LANA - 20/02', description = '' WHERE id_product = '22827' 02/09/2024 12:14:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '534.4262295081967' WHERE id_product = '22827' 02/09/2024 12:14:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '534.4262295081967', id_tax_rules_group = '1', id_category_default = '450', 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 = '22827' 02/09/2024 12:14:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '22827' 02/09/2024 12:14:28 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 = '22827' 02/09/2024 12:14:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22828' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 12:14:28 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 '22828' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22827' 02/09/2024 12:14:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22828' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22827' 02/09/2024 12:16:00 pm >> SELECT ean13 FROM ps_product WHERE ean13 = 'ART.20-023' AND id_product != '22828' AND ean13 != '' 02/09/2024 12:16:00 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = 'ART.20-023', date_upd = NOW() WHERE id_product = '22828' 02/09/2024 12:16:00 pm >> UPDATE ps_product_lang SET name = 'STOLA MISTO LANA - 20/023', description = '' WHERE id_product = '22828' 02/09/2024 12:16:00 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '127.04918032786885' WHERE id_product = '22828' 02/09/2024 12:16:00 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '127.04918032786885', id_tax_rules_group = '1', id_category_default = '450', 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 = '22828' 02/09/2024 12:16:00 pm >> DELETE FROM ps_specific_price WHERE id_product = '22828' 02/09/2024 12:16:02 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 = '22828' 02/09/2024 12:16:02 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22829' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 12:16:02 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 '22829' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22828' 02/09/2024 12:16:02 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22829' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22828' 02/09/2024 12: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 ( '31' , '4167/2024' , '2024-08-26' , '2024' , '0' , '129' , '4670237' , 'VIA ROMA, 10 54035 FOSDINOVO' , '' , '' , '13' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '864.61' , '708.69' , NOW() , NOW() ) 02/09/2024 12: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 = '92942' 02/09/2024 12:16:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '92942' 02/09/2024 12: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 ( '92942' , '17991' , 'STOLA LINO/POL GIGLIUCCIO A MANO' , '4' , '4' , '1' , '63.93' , '52.401639344262' , '22' , '3' , '302.6190' ) 02/09/2024 12:16:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17991' AND id_supplier = '129' 02/09/2024 12:16:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17991' , '129' , '1' ) 02/09/2024 12:16:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92942' , '15541' , 'STOLA LINO/POL CON GIGLIUCCIO A MANO - 60/3096' , '2' , '2' , '1' , '56.15' , '46.024590163934' , '22' , '3' , '132.8958' ) 02/09/2024 12:16:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15541' AND id_supplier = '129' 02/09/2024 12:16:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15541' , '129' , '1' ) 02/09/2024 12:16:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92942' , '22827' , 'CAMICE MISTO LANA - 20/02' , '1' , '1' , '1' , '285.25' , '233.81147540984' , '22' , '3' , '337.5648' ) 02/09/2024 12:16:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22827' AND id_supplier = '129' 02/09/2024 12:16:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22827' , '129' , '1' ) 02/09/2024 12:16:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92942' , '22828' , 'STOLA MISTO LANA - 20/023' , '1' , '1' , '1' , '63.94' , '52.409836065574' , '22' , '3' , '75.6666' ) 02/09/2024 12:16:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22828' AND id_supplier = '129' 02/09/2024 12:16:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22828' , '129' , '1' ) 02/09/2024 12:19:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2528' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 12:19:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2528' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 02/09/2024 12:19:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92943' 02/09/2024 12:19:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '92943' 02/09/2024 12:19:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92943' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '15' , '15' , '0' , '0' , '15.00' ) 02/09/2024 12:41:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2529' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 12:41:23 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2529' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.75' , '23.75' , NOW() , NOW() ) 02/09/2024 12:41:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92944' 02/09/2024 12:41:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '92944' 02/09/2024 12:41:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92944' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '5' , '-5' , '4' , '5.00' , '5' , '0' , '5' , '23.75' ) 02/09/2024 12:43:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2530' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 12:43: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 ( '11' , '2530' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 02/09/2024 12:43: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 = '92945' 02/09/2024 12:43:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '92945' 02/09/2024 12:43: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 ( '92945' , '22713' , 'AMEN - SET 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 02/09/2024 12:43: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 ( '92945' , '22712' , 'AMEN - OTT 24' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 02/09/2024 12:45:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 12:45:55 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' , '2531' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '62.80' , '61.30' , NOW() , NOW() ) 02/09/2024 12:45:55 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 = '92946' 02/09/2024 12:45:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '92946' 02/09/2024 12:45: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 ( '92946' , '17864' , 'MESSALE QUOTIDIANO GRANDE - N. E. ' , '1' , '-1' , '4' , '52.00' , '52' , '0' , '5' , '49.40' ) 02/09/2024 12:45: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 ( '92946' , '22199' , 'VINO LIQUOROSO ROSSO ' , '1' , '-1' , '1' , '7.90' , '6.4754098360656' , '22' , '0' , '7.90' ) 02/09/2024 12:45: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 ( '92946' , '16689' , 'OSTIA PAN DI CENA mm80' , '1' , '-1' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '2.00' ) 02/09/2024 12:45: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 ( '92946' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 02/09/2024 02:33:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2063' AND id_document != '92380' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-22') 02/09/2024 02:33:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2063', document_date = '2024-06-22', 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 = '85.00', price_tax_excluded = '69.67', date_upd = NOW() WHERE id_document = '92380' 02/09/2024 02:33: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 = '92380' 02/09/2024 02:33:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '92380' 02/09/2024 02:33: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 ( '92380' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 02/09/2024 02:33: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 ( '92380' , '15893' , 'CINGOLO - CING17' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 02/09/2024 02:36:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '2152' AND id_document != '92494' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-01') 02/09/2024 02:36:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2152', document_date = '2024-07-01', 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 = '110.00', price_tax_excluded = '90.16', date_upd = NOW() WHERE id_document = '92494' 02/09/2024 02:36:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '92494' 02/09/2024 02:36:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '92494' 02/09/2024 02:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92494' , '22566' , 'POLO SIMIL SCOZIA MM - M03' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 02/09/2024 02:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92494' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5' , '4.0983606557377' , '22' , '0' , '5.00' ) 02/09/2024 02:36:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92494' , '16958' , 'SERVIZIO MESSA M/LINO MARIANO - 6990' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 02/09/2024 04:08:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '91/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 04:08: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 ( '24' , '91/A' , '2024-09-02' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13986.00' , '13986.00' , NOW() , NOW() ) 02/09/2024 04:08: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 = '92947' 02/09/2024 04:08:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '92947' 02/09/2024 04:08: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 ( '92947' , '18529' , 'SAN CESARE DE BUS - FUMETTO' , '150' , '-150' , '4' , '5.00' , '5' , '0' , '0' , '750.00' ) 02/09/2024 04:08: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 ( '92947' , '17827' , 'ISTRUZIONI FAMILIARI VOL. I - IL CREDO ' , '32' , '-32' , '4' , '20.00' , '20' , '0' , '0' , '640.00' ) 02/09/2024 04:08: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 ( '92947' , '18717' , 'ISTRUZIONI FAMILIARI VOL. II - I DIECI COMANDAMENTI ' , '32' , '-32' , '4' , '20.00' , '20' , '0' , '0' , '640.00' ) 02/09/2024 04:08: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 ( '92947' , '19391' , 'ISTRUZIONI FAMILIARI VOL. III - I PRECETTI...' , '32' , '-32' , '4' , '20.00' , '20' , '0' , '0' , '640.00' ) 02/09/2024 04:08: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 ( '92947' , '21799' , 'ISTRUZIONI FAMILIARI VOL. IV - I VIZI E I SCARAMENTI' , '32' , '-32' , '4' , '25.00' , '25' , '0' , '0' , '800.00' ) 02/09/2024 04:08: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 ( '92947' , '17828' , 'ANGELO STRUFFOLINI - A.G. DIBISCEGLIA' , '96' , '-96' , '4' , '26.00' , '26' , '0' , '0' , '2496.00' ) 02/09/2024 04:08: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 ( '92947' , '17697' , 'SANTO ROSARIO CON SAN CESARE DE BUS' , '280' , '-280' , '4' , '2.50' , '2.5' , '0' , '0' , '700.00' ) 02/09/2024 04:08: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 ( '92947' , '19562' , 'SAN CESARE DE BUS. UNA VITA PER LA CATECHESI ' , '116' , '-116' , '4' , '20.00' , '20' , '0' , '0' , '2320.00' ) 02/09/2024 04:08: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 ( '92947' , '17582' , 'SAN CESARE DE BUS' , '200' , '-200' , '4' , '5.00' , '5' , '0' , '0' , '1000.00' ) 02/09/2024 04:08: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 ( '92947' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '400' , '-400' , '4' , '10.00' , '10' , '0' , '0' , '4000.00' ) 02/09/2024 04:08: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 ( '92947' , '' , 'POSTER' , '100' , '-100' , '4' , '0' , '0' , '0' , '0' , '0.00' ) 02/09/2024 04:11:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2361' AND id_document != '92741' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-07-26') 02/09/2024 04:11:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2361', document_date = '2024-07-26', 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 = '23.75', price_tax_excluded = '23.75', date_upd = NOW() WHERE id_document = '92741' 02/09/2024 04:11: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 = '92741' 02/09/2024 04:11:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '92741' 02/09/2024 04:11: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 ( '92741' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.1' , '1.1' , '0' , '0' , '1.10' ) 02/09/2024 04:11: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 ( '92741' , '10430' , 'TABOR' , '1' , '-1' , '4' , '17.9000' , '17.9' , '0' , '0' , '17.90' ) 02/09/2024 04:11: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 ( '92741' , '22693' , 'SULLA TUA PAROLA - SETT/OTT 2024' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 02/09/2024 04:36:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2532' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 04:36:25 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' , '2532' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 02/09/2024 04:36:25 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 = '92948' 02/09/2024 04:36:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '92948' 02/09/2024 04:36:25 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 ( '92948' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '17.50' ) 02/09/2024 04:36:25 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 ( '92948' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '1' , '-1' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '2.50' ) 02/09/2024 04:38:02 pm >> SELECT document_num FROM ps_document WHERE document_num = '2533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 04:38:02 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' , '2533' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.30' , '4.95' , NOW() , NOW() ) 02/09/2024 04:38:02 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 = '92949' 02/09/2024 04:38:02 pm >> DELETE FROM ps_document_detail WHERE id_document = '92949' 02/09/2024 04:38:02 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 ( '92949' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '1' , '-1' , '3' , '4.30' , '4.1346153846154' , '4' , '0' , '4.30' ) 02/09/2024 04:38:02 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 ( '92949' , '21597' , 'BIGLIETTI AUGURI SAN PAOLO' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 02/09/2024 04:38:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '2534' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 04:38:18 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' , '2534' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.00' , '3.85' , NOW() , NOW() ) 02/09/2024 04:38:18 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 = '92950' 02/09/2024 04:38:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '92950' 02/09/2024 04:38:18 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 ( '92950' , '7311' , 'OSTIA SOTTILE 74MM' , '2' , '-2' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '4.00' ) 02/09/2024 04:44:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '2535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 04:44: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' , '2535' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.30' , '13.30' , NOW() , NOW() ) 02/09/2024 04:44: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 = '92951' 02/09/2024 04:44:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '92951' 02/09/2024 04:44: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 ( '92951' , '1827' , 'CATECHISMO DELLA DOTTRINA CRISTIANA - PIO X' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '5' , '13.30' ) 02/09/2024 05:07:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 05:07: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' , '2536' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.15' , '9.79' , NOW() , NOW() ) 02/09/2024 05:07: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 = '92952' 02/09/2024 05:07:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '92952' 02/09/2024 05:07: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 ( '92952' , '6414' , 'MERAVIGLIOSO SEGRETO DELLE ANIME DEL PURGATORIO - 8110' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 02/09/2024 05:07: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 ( '92952' , '2761' , 'CORONA DI CENTO REQUIEM - 8181' , '1' , '-1' , '4' , '1.50' , '1.5' , '0' , '0' , '1.50' ) 02/09/2024 05:07: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 ( '92952' , '18130' , 'TAU GRANDE CM 4 - T9' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 02/09/2024 05:07: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 ( '92952' , '18131' , 'TAU MEDIO CM3 - T6' , '1' , '-1' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '1.00' ) 02/09/2024 05:09:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '2537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 05:09:41 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2537' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '58.80' , '49.87' , NOW() , NOW() ) 02/09/2024 05:09: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 = '92953' 02/09/2024 05:09:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '92953' 02/09/2024 05:09:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92953' , '10870' , 'UN MESE CON LA MEDAGLIA MIRACOLOSA - 8382' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 02/09/2024 05:09:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92953' , '6212' , 'MARIA APPARIZIONI E MESSAGGI' , '1' , '-1' , '4' , '2.50' , '2.5' , '0' , '0' , '2.50' ) 02/09/2024 05:09:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92953' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 02/09/2024 05:09:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92953' , '15019' , 'PREGHIAMO CON MARIA' , '1' , '-1' , '4' , '0.80' , '0.8' , '0' , '0' , '0.80' ) 02/09/2024 05:09:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92953' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14.5' , '11.885245901639' , '22' , '0' , '14.50' ) 02/09/2024 05:09:41 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92953' , '21180' , 'ROSARIO ARGENTO/EMATITE - 1498CAV' , '1' , '-1' , '1' , '35.00' , '28.688524590164' , '22' , '0' , '35.00' ) 02/09/2024 05:20: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 ( '32' , '24V604887' , '2024-08-31' , '' , '0' , '7' , '2602' , 'P. ZZA SAN PAOLO, 14 12051 ALBA' , '' , '' , '4.92' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '173.01' , '173.01' , NOW() , NOW() ) 02/09/2024 05:20: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 = '92954' 02/09/2024 05:20:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '92954' 02/09/2024 05:20: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 ( '92954' , '22825' , 'PAROLA E PREGHIERA - NOV 24' , '4' , '0' , '4' , '2.9000' , '2.9' , '0' , '33' , '7.77' ) 02/09/2024 05:21:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22825' AND id_supplier = '7' 02/09/2024 05:21:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22825' , '7' , '1' ) 02/09/2024 05:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22824' , 'INSIEME NELLA MESSA - NOV 24' , '1' , '0' , '4' , '1.8000' , '1.8' , '0' , '33' , '1.21' ) 02/09/2024 05:21:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22824' AND id_supplier = '7' 02/09/2024 05:21:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22824' , '7' , '1' ) 02/09/2024 05:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22818' , 'MOSCHETTIERI DI PADRE PIO - ALLEGRI' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 02/09/2024 05:21:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22818' AND id_supplier = '7' 02/09/2024 05:21:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22818' , '7' , '1' ) 02/09/2024 05:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22813' , 'GIUBILEO SPIEGATO AI BAMBINI' , '3' , '0' , '4' , '3.9000' , '3.9' , '0' , '30' , '8.19' ) 02/09/2024 05:21:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22813' AND id_supplier = '7' 02/09/2024 05:21:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22813' , '7' , '1' ) 02/09/2024 05:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22822' , 'INVITO ALLA TEOLOGIA MORALE - E. CHIAVACCI' , '1' , '0' , '4' , '13.0000' , '13' , '0' , '30' , '9.10' ) 02/09/2024 05:21:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22822' AND id_supplier = '7' 02/09/2024 05:21:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22822' , '7' , '1' ) 02/09/2024 05:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22811' , 'NON PERDERE LA SPERANZA' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 02/09/2024 05:21:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22811' AND id_supplier = '7' 02/09/2024 05:21:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22811' , '7' , '1' ) 02/09/2024 05:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22810' , 'SULLA VALIDITA DEI SACRAMENTI - A. LAMERI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 02/09/2024 05:21:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22810' AND id_supplier = '7' 02/09/2024 05:21:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22810' , '7' , '1' ) 02/09/2024 05:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22814' , 'STRADE DELLA BENEDIZIONE - P. BOVATI' , '1' , '0' , '4' , '28.0000' , '28' , '0' , '33' , '18.76' ) 02/09/2024 05:21:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22814' AND id_supplier = '7' 02/09/2024 05:21:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22814' , '7' , '1' ) 02/09/2024 05:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22815' , 'VITA DI SAN FRANCESCO - SAN BONAVENTURA' , '1' , '0' , '4' , '14.0000' , '14' , '0' , '33' , '9.38' ) 02/09/2024 05:21:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22815' AND id_supplier = '7' 02/09/2024 05:21:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22815' , '7' , '1' ) 02/09/2024 05:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22816' , 'COMPAGNI DI VIAGGIO - M.R. MANALI' , '1' , '0' , '4' , '16.0000' , '16' , '0' , '33' , '10.72' ) 02/09/2024 05:21:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22816' AND id_supplier = '7' 02/09/2024 05:21:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22816' , '7' , '1' ) 02/09/2024 05:21:00 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22819' , 'SANTI PELLEGRINI DI SPERANZA - SEMERARO' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 02/09/2024 05:21:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22819' AND id_supplier = '7' 02/09/2024 05:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22819' , '7' , '1' ) 02/09/2024 05:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22820' , 'DISCERNIMENTO COMUNITARIO - BRAMBILLA/RUCCIA' , '1' , '0' , '4' , '15.0000' , '15' , '0' , '30' , '10.50' ) 02/09/2024 05:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22820' AND id_supplier = '7' 02/09/2024 05:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22820' , '7' , '1' ) 02/09/2024 05:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22817' , 'POSSESSIONI DIABOLICHE ED ESORCISMO - F. BAMONTE' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '33' , '12.06' ) 02/09/2024 05:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22817' AND id_supplier = '7' 02/09/2024 05:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22817' , '7' , '1' ) 02/09/2024 05:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22812' , 'RIPENSARE LA PENITENZA - BICHER/TONIOLO' , '1' , '0' , '4' , '22.0000' , '22' , '0' , '30' , '15.40' ) 02/09/2024 05:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22812' AND id_supplier = '7' 02/09/2024 05:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22812' , '7' , '1' ) 02/09/2024 05:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22821' , 'CARLO ACUTIS - G. PARIS' , '1' , '0' , '4' , '18.0000' , '18' , '0' , '30' , '12.60' ) 02/09/2024 05:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22821' AND id_supplier = '7' 02/09/2024 05:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22821' , '7' , '1' ) 02/09/2024 05:21:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92954' , '22823' , 'LAUDATO SI MI SIGNORE - C. PAOLAZZI' , '1' , '0' , '4' , '12.0000' , '12' , '0' , '30' , '8.40' ) 02/09/2024 05:21:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22823' AND id_supplier = '7' 02/09/2024 05:21:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22823' , '7' , '1' ) 02/09/2024 05:46:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 05:46:56 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' , '2538' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '59.00' , '48.36' , NOW() , NOW() ) 02/09/2024 05:46:56 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 = '92955' 02/09/2024 05:46:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '92955' 02/09/2024 05:46:56 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 ( '92955' , '14088' , 'CAMICE IN MICROFIBRA - 429/PMA' , '1' , '-1' , '1' , '59.00' , '48.360655737705' , '22' , '0' , '59.00' ) 02/09/2024 05:53:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '103' AND id_document != '92847' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-08-08') 02/09/2024 05:53:13 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '103', document_date = '2024-08-08', document_letter = '', id_customer = '3978', id_supplier = '', id_address = '4677362', address1 = 'VIA MALTA 3 83100 AVELLINO', address2 = '', note = '', price_shipping = '5.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 = '43.00', price_tax_excluded = '43.00', date_upd = NOW() WHERE id_document = '92847' 02/09/2024 05:53: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 = '92847' 02/09/2024 05:53:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '92847' 02/09/2024 05:53: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 ( '92847' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '5' , '38.00' ) 02/09/2024 05:54:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '104' AND id_document != '92860' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-08-09') 02/09/2024 05:54:22 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '104', document_date = '2024-08-09', document_letter = '', id_customer = '4111', id_supplier = '', id_address = '4679337', address1 = 'VIA NIVES 23 39048 SELVA DI VAL GARDENA', address2 = '', note = '', price_shipping = '5.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 = '50.60', price_tax_excluded = '50.60', date_upd = NOW() WHERE id_document = '92860' 02/09/2024 05:54: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 = '92860' 02/09/2024 05:54:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '92860' 02/09/2024 05:54:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92860' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '4' , '-4' , '4' , '10.00' , '10' , '0' , '5' , '38.00' ) 02/09/2024 05:54:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '92860' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '8' , '8' , '0' , '5' , '7.60' ) 02/09/2024 05:54:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '105' AND id_document != '92870' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2024-08-26') 02/09/2024 05:54:45 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '105', document_date = '2024-08-26', document_letter = '', id_customer = '3980', id_supplier = '', id_address = '4677356', address1 = 'P. ZZA RISORGIMENTO 1 80047 S. GIUSEPPE VESUVIANO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '9', id_causal = '0', price_tax_included = '76.00', price_tax_excluded = '76.00', date_upd = NOW() WHERE id_document = '92870' 02/09/2024 05:54:46 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 = '92870' 02/09/2024 05:54:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '92870' 02/09/2024 05:54:46 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 ( '92870' , '15271' , 'TRAMONTO DI SETTEMBRE - V. FRANCIA' , '8' , '-8' , '4' , '10.00' , '10' , '0' , '5' , '76.00' ) 02/09/2024 06:30:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '70/145-1' AND id_product != '22829' AND ean13 != '' 02/09/2024 06:30:05 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '70/145-1', date_upd = NOW() WHERE id_product = '22829' 02/09/2024 06:30:05 pm >> UPDATE ps_product_lang SET name = 'CASULA CON CROCE - 70/145-1', description = '' WHERE id_product = '22829' 02/09/2024 06:30:05 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22829' 02/09/2024 06:30:05 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22829' 02/09/2024 06:30:05 pm >> DELETE FROM ps_specific_price WHERE id_product = '22829' 02/09/2024 06:30:06 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22829' 02/09/2024 06:30:06 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22830' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:30:06 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22830' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22829' 02/09/2024 06:30:06 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22830' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22829' 02/09/2024 06:30:34 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '70/439' AND id_product != '22830' AND ean13 != '' 02/09/2024 06:30:34 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '70/439', date_upd = NOW() WHERE id_product = '22830' 02/09/2024 06:30:34 pm >> UPDATE ps_product_lang SET name = 'ROCCHETTO IN LINO RICAMO AD INTAGLIO - 70/439', description = '' WHERE id_product = '22830' 02/09/2024 06:30:34 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22830' 02/09/2024 06:30:34 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22830' 02/09/2024 06:30:34 pm >> DELETE FROM ps_specific_price WHERE id_product = '22830' 02/09/2024 06:30:35 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 = '22830' 02/09/2024 06:30:36 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22831' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:30:36 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 '22831' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22830' 02/09/2024 06:30:36 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22831' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22830' 02/09/2024 06:31:08 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '70/423-1' AND id_product != '22831' AND ean13 != '' 02/09/2024 06:31:08 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '70/423-1', date_upd = NOW() WHERE id_product = '22831' 02/09/2024 06:31:08 pm >> UPDATE ps_product_lang SET name = 'COTTA MISTO LANA RICAMO A MANO - 70/423-1', description = '' WHERE id_product = '22831' 02/09/2024 06:31:09 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22831' 02/09/2024 06:31:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22831' 02/09/2024 06:31:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '22831' 02/09/2024 06:31:09 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 = '22831' 02/09/2024 06:31:09 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22832' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:31:09 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 '22832' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22831' 02/09/2024 06:31:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22832' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22831' 02/09/2024 06:31:57 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '60/2035' AND id_product != '22832' AND ean13 != '' 02/09/2024 06:31:57 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '60/2035', date_upd = NOW() WHERE id_product = '22832' 02/09/2024 06:31:57 pm >> UPDATE ps_product_lang SET name = 'CASULA PURA SETA GREGGIA - 60/2035', description = '' WHERE id_product = '22832' 02/09/2024 06:31:57 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22832' 02/09/2024 06:31:57 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22832' 02/09/2024 06:31:57 pm >> DELETE FROM ps_specific_price WHERE id_product = '22832' 02/09/2024 06:31:58 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 = '22832' 02/09/2024 06:31:58 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22833' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:31:58 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 '22833' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22832' 02/09/2024 06:31:58 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22833' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22832' 02/09/2024 06:33:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '70/504' AND id_product != '22833' AND ean13 != '' 02/09/2024 06:33:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '70/504', date_upd = NOW() WHERE id_product = '22833' 02/09/2024 06:33:41 pm >> UPDATE ps_product_lang SET name = ' CASULA P/LANA CON FASCIONE AD INTAGLIO - 70/504', description = '' WHERE id_product = '22833' 02/09/2024 06:33:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22833' 02/09/2024 06:33:42 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22833' 02/09/2024 06:33:42 pm >> DELETE FROM ps_specific_price WHERE id_product = '22833' 02/09/2024 06:33:42 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 = '22833' 02/09/2024 06:33:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22834' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:33:42 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 '22834' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22833' 02/09/2024 06:33:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22834' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22833' 02/09/2024 06:41:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '50/393' AND id_product != '22834' AND ean13 != '' 02/09/2024 06:41:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '50/393', date_upd = NOW() WHERE id_product = '22834' 02/09/2024 06:41:30 pm >> UPDATE ps_product_lang SET name = 'PALLA - 50/393', description = '' WHERE id_product = '22834' 02/09/2024 06:41:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22834' 02/09/2024 06:41:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22834' 02/09/2024 06:41:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '22834' 02/09/2024 06:41:33 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 = '22834' 02/09/2024 06:41:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22835' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:41:33 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 '22835' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22834' 02/09/2024 06:41:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22835' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22834' 02/09/2024 06:42:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '50/361.' AND id_product != '22835' AND ean13 != '' 02/09/2024 06:42:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '50/361.', date_upd = NOW() WHERE id_product = '22835' 02/09/2024 06:42:32 pm >> UPDATE ps_product_lang SET name = 'PALLA - 50/361.', description = '' WHERE id_product = '22835' 02/09/2024 06:42:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22835' 02/09/2024 06:42:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22835' 02/09/2024 06:42:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '22835' 02/09/2024 06:42:39 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 = '22835' 02/09/2024 06:42:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22836' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:42:40 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 '22836' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22835' 02/09/2024 06:42:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22836' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22835' 02/09/2024 06:43:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '75/1634.' AND id_product != '22836' AND ean13 != '' 02/09/2024 06:43:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '75/1634.', date_upd = NOW() WHERE id_product = '22836' 02/09/2024 06:43:32 pm >> UPDATE ps_product_lang SET name = 'PALLA - 75/1634.', description = '' WHERE id_product = '22836' 02/09/2024 06:43:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22836' 02/09/2024 06:43:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22836' 02/09/2024 06:43:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '22836' 02/09/2024 06:45:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '75/1634.' AND id_product != '22836' AND ean13 != '' 02/09/2024 06:45:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '75/1634.', date_upd = NOW() WHERE id_product = '22836' 02/09/2024 06:45:46 pm >> UPDATE ps_product_lang SET name = 'PALLA - 75/1634.', description = '' WHERE id_product = '22836' 02/09/2024 06:45:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22836' 02/09/2024 06:45:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22836' 02/09/2024 06:45:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '22836' 02/09/2024 06:45:48 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 = '22836' 02/09/2024 06:45:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22837' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:45:48 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 '22837' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22836' 02/09/2024 06:45:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22837' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22836' 02/09/2024 06:46:31 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '508331' AND id_product != '22837' AND ean13 != '' 02/09/2024 06:46:31 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '508331', date_upd = NOW() WHERE id_product = '22837' 02/09/2024 06:46:31 pm >> UPDATE ps_product_lang SET name = 'PALLA RICAMO ARG. mf', description = '' WHERE id_product = '22837' 02/09/2024 06:46:31 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22837' 02/09/2024 06:46:31 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22837' 02/09/2024 06:46:31 pm >> DELETE FROM ps_specific_price WHERE id_product = '22837' 02/09/2024 06:46:32 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 = '22837' 02/09/2024 06:46:32 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22838' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:46:32 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 '22838' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22837' 02/09/2024 06:46:32 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22838' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22837' 02/09/2024 06:47:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '70/5322' AND id_product != '22838' AND ean13 != '' 02/09/2024 06:47:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '70/5322', date_upd = NOW() WHERE id_product = '22838' 02/09/2024 06:47:07 pm >> UPDATE ps_product_lang SET name = 'STOLA LANA/LUREX - 70/5322', description = '' WHERE id_product = '22838' 02/09/2024 06:47:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22838' 02/09/2024 06:47:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22838' 02/09/2024 06:47:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '22838' 02/09/2024 06:47:08 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 = '22838' 02/09/2024 06:47:08 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22839' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:47:09 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 '22839' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22838' 02/09/2024 06:47:09 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22839' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22838' 02/09/2024 06:47:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '70/506-1' AND id_product != '22839' AND ean13 != '' 02/09/2024 06:47:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '70/506-1', date_upd = NOW() WHERE id_product = '22839' 02/09/2024 06:47:41 pm >> UPDATE ps_product_lang SET name = 'STOLA SETA - 70/506-1', description = '' WHERE id_product = '22839' 02/09/2024 06:47:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22839' 02/09/2024 06:47:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22839' 02/09/2024 06:47:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '22839' 02/09/2024 06:47:42 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 = '22839' 02/09/2024 06:47:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22840' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:47:42 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 '22840' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22839' 02/09/2024 06:47:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22840' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22839' 02/09/2024 06:49:16 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '50/3611' AND id_product != '22840' AND ean13 != '' 02/09/2024 06:49:16 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '50/3611', date_upd = NOW() WHERE id_product = '22840' 02/09/2024 06:49:16 pm >> UPDATE ps_product_lang SET name = 'STOLA RICAMO ORO mf - 50/3611', description = '' WHERE id_product = '22840' 02/09/2024 06:49:16 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22840' 02/09/2024 06:49:16 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22840' 02/09/2024 06:49:16 pm >> DELETE FROM ps_specific_price WHERE id_product = '22840' 02/09/2024 06:49:17 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 = '22840' 02/09/2024 06:49:17 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22841' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:49:17 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 '22841' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22840' 02/09/2024 06:49:17 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22841' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22840' 02/09/2024 06:49:46 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '60/3098' AND id_product != '22841' AND ean13 != '' 02/09/2024 06:49:46 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '60/3098', date_upd = NOW() WHERE id_product = '22841' 02/09/2024 06:49:46 pm >> UPDATE ps_product_lang SET name = 'STOLA CANAPA/LINO - 60/3098', description = '' WHERE id_product = '22841' 02/09/2024 06:49:46 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22841' 02/09/2024 06:49:46 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22841' 02/09/2024 06:49:46 pm >> DELETE FROM ps_specific_price WHERE id_product = '22841' 02/09/2024 06:49:48 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 = '22841' 02/09/2024 06:49:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22842' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:49:48 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 '22842' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22841' 02/09/2024 06:49:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22842' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22841' 02/09/2024 06:53:03 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '50/331' AND id_product != '22842' AND ean13 != '' 02/09/2024 06:53:03 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '50/331', date_upd = NOW() WHERE id_product = '22842' 02/09/2024 06:53:03 pm >> UPDATE ps_product_lang SET name = 'PALLA SETA CON RICAMO ARG mf', description = '' WHERE id_product = '22842' 02/09/2024 06:53:03 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22842' 02/09/2024 06:53:03 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22842' 02/09/2024 06:53:03 pm >> DELETE FROM ps_specific_price WHERE id_product = '22842' 02/09/2024 06:53:07 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 = '22842' 02/09/2024 06:53:07 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22843' , '1' , '' , 'nuovo-prodotto' ) 02/09/2024 06:53:07 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 '22843' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22842' 02/09/2024 06:53:07 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22843' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22842' 02/09/2024 06:53:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '50/331' AND id_product != '22842' AND ean13 != '' 02/09/2024 06:53:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '50/331', date_upd = NOW() WHERE id_product = '22842' 02/09/2024 06:53:27 pm >> UPDATE ps_product_lang SET name = 'PALLA SETA CON RICAMO ARG mf - 50/331', description = '' WHERE id_product = '22842' 02/09/2024 06:53:28 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22842' 02/09/2024 06:53:28 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22842' 02/09/2024 06:53:28 pm >> DELETE FROM ps_specific_price WHERE id_product = '22842' 02/09/2024 06:54:07 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '75/1634' AND id_product != '22836' AND ean13 != '' 02/09/2024 06:54:07 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '75/1634', date_upd = NOW() WHERE id_product = '22836' 02/09/2024 06:54:07 pm >> UPDATE ps_product_lang SET name = 'PALLA - 75/1634', description = '' WHERE id_product = '22836' 02/09/2024 06:54:07 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '22836' 02/09/2024 06:54:07 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '450', 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 = '22836' 02/09/2024 06:54:07 pm >> DELETE FROM ps_specific_price WHERE id_product = '22836' 02/09/2024 06:55:18 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' , '5832/2024' , '2024-08-26' , '2024' , '0' , '129' , '4670237' , 'VIA ROMA, 10 54035 FOSDINOVO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '17' , '0' , '5860.27' , '4803.50' , NOW() , NOW() ) 02/09/2024 06:55:18 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 = '92956' 02/09/2024 06:55:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '92956' 02/09/2024 06:55:18 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 ( '92956' , '22829' , 'CASULA CON CROCE - 70/145-1' , '1' , '1' , '1' , '367' , '300.81967213115' , '22' , '0' , '447.7400' ) 02/09/2024 06:55:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22829' AND id_supplier = '129' 02/09/2024 06:55:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22829' , '129' , '1' ) 02/09/2024 06:55:18 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 ( '92956' , '22830' , 'ROCCHETTO IN LINO RICAMO AD INTAGLIO - 70/439' , '1' , '1' , '1' , '1415' , '1159.8360655738' , '22' , '0' , '1726.3000' ) 02/09/2024 06:55:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22830' AND id_supplier = '129' 02/09/2024 06:55:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22830' , '129' , '1' ) 02/09/2024 06:55:18 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 ( '92956' , '22831' , 'COTTA MISTO LANA RICAMO A MANO - 70/423-1' , '1' , '1' , '1' , '247' , '202.45901639344' , '22' , '0' , '301.3400' ) 02/09/2024 06:55:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22831' AND id_supplier = '129' 02/09/2024 06:55:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22831' , '129' , '1' ) 02/09/2024 06:55:18 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 ( '92956' , '22832' , 'CASULA PURA SETA GREGGIA - 60/2035' , '1' , '1' , '1' , '793' , '650' , '22' , '0' , '967.4600' ) 02/09/2024 06:55:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22832' AND id_supplier = '129' 02/09/2024 06:55:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22832' , '129' , '1' ) 02/09/2024 06:55:18 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 ( '92956' , '22833' , ' CASULA P/LANA CON FASCIONE AD INTAGLIO - 70/504' , '1' , '1' , '1' , '615' , '504.09836065574' , '22' , '0' , '750.3000' ) 02/09/2024 06:55:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22833' AND id_supplier = '129' 02/09/2024 06:55:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22833' , '129' , '1' ) 02/09/2024 06:55:18 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 ( '92956' , '22834' , 'PALLA - 50/393' , '1' , '1' , '1' , '118' , '96.72131147541' , '22' , '0' , '143.9600' ) 02/09/2024 06:55:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22834' AND id_supplier = '129' 02/09/2024 06:55:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22834' , '129' , '1' ) 02/09/2024 06:55:18 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 ( '92956' , '22835' , 'PALLA - 50/361.' , '4' , '4' , '1' , '68' , '55.737704918033' , '22' , '0' , '331.8400' ) 02/09/2024 06:55:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22835' AND id_supplier = '129' 02/09/2024 06:55:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22835' , '129' , '1' ) 02/09/2024 06:55: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 ( '92956' , '22842' , 'PALLA SETA CON RICAMO ARG mf - 50/331' , '1' , '1' , '1' , '131' , '107.37704918033' , '22' , '0' , '159.8200' ) 02/09/2024 06:55:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22842' AND id_supplier = '129' 02/09/2024 06:55:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22842' , '129' , '1' ) 02/09/2024 06:55: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 ( '92956' , '22836' , 'PALLA - 75/1634' , '5' , '5' , '1' , '39.5' , '32.377049180328' , '22' , '0' , '240.9500' ) 02/09/2024 06:55:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22836' AND id_supplier = '129' 02/09/2024 06:55:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22836' , '129' , '1' ) 02/09/2024 06:55: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 ( '92956' , '22838' , 'STOLA LANA/LUREX - 70/5322' , '1' , '1' , '1' , '118' , '96.72131147541' , '22' , '0' , '143.9600' ) 02/09/2024 06:55:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22838' AND id_supplier = '129' 02/09/2024 06:55:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22838' , '129' , '1' ) 02/09/2024 06:55: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 ( '92956' , '22839' , 'STOLA SETA - 70/506-1' , '1' , '1' , '1' , '197' , '161.47540983607' , '22' , '0' , '240.3400' ) 02/09/2024 06:55:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22839' AND id_supplier = '129' 02/09/2024 06:55:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22839' , '129' , '1' ) 02/09/2024 06:55: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 ( '92956' , '22840' , 'STOLA RICAMO ORO mf - 50/3611' , '1' , '1' , '1' , '224' , '183.60655737705' , '22' , '0' , '273.2800' ) 02/09/2024 06:55:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22840' AND id_supplier = '129' 02/09/2024 06:55:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22840' , '129' , '1' ) 02/09/2024 06:55: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 ( '92956' , '22841' , 'STOLA CANAPA/LINO - 60/3098' , '1' , '1' , '1' , '109' , '89.344262295082' , '22' , '0' , '132.9800' ) 02/09/2024 06:55:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22841' AND id_supplier = '129' 02/09/2024 06:55:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22841' , '129' , '1' ) 02/09/2024 06:55:49 pm >> UPDATE ps_document SET id_document_type = '33', document_num = '5832/2024', document_date = '2024-08-26', document_letter = '2024', id_customer = '0', id_supplier = '', id_address = '4670237', address1 = 'VIA ROMA, 10 54035 FOSDINOVO', address2 = '', note = 'CONTO DEPOSITO A 60 GG', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '17', id_causal = '0', price_tax_included = '5860.27', price_tax_excluded = '4803.50', date_upd = NOW() WHERE id_document = '92956' 02/09/2024 06:55: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 = '92956' 02/09/2024 06:55:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '92956' 02/09/2024 06:55: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 ( '92956' , '22829' , 'CASULA CON CROCE - 70/145-1' , '1' , '1' , '1' , '367.0000' , '300.81967213115' , '22' , '0' , '447.74' ) 02/09/2024 06:55: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 ( '92956' , '22830' , 'ROCCHETTO IN LINO RICAMO AD INTAGLIO - 70/439' , '1' , '1' , '1' , '1415.0000' , '1159.8360655738' , '22' , '0' , '1726.30' ) 02/09/2024 06:55: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 ( '92956' , '22831' , 'COTTA MISTO LANA RICAMO A MANO - 70/423-1' , '1' , '1' , '1' , '247.0000' , '202.45901639344' , '22' , '0' , '301.34' ) 02/09/2024 06:55: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 ( '92956' , '22832' , 'CASULA PURA SETA GREGGIA - 60/2035' , '1' , '1' , '1' , '793.0000' , '650' , '22' , '0' , '967.46' ) 02/09/2024 06:55: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 ( '92956' , '22833' , ' CASULA P/LANA CON FASCIONE AD INTAGLIO - 70/504' , '1' , '1' , '1' , '615.0000' , '504.09836065574' , '22' , '0' , '750.30' ) 02/09/2024 06:55: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 ( '92956' , '22834' , 'PALLA - 50/393' , '1' , '1' , '1' , '118.0000' , '96.72131147541' , '22' , '0' , '143.96' ) 02/09/2024 06:55: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 ( '92956' , '22835' , 'PALLA - 50/361.' , '4' , '4' , '1' , '68.0000' , '55.737704918033' , '22' , '0' , '331.84' ) 02/09/2024 06:55: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 ( '92956' , '22842' , 'PALLA SETA CON RICAMO ARG mf - 50/331' , '1' , '1' , '1' , '131.0000' , '107.37704918033' , '22' , '0' , '159.82' ) 02/09/2024 06:55: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 ( '92956' , '22836' , 'PALLA - 75/1634' , '5' , '5' , '1' , '39.5000' , '32.377049180328' , '22' , '0' , '240.95' ) 02/09/2024 06:55: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 ( '92956' , '22838' , 'STOLA LANA/LUREX - 70/5322' , '1' , '1' , '1' , '118.0000' , '96.72131147541' , '22' , '0' , '143.96' ) 02/09/2024 06:55: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 ( '92956' , '22839' , 'STOLA SETA - 70/506-1' , '1' , '1' , '1' , '197.0000' , '161.47540983607' , '22' , '0' , '240.34' ) 02/09/2024 06:55: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 ( '92956' , '22840' , 'STOLA RICAMO ORO mf - 50/3611' , '1' , '1' , '1' , '224.0000' , '183.60655737705' , '22' , '0' , '273.28' ) 02/09/2024 06:55: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 ( '92956' , '22841' , 'STOLA CANAPA/LINO - 60/3098' , '1' , '1' , '1' , '109.0000' , '89.344262295082' , '22' , '0' , '132.98' ) 02/09/2024 07:11:26 pm >> SELECT document_num FROM ps_document WHERE document_num = '2539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-09-02') 02/09/2024 07:11: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' , '2539' , '2024-09-02' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '6.65' , '6.65' , NOW() , NOW() ) 02/09/2024 07:11: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 = '92957' 02/09/2024 07:11:26 pm >> DELETE FROM ps_document_detail WHERE id_document = '92957' 02/09/2024 07:11: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 ( '92957' , '9647' , 'SANTO ROSARIO - A. COMASTRI - 8627' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 02/09/2024 07:50:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2037' AND id_document != '92345' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-06-19') 02/09/2024 07:50:31 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2037', document_date = '2024-06-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '180.00', price_tax_excluded = '147.54', date_upd = NOW() WHERE id_document = '92345' 02/09/2024 07:50: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 = '92345' 02/09/2024 07:50:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '92345' 02/09/2024 07:50: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 ( '92345' , '22234' , 'CAMICE MISTO LANA - 70/002020' , '1' , '-1' , '1' , '180' , '147.54098360656' , '22' , '0' , '180.00' )