30/06/2022 08:30:54 am >> SELECT document_num FROM ps_document WHERE document_num = '96' AND id_document != '58595' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-04') 30/06/2022 08:30:54 am >> UPDATE ps_document SET id_document_type = '21', document_num = '96', document_date = '2022-06-04', document_letter = '', id_customer = '690', id_supplier = '', id_address = '4670873', address1 = 'VIA MUNICIPIO, 2 31014 COLLE UMBERTO', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '42.10', price_tax_excluded = '42.10', date_upd = NOW() WHERE id_document = '58595' 30/06/2022 08:30:54 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 = '58595' 30/06/2022 08:30:54 am >> DELETE FROM ps_document_detail WHERE id_document = '58595' 30/06/2022 08:30:54 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 ( '58595' , '15020' , 'PREGARE OGNI GIORNO' , '40' , '-40' , '4' , '1.00' , '1' , '0' , '15' , '34.00' ) 30/06/2022 08:30:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '15020' AND id_supplier = '' 30/06/2022 08:30:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15020' , '' , '1' ) 30/06/2022 08:30:54 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 ( '58595' , '0' , 'contrassegno' , '1' , '-1' , '0' , '3.1' , '3.1' , '' , '0' , '3.10' ) 30/06/2022 08:30:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 30/06/2022 08:30:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 30/06/2022 08:32:53 am >> SELECT document_num FROM ps_document WHERE document_num = '100' AND id_document != '58857' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-22') 30/06/2022 08:32:53 am >> UPDATE ps_document SET id_document_type = '21', document_num = '100', document_date = '2022-06-22', document_letter = '', id_customer = '3887', id_supplier = '', id_address = '4674407', address1 = 'PIAZZA DELL\\\'AURO 1 80062 META ', address2 = '', note = '', price_shipping = '5.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '42.10', price_tax_excluded = '42.10', date_upd = NOW() WHERE id_document = '58857' 30/06/2022 08:32: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 = '58857' 30/06/2022 08:32:53 am >> DELETE FROM ps_document_detail WHERE id_document = '58857' 30/06/2022 08:32: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 ( '58857' , '5251' , 'INCONTRI EUCARISTICI' , '10' , '-10' , '4' , '3.42' , '3.42' , '0' , '0' , '34.20' ) 30/06/2022 08:32:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 30/06/2022 08:32:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 30/06/2022 08:32: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 ( '58857' , '0' , 'contrassegno' , '1' , '-1' , '0' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 30/06/2022 08:32:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 30/06/2022 08:32:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 30/06/2022 08:57:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2028' AND id_document != '58881' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-24') 30/06/2022 08:57:30 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2028', document_date = '2022-06-24', 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.60', price_tax_excluded = '15.60', date_upd = NOW() WHERE id_document = '58881' 30/06/2022 08:57:30 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58881' 30/06/2022 08:57:30 am >> DELETE FROM ps_document_detail WHERE id_document = '58881' 30/06/2022 08:57: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 ( '58881' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '7.18' , '7.18' , '0' , '0' , '7.18' ) 30/06/2022 08:57:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 30/06/2022 08:57:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 30/06/2022 08:57: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 ( '58881' , '19693' , 'CALENDARIO LITURGICO 2023' , '2' , '-2' , '4' , '0.50' , '0.5' , '0' , '0' , '1.00' ) 30/06/2022 08:57:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 30/06/2022 08:57:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 30/06/2022 08:57: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 ( '58881' , '19684' , 'AMEN - SETT. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/06/2022 08:57:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = '' 30/06/2022 08:57:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '' , '1' ) 30/06/2022 08:57: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 ( '58881' , '19685' , 'AMEN - OTT 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 30/06/2022 08:57:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 30/06/2022 08:57:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 30/06/2022 08:57:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2/A' AND id_document != '50074' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-01-12') 30/06/2022 08:57:54 am >> UPDATE ps_document SET id_document_type = '24', document_num = '2/A', document_date = '2022-01-12', document_letter = 'A', id_customer = '206', id_supplier = '', id_address = '4671015', address1 = 'VIA N. BUONSERVIZI, 25 84135 SALERNO', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '5.80', price_tax_excluded = '5.80', date_upd = NOW() WHERE id_document = '50074' 30/06/2022 08:57:54 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '50074' 30/06/2022 08:57:54 am >> DELETE FROM ps_document_detail WHERE id_document = '50074' 30/06/2022 08:57:54 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '50074' , '19686' , 'PAROLA E PREGHIERA - SET 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 30/06/2022 08:57:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '19686' AND id_supplier = '' 30/06/2022 08:57:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19686' , '' , '1' ) 30/06/2022 09:33:30 am >> SELECT document_num FROM ps_document WHERE document_num = '2103' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 09:33: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' , '2103' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '116.20' , '101.19' , NOW() , NOW() ) 30/06/2022 09:33: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 = '58970' 30/06/2022 09:33:30 am >> DELETE FROM ps_document_detail WHERE id_document = '58970' 30/06/2022 09:33: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 ( '58970' , '11151' , 'LIBRI' , '6' , '-6' , '4' , '3.5' , '3.5' , '0' , '0' , '21.00' ) 30/06/2022 09:33:30 am >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 30/06/2022 09:33:30 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 30/06/2022 09:33: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 ( '58970' , '7311' , 'OSTIA SOTTILE 74MM' , '8' , '-8' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '15.20' ) 30/06/2022 09:33:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 30/06/2022 09:33:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 30/06/2022 09:33: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 ( '58970' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 30/06/2022 09:33:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 30/06/2022 09:33:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 30/06/2022 09:33: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 ( '58970' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.00' , '24.590163934426' , '22' , '0' , '30.00' ) 30/06/2022 09:33:31 am >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 30/06/2022 09:33:31 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 30/06/2022 09:37:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2104' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 09:37:25 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' , '2104' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 30/06/2022 09:37: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 = '58971' 30/06/2022 09:37:25 am >> DELETE FROM ps_document_detail WHERE id_document = '58971' 30/06/2022 09:37: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 ( '58971' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 30/06/2022 09:37:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 30/06/2022 09:37:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 30/06/2022 09:37:49 am >> SELECT document_num FROM ps_document WHERE document_num = '2105' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 09:37:49 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' , '2105' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.45' , '5.45' , NOW() , NOW() ) 30/06/2022 09:37: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 = '58972' 30/06/2022 09:37:49 am >> DELETE FROM ps_document_detail WHERE id_document = '58972' 30/06/2022 09:37:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58972' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2022 09:37:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 30/06/2022 09:37:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 30/06/2022 09:37:50 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58972' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '1' , '-1' , '4' , '0.70' , '0.7' , '0' , '0' , '0.70' ) 30/06/2022 09:37:50 am >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 30/06/2022 09:37:50 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 30/06/2022 10:59:19 am >> SELECT document_num FROM ps_document WHERE document_num = '2106' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 10:59:19 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' , '2106' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.20' , '15.20' , NOW() , NOW() ) 30/06/2022 10:59:19 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 = '58973' 30/06/2022 10:59:19 am >> DELETE FROM ps_document_detail WHERE id_document = '58973' 30/06/2022 10:59:19 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 ( '58973' , '16852' , 'COMPAGNIA DELLO SPIRITO - G. FORLAI' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 30/06/2022 10:59:19 am >> DELETE FROM ps_product_supplier WHERE id_product = '16852' AND id_supplier = '' 30/06/2022 10:59:19 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16852' , '' , '1' ) 30/06/2022 10:59:57 am >> SELECT document_num FROM ps_document WHERE document_num = '2107' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 10:59:57 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' , '2107' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '20.00' , '16.39' , NOW() , NOW() ) 30/06/2022 10:59:57 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 = '58974' 30/06/2022 10:59:57 am >> DELETE FROM ps_document_detail WHERE id_document = '58974' 30/06/2022 10:59:57 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 ( '58974' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 30/06/2022 10:59:57 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/06/2022 10:59:57 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/06/2022 11:05:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2108' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 11:05:21 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2108' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.37' , '8.37' , NOW() , NOW() ) 30/06/2022 11:05: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 = '58975' 30/06/2022 11:05:21 am >> DELETE FROM ps_document_detail WHERE id_document = '58975' 30/06/2022 11:05:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58975' , '18385' , 'LETTERA A GESU NEL DESERTO - T. BELLO' , '1' , '-1' , '4' , '2.90' , '2.9' , '0' , '5' , '2.76' ) 30/06/2022 11:05:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '18385' AND id_supplier = '' 30/06/2022 11:05:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18385' , '' , '1' ) 30/06/2022 11:05:21 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58975' , '19469' , 'SALMI PREGHIERE PER I RAGAZZI - G. NOVELLA' , '1' , '-1' , '4' , '5.90' , '5.9' , '0' , '5' , '5.61' ) 30/06/2022 11:05:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19469' AND id_supplier = '' 30/06/2022 11:05:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19469' , '' , '1' ) 30/06/2022 11:23:44 am >> SELECT document_num FROM ps_document WHERE document_num = '2109' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 11:23:44 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2109' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.00' , '5.00' , NOW() , NOW() ) 30/06/2022 11:23:44 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58976' 30/06/2022 11:23:44 am >> DELETE FROM ps_document_detail WHERE id_document = '58976' 30/06/2022 11:23:44 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58976' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 30/06/2022 11:23:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 30/06/2022 11:23:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 30/06/2022 11:57:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2110' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 11:57: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 ( '11' , '2110' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '16.00' , '16.00' , NOW() , NOW() ) 30/06/2022 11:57: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 = '58977' 30/06/2022 11:57:22 am >> DELETE FROM ps_document_detail WHERE id_document = '58977' 30/06/2022 11:57: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 ( '58977' , '19588' , 'SCELTA DI ENEA - L. EPICOCO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '0' , '16.00' ) 30/06/2022 11:57:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '19588' AND id_supplier = '' 30/06/2022 11:57:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19588' , '' , '1' ) 30/06/2022 12:11:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2111' AND id_document != '' AND id_document_type LIKE '14' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 12:11: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' , '2111' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 30/06/2022 12:11: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 = '58978' 30/06/2022 12:11:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '58978' 30/06/2022 12:11: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 ( '58978' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2022 12:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 30/06/2022 12:11:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 30/06/2022 12:13:41 pm >> SELECT document_num FROM ps_document WHERE document_num = '1167' AND id_document != '55300' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-16') 30/06/2022 12:13:41 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1167', document_date = '2022-04-16', 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 = '430.00', price_tax_excluded = '352.46', date_upd = NOW() WHERE id_document = '55300' 30/06/2022 12:13: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 = '55300' 30/06/2022 12:13:41 pm >> DELETE FROM ps_document_detail WHERE id_document = '55300' 30/06/2022 12:13: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 ( '55300' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '20' , '-20' , '1' , '3' , '2.4590163934426' , '22' , '0' , '60.00' ) 30/06/2022 12:13:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 30/06/2022 12:13:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 30/06/2022 12:13: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 ( '55300' , '16040' , 'STOLA ROMANA S/MOIRE - 7336S' , '1' , '-1' , '1' , '370' , '303.27868852459' , '22' , '0' , '370.00' ) 30/06/2022 12:13:41 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16040' AND id_supplier = '' 30/06/2022 12:13:41 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16040' , '' , '1' ) 30/06/2022 12:17:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '2112' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 12:17:21 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' , '2112' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '23.08' , NOW() , NOW() ) 30/06/2022 12:17:21 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 = '58979' 30/06/2022 12:17:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '58979' 30/06/2022 12:17:21 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 ( '58979' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.00' , '1.9230769230769' , '4' , '0' , '10.00' ) 30/06/2022 12:17:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 30/06/2022 12:17:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 30/06/2022 12:17:21 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 ( '58979' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 30/06/2022 12:17:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/06/2022 12:17:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/06/2022 12:21:46 pm >> SELECT document_num FROM ps_document WHERE document_num = '2113' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 12:21:46 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' , '2113' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.50' , '19.50' , NOW() , NOW() ) 30/06/2022 12:21: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 = '58980' 30/06/2022 12:21:46 pm >> DELETE FROM ps_document_detail WHERE id_document = '58980' 30/06/2022 12:21: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 ( '58980' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '19.5' , '19.5' , '0' , '0' , '19.50' ) 30/06/2022 12:21:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 30/06/2022 12:21:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 30/06/2022 12:35:40 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 30/06/2022 12:35:40 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19716' , '1' , '' , 'nuovo-prodotto' ) 30/06/2022 12:35:40 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19716' , '1' , '1' , '2' , NOW() , NOW() ) 30/06/2022 12:35:40 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19716' , '0' , '1' , '0' , '0' ) 30/06/2022 12:38:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002006' AND id_product != '19716' AND ean13 != '' 30/06/2022 12:38:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002006', date_upd = NOW() WHERE id_product = '19716' 30/06/2022 12:38:02 pm >> UPDATE ps_product_lang SET name = 'MEDAGLIA SAN BENEDETTO - Q1001-OX', description = '' WHERE id_product = '19716' 30/06/2022 12:38:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '0.2459016393442623' WHERE id_product = '19716' 30/06/2022 12:38:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '0.2459016393442623', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19716' 30/06/2022 12:38:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '19716' 30/06/2022 12:38:04 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19716' 30/06/2022 12:38:04 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19717' , '1' , '' , 'nuovo-prodotto' ) 30/06/2022 12:38:04 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19717' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19716' 30/06/2022 12:38:04 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19717' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19716' 30/06/2022 12:42:27 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '002007' AND id_product != '19717' AND ean13 != '' 30/06/2022 12:42:27 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '002007', date_upd = NOW() WHERE id_product = '19717' 30/06/2022 12:42:27 pm >> UPDATE ps_product_lang SET name = 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT', description = '' WHERE id_product = '19717' 30/06/2022 12:42:27 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '4.754098360655738' WHERE id_product = '19717' 30/06/2022 12:42:27 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '4.754098360655738', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19717' 30/06/2022 12:42:27 pm >> DELETE FROM ps_specific_price WHERE id_product = '19717' 30/06/2022 12:42: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 = '19717' 30/06/2022 12:42:28 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19718' , '1' , '' , 'nuovo-prodotto' ) 30/06/2022 12:42: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 '19718' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19717' 30/06/2022 12:42:28 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19718' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19717' 30/06/2022 12:43:20 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846135668' AND id_product != '19718' AND ean13 != '' 30/06/2022 12:43:20 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846135668', date_upd = NOW() WHERE id_product = '19718' 30/06/2022 12:43:20 pm >> UPDATE ps_product_lang SET name = 'CROCE CORPO IN RESINA - CL192', description = '' WHERE id_product = '19718' 30/06/2022 12:43:20 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '28.688524590163937' WHERE id_product = '19718' 30/06/2022 12:43:20 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '28.688524590163937', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19718' 30/06/2022 12:43:20 pm >> DELETE FROM ps_specific_price WHERE id_product = '19718' 30/06/2022 12:43:21 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 = '19718' 30/06/2022 12:43:21 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19719' , '1' , '' , 'nuovo-prodotto' ) 30/06/2022 12:43:21 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 '19719' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19718' 30/06/2022 12:43:21 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19719' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19718' 30/06/2022 12:44:19 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846207761' AND id_product != '19719' AND ean13 != '' 30/06/2022 12:44:19 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846207761', date_upd = NOW() WHERE id_product = '19719' 30/06/2022 12:44:19 pm >> UPDATE ps_product_lang SET name = 'CROCE IN LEGNO CORPO RESINA - CL249', description = '' WHERE id_product = '19719' 30/06/2022 12:44:19 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.0655737704918' WHERE id_product = '19719' 30/06/2022 12:44:19 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.0655737704918', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19719' 30/06/2022 12:44:19 pm >> DELETE FROM ps_specific_price WHERE id_product = '19719' 30/06/2022 12:44:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846207761' AND id_product != '19719' AND ean13 != '' 30/06/2022 12:44:30 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846207761', date_upd = NOW() WHERE id_product = '19719' 30/06/2022 12:44:30 pm >> UPDATE ps_product_lang SET name = 'CROCE IN LEGNO CORPO RESINA - CL249', description = '' WHERE id_product = '19719' 30/06/2022 12:44:30 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '36.0655737704918' WHERE id_product = '19719' 30/06/2022 12:44:30 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '36.0655737704918', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19719' 30/06/2022 12:44:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '19719' 30/06/2022 12:44:31 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 = '19719' 30/06/2022 12:44:31 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19720' , '1' , '' , 'nuovo-prodotto' ) 30/06/2022 12:44:31 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 '19720' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19719' 30/06/2022 12:44:31 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19720' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19719' 30/06/2022 12:45:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846207723' AND id_product != '19720' AND ean13 != '' 30/06/2022 12:45:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846207723', date_upd = NOW() WHERE id_product = '19720' 30/06/2022 12:45:32 pm >> UPDATE ps_product_lang SET name = 'CROCE LEGNO MET. - CL247', description = '' WHERE id_product = '19720' 30/06/2022 12:45:32 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '18.852459016393443' WHERE id_product = '19720' 30/06/2022 12:45:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '18.852459016393443', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19720' 30/06/2022 12:45:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '19720' 30/06/2022 12:45: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 = '19720' 30/06/2022 12:45:33 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19721' , '1' , '' , 'nuovo-prodotto' ) 30/06/2022 12:45: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 '19721' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19720' 30/06/2022 12:45:33 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19721' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19720' 30/06/2022 12:46:38 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846207631' AND id_product != '19721' AND ean13 != '' 30/06/2022 12:46:38 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846207631', date_upd = NOW() WHERE id_product = '19721' 30/06/2022 12:46:38 pm >> UPDATE ps_product_lang SET name = 'CROCE CON BASE CORPO RESINA - CLB245', description = '' WHERE id_product = '19721' 30/06/2022 12:46:38 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15.98360655737705' WHERE id_product = '19721' 30/06/2022 12:46:38 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15.98360655737705', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19721' 30/06/2022 12:46:38 pm >> DELETE FROM ps_specific_price WHERE id_product = '19721' 30/06/2022 12:46: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 = '19721' 30/06/2022 12:46:39 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19722' , '1' , '' , 'nuovo-prodotto' ) 30/06/2022 12:46:39 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 '19722' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19721' 30/06/2022 12:46:39 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19722' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19721' 30/06/2022 12:47:47 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846206627' AND id_product != '19722' AND ean13 != '' 30/06/2022 12:47:47 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846206627', date_upd = NOW() WHERE id_product = '19722' 30/06/2022 12:47:47 pm >> UPDATE ps_product_lang SET name = 'CROCE ULIVO CORDA - PG674', description = '' WHERE id_product = '19722' 30/06/2022 12:47:47 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '29.918032786885245' WHERE id_product = '19722' 30/06/2022 12:47:47 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '29.918032786885245', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19722' 30/06/2022 12:47:47 pm >> DELETE FROM ps_specific_price WHERE id_product = '19722' 30/06/2022 12:47: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 = '19722' 30/06/2022 12:47:48 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19723' , '1' , '' , 'nuovo-prodotto' ) 30/06/2022 12:47: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 '19723' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19722' 30/06/2022 12:47:48 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19723' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19722' 30/06/2022 12:49:24 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846199219' AND id_product != '19723' AND ean13 != '' 30/06/2022 12:49:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846199219', date_upd = NOW() WHERE id_product = '19723' 30/06/2022 12:49:24 pm >> UPDATE ps_product_lang SET name = 'ROSARIO COPPIGLIATO MM8 - RE1715-SM', description = '' WHERE id_product = '19723' 30/06/2022 12:49:24 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.426229508196721' WHERE id_product = '19723' 30/06/2022 12:49:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.426229508196721', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19723' 30/06/2022 12:49:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '19723' 30/06/2022 12:49:26 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 = '19723' 30/06/2022 12:49:26 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19724' , '1' , '' , 'nuovo-prodotto' ) 30/06/2022 12:49:26 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 '19724' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19723' 30/06/2022 12:49:26 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19724' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19723' 30/06/2022 12:50:41 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846199233' AND id_product != '19724' AND ean13 != '' 30/06/2022 12:50:41 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '8027846199233', date_upd = NOW() WHERE id_product = '19724' 30/06/2022 12:50:41 pm >> UPDATE ps_product_lang SET name = 'ROSARIO COPPIGLIATO S. FAMIGLIA MM8 - RE1717-SM', description = '' WHERE id_product = '19724' 30/06/2022 12:50:41 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9.426229508196721' WHERE id_product = '19724' 30/06/2022 12:50:41 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9.426229508196721', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19724' 30/06/2022 12:50:41 pm >> DELETE FROM ps_specific_price WHERE id_product = '19724' 30/06/2022 12:50: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 = '19724' 30/06/2022 12:50:42 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19725' , '1' , '' , 'nuovo-prodotto' ) 30/06/2022 12:50: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 '19725' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19724' 30/06/2022 12:50:42 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19725' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19724' 30/06/2022 03:04:47 pm >> SELECT document_num FROM ps_document WHERE document_num = '2114' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 03:04: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' , '2114' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.00' , '14.00' , NOW() , NOW() ) 30/06/2022 03:04: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 = '58981' 30/06/2022 03:04:47 pm >> DELETE FROM ps_document_detail WHERE id_document = '58981' 30/06/2022 03:04: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 ( '58981' , '19713' , 'vivere con gli angeli' , '1' , '-1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 30/06/2022 03:04:47 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19713' AND id_supplier = '' 30/06/2022 03:04:47 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19713' , '' , '1' ) 30/06/2022 03:39:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2115' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 03:39:36 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' , '2115' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '410.00' , '336.07' , NOW() , NOW() ) 30/06/2022 03:39:36 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 = '58982' 30/06/2022 03:39:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '58982' 30/06/2022 03:39:36 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 ( '58982' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '140' , '114.75409836066' , '22' , '0' , '140.00' ) 30/06/2022 03:39:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17544' AND id_supplier = '' 30/06/2022 03:39:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17544' , '' , '1' ) 30/06/2022 03:39:36 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 ( '58982' , '17404' , 'CASULA RIGATA' , '1' , '-1' , '1' , '270.00' , '221.31147540984' , '22' , '0' , '270.00' ) 30/06/2022 03:39:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17404' AND id_supplier = '' 30/06/2022 03:39:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17404' , '' , '1' ) 30/06/2022 03:43:30 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846219658' AND id_product != '18715' AND ean13 != '' 30/06/2022 03:43:30 pm >> UPDATE ps_product SET id_supplier = '43', reference = '', ean13 = '8027846219658', date_upd = NOW() WHERE id_product = '18715' 30/06/2022 03:43:30 pm >> UPDATE ps_product_lang SET name = 'COLLANA CON MEDAGLIA ARG. STRASS - SL211-RC', description = '' WHERE id_product = '18715' 30/06/2022 03:43:30 pm >> UPDATE ps_product SET wholesale_price = '13.02', on_sale = '0', price = '29.5082' WHERE id_product = '18715' 30/06/2022 03:43:30 pm >> UPDATE ps_product_shop SET wholesale_price = '13.02', price = '29.5082', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '18715' 30/06/2022 03:43:30 pm >> DELETE FROM ps_specific_price WHERE id_product = '18715' 30/06/2022 03:47:05 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846089114' AND id_product != '4915' AND ean13 != '' 30/06/2022 03:47:05 pm >> UPDATE ps_product SET id_supplier = '43', reference = '2013', ean13 = '8027846089114', date_upd = NOW() WHERE id_product = '4915' 30/06/2022 03:47:06 pm >> UPDATE ps_product_lang SET name = 'ICONA SU TELA LEGNO MADONNA NODI CM 22X16,5 - AN025 ', description = '' WHERE id_product = '4915' 30/06/2022 03:47:06 pm >> UPDATE ps_product SET wholesale_price = '9.78', on_sale = '0', price = '22.950819672131146' WHERE id_product = '4915' 30/06/2022 03:47:06 pm >> UPDATE ps_product_shop SET wholesale_price = '9.78', price = '22.950819672131146', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4915' 30/06/2022 03:47:06 pm >> DELETE FROM ps_specific_price WHERE id_product = '4915' 30/06/2022 03:47:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '8027846089114' AND id_product != '4915' AND ean13 != '' 30/06/2022 03:47:32 pm >> UPDATE ps_product SET id_supplier = '43', reference = '2013', ean13 = '8027846089114', date_upd = NOW() WHERE id_product = '4915' 30/06/2022 03:47:32 pm >> UPDATE ps_product_lang SET name = 'ICONA SU TELA LEGNO MADONNA NODI CM 22X16,5 - AN025 ', description = '' WHERE id_product = '4915' 30/06/2022 03:47:32 pm >> UPDATE ps_product SET wholesale_price = '9.78', on_sale = '0', price = '22.950819672131146' WHERE id_product = '4915' 30/06/2022 03:47:32 pm >> UPDATE ps_product_shop SET wholesale_price = '9.78', price = '22.950819672131146', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '4915' 30/06/2022 03:47:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '4915' 30/06/2022 04:00:58 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000495' AND id_product != '9183' AND ean13 != '' 30/06/2022 04:00:58 pm >> UPDATE ps_product SET id_supplier = '43', reference = '2013', ean13 = '000495', date_upd = NOW() WHERE id_product = '9183' 30/06/2022 04:00:58 pm >> UPDATE ps_product_lang SET name = 'ROSARIO S. MICHELE - LEGNO RL 753 ', description = '' WHERE id_product = '9183' 30/06/2022 04:00:58 pm >> UPDATE ps_product SET wholesale_price = '1.64', on_sale = '0', price = '3.6885245901639343' WHERE id_product = '9183' 30/06/2022 04:00:58 pm >> UPDATE ps_product_shop SET wholesale_price = '1.64', price = '3.6885245901639343', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9183' 30/06/2022 04:00:58 pm >> DELETE FROM ps_specific_price WHERE id_product = '9183' 30/06/2022 04:03:56 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '000494' AND id_product != '9184' AND ean13 != '' 30/06/2022 04:03:56 pm >> UPDATE ps_product SET id_supplier = '43', reference = '2013', ean13 = '000494', date_upd = NOW() WHERE id_product = '9184' 30/06/2022 04:03:56 pm >> UPDATE ps_product_lang SET name = 'ROSARIO S. MICHELE IN CRISTALLO - RL 753/C', description = '' WHERE id_product = '9184' 30/06/2022 04:03:56 pm >> UPDATE ps_product SET wholesale_price = '1.79', on_sale = '0', price = '3.9344262295081966' WHERE id_product = '9184' 30/06/2022 04:03:56 pm >> UPDATE ps_product_shop SET wholesale_price = '1.79', price = '3.9344262295081966', id_tax_rules_group = '1', id_category_default = '151', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9184' 30/06/2022 04:03:56 pm >> DELETE FROM ps_specific_price WHERE id_product = '9184' 30/06/2022 04:11: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 ( '31' , '0' , '2022-06-30' , '' , '0' , '43' , '2638' , 'VIA COSTABIANCA, 43 60025 LORETO' , '' , 'INSERIRE N. FATTURA' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '372.38' , '305.23' , NOW() , NOW() ) 30/06/2022 04:11: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 = '58983' 30/06/2022 04:11:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '58983' 30/06/2022 04:11: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 ( '58983' , '19716' , 'MEDAGLIA SAN BENEDETTO - Q1001-OX' , '1000' , '1000' , '1' , '0.1157' , '0.09483606557377' , '22' , '5+5' , '127.3915' ) 30/06/2022 04:11:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19716' AND id_supplier = '43' 30/06/2022 04:11:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19716' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '12' , '12' , '1' , '2.27' , '1.8606557377049' , '22' , '5+5' , '29.9926' ) 30/06/2022 04:11:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19717' AND id_supplier = '43' 30/06/2022 04:11:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19717' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '19718' , 'CROCE CORPO IN RESINA - CL192' , '1' , '1' , '1' , '14.26' , '11.688524590164' , '22' , '5+5' , '15.7010' ) 30/06/2022 04:11:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19718' AND id_supplier = '43' 30/06/2022 04:11:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19718' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '19719' , 'CROCE IN LEGNO CORPO RESINA - CL249' , '1' , '1' , '1' , '18' , '14.754098360656' , '22' , '5+5' , '19.8189' ) 30/06/2022 04:11:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19719' AND id_supplier = '43' 30/06/2022 04:11:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19719' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '19720' , 'CROCE LEGNO MET. - CL247' , '1' , '1' , '1' , '9.1' , '7.4590163934426' , '22' , '5+5' , '10.0196' ) 30/06/2022 04:11:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19720' AND id_supplier = '43' 30/06/2022 04:11:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19720' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '19721' , 'CROCE CON BASE CORPO RESINA - CLB245' , '1' , '1' , '1' , '7.9' , '6.4754098360656' , '22' , '5+5' , '8.6983' ) 30/06/2022 04:11:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19721' AND id_supplier = '43' 30/06/2022 04:11:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19721' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '17599' , 'STATUA S. MICHELE CM 20 COLORATA - 213SM' , '2' , '2' , '1' , '10.12' , '8.2950819672131' , '22' , '5+5' , '22.2853' ) 30/06/2022 04:11:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17599' AND id_supplier = '43' 30/06/2022 04:11:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17599' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '18715' , 'COLLANA CON MEDAGLIA ARG. STRASS - SL211-RC' , '1' , '1' , '1' , '13.7' , '11.229508196721' , '22' , '5+5' , '15.0844' ) 30/06/2022 04:11:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18715' AND id_supplier = '43' 30/06/2022 04:11:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18715' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '17602' , 'BRACCIALE SIMIL PELLE BLU - AC120P' , '1' , '1' , '1' , '5.97' , '4.8934426229508' , '22' , '5+5' , '6.5733' ) 30/06/2022 04:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17602' AND id_supplier = '43' 30/06/2022 04:11:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17602' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '17609' , 'CATENINA MEDAGLIA MIR. ARG. E STRASS - SL209RC' , '1' , '1' , '1' , '16.5' , '13.524590163934' , '22' , '5+5' , '18.1673' ) 30/06/2022 04:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17609' AND id_supplier = '43' 30/06/2022 04:11:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17609' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '19722' , 'CROCE ULIVO CORDA - PG674' , '1' , '1' , '1' , '14.9' , '12.213114754098' , '22' , '5+5' , '16.4056' ) 30/06/2022 04:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19722' AND id_supplier = '43' 30/06/2022 04:11:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19722' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '4915' , 'ICONA SU TELA LEGNO MADONNA NODI CM 22X16,5 - AN025 ' , '1' , '1' , '1' , '11.47' , '9.4016393442623' , '22' , '5+5' , '12.6290' ) 30/06/2022 04:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4915' AND id_supplier = '43' 30/06/2022 04:11:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4915' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '9183' , 'ROSARIO S. MICHELE - LEGNO RL 753 ' , '6' , '6' , '1' , '1.82' , '1.4918032786885' , '22' , '5+5' , '12.0235' ) 30/06/2022 04:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9183' AND id_supplier = '43' 30/06/2022 04:11:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9183' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '9184' , 'ROSARIO S. MICHELE IN CRISTALLO - RL 753/C' , '6' , '6' , '1' , '1.97' , '1.6147540983607' , '22' , '5+5' , '13.0144' ) 30/06/2022 04:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9184' AND id_supplier = '43' 30/06/2022 04:11:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9184' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '19723' , 'ROSARIO COPPIGLIATO MM8 - RE1715-SM' , '3' , '3' , '1' , '3' , '2.4590163934426' , '22' , '5+5' , '9.9094' ) 30/06/2022 04:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19723' AND id_supplier = '43' 30/06/2022 04:11:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19723' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '19724' , 'ROSARIO COPPIGLIATO S. FAMIGLIA MM8 - RE1717-SM' , '3' , '3' , '1' , '3' , '2.4590163934426' , '22' , '5+5' , '9.9094' ) 30/06/2022 04:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19724' AND id_supplier = '43' 30/06/2022 04:11:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19724' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '19597' , 'MEDAGLIA SAN BENEDETTO ARG. RA631' , '2' , '2' , '1' , '6.83' , '5.5983606557377' , '22' , '5+5' , '15.0403' ) 30/06/2022 04:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19597' AND id_supplier = '43' 30/06/2022 04:11:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19597' , '43' , '1' ) 30/06/2022 04:11: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 ( '58983' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA630' , '2' , '2' , '1' , '4.41' , '3.6147540983607' , '22' , '5+5' , '9.7113' ) 30/06/2022 04:11:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19596' AND id_supplier = '43' 30/06/2022 04:11:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19596' , '43' , '1' ) 30/06/2022 04:38:54 pm >> SELECT document_num FROM ps_document WHERE document_num = '2116' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 04:38: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' , '2116' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.40' , '12.88' , NOW() , NOW() ) 30/06/2022 04:38: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 = '58984' 30/06/2022 04:38:54 pm >> DELETE FROM ps_document_detail WHERE id_document = '58984' 30/06/2022 04:38: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 ( '58984' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.00' , '3.8461538461538' , '4' , '0' , '8.00' ) 30/06/2022 04:38:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 30/06/2022 04:38:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 30/06/2022 04:38: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 ( '58984' , '7311' , 'OSTIA SOTTILE 74MM' , '1' , '-1' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '1.90' ) 30/06/2022 04:38:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 30/06/2022 04:38:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 30/06/2022 04:38: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 ( '58984' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 30/06/2022 04:38:54 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 30/06/2022 04:38:54 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 30/06/2022 04:44:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2117' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 04:44:08 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2117' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '119.87' , '111.76' , NOW() , NOW() ) 30/06/2022 04:44: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 = '58985' 30/06/2022 04:44:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '58985' 30/06/2022 04:44:08 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58985' , '19672' , 'NOVENE AL PREZIOSISSIMO SANGUE - 8075' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '5' , '2.85' ) 30/06/2022 04:44:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19672' AND id_supplier = '' 30/06/2022 04:44:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19672' , '' , '1' ) 30/06/2022 04:44: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 ( '58985' , '19671' , 'UN MESE CON IL PREZIOSISSIMO SANGUE - 8074' , '1' , '-1' , '4' , '7.00' , '7' , '0' , '5' , '6.65' ) 30/06/2022 04:44:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19671' AND id_supplier = '' 30/06/2022 04:44:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19671' , '' , '1' ) 30/06/2022 04:44: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 ( '58985' , '8340' , 'PREGHIERE AL PREZIOSISSIMO SANGUE - 8158' , '1' , '-1' , '4' , '8.00' , '8' , '0' , '5' , '7.60' ) 30/06/2022 04:44:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8340' AND id_supplier = '' 30/06/2022 04:44:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8340' , '' , '1' ) 30/06/2022 04:44: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 ( '58985' , '19510' , 'MARIA, MADRE DEL CORPO MISTICO - E. STEIN' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 30/06/2022 04:44:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19510' AND id_supplier = '' 30/06/2022 04:44:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19510' , '' , '1' ) 30/06/2022 04:44: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 ( '58985' , '19509' , 'DONO DEL CAVALIERE - IGNAZIO DI LOYOLA' , '1' , '-1' , '4' , '7.90' , '7.9' , '0' , '5' , '7.51' ) 30/06/2022 04:44:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19509' AND id_supplier = '' 30/06/2022 04:44:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19509' , '' , '1' ) 30/06/2022 04:44: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 ( '58985' , '17673' , 'FUI CHIAMATO DOLINDO' , '1' , '-1' , '4' , '35.00' , '35' , '0' , '5' , '33.25' ) 30/06/2022 04:44:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17673' AND id_supplier = '' 30/06/2022 04:44:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17673' , '' , '1' ) 30/06/2022 04:44: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 ( '58985' , '11384' , 'VINO BIANCO DOLCE - 102' , '6' , '-6' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '45.00' ) 30/06/2022 04:44:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 30/06/2022 04:44:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 30/06/2022 04:44: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 ( '58985' , '19679' , 'ITINERARI CAT. PER LA VITA MATRIMONIALE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 30/06/2022 04:44:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19679' AND id_supplier = '' 30/06/2022 04:44:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19679' , '' , '1' ) 30/06/2022 04:46:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2118' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 04:46:03 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2118' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '3.00' , '3.00' , NOW() , NOW() ) 30/06/2022 04:46:03 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58986' 30/06/2022 04:46:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '58986' 30/06/2022 04:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58986' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.50' , '0.5' , '0' , '0' , '0.50' ) 30/06/2022 04:46:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 30/06/2022 04:46:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 30/06/2022 04:46:03 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58986' , '6680' , 'MINISTERO DEL LETTORE E D/ ACCOLITO' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 30/06/2022 04:46:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6680' AND id_supplier = '' 30/06/2022 04:46:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6680' , '' , '1' ) 30/06/2022 04:53:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '2119' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 04:53: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' , '2119' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.50' , NOW() , NOW() ) 30/06/2022 04:53: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 = '58987' 30/06/2022 04:53:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '58987' 30/06/2022 04:53: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 ( '58987' , '17319' , 'EREDITA SPIRITUALE DEL MONTE CARMELO - M.E. PATRIZI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 30/06/2022 04:53:39 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17319' AND id_supplier = '' 30/06/2022 04:53:39 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17319' , '' , '1' ) 30/06/2022 05:00:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2118' AND id_document != '58986' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 05:00:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2118', document_date = '2022-06-30', 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 = '3.00', date_upd = NOW() WHERE id_document = '58986' 30/06/2022 05:00:12 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 = '58986' 30/06/2022 05:00:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '58986' 30/06/2022 05:00:12 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 ( '58986' , '19693' , 'CALENDARIO LITURGICO 2023' , '1' , '-1' , '4' , '0.5000' , '0.5' , '0' , '0' , '0.50' ) 30/06/2022 05:00:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19693' AND id_supplier = '' 30/06/2022 05:00:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19693' , '' , '1' ) 30/06/2022 05:00:12 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 ( '58986' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '2.5' , '2.5' , '0' , '0' , '2.50' ) 30/06/2022 05:00:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 30/06/2022 05:00:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 30/06/2022 05:07:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '2107' AND id_document != '58974' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 05:07:28 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2107', document_date = '2022-06-30', 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 = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '58974' 30/06/2022 05:07:28 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 = '58974' 30/06/2022 05:07:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '58974' 30/06/2022 05:07:28 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 ( '58974' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '14.2' , '11.639344262295' , '22' , '0' , '14.20' ) 30/06/2022 05:07:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/06/2022 05:07:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 30/06/2022 05:07:28 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 ( '58974' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.80' , '4.7540983606557' , '22' , '0' , '5.80' ) 30/06/2022 05:07:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19717' AND id_supplier = '' 30/06/2022 05:07:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19717' , '' , '1' ) 30/06/2022 05:08:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2107' AND id_document != '58974' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 05:08:00 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2107', document_date = '2022-06-30', 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 = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '58974' 30/06/2022 05:08:00 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 = '58974' 30/06/2022 05:08:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '58974' 30/06/2022 05:08: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 ( '58974' , '11384' , 'VINO BIANCO DOLCE - 102' , '2' , '-2' , '1' , '7.1' , '5.8196721311475' , '22' , '0' , '14.20' ) 30/06/2022 05:08:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 30/06/2022 05:08:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 30/06/2022 05:08: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 ( '58974' , '19717' , 'ROSARIO LEGNO SAN BENEDETTO - RE5042NAT' , '1' , '-1' , '1' , '5.8000' , '4.7540983606557' , '22' , '0' , '5.80' ) 30/06/2022 05:08:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19717' AND id_supplier = '' 30/06/2022 05:08:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19717' , '' , '1' ) 30/06/2022 05:08:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '1387' AND id_document != '56578' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-04') 30/06/2022 05:08:48 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1387', document_date = '2022-05-04', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '120.00', price_tax_excluded = '105.67', date_upd = NOW() WHERE id_document = '56578' 30/06/2022 05:08:48 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '56578' 30/06/2022 05:08:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '56578' 30/06/2022 05:08:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56578' , '2177' , 'CLERGY BASIC - MM - B&P' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 30/06/2022 05:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2177' AND id_supplier = '' 30/06/2022 05:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2177' , '' , '1' ) 30/06/2022 05:08:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56578' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 30/06/2022 05:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 30/06/2022 05:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 30/06/2022 05:08:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56578' , '9602' , 'SANTA RITA DA CASCIA - RITA DA CASCIA' , '1' , '-1' , '4' , '9.4400' , '9.44' , '0' , '0' , '9.44' ) 30/06/2022 05:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9602' AND id_supplier = '' 30/06/2022 05:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9602' , '' , '1' ) 30/06/2022 05:08:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56578' , '18667' , 'SCOPRIAMO LA CRESIMA' , '1' , '-1' , '4' , '4.9000' , '4.9' , '0' , '5' , '4.66' ) 30/06/2022 05:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18667' AND id_supplier = '' 30/06/2022 05:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18667' , '' , '1' ) 30/06/2022 05:08:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56578' , '791' , 'ASSISI IN BUSTA BATTESIMO - 20X270 - BAAS' , '40' , '-40' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '48.00' ) 30/06/2022 05:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '791' AND id_supplier = '' 30/06/2022 05:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '791' , '' , '1' ) 30/06/2022 05:08:48 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '56578' , '19361' , 'LITANIE LAURETANE - M. DE ROSA' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 30/06/2022 05:08:48 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19361' AND id_supplier = '' 30/06/2022 05:08:48 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19361' , '' , '1' ) 30/06/2022 05:08: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 ( '56578' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 30/06/2022 05:08:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18906' AND id_supplier = '' 30/06/2022 05:08:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18906' , '' , '1' ) 30/06/2022 05:25:36 pm >> SELECT document_num FROM ps_document WHERE document_num = '2120' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 05:25:36 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' , '2120' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 30/06/2022 05:25:36 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 = '58988' 30/06/2022 05:25:36 pm >> DELETE FROM ps_document_detail WHERE id_document = '58988' 30/06/2022 05:25:36 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 ( '58988' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2022 05:25:36 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 30/06/2022 05:25:36 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 30/06/2022 05:41:53 pm >> SELECT document_num FROM ps_document WHERE document_num = '2121' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 05:41:53 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' , '2121' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '6.56' , NOW() , NOW() ) 30/06/2022 05:41:53 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 = '58989' 30/06/2022 05:41:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '58989' 30/06/2022 05:41:53 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 ( '58989' , '11389' , 'VINO ROSSO DOLCE - 103' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 30/06/2022 05:41:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11389' AND id_supplier = '' 30/06/2022 05:41:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11389' , '' , '1' ) 30/06/2022 06:22:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2122' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 06:22:00 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' , '2122' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.50' , '3.69' , NOW() , NOW() ) 30/06/2022 06:22:00 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 = '58990' 30/06/2022 06:22:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '58990' 30/06/2022 06:22: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 ( '58990' , '2764' , 'CORONA EMATITE TONDA ' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 30/06/2022 06:22:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2764' AND id_supplier = '' 30/06/2022 06:22:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2764' , '' , '1' ) 30/06/2022 06:56:40 pm >> SELECT document_num FROM ps_document WHERE document_num = '101' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 06:56:40 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' , '101' , '2022-06-30' , '' , '979' , '0' , '4671729' , 'VIA ROBERTO MAZZETTI, 5/A 84135 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '1' , '0' , '17.85' , '17.85' , NOW() , NOW() ) 30/06/2022 06:56:40 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 = '58991' 30/06/2022 06:56:40 pm >> DELETE FROM ps_document_detail WHERE id_document = '58991' 30/06/2022 06:56:40 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 ( '58991' , '11105' , 'VANGELO E ATTI DEGLI APOSTOLI PER OCCASIONI' , '6' , '-6' , '4' , '3.50' , '3.5' , '0' , '15' , '17.85' ) 30/06/2022 07:15:51 pm >> SELECT document_num FROM ps_document WHERE document_num = '2123' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 07:15:51 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' , '2123' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '23.90' , '23.90' , NOW() , NOW() ) 30/06/2022 07:15:51 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 = '58992' 30/06/2022 07:15:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '58992' 30/06/2022 07:15:51 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 ( '58992' , '4223' , 'FOGLIETTI LA DOMENICA SAN PAOLO' , '7' , '-7' , '4' , '0.70' , '0.7' , '0' , '0' , '4.90' ) 30/06/2022 07:15:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4223' AND id_supplier = '' 30/06/2022 07:15:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4223' , '' , '1' ) 30/06/2022 07:15:52 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 ( '58992' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 30/06/2022 07:15:52 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 30/06/2022 07:15:52 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 30/06/2022 07:28:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2124' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 07:28:59 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2124' , '2022-06-30' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 30/06/2022 07:28: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 = '58993' 30/06/2022 07:28:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '58993' 30/06/2022 07:28: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 ( '58993' , '19467' , 'SULLA TUA PAROLA - LUG/AGO 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 30/06/2022 07:28:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19467' AND id_supplier = '' 30/06/2022 07:28:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19467' , '' , '1' ) 30/06/2022 07:30:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '2115' AND id_document != '58982' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 30/06/2022 07:30:30 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2115', document_date = '2022-06-30', 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 = '410.00', price_tax_excluded = '336.07', date_upd = NOW() WHERE id_document = '58982' 30/06/2022 07:30:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58982' 30/06/2022 07:30:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '58982' 30/06/2022 07:30:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58982' , '17544' , 'CAMICE BAMBOO' , '1' , '-1' , '1' , '140.0000' , '114.75409836066' , '22' , '0' , '140.00' ) 30/06/2022 07:30:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17544' AND id_supplier = '' 30/06/2022 07:30:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17544' , '' , '1' ) 30/06/2022 07:30:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58982' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '270' , '221.31147540984' , '22' , '0' , '270.00' ) 30/06/2022 07:30:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 30/06/2022 07:30:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' )