16/09/2022 10:51:59 am >> SELECT document_num FROM ps_document WHERE document_num = '2750' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 10:51:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2750' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '226.80' , '226.80' , NOW() , NOW() ) 16/09/2022 10:51:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61822' 16/09/2022 10:51:59 am >> DELETE FROM ps_document_detail WHERE id_document = '61822' 16/09/2022 10:51:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61822' , '19644' , 'CHIESA CHE VERRA - A. MATTEO' , '14' , '-14' , '4' , '16.2' , '16.2' , '0' , '0' , '226.80' ) 16/09/2022 10:51:59 am >> DELETE FROM ps_product_supplier WHERE id_product = '19644' AND id_supplier = '' 16/09/2022 10:51:59 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19644' , '' , '1' ) 16/09/2022 10:56:53 am >> SELECT document_num FROM ps_document WHERE document_num = '2751' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 10:56:53 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2751' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '105.42' , '87.75' , NOW() , NOW() ) 16/09/2022 10:56: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 = '61823' 16/09/2022 10:56:53 am >> DELETE FROM ps_document_detail WHERE id_document = '61823' 16/09/2022 10:56: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 ( '61823' , '7943' , 'PERGAMENE - OCCASIONI MOD. B' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '15.00' ) 16/09/2022 10:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '7943' AND id_supplier = '' 16/09/2022 10:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7943' , '' , '1' ) 16/09/2022 10:56: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 ( '61823' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 16/09/2022 10:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 16/09/2022 10:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 16/09/2022 10:56: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 ( '61823' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/09/2022 10:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '17160' AND id_supplier = '' 16/09/2022 10:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17160' , '' , '1' ) 16/09/2022 10:56: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 ( '61823' , '19818' , 'INCENSO NATURALE 3A KG 1' , '1' , '-1' , '1' , '23.00' , '18.852459016393' , '22' , '0' , '23.00' ) 16/09/2022 10:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19818' AND id_supplier = '' 16/09/2022 10:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19818' , '' , '1' ) 16/09/2022 10:56: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 ( '61823' , '19925' , 'AMEN - NOV. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 16/09/2022 10:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 16/09/2022 10:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 16/09/2022 10:56: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 ( '61823' , '19926' , 'AMEN - DIC. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 16/09/2022 10:56:53 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 16/09/2022 10:56:53 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 16/09/2022 10:57:13 am >> SELECT document_num FROM ps_document WHERE document_num = '2752' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 10:57:13 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2752' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.84' , '14.84' , NOW() , NOW() ) 16/09/2022 10:57:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61824' 16/09/2022 10:57:13 am >> DELETE FROM ps_document_detail WHERE id_document = '61824' 16/09/2022 10:57:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61824' , '19926' , 'AMEN - DIC. 2022' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 16/09/2022 10:57:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 16/09/2022 10:57:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 16/09/2022 10:57:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61824' , '19925' , 'AMEN - NOV. 2022' , '2' , '-2' , '4' , '3.90' , '3.9' , '0' , '5' , '7.42' ) 16/09/2022 10:57:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 16/09/2022 10:57:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 16/09/2022 11:17:36 am >> SELECT document_num FROM ps_document WHERE document_num = '2753' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 11:17:36 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' , '2753' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '50.00' , '40.98' , NOW() , NOW() ) 16/09/2022 11:17:36 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 = '61825' 16/09/2022 11:17:36 am >> DELETE FROM ps_document_detail WHERE id_document = '61825' 16/09/2022 11:17:36 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 ( '61825' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 16/09/2022 11:17:36 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 16/09/2022 11:17:36 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 16/09/2022 11:49:51 am >> SELECT document_num FROM ps_document WHERE document_num = '2001' AND id_document != '58853' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-22') 16/09/2022 11:49:51 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2001', document_date = '2022-06-22', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '20.00', price_tax_excluded = '16.39', date_upd = NOW() WHERE id_document = '58853' 16/09/2022 11:49:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58853' 16/09/2022 11:49:51 am >> DELETE FROM ps_document_detail WHERE id_document = '58853' 16/09/2022 11:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58853' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '5' , '-5' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '15.00' ) 16/09/2022 11:49:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 16/09/2022 11:49:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 16/09/2022 11:49:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58853' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 16/09/2022 11:49:51 am >> DELETE FROM ps_product_supplier WHERE id_product = '14926' AND id_supplier = '' 16/09/2022 11:49:51 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14926' , '' , '1' ) 16/09/2022 11:50:13 am >> SELECT document_num FROM ps_document WHERE document_num = '1939' AND id_document != '58783' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-15') 16/09/2022 11:50:13 am >> UPDATE ps_document SET id_document_type = '11', document_num = '1939', document_date = '2022-06-15', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '140.00', price_tax_excluded = '123.32', date_upd = NOW() WHERE id_document = '58783' 16/09/2022 11:50:13 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58783' 16/09/2022 11:50:13 am >> DELETE FROM ps_document_detail WHERE id_document = '58783' 16/09/2022 11:50:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7' , '5.7377049180328' , '22' , '0' , '7.00' ) 16/09/2022 11:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 16/09/2022 11:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 16/09/2022 11:50:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '6058' , 'MADONNA DEL CARMINE - 117 BIS ' , '2' , '-2' , '1' , '3.5000' , '2.8688524590164' , '22' , '0' , '7.00' ) 16/09/2022 11:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '6058' AND id_supplier = '' 16/09/2022 11:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6058' , '' , '1' ) 16/09/2022 11:50:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '6353' , 'MEDAGLIA S. BENEDETTO SMALTATA - M016' , '20' , '-20' , '1' , '1.1000' , '0.9016393442623' , '22' , '0' , '22.00' ) 16/09/2022 11:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '6353' AND id_supplier = '' 16/09/2022 11:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6353' , '' , '1' ) 16/09/2022 11:50:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '19644' , 'CHIESA CHE VERRA - A. MATTEO' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '5' , '17.10' ) 16/09/2022 11:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19644' AND id_supplier = '' 16/09/2022 11:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19644' , '' , '1' ) 16/09/2022 11:50:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '19334' , 'INSEGNACI A PREGARE - J. MARTIN' , '1' , '-1' , '4' , '20.0000' , '20' , '0' , '5' , '19.00' ) 16/09/2022 11:50:13 am >> DELETE FROM ps_product_supplier WHERE id_product = '19334' AND id_supplier = '' 16/09/2022 11:50:13 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19334' , '' , '1' ) 16/09/2022 11:50:13 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '19131' , 'VIVI CRESCI AMA - M. DANIELI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 16/09/2022 11:50:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19131' AND id_supplier = '' 16/09/2022 11:50:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19131' , '' , '1' ) 16/09/2022 11:50:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '19597' , 'MEDAGLIA SAN BENEDETTO ARG. RA631' , '1' , '-1' , '1' , '15.8000' , '12.950819672131' , '22' , '0' , '15.80' ) 16/09/2022 11:50:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19597' AND id_supplier = '' 16/09/2022 11:50:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19597' , '' , '1' ) 16/09/2022 11:50:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '19596' , 'MEDAGLIA SAN BENEDETTO ARG. RA630' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 16/09/2022 11:50:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19596' AND id_supplier = '' 16/09/2022 11:50:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19596' , '' , '1' ) 16/09/2022 11:50:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '17161' , 'CARBONCINI NERI - CARNE' , '1' , '-1' , '1' , '12.0000' , '9.8360655737705' , '22' , '0' , '12.00' ) 16/09/2022 11:50:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '17161' AND id_supplier = '' 16/09/2022 11:50:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17161' , '' , '1' ) 16/09/2022 11:50:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '19301' , 'VERGINE DEL SILENZIO - 8068' , '1' , '-1' , '4' , '2.0000' , '2' , '0' , '5' , '1.90' ) 16/09/2022 11:50:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19301' AND id_supplier = '' 16/09/2022 11:50:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19301' , '' , '1' ) 16/09/2022 11:50:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '19629' , 'SEGNALIBRO sacro cuore - 109' , '78' , '-78' , '1' , '0.1500' , '0.12295081967213' , '22' , '0' , '11.70' ) 16/09/2022 11:50:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '19629' AND id_supplier = '' 16/09/2022 11:50:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19629' , '' , '1' ) 16/09/2022 11:50:14 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58783' , '14926' , 'VESTINA BATTESIMALE' , '1' , '-1' , '1' , '5.00' , '4.0983606557377' , '22' , '0' , '5.00' ) 16/09/2022 11:50:14 am >> DELETE FROM ps_product_supplier WHERE id_product = '14926' AND id_supplier = '' 16/09/2022 11:50:14 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14926' , '' , '1' ) 16/09/2022 12:42:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2754' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 12:42:14 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' , '2754' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '60.00' , '49.18' , NOW() , NOW() ) 16/09/2022 12:42:14 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 = '61826' 16/09/2022 12:42:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '61826' 16/09/2022 12:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '5' , '-5' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '5.50' ) 16/09/2022 12:42:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 16/09/2022 12:42:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 16/09/2022 12:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '3.7' , '3.0327868852459' , '22' , '0' , '3.70' ) 16/09/2022 12:42:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 16/09/2022 12:42:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 16/09/2022 12:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '12528' , 'LAMPADA A SFERA BLU' , '1' , '-1' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '25.00' ) 16/09/2022 12:42:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12528' AND id_supplier = '' 16/09/2022 12:42:14 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12528' , '' , '1' ) 16/09/2022 12:42:14 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '7484' , 'PAPA FRANCESCO - FOTO UFF. 25X35 ' , '2' , '-2' , '1' , '1.00' , '0.81967213114754' , '22' , '0' , '2.00' ) 16/09/2022 12:42:14 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7484' AND id_supplier = '' 16/09/2022 12:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7484' , '' , '1' ) 16/09/2022 12:42:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '12833' , 'BOTTONE RETROCOLLO - 21630' , '1' , '-1' , '1' , '2.80' , '2.2950819672131' , '22' , '0' , '2.80' ) 16/09/2022 12:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12833' AND id_supplier = '' 16/09/2022 12:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12833' , '' , '1' ) 16/09/2022 12:42:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '11' , '9.016393442623' , '22' , '0' , '11.00' ) 16/09/2022 12:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 16/09/2022 12:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 16/09/2022 12:42:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61826' , '2424' , 'COLLETTO DOPPIO - CM 3,5 ' , '1' , '-1' , '1' , '10' , '8.1967213114754' , '22' , '0' , '10.00' ) 16/09/2022 12:42:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2424' AND id_supplier = '' 16/09/2022 12:42:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2424' , '' , '1' ) 16/09/2022 12:43:00 pm >> SELECT document_num FROM ps_document WHERE document_num = '2755' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 12:43: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' , '2755' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.00' , '5.74' , NOW() , NOW() ) 16/09/2022 12:43: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 = '61827' 16/09/2022 12:43:00 pm >> DELETE FROM ps_document_detail WHERE id_document = '61827' 16/09/2022 12:43: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 ( '61827' , '9228' , 'S. PIO - 291' , '2' , '-2' , '1' , '3.50' , '2.8688524590164' , '22' , '0' , '7.00' ) 16/09/2022 12:43:00 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9228' AND id_supplier = '' 16/09/2022 12:43:00 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9228' , '' , '1' ) 16/09/2022 12:49:32 pm >> SELECT document_num FROM ps_document WHERE document_num = '2084' AND id_document != '58948' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-28') 16/09/2022 12:49:32 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2084', document_date = '2022-06-28', 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 = '880.00', price_tax_excluded = '727.31', date_upd = NOW() WHERE id_document = '58948' 16/09/2022 12:49:32 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58948' 16/09/2022 12:49:32 pm >> DELETE FROM ps_document_detail WHERE id_document = '58948' 16/09/2022 12:49:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58948' , '19088' , 'TU SOLO IL SANTO - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 16/09/2022 12:49:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19088' AND id_supplier = '' 16/09/2022 12:49:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19088' , '' , '1' ) 16/09/2022 12:49:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58948' , '18906' , 'MI CHIAMERANNO BEATA - G. VALSECCHI' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 16/09/2022 12:49:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18906' AND id_supplier = '' 16/09/2022 12:49:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18906' , '' , '1' ) 16/09/2022 12:49:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58948' , '18689' , 'OGGI RIMANGO DA TE - ANNO C - P.R. SCALABRINI' , '1' , '-1' , '4' , '15.0000' , '15' , '0' , '5' , '14.25' ) 16/09/2022 12:49:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18689' AND id_supplier = '' 16/09/2022 12:49:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18689' , '' , '1' ) 16/09/2022 12:49:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58948' , '19436' , 'CAMICE LINO 100% - CAM0M70' , '1' , '-1' , '1' , '710.0000' , '581.96721311475' , '22' , '0' , '710.00' ) 16/09/2022 12:49:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19436' AND id_supplier = '' 16/09/2022 12:49:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19436' , '' , '1' ) 16/09/2022 12:49:32 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58948' , '18023' , 'TURIBOLO H 30' , '1' , '-1' , '1' , '136.75' , '112.09016393443' , '22' , '0' , '136.75' ) 16/09/2022 12:49:32 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18023' AND id_supplier = '' 16/09/2022 12:49:32 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18023' , '' , '1' ) 16/09/2022 12:53:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2756' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 12:53:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2756' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 16/09/2022 12:53:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61828' 16/09/2022 12:53:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '61828' 16/09/2022 12:53:20 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61828' , '16939' , 'SACCO PORTAELEMOSINA CON ASTA 1 m - 1750' , '1' , '-1' , '1' , '45.00' , '36.885245901639' , '22' , '0' , '45.00' ) 16/09/2022 12:53:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16939' AND id_supplier = '' 16/09/2022 12:53:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16939' , '' , '1' ) 16/09/2022 01:03:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2757' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 01:03:35 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' , '2757' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '27.50' , '22.54' , NOW() , NOW() ) 16/09/2022 01:03:35 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 = '61829' 16/09/2022 01:03:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '61829' 16/09/2022 01:03:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61829' , '1751' , 'CARTUCCIA TRASPARENTE DIAM. 4 - 455' , '1' , '-1' , '1' , '14.00' , '11.475409836066' , '22' , '0' , '14.00' ) 16/09/2022 01:03:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1751' AND id_supplier = '' 16/09/2022 01:03:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1751' , '' , '1' ) 16/09/2022 01:03:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61829' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '13.5' , '11.065573770492' , '22' , '0' , '13.50' ) 16/09/2022 01:03:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 16/09/2022 01:03:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 16/09/2022 01:06:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '2569' AND id_document != '61087' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-31') 16/09/2022 01:06:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2569', document_date = '2022-08-31', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.30', price_tax_excluded = '9.33', date_upd = NOW() WHERE id_document = '61087' 16/09/2022 01:06: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 = '61087' 16/09/2022 01:06:08 pm >> DELETE FROM ps_document_detail WHERE id_document = '61087' 16/09/2022 01:06: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 ( '61087' , '8368' , 'PREGHIERE DI LIBERAZIONE - DIVINA MISERICORDIA' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 16/09/2022 01:06:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8368' AND id_supplier = '' 16/09/2022 01:06:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8368' , '' , '1' ) 16/09/2022 01:06: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 ( '61087' , '19323' , 'PREGHIERE DI SANTA BRIGIDA' , '1' , '-1' , '4' , '0.7000' , '0.7' , '0' , '0' , '0.70' ) 16/09/2022 01:06:08 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19323' AND id_supplier = '' 16/09/2022 01:06:08 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19323' , '' , '1' ) 16/09/2022 01:06: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 ( '61087' , '7096' , 'NOVE PRIMI VENERDÍ DEL MESE - 8247' , '1' , '-1' , '4' , '1.7' , '1.7' , '0' , '0' , '1.70' ) 16/09/2022 01:06:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7096' AND id_supplier = '' 16/09/2022 01:06:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7096' , '' , '1' ) 16/09/2022 01:06: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 ( '61087' , '9702' , 'SCAPOLARE TIPO GRANDE - 1216/ITA ' , '1' , '-1' , '1' , '1.5000' , '1.2295081967213' , '22' , '0' , '1.50' ) 16/09/2022 01:06:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9702' AND id_supplier = '' 16/09/2022 01:06:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9702' , '' , '1' ) 16/09/2022 01:06: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 ( '61087' , '19561' , 'CARD SAN GIUDA TADDEO' , '1' , '-1' , '1' , '1.6000' , '1.3114754098361' , '22' , '0' , '1.60' ) 16/09/2022 01:06:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19561' AND id_supplier = '' 16/09/2022 01:06:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19561' , '' , '1' ) 16/09/2022 01:06: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 ( '61087' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.0000' , '1' , '0' , '0' , '1.00' ) 16/09/2022 01:06:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '' 16/09/2022 01:06:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' ) 16/09/2022 01:06: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 ( '61087' , '11677' , 'MEDAGLIA MIRACOLOSA - 1311L' , '1' , '-1' , '1' , '1.0000' , '0.81967213114754' , '22' , '0' , '1.00' ) 16/09/2022 01:06:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11677' AND id_supplier = '' 16/09/2022 01:06:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11677' , '' , '1' ) 16/09/2022 01:06: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 ( '61087' , '3103' , 'CROCE SAN BENEDETTO' , '1' , '-1' , '1' , '1.3000' , '1.0655737704918' , '22' , '0' , '1.30' ) 16/09/2022 01:06:09 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3103' AND id_supplier = '' 16/09/2022 01:06:09 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3103' , '' , '1' ) 16/09/2022 01:06:35 pm >> SELECT document_num FROM ps_document WHERE document_num = '2758' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 01:06:35 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' , '2758' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '10.00' , '10.00' , NOW() , NOW() ) 16/09/2022 01:06:35 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 = '61830' 16/09/2022 01:06:35 pm >> DELETE FROM ps_document_detail WHERE id_document = '61830' 16/09/2022 01:06:35 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61830' , '16295' , 'MESSA PRONTI E VIA - ANNO A - C. PELLEGRINO' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 16/09/2022 01:06:35 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16295' AND id_supplier = '' 16/09/2022 01:06:35 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16295' , '' , '1' ) 16/09/2022 02:45:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '2022-dl002624' , '2022-09-15' , '' , '0' , '79' , '2686' , 'CITTA\\\' DEL VATICANO 00120 CITTA\\\' DEL VATICANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '203.00' , '203.00' , NOW() , NOW() ) 16/09/2022 02:45:06 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61831' 16/09/2022 02:45:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '61831' 16/09/2022 02:45:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61831' , '17329' , 'MESSALE ROMANO DALTARE N.E' , '2' , '2' , '4' , '110.00' , '110' , '0' , '30' , '154.0000' ) 16/09/2022 02:45:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17329' AND id_supplier = '79' 16/09/2022 02:45:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17329' , '79' , '1' ) 16/09/2022 02:45:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61831' , '8290' , 'PREGHIERA DEL MATTINO E DELLA SERA - PER LAICI' , '1' , '1' , '4' , '35.00' , '35' , '0' , '30' , '24.5000' ) 16/09/2022 02:45:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8290' AND id_supplier = '79' 16/09/2022 02:45:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8290' , '79' , '1' ) 16/09/2022 02:45:06 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61831' , '3419' , 'DIARIO LA MISERICORDIA DIVINA - S. FAUSTINA K.' , '1' , '1' , '4' , '13.00' , '13' , '0' , '30' , '9.1000' ) 16/09/2022 02:45:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3419' AND id_supplier = '79' 16/09/2022 02:45:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3419' , '79' , '1' ) 16/09/2022 02:45:07 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61831' , '19680' , 'SANTA MESSA - J.J. SILVESTRE VALOR' , '1' , '1' , '4' , '28.00' , '28' , '0' , '45' , '15.4000' ) 16/09/2022 02:45:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19680' AND id_supplier = '79' 16/09/2022 02:45:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19680' , '79' , '1' ) 16/09/2022 02:46:22 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 16/09/2022 02:46:22 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19955' , '1' , '' , 'nuovo-prodotto' ) 16/09/2022 02:46:22 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '19955' , '1' , '1' , '2' , NOW() , NOW() ) 16/09/2022 02:46:22 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '19955' , '0' , '1' , '0' , '0' ) 16/09/2022 02:47:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254780145' AND id_product != '19955' AND ean13 != '' 16/09/2022 02:47:23 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9791254780145', date_upd = NOW() WHERE id_product = '19955' 16/09/2022 02:47:23 pm >> UPDATE ps_product_lang SET name = 'SAN FRANCESCO DI SALES - G. JEANGUENIN', description = '' WHERE id_product = '19955' 16/09/2022 02:47:23 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '19955' 16/09/2022 02:47:23 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '100', id_argoment_default = '23', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19955' 16/09/2022 02:47:23 pm >> DELETE FROM ps_specific_price WHERE id_product = '19955' 16/09/2022 02:47:24 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 = '19955' 16/09/2022 02:47:24 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19956' , '1' , '' , 'nuovo-prodotto' ) 16/09/2022 02:47:24 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 '19956' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19955' 16/09/2022 02:47:24 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19956' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19955' 16/09/2022 02:48:11 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9791254780183' AND id_product != '19956' AND ean13 != '' 16/09/2022 02:48:11 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/5', ean13 = '9791254780183', date_upd = NOW() WHERE id_product = '19956' 16/09/2022 02:48:11 pm >> UPDATE ps_product_lang SET name = 'VITA DI CRISTO - F. SHEEN', description = '' WHERE id_product = '19956' 16/09/2022 02:48:11 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '25' WHERE id_product = '19956' 16/09/2022 02:48:11 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '25', id_tax_rules_group = '4', id_category_default = '100', id_argoment_default = '72', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19956' 16/09/2022 02:48:11 pm >> DELETE FROM ps_specific_price WHERE id_product = '19956' 16/09/2022 02:48:14 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '19956' 16/09/2022 02:48:14 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19957' , '1' , '' , 'nuovo-prodotto' ) 16/09/2022 02:48:14 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '19957' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19956' 16/09/2022 02:48:14 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19957' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19956' 16/09/2022 02:49:02 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832712117' AND id_product != '19957' AND ean13 != '' 16/09/2022 02:49:02 pm >> UPDATE ps_product SET id_supplier = '', reference = '7/3', ean13 = '9788832712117', date_upd = NOW() WHERE id_product = '19957' 16/09/2022 02:49:02 pm >> UPDATE ps_product_lang SET name = 'ESERCIZI SPIRITUALI CON SAN PAOLO - B. SECONDIN', description = '' WHERE id_product = '19957' 16/09/2022 02:49:02 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '15' WHERE id_product = '19957' 16/09/2022 02:49:02 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '15', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '41', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19957' 16/09/2022 02:49:02 pm >> DELETE FROM ps_specific_price WHERE id_product = '19957' 16/09/2022 02:49:03 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 = '19957' 16/09/2022 02:49:03 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19958' , '1' , '' , 'nuovo-prodotto' ) 16/09/2022 02:49:03 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 '19958' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19957' 16/09/2022 02:49:03 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19958' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19957' 16/09/2022 02:49:37 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788832713480' AND id_product != '19958' AND ean13 != '' 16/09/2022 02:49:37 pm >> UPDATE ps_product SET id_supplier = '', reference = '6/6', ean13 = '9788832713480', date_upd = NOW() WHERE id_product = '19958' 16/09/2022 02:49:37 pm >> UPDATE ps_product_lang SET name = 'FINO IN CIMA - A. BELLO', description = '' WHERE id_product = '19958' 16/09/2022 02:49:37 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '19958' 16/09/2022 02:49:37 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '80', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19958' 16/09/2022 02:49:37 pm >> DELETE FROM ps_specific_price WHERE id_product = '19958' 16/09/2022 02:49:38 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 = '19958' 16/09/2022 02:49:38 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19959' , '1' , '' , 'nuovo-prodotto' ) 16/09/2022 02:49:38 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 '19959' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19958' 16/09/2022 02:49:38 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19959' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19958' 16/09/2022 02:50:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788869292651' AND id_product != '19959' AND ean13 != '' 16/09/2022 02:50:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788869292651', date_upd = NOW() WHERE id_product = '19959' 16/09/2022 02:50:14 pm >> UPDATE ps_product_lang SET name = 'PREGHIERE PER DUE', description = '' WHERE id_product = '19959' 16/09/2022 02:50:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '9' WHERE id_product = '19959' 16/09/2022 02:50:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '9', id_tax_rules_group = '4', id_category_default = '45', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '19959' 16/09/2022 02:50:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '19959' 16/09/2022 02:50:15 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 = '19959' 16/09/2022 02:50:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '19960' , '1' , '' , 'nuovo-prodotto' ) 16/09/2022 02:50:15 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 '19960' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '19959' 16/09/2022 02:50:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '19960' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '19959' 16/09/2022 02:51:20 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '33' , '0000' , '2022-09-16' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.90' , '140.90' , NOW() , NOW() ) 16/09/2022 02:51:20 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61832' 16/09/2022 02:51:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '61832' 16/09/2022 02:51: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 ( '61832' , '19959' , 'PREGHIERE PER DUE' , '1' , '1' , '4' , '9.00' , '9' , '0' , '0' , '9.00' ) 16/09/2022 02:51:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19959' AND id_supplier = '109' 16/09/2022 02:51:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19959' , '109' , '1' ) 16/09/2022 02:51: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 ( '61832' , '17254' , 'PADRE NOSTRO PER I PICCOLI - M. BALDACCI' , '1' , '1' , '4' , '13.90' , '13.9' , '0' , '0' , '13.90' ) 16/09/2022 02:51:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17254' AND id_supplier = '109' 16/09/2022 02:51:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17254' , '109' , '1' ) 16/09/2022 02:51: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 ( '61832' , '19958' , 'FINO IN CIMA - A. BELLO' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 16/09/2022 02:51:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19958' AND id_supplier = '109' 16/09/2022 02:51:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19958' , '109' , '1' ) 16/09/2022 02:51: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 ( '61832' , '19957' , 'ESERCIZI SPIRITUALI CON SAN PAOLO - B. SECONDIN' , '1' , '1' , '4' , '15.00' , '15' , '0' , '0' , '15.00' ) 16/09/2022 02:51:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19957' AND id_supplier = '109' 16/09/2022 02:51:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19957' , '109' , '1' ) 16/09/2022 02:51: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 ( '61832' , '19956' , 'VITA DI CRISTO - F. SHEEN' , '2' , '2' , '4' , '25.00' , '25' , '0' , '0' , '50.0000' ) 16/09/2022 02:51:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19956' AND id_supplier = '109' 16/09/2022 02:51:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19956' , '109' , '1' ) 16/09/2022 02:51: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 ( '61832' , '19837' , 'ABBANDONATEVI A CRISTO - F. SHEEN' , '1' , '1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 16/09/2022 02:51:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19837' AND id_supplier = '109' 16/09/2022 02:51:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19837' , '109' , '1' ) 16/09/2022 02:51: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 ( '61832' , '19955' , 'SAN FRANCESCO DI SALES - G. JEANGUENIN' , '1' , '1' , '4' , '14.00' , '14' , '0' , '0' , '14.00' ) 16/09/2022 02:51:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19955' AND id_supplier = '109' 16/09/2022 02:51:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19955' , '109' , '1' ) 16/09/2022 03:41:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '68/A' AND id_document != '61794' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-09-14') 16/09/2022 03:41:45 pm >> UPDATE ps_document SET id_document_type = '24', document_num = '68/A', document_date = '2022-09-14', 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 = '67.40', price_tax_excluded = '67.40', date_upd = NOW() WHERE id_document = '61794' 16/09/2022 03:41:45 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61794' 16/09/2022 03:41:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '61794' 16/09/2022 03:41:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19021' , 'CHI E PAOLO - G. LAJOLA' , '1' , '-1' , '4' , '18.0000' , '18' , '0' , '0' , '18.00' ) 16/09/2022 03:41:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19021' AND id_supplier = '' 16/09/2022 03:41:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19021' , '' , '1' ) 16/09/2022 03:41:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19925' , 'AMEN - NOV. 2022' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 16/09/2022 03:41:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 16/09/2022 03:41:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 16/09/2022 03:41:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19926' , 'AMEN - DIC. 2022' , '1' , '-1' , '4' , '3.9000' , '3.9' , '0' , '0' , '3.90' ) 16/09/2022 03:41:45 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 16/09/2022 03:41:45 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 16/09/2022 03:41:45 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61794' , '19909' , 'SULLA TUA PAROLA - NOV/DIC 2022' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 16/09/2022 03:41:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19909' AND id_supplier = '' 16/09/2022 03:41:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19909' , '' , '1' ) 16/09/2022 03:41: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 ( '61794' , '19928' , 'PAROLA E PREGHIERA - OTT. 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 16/09/2022 03:41:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19928' AND id_supplier = '' 16/09/2022 03:41:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19928' , '' , '1' ) 16/09/2022 03:41: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 ( '61794' , '19929' , 'PAROLA E PREGHIERA - NOV. 2022' , '2' , '-2' , '4' , '2.9000' , '2.9' , '0' , '0' , '5.80' ) 16/09/2022 03:41:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19929' AND id_supplier = '' 16/09/2022 03:41:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19929' , '' , '1' ) 16/09/2022 03:41: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 ( '61794' , '19956' , 'VITA DI CRISTO - F. SHEEN' , '1' , '-1' , '4' , '25.00' , '25' , '0' , '0' , '25.00' ) 16/09/2022 03:41:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19956' AND id_supplier = '' 16/09/2022 03:41:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19956' , '' , '1' ) 16/09/2022 05:34:14 pm >> SELECT document_num FROM ps_document WHERE document_num = '2759' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 05:34:14 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' , '2759' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '8.00' , '8.00' , NOW() , NOW() ) 16/09/2022 05:34:14 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 = '61833' 16/09/2022 05:34:14 pm >> DELETE FROM ps_document_detail WHERE id_document = '61833' 16/09/2022 05:34:15 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61833' , '11102' , 'VANGELO E ATTI DEGLI APOSTOLI - RIL.' , '1' , '-1' , '4' , '8' , '8' , '0' , '0' , '8.00' ) 16/09/2022 05:34:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11102' AND id_supplier = '' 16/09/2022 05:34:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11102' , '' , '1' ) 16/09/2022 07:29:22 pm >> SELECT document_num FROM ps_document WHERE document_num = '2760' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 07:29:22 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' , '2760' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '92.13' , '77.52' , NOW() , NOW() ) 16/09/2022 07:29:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61834' 16/09/2022 07:29:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '61834' 16/09/2022 07:29:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61834' , '6811' , 'MOCCOLO 80X200' , '9' , '-9' , '1' , '9.00' , '7.3770491803279' , '22' , '0' , '81.00' ) 16/09/2022 07:29:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6811' AND id_supplier = '' 16/09/2022 07:29:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6811' , '' , '1' ) 16/09/2022 07:29:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61834' , '19926' , 'AMEN - DIC. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 16/09/2022 07:29:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19926' AND id_supplier = '' 16/09/2022 07:29:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19926' , '' , '1' ) 16/09/2022 07:29:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61834' , '19925' , 'AMEN - NOV. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 16/09/2022 07:29:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19925' AND id_supplier = '' 16/09/2022 07:29:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19925' , '' , '1' ) 16/09/2022 07:29:23 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61834' , '19685' , 'AMEN - OTT 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 16/09/2022 07:29:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 16/09/2022 07:29:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 16/09/2022 07:43:29 pm >> SELECT document_num FROM ps_document WHERE document_num = '2761' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 07:43:29 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' , '2761' , '2022-09-16' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '7.79' , NOW() , NOW() ) 16/09/2022 07:43:29 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 = '61835' 16/09/2022 07:43:29 pm >> DELETE FROM ps_document_detail WHERE id_document = '61835' 16/09/2022 07:43:29 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61835' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '9.5' , '7.7868852459016' , '22' , '0' , '9.50' ) 16/09/2022 07:43:30 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 16/09/2022 07:43:30 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 16/09/2022 07:45:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2761' AND id_document != '61835' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-09-16') 16/09/2022 07:45:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2761', document_date = '2022-09-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 = '9.50', price_tax_excluded = '7.79', date_upd = NOW() WHERE id_document = '61835' 16/09/2022 07:45: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 = '61835' 16/09/2022 07:45:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '61835' 16/09/2022 07:45: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 ( '61835' , '9229' , 'S. PIO - CM 15 - 023 PP15' , '1' , '-1' , '1' , '9.5' , '7.7868852459016' , '22' , '0' , '9.50' ) 16/09/2022 07:45:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9229' AND id_supplier = '' 16/09/2022 07:45:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9229' , '' , '1' )