29/06/2023 08:59:43 am >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 08:59:43 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '69/A' , '2023-06-29' , 'A' , '3550' , '0' , '4671016' , 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '11.00' , NOW() , NOW() ) 29/06/2023 08:59:43 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86558' 29/06/2023 08:59:43 am >> DELETE FROM ps_document_detail WHERE id_document = '86558' 29/06/2023 08:59:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '15' , '-15' , '4' , '0.70' , '0.7' , '0' , '0' , '10.50' ) 29/06/2023 08:59:43 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 29/06/2023 09:01:02 am >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '86558' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 09:01:02 am >> UPDATE ps_document SET id_document_type = '24', document_num = '69/A', document_date = '2023-06-29', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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.80', price_tax_excluded = '23.80', date_upd = NOW() WHERE id_document = '86558' 29/06/2023 09:01: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 = '86558' 29/06/2023 09:01:02 am >> DELETE FROM ps_document_detail WHERE id_document = '86558' 29/06/2023 09:01: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 ( '86558' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '15' , '-15' , '4' , '0.7000' , '0.7' , '0' , '0' , '10.50' ) 29/06/2023 09:01: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 ( '86558' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 29/06/2023 09:01: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 ( '86558' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 29/06/2023 09:01: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 ( '86558' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 09:01: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 ( '86558' , '21199' , 'AMEN - OTT 2023' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 09:02:45 am >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '86558' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 09:02:45 am >> UPDATE ps_document SET id_document_type = '24', document_num = '69/A', document_date = '2023-06-29', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '41.80', price_tax_excluded = '41.80', date_upd = NOW() WHERE id_document = '86558' 29/06/2023 09:02:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86558' 29/06/2023 09:02:45 am >> DELETE FROM ps_document_detail WHERE id_document = '86558' 29/06/2023 09:02:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '15' , '-15' , '4' , '0.7000' , '0.7' , '0' , '0' , '10.50' ) 29/06/2023 09:02:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 29/06/2023 09:02:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 29/06/2023 09:02:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 09:02:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21199' , 'AMEN - OTT 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 09:02:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '0' , '18.00' ) 29/06/2023 09:06:31 am >> SELECT document_num FROM ps_document WHERE document_num = '2235' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 09:06:31 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' , '2235' , '2023-06-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '61.75' , '61.75' , NOW() , NOW() ) 29/06/2023 09:06:31 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 = '86559' 29/06/2023 09:06:31 am >> DELETE FROM ps_document_detail WHERE id_document = '86559' 29/06/2023 09:06:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86559' , '1146' , 'BIBBIA DI GERUSALEMME X OCCASIONI ' , '1' , '-1' , '4' , '45.00' , '45' , '0' , '5' , '42.75' ) 29/06/2023 09:06:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86559' , '11882' , '365 GIORNI CON LA BIBBIA - 8827' , '1' , '-1' , '4' , '20.00' , '20' , '0' , '5' , '19.00' ) 29/06/2023 09:15:06 am >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '86558' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 09:15:06 am >> UPDATE ps_document SET id_document_type = '24', document_num = '69/A', document_date = '2023-06-29', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '55.80', price_tax_excluded = '53.28', date_upd = NOW() WHERE id_document = '86558' 29/06/2023 09:15: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 = '86558' 29/06/2023 09:15:06 am >> DELETE FROM ps_document_detail WHERE id_document = '86558' 29/06/2023 09:15: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 ( '86558' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '15' , '-15' , '4' , '0.7000' , '0.7' , '0' , '0' , '10.50' ) 29/06/2023 09:15: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 ( '86558' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 29/06/2023 09:15: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 ( '86558' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 29/06/2023 09:15: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 ( '86558' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 09:15: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 ( '86558' , '21199' , 'AMEN - OTT 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 09:15:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '0' , '18.00' ) 29/06/2023 09:15:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 29/06/2023 09:32:39 am >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '86558' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 09:32:39 am >> UPDATE ps_document SET id_document_type = '24', document_num = '69/A', document_date = '2023-06-29', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '375.80', price_tax_excluded = '315.57', date_upd = NOW() WHERE id_document = '86558' 29/06/2023 09:32:39 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 = '86558' 29/06/2023 09:32:39 am >> DELETE FROM ps_document_detail WHERE id_document = '86558' 29/06/2023 09:32:39 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 ( '86558' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '15' , '-15' , '4' , '0.7000' , '0.7' , '0' , '0' , '10.50' ) 29/06/2023 09:32:39 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 ( '86558' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 29/06/2023 09:32:39 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 ( '86558' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 29/06/2023 09:32:40 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 ( '86558' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 09:32:40 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 ( '86558' , '21199' , 'AMEN - OTT 2023' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 09:32:40 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 ( '86558' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '0' , '18.00' ) 29/06/2023 09:32:40 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 ( '86558' , '16456' , 'CINGOLO - CING03' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 29/06/2023 09:32:40 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 ( '86558' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '74.00' ) 29/06/2023 09:32:40 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 ( '86558' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '2' , '-2' , '1' , '39.00' , '31.967213114754' , '22' , '0' , '78.00' ) 29/06/2023 09:32:40 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 ( '86558' , '14962' , 'CAMICIA PER TALARE - COTONE - 41' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 29/06/2023 09:32:40 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 ( '86558' , '14960' , 'CAMICIA PER TALARE - COTONE - 39' , '2' , '-2' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '84.00' ) 29/06/2023 09:32:40 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 ( '86558' , '14961' , 'CAMICIA PER TALARE - COTONE - 40' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 29/06/2023 09:48:49 am >> SELECT document_num FROM ps_document WHERE document_num = '1965' AND id_document != '85723' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-06') 29/06/2023 09:48:49 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1965', document_date = '2023-06-06', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '15.00', price_tax_excluded = '15.00', date_upd = NOW() WHERE id_document = '85723' 29/06/2023 09:48:49 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 = '85723' 29/06/2023 09:48:49 am >> DELETE FROM ps_document_detail WHERE id_document = '85723' 29/06/2023 09:48:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85723' , '21068' , 'MESSALINO AGO/SET/OTT 2023' , '3' , '-3' , '4' , '5' , '5' , '0' , '0' , '15.00' ) 29/06/2023 09:49:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2039' AND id_document != '85814' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-12') 29/06/2023 09:49:21 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2039', document_date = '2023-06-12', 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 = '31.80', price_tax_excluded = '30.72', date_upd = NOW() WHERE id_document = '85814' 29/06/2023 09:49:21 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '85814' 29/06/2023 09:49:21 am >> DELETE FROM ps_document_detail WHERE id_document = '85814' 29/06/2023 09:49:22 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 ( '85814' , '16163' , 'PARTICOLE DOMUS - PAN DI CENA' , '8' , '-8' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '28.00' ) 29/06/2023 09:49:22 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 ( '85814' , '21199' , 'AMEN - OTT 2023' , '1' , '-1' , '4' , '3.8' , '3.8' , '0' , '0' , '3.80' ) 29/06/2023 09:50:46 am >> SELECT document_num FROM ps_document WHERE document_num = '1885' AND id_document != '85621' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-29') 29/06/2023 09:50:46 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1885', document_date = '2023-05-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 = '10.00', price_tax_excluded = '10.00', date_upd = NOW() WHERE id_document = '85621' 29/06/2023 09:50: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 = '85621' 29/06/2023 09:50:46 am >> DELETE FROM ps_document_detail WHERE id_document = '85621' 29/06/2023 09:50: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 ( '85621' , '15020' , 'PREGARE OGNI GIORNO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 29/06/2023 09:50: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 ( '85621' , '21198' , 'AMEN - SET 2023' , '1' , '-1' , '4' , '3.5' , '3.5' , '0' , '0' , '3.50' ) 29/06/2023 09:50: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 ( '85621' , '21196' , 'CALENDARIO LITURGICO 2024' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 29/06/2023 09:50: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 ( '85621' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 29/06/2023 09:52:08 am >> SELECT document_num FROM ps_document WHERE document_num = '2017' AND id_document != '85789' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-09') 29/06/2023 09:52:08 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2017', document_date = '2023-06-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 = '145.00', price_tax_excluded = '126.97', date_upd = NOW() WHERE id_document = '85789' 29/06/2023 09:52: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 = '85789' 29/06/2023 09:52:08 am >> DELETE FROM ps_document_detail WHERE id_document = '85789' 29/06/2023 09:52: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 ( '85789' , '5458' , 'IO SONO CON VOI 2 PARTE' , '1' , '-1' , '4' , '2.2500' , '2.25' , '0' , '0' , '2.25' ) 29/06/2023 09:52: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 ( '85789' , '21037' , 'SULLA TUA PAROLA LUG/AGO 2023' , '9' , '-9' , '4' , '5.0000' , '5' , '0' , '5' , '42.75' ) 29/06/2023 09:52: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 ( '85789' , '14962' , 'CAMICIA PER TALARE - COTONE - 41' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 29/06/2023 09:52: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 ( '85789' , '14961' , 'CAMICIA PER TALARE - COTONE - 40' , '1' , '-1' , '1' , '35' , '28.688524590164' , '22' , '0' , '35.00' ) 29/06/2023 09:52: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 ( '85789' , '14960' , 'CAMICIA PER TALARE - COTONE - 39' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 29/06/2023 09:52:31 am >> SELECT document_num FROM ps_document WHERE document_num = '1878' AND id_document != '85614' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-05-29') 29/06/2023 09:52:31 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1878', document_date = '2023-05-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 = '420.00', price_tax_excluded = '344.26', date_upd = NOW() WHERE id_document = '85614' 29/06/2023 09:52:31 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 = '85614' 29/06/2023 09:52:31 am >> DELETE FROM ps_document_detail WHERE id_document = '85614' 29/06/2023 09:52:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85614' , '19607' , 'CLERGY F/F ML ' , '1' , '-1' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '39.90' ) 29/06/2023 09:52:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85614' , '18947' , 'CLERGY MISTO 80-20 ML - COM' , '1' , '-1' , '1' , '39.9000' , '32.704918032787' , '22' , '0' , '39.90' ) 29/06/2023 09:52:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85614' , '13875' , 'CLERGY TESS. BOSTON - BLU - MISTO ML 46' , '1' , '-1' , '1' , '52.0000' , '42.622950819672' , '22' , '0' , '52.00' ) 29/06/2023 09:52:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85614' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '37.00' ) 29/06/2023 09:52:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85614' , '2168' , 'CLERGY BASIC - ML - B&P' , '4' , '-4' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '140.00' ) 29/06/2023 09:52:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85614' , '13229' , 'CLERGY SPIGATO GRIGIO CHIARO ML COTONE - 45' , '1' , '-1' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '70.00' ) 29/06/2023 09:52:31 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '85614' , '14960' , 'CAMICIA PER TALARE - COTONE - 39' , '1' , '-1' , '1' , '41.2' , '33.770491803279' , '22' , '0' , '41.20' ) 29/06/2023 10:15:14 am >> SELECT document_num FROM ps_document WHERE document_num = '2236' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 10:15:14 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2236' , '2023-06-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '11.48' , NOW() , NOW() ) 29/06/2023 10:15:14 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86560' 29/06/2023 10:15:14 am >> DELETE FROM ps_document_detail WHERE id_document = '86560' 29/06/2023 10:15:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86560' , '13142' , 'CERETTI DIAM 26X350 - 2635' , '5' , '-5' , '1' , '2.20' , '1.8032786885246' , '22' , '0' , '11.00' ) 29/06/2023 10:15:15 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 ( '86560' , '11694' , 'BRACCIALE ROSARIO LEGNO - 186/R' , '1' , '-1' , '1' , '3.00' , '2.4590163934426' , '22' , '0' , '3.00' ) 29/06/2023 10:29:40 am >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '86558' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 10:29:40 am >> UPDATE ps_document SET id_document_type = '24', document_num = '69/A', document_date = '2023-06-29', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '375.80', price_tax_excluded = '315.57', date_upd = NOW() WHERE id_document = '86558' 29/06/2023 10:29:40 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 = '86558' 29/06/2023 10:29:40 am >> DELETE FROM ps_document_detail WHERE id_document = '86558' 29/06/2023 10:29:40 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 ( '86558' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '15' , '-15' , '4' , '0.7000' , '0.7' , '0' , '0' , '10.50' ) 29/06/2023 10:29:40 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 ( '86558' , '21196' , 'CALENDARIO LITURGICO 2024 ***' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 29/06/2023 10:29:40 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 ( '86558' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23 ****' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 29/06/2023 10:29:40 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 ( '86558' , '21198' , 'AMEN - SET 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 10:29:40 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 ( '86558' , '21199' , 'AMEN - OTT 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 10:29:40 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 ( '86558' , '21068' , 'MESSALINO AGO/SET/OTT 2023***' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '0' , '18.00' ) 29/06/2023 10:29:40 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 ( '86558' , '16456' , 'CINGOLO - CING03***' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 29/06/2023 10:29:40 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 ( '86558' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '74.00' ) 29/06/2023 10:29:40 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 ( '86558' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '2' , '-2' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '78.00' ) 29/06/2023 10:29:41 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 ( '86558' , '14962' , 'CAMICIA PER TALARE - COTONE - 41 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 29/06/2023 10:29:41 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 ( '86558' , '14960' , 'CAMICIA PER TALARE - COTONE - 39 ***' , '2' , '-2' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '84.00' ) 29/06/2023 10:29:41 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 ( '86558' , '14961' , 'CAMICIA PER TALARE - COTONE - 40 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 29/06/2023 11:13:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2237' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 11:13:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2237' , '2023-06-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.30' , '1.30' , NOW() , NOW() ) 29/06/2023 11:13:53 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86561' 29/06/2023 11:13:53 am >> DELETE FROM ps_document_detail WHERE id_document = '86561' 29/06/2023 11:13:53 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86561' , '7134' , 'NOZIONI E PRECI' , '1' , '-1' , '4' , '1.30' , '1.3' , '0' , '0' , '1.30' ) 29/06/2023 11:25:21 am >> SELECT ean13 FROM ps_product WHERE ean13 = '001802' AND id_product != '18764' AND ean13 != '' 29/06/2023 11:25:21 am >> UPDATE ps_product SET id_supplier = '116', reference = '', ean13 = '001802', date_upd = NOW() WHERE id_product = '18764' 29/06/2023 11:25:21 am >> UPDATE ps_product_lang SET name = 'STELLARIO PLEX CM 18/20', description = '' WHERE id_product = '18764' 29/06/2023 11:25:21 am >> UPDATE ps_product SET wholesale_price = '5.17', on_sale = '0', price = '12.7049' WHERE id_product = '18764' 29/06/2023 11:25:21 am >> UPDATE ps_product_shop SET wholesale_price = '5.17', price = '12.7049', id_tax_rules_group = '1', id_category_default = '424', 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 = '18764' 29/06/2023 11:25:21 am >> DELETE FROM ps_specific_price WHERE id_product = '18764' 29/06/2023 11:27:54 am >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 29/06/2023 11:27:54 am >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21289' , '1' , '' , 'nuovo-prodotto' ) 29/06/2023 11:27:54 am >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21289' , '1' , '1' , '2' , NOW() , NOW() ) 29/06/2023 11:27:54 am >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21289' , '0' , '1' , '0' , '0' ) 29/06/2023 11:38:13 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002161' AND id_product != '21289' AND ean13 != '' 29/06/2023 11:38:13 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002161', date_upd = NOW() WHERE id_product = '21289' 29/06/2023 11:38:13 am >> UPDATE ps_product_lang SET name = 'STELLARIO CM 22', description = '' WHERE id_product = '21289' 29/06/2023 11:38:13 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.0000' WHERE id_product = '21289' 29/06/2023 11:38:13 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.0000', id_tax_rules_group = '1', id_category_default = '424', 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 = '21289' 29/06/2023 11:38:13 am >> DELETE FROM ps_specific_price WHERE id_product = '21289' 29/06/2023 11:38:22 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' , '185/A' , '2023-06-28' , 'A' , '0' , '116' , '4669160' , 'VIA SAN DOMENICO snc 80044 OTTAVIANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '218.75' , '179.30' , NOW() , NOW() ) 29/06/2023 11:38:22 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 = '86562' 29/06/2023 11:38:22 am >> DELETE FROM ps_document_detail WHERE id_document = '86562' 29/06/2023 11:38:22 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 ( '86562' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '20' , '20' , '1' , '6.5' , '5.327868852459' , '22' , '45' , '87.2300' ) 29/06/2023 11:38:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '14063' AND id_supplier = '116' 29/06/2023 11:38:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14063' , '116' , '1' ) 29/06/2023 11:38:22 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 ( '86562' , '20487' , 'STELLARIO CM 14 - ART. 70' , '5' , '5' , '1' , '7.6' , '6.2295081967213' , '22' , '45' , '25.4980' ) 29/06/2023 11:38:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '20487' AND id_supplier = '116' 29/06/2023 11:38:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20487' , '116' , '1' ) 29/06/2023 11:38:22 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 ( '86562' , '14064' , 'STELLARIO PLEX CM 16' , '5' , '5' , '1' , '7.6' , '6.2295081967213' , '22' , '45' , '25.4980' ) 29/06/2023 11:38:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '14064' AND id_supplier = '116' 29/06/2023 11:38:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14064' , '116' , '1' ) 29/06/2023 11:38:22 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 ( '86562' , '18764' , 'STELLARIO PLEX CM 18/20' , '12' , '12' , '1' , '10' , '8.1967213114754' , '22' , '45' , '80.5200' ) 29/06/2023 11:38:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '18764' AND id_supplier = '116' 29/06/2023 11:38:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18764' , '116' , '1' ) 29/06/2023 11:39:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2238' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 11:39:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2238' , '2023-06-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '122.95' , NOW() , NOW() ) 29/06/2023 11:39:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86563' 29/06/2023 11:39:59 am >> DELETE FROM ps_document_detail WHERE id_document = '86563' 29/06/2023 11:39:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86563' , '16962' , 'SERVIZIO MESSA P/LINO - ' , '1' , '-1' , '1' , '150' , '122.95081967213' , '22' , '0' , '150.00' ) 29/06/2023 11:41:28 am >> SELECT ean13 FROM ps_product WHERE ean13 = '002161' AND id_product != '21289' AND ean13 != '' 29/06/2023 11:41:28 am >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002161', date_upd = NOW() WHERE id_product = '21289' 29/06/2023 11:41:28 am >> UPDATE ps_product_lang SET name = 'STELLARIO PLEX CM 22', description = '' WHERE id_product = '21289' 29/06/2023 11:41:28 am >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '17.21311475409836' WHERE id_product = '21289' 29/06/2023 11:41:28 am >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '17.21311475409836', id_tax_rules_group = '1', id_category_default = '424', 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 = '21289' 29/06/2023 11:41:28 am >> DELETE FROM ps_specific_price WHERE id_product = '21289' 29/06/2023 11:42:10 am >> UPDATE ps_document SET id_document_type = '31', document_num = '185/A', document_date = '2023-06-28', document_letter = 'A', id_customer = '0', id_supplier = '', id_address = '4669160', address1 = 'VIA SAN DOMENICO snc 80044 OTTAVIANO', address2 = '', note = '', price_shipping = '12.99', id_tax_shipping_rules = '1', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '253.39', price_tax_excluded = '207.69', date_upd = NOW() WHERE id_document = '86562' 29/06/2023 11:42:10 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 = '86562' 29/06/2023 11:42:10 am >> DELETE FROM ps_document_detail WHERE id_document = '86562' 29/06/2023 11:42:11 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 ( '86562' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '20' , '20' , '1' , '6.5000' , '5.327868852459' , '22' , '45' , '87.23' ) 29/06/2023 11:42:11 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 ( '86562' , '20487' , 'STELLARIO CM 14 - ART. 70' , '5' , '5' , '1' , '7.6000' , '6.2295081967213' , '22' , '45' , '25.50' ) 29/06/2023 11:42:11 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 ( '86562' , '14064' , 'STELLARIO PLEX CM 16' , '5' , '5' , '1' , '7.6000' , '6.2295081967213' , '22' , '45' , '25.50' ) 29/06/2023 11:42:11 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 ( '86562' , '18764' , 'STELLARIO PLEX CM 18/20' , '12' , '12' , '1' , '10.0000' , '8.1967213114754' , '22' , '45' , '80.52' ) 29/06/2023 11:42:11 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 ( '86562' , '21289' , 'STELLARIO PLEX CM 22' , '2' , '2' , '1' , '14' , '11.475409836066' , '22' , '45' , '18.7880' ) 29/06/2023 12:20:13 pm >> SELECT document_num FROM ps_document WHERE document_num = '2239' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 12:20:13 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2239' , '2023-06-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.65' , '25.65' , NOW() , NOW() ) 29/06/2023 12:20: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 = '86564' 29/06/2023 12:20:13 pm >> DELETE FROM ps_document_detail WHERE id_document = '86564' 29/06/2023 12:20: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 ( '86564' , '21194' , 'EMOZIONI DI DIO - E. DURAND' , '1' , '-1' , '4' , '27.00' , '27' , '0' , '5' , '25.65' ) 29/06/2023 12:23:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '2240' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 12:23:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2240' , '2023-06-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '2.00' , '1.64' , NOW() , NOW() ) 29/06/2023 12:23: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 = '86565' 29/06/2023 12:23:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '86565' 29/06/2023 12:23: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 ( '86565' , '17005' , 'BIGLIETTO AUGURALE medio' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 29/06/2023 12:59:05 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 29/06/2023 12:59:05 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21290' , '1' , '' , 'nuovo-prodotto' ) 29/06/2023 12:59:05 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '21290' , '1' , '1' , '2' , NOW() , NOW() ) 29/06/2023 12:59:05 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '21290' , '0' , '1' , '0' , '0' ) 29/06/2023 01:00:10 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002162' AND id_product != '21290' AND ean13 != '' 29/06/2023 01:00:10 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002162', date_upd = NOW() WHERE id_product = '21290' 29/06/2023 01:00:10 pm >> UPDATE ps_product_lang SET name = 'ROSARIO ADDOLORATA', description = '' WHERE id_product = '21290' 29/06/2023 01:00:10 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.0163934426229515' WHERE id_product = '21290' 29/06/2023 01:00:10 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.0163934426229515', id_tax_rules_group = '1', id_category_default = '154', 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 = '21290' 29/06/2023 01:00:10 pm >> DELETE FROM ps_specific_price WHERE id_product = '21290' 29/06/2023 01:00:14 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 = '21290' 29/06/2023 01:00:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '21291' , '1' , '' , 'nuovo-prodotto' ) 29/06/2023 01:00:14 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 '21291' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '21290' 29/06/2023 01:00:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '21291' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '21290' 29/06/2023 01:01: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 ( '31' , '56' , '2023-06-27' , '' , '0' , '60' , '2655' , 'Z.I. PIANE MAVONE 64042 COLLEDARA' , '' , 'CONTROLLARE NUMERO' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '1183.40' , '970.00' , NOW() , NOW() ) 29/06/2023 01:01: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 = '86566' 29/06/2023 01:01:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '86566' 29/06/2023 01:01:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86566' , '21290' , 'ROSARIO ADDOLORATA' , '500' , '500' , '1' , '2' , '1.6393442622951' , '22' , '3' , '1183.4000' ) 29/06/2023 01:01:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '21290' AND id_supplier = '60' 29/06/2023 01:01:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '21290' , '60' , '1' ) 29/06/2023 02:36:22 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '001496' AND id_product != '16962' AND ean13 != '' 29/06/2023 02:36:22 pm >> UPDATE ps_product SET id_supplier = '126', reference = '', ean13 = '001496', date_upd = NOW() WHERE id_product = '16962' 29/06/2023 02:36:22 pm >> UPDATE ps_product_lang SET name = 'SERVIZIO MESSA LINO ', description = '' WHERE id_product = '16962' 29/06/2023 02:36:22 pm >> UPDATE ps_product SET wholesale_price = '60.00', on_sale = '0', price = '131.1475' WHERE id_product = '16962' 29/06/2023 02:36:22 pm >> UPDATE ps_product_shop SET wholesale_price = '60.00', price = '131.1475', id_tax_rules_group = '1', id_category_default = '448', 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 = '16962' 29/06/2023 02:36:22 pm >> DELETE FROM ps_specific_price WHERE id_product = '16962' 29/06/2023 03:42:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2241' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 03:42:50 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' , '2241' , '2023-06-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.20' , '34.62' , NOW() , NOW() ) 29/06/2023 03:42:50 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 = '86567' 29/06/2023 03:42:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '86567' 29/06/2023 03:42:50 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 ( '86567' , '17526' , 'PREGHIERE EUCARISTICHE PER CONCELEBRAZIONE N.E.' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 29/06/2023 03:42:50 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 ( '86567' , '19089' , 'OSTIA MAGNA 150 -OM150' , '1' , '-1' , '3' , '4.50' , '4.3269230769231' , '4' , '0' , '4.50' ) 29/06/2023 03:42:50 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 ( '86567' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 29/06/2023 04:32:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '69/A' AND id_document != '86558' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 04:32:22 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '69/A', document_date = '2023-06-29', document_letter = 'A', id_customer = '3550', id_supplier = '', id_address = '4671016', address1 = 'VIA S. MARIA IN MONTICELLI, 28 00186 ROMA', 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 = '383.30', price_tax_excluded = '321.72', date_upd = NOW() WHERE id_document = '86558' 29/06/2023 04:32: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 = '86558' 29/06/2023 04:32:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '86558' 29/06/2023 04:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '15' , '-15' , '4' , '0.7000' , '0.7' , '0' , '0' , '10.50' ) 29/06/2023 04:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21196' , 'CALENDARIO LITURGICO 2024 ***' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 29/06/2023 04:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21192' , 'SULLA TUA PAROLA - SET/OTT 23 ****' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 29/06/2023 04:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21198' , 'AMEN - SET 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 04:32:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86558' , '21199' , 'AMEN - OTT 2023 ***' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 29/06/2023 04:32: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 ( '86558' , '21068' , 'MESSALINO AGO/SET/OTT 2023***' , '3' , '-3' , '4' , '6.0000' , '6' , '0' , '0' , '18.00' ) 29/06/2023 04:32: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 ( '86558' , '16456' , 'CINGOLO - CING03***' , '1' , '-1' , '1' , '14.0000' , '11.475409836066' , '22' , '0' , '14.00' ) 29/06/2023 04:32: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 ( '86558' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '2' , '-2' , '1' , '37.0000' , '30.327868852459' , '22' , '0' , '74.00' ) 29/06/2023 04:32: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 ( '86558' , '19606' , 'CAMICIA SOTTOTALARE MISTO COTONE- C15' , '2' , '-2' , '1' , '39.0000' , '31.967213114754' , '22' , '0' , '78.00' ) 29/06/2023 04:32: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 ( '86558' , '14962' , 'CAMICIA PER TALARE - COTONE - 41 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 29/06/2023 04:32: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 ( '86558' , '14960' , 'CAMICIA PER TALARE - COTONE - 39 ***' , '2' , '-2' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '84.00' ) 29/06/2023 04:32: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 ( '86558' , '14961' , 'CAMICIA PER TALARE - COTONE - 40 ***' , '1' , '-1' , '1' , '42.0000' , '34.426229508197' , '22' , '0' , '42.00' ) 29/06/2023 04:32: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 ( '86558' , '14247' , 'ROSARIO ULIVO OVALE CON SETA E CROCE SAN DAMIANO' , '5' , '-5' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '7.50' ) 29/06/2023 06:20:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2242' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 06:20:47 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2242' , '2023-06-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '2.46' , NOW() , NOW() ) 29/06/2023 06:20:47 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86568' 29/06/2023 06:20:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '86568' 29/06/2023 06:20:47 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86568' , '3104' , 'CROCE SAN BENEDETTO - CARTONCINO' , '2' , '-2' , '1' , '1.50' , '1.2295081967213' , '22' , '0' , '3.00' ) 29/06/2023 06:29:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2242' AND id_document != '86568' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 06:29:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2242', document_date = '2023-06-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 = '3.00', price_tax_excluded = '2.46', date_upd = NOW() WHERE id_document = '86568' 29/06/2023 06:29:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86568' 29/06/2023 06:29:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '86568' 29/06/2023 06:29:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86568' , '20526' , 'MEDAGLIA SAN BENEDETTO 36MM - M275/A' , '3' , '-3' , '1' , '1' , '0.81967213114754' , '22' , '0' , '3.00' ) 29/06/2023 06:33:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2243' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 06:33:54 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2243' , '2023-06-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.00' , '15.00' , NOW() , NOW() ) 29/06/2023 06:33:54 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '86569' 29/06/2023 06:33:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '86569' 29/06/2023 06:33:54 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '86569' , '21144' , 'FIORETTI DI SAN FRANCESCO' , '1' , '-1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 29/06/2023 06:49:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '2244' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 06:49: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' , '2244' , '2023-06-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '40.00' , '32.79' , NOW() , NOW() ) 29/06/2023 06:49: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 = '86570' 29/06/2023 06:49:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '86570' 29/06/2023 06:49: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 ( '86570' , '17609' , 'CATENINA MEDAGLIA MIR. ARG. E STRASS - SL209RC' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 29/06/2023 07:06:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2245' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2023-06-29') 29/06/2023 07:06:06 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' , '2245' , '2023-06-29' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1430.00' , '1172.13' , NOW() , NOW() ) 29/06/2023 07:06:06 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 = '86571' 29/06/2023 07:06:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '86571' 29/06/2023 07:06:06 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 ( '86571' , '18335' , 'CALICE METALLO COPPA ARG. 800 - 12078MATER' , '1' , '-1' , '1' , '1320' , '1081.9672131148' , '22' , '0' , '1320.00' ) 29/06/2023 07:06:06 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 ( '86571' , '19852' , 'PATENA CON GRECA CM 19 - 999/7 D' , '1' , '-1' , '1' , '110' , '90.16393442623' , '22' , '0' , '110.00' )