29/08/2022 08:55:48 am >> SELECT document_num FROM ps_document WHERE document_num = '44' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 08:55:48 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '44' , '2022-08-29' , '' , '3412' , '0' , '4670133' , 'VIA PROVINCIALE, 776 41055 MONTESE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 29/08/2022 08:55:48 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 = '5397' 29/08/2022 08:55:48 am >> DELETE FROM ps_document_detail WHERE id_document = '5397' 29/08/2022 08:55:48 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 ( '5397' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 29/08/2022 08:56:45 am >> SELECT document_num FROM ps_document WHERE document_num = '45' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 08:56:45 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '45' , '2022-08-29' , '' , '3449' , '0' , '4670097' , 'VIA SIMEONE PARATICO, 46 25031 CAPRIOLO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '9' , '0' , '18.00' , '18.00' , NOW() , NOW() ) 29/08/2022 08:56:45 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5398' 29/08/2022 08:56:45 am >> DELETE FROM ps_document_detail WHERE id_document = '5398' 29/08/2022 08:56:45 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5398' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '0' , '18.00' ) 29/08/2022 09:14:44 am >> SELECT document_num FROM ps_document WHERE document_num = '108' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 09:14: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 ( '21' , '108' , '2022-08-29' , '' , '3895' , '' , '4674649' , 'Piazza Duomo , 1 84011 Amalfi ' , '' , '' , '' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '75.10' , '75.10' , NOW() , NOW() ) 29/08/2022 09:14: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 = '60520' 29/08/2022 09:14:44 am >> DELETE FROM ps_document_detail WHERE id_document = '60520' 29/08/2022 09:14: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 ( '60520' , '12817' , 'LIBRO DEI MATRIMONI' , '2' , '-2' , '0' , '38.0030' , '38.003' , '' , '5' , '72.20' ) 29/08/2022 09:14:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 29/08/2022 09:14:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 29/08/2022 09:14: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 ( '60520' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 29/08/2022 09:14:44 am >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 29/08/2022 09:14:44 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 29/08/2022 09:14:59 am >> UPDATE ps_orders SET current_state = '4', delivery_date = '2022-08-20' WHERE id_order = '368' 29/08/2022 09:15:00 am >> DELETE FROM ps_document WHERE document_num = '368' AND id_document_type = '28' 29/08/2022 09:15:29 am >> SELECT document_num FROM ps_document WHERE document_num = '108' AND id_document != '60520' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 09:15:29 am >> UPDATE ps_document SET id_document_type = '21', document_num = '108', document_date = '2022-08-29', document_letter = '', id_customer = '3895', id_supplier = '', id_address = '4674649', address1 = 'Piazza Duomo , 1 84011 Amalfi ', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '0', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '75.10', price_tax_excluded = '75.10', date_upd = NOW() WHERE id_document = '60520' 29/08/2022 09:15:29 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 = '60520' 29/08/2022 09:15:29 am >> DELETE FROM ps_document_detail WHERE id_document = '60520' 29/08/2022 09:15:29 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 ( '60520' , '12817' , 'LIBRO DEI MATRIMONI' , '2' , '-2' , '0' , '38.0030' , '38.003' , '0' , '5' , '72.20' ) 29/08/2022 09:15:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '12817' AND id_supplier = '' 29/08/2022 09:15:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12817' , '' , '1' ) 29/08/2022 09:15:29 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 ( '60520' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 29/08/2022 09:15:29 am >> DELETE FROM ps_product_supplier WHERE id_product = '0' AND id_supplier = '' 29/08/2022 09:15:29 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '0' , '' , '1' ) 29/08/2022 09:50:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2526' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 09:50:27 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2526' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.00' , '19.67' , NOW() , NOW() ) 29/08/2022 09:50:27 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 = '60521' 29/08/2022 09:50:27 am >> DELETE FROM ps_document_detail WHERE id_document = '60521' 29/08/2022 09:50:27 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 ( '60521' , '7202' , 'ARTICOLI RELIGIOSI' , '3' , '-3' , '1' , '8' , '6.5573770491803' , '22' , '0' , '24.00' ) 29/08/2022 09:50:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/08/2022 09:50:27 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/08/2022 10:04:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2527' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 10:04: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' , '2527' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '132.00' , '108.20' , NOW() , NOW() ) 29/08/2022 10:04: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 = '60522' 29/08/2022 10:04:25 am >> DELETE FROM ps_document_detail WHERE id_document = '60522' 29/08/2022 10:04: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 ( '60522' , '18426' , 'CAMICE BENEDETTINO MISTO LINO - 378' , '1' , '-1' , '1' , '132' , '108.19672131148' , '22' , '0' , '132.00' ) 29/08/2022 10:04:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '18426' AND id_supplier = '' 29/08/2022 10:04:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18426' , '' , '1' ) 29/08/2022 10:07:54 am >> SELECT document_num FROM ps_document WHERE document_num = '2528' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 10:07:54 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' , '2528' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '9.50' , '9.13' , NOW() , NOW() ) 29/08/2022 10:07: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 = '60523' 29/08/2022 10:07:54 am >> DELETE FROM ps_document_detail WHERE id_document = '60523' 29/08/2022 10:07: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 ( '60523' , '7311' , 'OSTIA SOTTILE 74MM' , '5' , '-5' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '9.50' ) 29/08/2022 10:07:54 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 29/08/2022 10:07:54 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 29/08/2022 10:26:22 am >> SELECT document_num FROM ps_document WHERE document_num = '2529' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 10:26: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' , '2529' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 29/08/2022 10:26: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 = '60524' 29/08/2022 10:26:22 am >> DELETE FROM ps_document_detail WHERE id_document = '60524' 29/08/2022 10:26: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 ( '60524' , '14063' , 'STELLARIO PLEX CM 10 / 12' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 29/08/2022 10:26:22 am >> DELETE FROM ps_product_supplier WHERE id_product = '14063' AND id_supplier = '' 29/08/2022 10:26:22 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14063' , '' , '1' ) 29/08/2022 10:41:55 am >> SELECT document_num FROM ps_document WHERE document_num = '54/A' AND id_document != '59768' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-07-23') 29/08/2022 10:41:55 am >> UPDATE ps_document SET id_document_type = '24', document_num = '54/A', document_date = '2022-07-23', document_letter = 'A', id_customer = '230', id_supplier = '', id_address = '4668969', address1 = 'VIA G. NICOTERA, 66 84080 PELLEZZANO', 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 = '320.00', price_tax_excluded = '262.30', date_upd = NOW() WHERE id_document = '59768' 29/08/2022 10:41:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59768' 29/08/2022 10:41:55 am >> DELETE FROM ps_document_detail WHERE id_document = '59768' 29/08/2022 10:41:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '1914' , 'CERA DELLA LITURGIA' , '60' , '-60' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '270.00' ) 29/08/2022 10:41:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 29/08/2022 10:41:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 29/08/2022 10:41:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59768' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '50.00' ) 29/08/2022 10:41:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 29/08/2022 10:41:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 29/08/2022 10:46:21 am >> SELECT document_num FROM ps_document WHERE document_num = '2530' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 10:46: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' , '2530' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '19.00' , '19.00' , NOW() , NOW() ) 29/08/2022 10:46: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 = '60525' 29/08/2022 10:46:21 am >> DELETE FROM ps_document_detail WHERE id_document = '60525' 29/08/2022 10:46: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 ( '60525' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 29/08/2022 10:46:21 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 29/08/2022 10:46:21 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 29/08/2022 10:48:35 am >> SELECT document_num FROM ps_document WHERE document_num = '2384' AND id_document != '59828' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-28') 29/08/2022 10:48:35 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2384', document_date = '2022-07-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 = '407.00', price_tax_excluded = '339.02', date_upd = NOW() WHERE id_document = '59828' 29/08/2022 10:48:35 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 = '59828' 29/08/2022 10:48:35 am >> DELETE FROM ps_document_detail WHERE id_document = '59828' 29/08/2022 10:48:35 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 ( '59828' , '795' , 'ASTUCCIO A 3 OLI SANTI IN ALLUMINIO - 1958' , '1' , '-1' , '1' , '67.0000' , '54.918032786885' , '22' , '0' , '67.00' ) 29/08/2022 10:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '795' AND id_supplier = '' 29/08/2022 10:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '795' , '' , '1' ) 29/08/2022 10:48:35 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 ( '59828' , '17101' , 'CASULA POLIESTERE CROCE ORO - AECU04' , '4' , '-4' , '1' , '70.0000' , '57.377049180328' , '22' , '0' , '280.00' ) 29/08/2022 10:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '17101' AND id_supplier = '' 29/08/2022 10:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17101' , '' , '1' ) 29/08/2022 10:48:35 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 ( '59828' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '1' , '-1' , '4' , '30' , '30' , '0' , '0' , '30.00' ) 29/08/2022 10:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = '' 29/08/2022 10:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' ) 29/08/2022 10:48:35 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 ( '59828' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 29/08/2022 10:48:35 am >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 29/08/2022 10:48:35 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 29/08/2022 10:50:25 am >> SELECT document_num FROM ps_document WHERE document_num = '2526' AND id_document != '60521' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 10:50:25 am >> UPDATE ps_document SET id_document_type = '11', document_num = '2526', document_date = '2022-08-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '24.00', price_tax_excluded = '19.67', date_upd = NOW() WHERE id_document = '60521' 29/08/2022 10:50: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 = '60521' 29/08/2022 10:50:25 am >> DELETE FROM ps_document_detail WHERE id_document = '60521' 29/08/2022 10:50: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 ( '60521' , '12123' , 'MERLETTO CM 10,5 - CROCE E CALICE' , '5' , '-5' , '1' , '4.8' , '3.9344262295082' , '22' , '0' , '24.00' ) 29/08/2022 10:50:25 am >> DELETE FROM ps_product_supplier WHERE id_product = '12123' AND id_supplier = '' 29/08/2022 10:50:25 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12123' , '' , '1' ) 29/08/2022 10:58:27 am >> SELECT document_num FROM ps_document WHERE document_num = '2531' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 10:58:27 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' , '2531' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 29/08/2022 10:58:27 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 = '60526' 29/08/2022 10:58:27 am >> DELETE FROM ps_document_detail WHERE id_document = '60526' 29/08/2022 10:58:27 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 ( '60526' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/08/2022 10:58:27 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 29/08/2022 10:58:28 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 29/08/2022 11:11:10 am >> SELECT document_num FROM ps_document WHERE document_num = '2532' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 11:11:10 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' , '2532' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '100.00' , '81.97' , NOW() , NOW() ) 29/08/2022 11:11:10 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60527' 29/08/2022 11:11:10 am >> DELETE FROM ps_document_detail WHERE id_document = '60527' 29/08/2022 11:11:10 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 ( '60527' , '19771' , 'ROSARIO ARGENTO/EMATITE' , '1' , '-1' , '1' , '30' , '24.590163934426' , '22' , '0' , '30.00' ) 29/08/2022 11:11:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '19771' AND id_supplier = '' 29/08/2022 11:11:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19771' , '' , '1' ) 29/08/2022 11:11:10 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 ( '60527' , '16070' , 'CASULA - PCA020' , '1' , '-1' , '1' , '70' , '57.377049180328' , '22' , '0' , '70.00' ) 29/08/2022 11:11:10 am >> DELETE FROM ps_product_supplier WHERE id_product = '16070' AND id_supplier = '' 29/08/2022 11:11:10 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16070' , '' , '1' ) 29/08/2022 11:32:17 am >> SELECT document_num FROM ps_document WHERE document_num = '2533' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 11:32:17 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2533' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '12.20' , '11.57' , NOW() , NOW() ) 29/08/2022 11:32:17 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60528' 29/08/2022 11:32:17 am >> DELETE FROM ps_document_detail WHERE id_document = '60528' 29/08/2022 11:32:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60528' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '1' , '-1' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '3.50' ) 29/08/2022 11:32:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 29/08/2022 11:32:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 29/08/2022 11:32:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60528' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 29/08/2022 11:32:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 29/08/2022 11:32:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 29/08/2022 11:32:17 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60528' , '18122' , 'ROCCA STOPPINO M. 100 - 469/100' , '1' , '-1' , '1' , '1.10' , '0.9016393442623' , '22' , '0' , '1.10' ) 29/08/2022 11:32:17 am >> DELETE FROM ps_product_supplier WHERE id_product = '18122' AND id_supplier = '' 29/08/2022 11:32:17 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18122' , '' , '1' ) 29/08/2022 11:48:55 am >> SELECT document_num FROM ps_document WHERE document_num = '2534' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 11:48:55 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' , '2534' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.75' , '4.75' , NOW() , NOW() ) 29/08/2022 11:48:55 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60529' 29/08/2022 11:48:55 am >> DELETE FROM ps_document_detail WHERE id_document = '60529' 29/08/2022 11:48:55 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60529' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 29/08/2022 11:48:55 am >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 29/08/2022 11:48:55 am >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 29/08/2022 12:30:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '2535' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 12:30:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2535' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.42' , '7.42' , NOW() , NOW() ) 29/08/2022 12:30:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60530' 29/08/2022 12:30:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '60530' 29/08/2022 12:30:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60530' , '19684' , 'AMEN - SET. 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 29/08/2022 12:30:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19684' AND id_supplier = '' 29/08/2022 12:30:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19684' , '' , '1' ) 29/08/2022 12:30:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60530' , '19685' , 'AMEN - OTT 2022' , '1' , '-1' , '4' , '3.90' , '3.9' , '0' , '5' , '3.71' ) 29/08/2022 12:30:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19685' AND id_supplier = '' 29/08/2022 12:30:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19685' , '' , '1' ) 29/08/2022 12:37:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '62/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 12:37:16 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '62/A' , '2022-08-29' , 'A' , '188' , '0' , '4668955' , 'VIA ROMA 84121 SALERNO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '171.60' , '143.72' , NOW() , NOW() ) 29/08/2022 12:37:16 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 = '60531' 29/08/2022 12:37:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '60531' 29/08/2022 12:37:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60531' , '15387' , 'VESTINA BATTESIMALE ' , '60' , '-60' , '1' , '2.5' , '2.0491803278689' , '22' , '0' , '150.00' ) 29/08/2022 12:37:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60531' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '4' , '-4' , '3' , '3.50' , '3.3653846153846' , '4' , '0' , '14.00' ) 29/08/2022 12:37:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60531' , '7311' , 'OSTIA SOTTILE 74MM' , '4' , '-4' , '3' , '1.90' , '1.8269230769231' , '4' , '0' , '7.60' ) 29/08/2022 02:42:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '46' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 02:42:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '46' , '2022-08-29' , '' , '3347' , '0' , '4669949' , 'LARGO DELLA VITTORIA, 4 25065 LUMEZZANE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '90.00' , '90.00' , NOW() , NOW() ) 29/08/2022 02:42: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 = '5399' 29/08/2022 02:42:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '5399' 29/08/2022 02:42: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 ( '5399' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '5' , '-5' , '4' , '18.00' , '18' , '0' , '0' , '90.00' ) 29/08/2022 02:47:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '47' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 02:47:04 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' , '47' , '2022-08-29' , '' , '3350' , '0' , '4669953' , 'VIA RISORGIMENTO, 2 37068 VIGASIO ' , '' , '' , '4.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '22.00' , '22.00' , NOW() , NOW() ) 29/08/2022 02:47:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '5400' 29/08/2022 02:47:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '5400' 29/08/2022 02:47:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '5400' , '133' , 'LIBRO AGENDA CATTOLICO 2023' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 29/08/2022 02:48:35 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788887688412' AND id_product != '9' AND ean13 != '' 29/08/2022 02:48:35 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788887688412', date_upd = NOW() WHERE id_product = '9' 29/08/2022 02:48:35 pm >> UPDATE ps_product_lang SET name = 'PSICOLOGIA PRATICA PER EDUCATORI', description = '' WHERE id_product = '9' 29/08/2022 02:48:35 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10.50' WHERE id_product = '9' 29/08/2022 02:48:35 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10.50', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '9' 29/08/2022 02:48:35 pm >> DELETE FROM ps_specific_price WHERE id_product = '9' 29/08/2022 02:48:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '48' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 02:48:52 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' , '48' , '2022-08-29' , '' , '112' , '0' , '112' , 'P.ZZA SACRO CUORE, 1 27053 LUNGAVILLA' , '' , '' , '6.9' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '16.87' , '16.87' , NOW() , NOW() ) 29/08/2022 02:48:52 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 = '5401' 29/08/2022 02:48:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '5401' 29/08/2022 02:48: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 ( '5401' , '9' , 'PSICOLOGIA PRATICA PER EDUCATORI' , '1' , '-1' , '4' , '10.50' , '10.5' , '0' , '5' , '9.97' ) 29/08/2022 02:53:21 pm >> INSERT INTO ps_customer ( id_gender , firstname , lastname , email , passwd , `date_add` , `date_upd` ) VALUES ( '1' , '' , '' , '' , 'LeQiHI2p47hxPhDy' , NOW() , NOW() ) 29/08/2022 02:53:21 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3897' , '1' ) 29/08/2022 02:53:21 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3897' , '2' ) 29/08/2022 02:53:21 pm >> INSERT INTO ps_customer_group ( id_customer , id_group ) VALUES ( '3897' , '3' ) 29/08/2022 02:55:23 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '3897' 29/08/2022 02:55:23 pm >> INSERT INTO ps_address ( id_customer , id_country , id_state , company , lastname , firstname , address1 , address2 , postcode , city , other , phone , phone_mobile , vat_number , dni , date_add , date_upd ) VALUES ( '3897' , '10' , '162' , 'PARROCCHIA SAN GIUSEPPE' , '' , '' , 'PIAZZALE DON PINO DE LUISA 2' , '' , '34074' , 'MONFALCONE' , '' , '' , '3287861173' , '' , '' , NOW() , NOW() ) 29/08/2022 02:55:23 pm >> UPDATE ps_customer SET email = '', sdi = '', pec = 'parr.sgiuseppe.monf@gmail.com', date_upd = NOW() WHERE id_customer = '3897' 29/08/2022 02:56:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '109' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 02:56:15 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' , '109' , '2022-08-29' , '' , '3897' , '0' , '4674650' , 'PIAZZALE DON PINO DE LUISA 2 34074 MONFALCONE' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '3' , '0' , '72.20' , '59.18' , NOW() , NOW() ) 29/08/2022 02:56:15 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 = '60532' 29/08/2022 02:56:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '60532' 29/08/2022 02:56:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60532' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '5' , '36.10' ) 29/08/2022 02:56:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60532' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '1' , '38.00' , '31.147540983607' , '22' , '5' , '36.10' ) 29/08/2022 02:57:28 pm >> SELECT document_num FROM ps_document WHERE document_num = '109' AND id_document != '60532' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 02:57:28 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '109', document_date = '2022-08-29', document_letter = '', id_customer = '3897', id_supplier = '', id_address = '4674650', address1 = 'PIAZZALE DON PINO DE LUISA 2 34074 MONFALCONE', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '3', id_causal = '0', price_tax_included = '72.20', price_tax_excluded = '72.20', date_upd = NOW() WHERE id_document = '60532' 29/08/2022 02:57: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 = '60532' 29/08/2022 02:57:28 pm >> DELETE FROM ps_document_detail WHERE id_document = '60532' 29/08/2022 02:57: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 ( '60532' , '12814' , 'LIBRO DEI BATTEZZATI' , '1' , '-1' , '0' , '38.0000' , '38' , '' , '5' , '36.10' ) 29/08/2022 02:57:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12814' AND id_supplier = '' 29/08/2022 02:57:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12814' , '' , '1' ) 29/08/2022 02:57: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 ( '60532' , '12815' , 'LIBRO DEI CRESIMATI' , '1' , '-1' , '0' , '38.0000' , '38' , '' , '5' , '36.10' ) 29/08/2022 02:57:28 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12815' AND id_supplier = '' 29/08/2022 02:57:28 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12815' , '' , '1' ) 29/08/2022 03:11:19 pm >> UPDATE ps_address SET id_state = '210', lastname = 'ARGO STUDIO S.R.L.', address1 = 'VIA TERRE RISAIE 13', address2 = '', postcode = '84131', dni = '', vat_number = '05580570652', city = 'SALERNO', phone = '089792757', phone_mobile = '', date_upd = NOW() WHERE id_supplier = '53' 29/08/2022 03:11:19 pm >> UPDATE ps_supplier SET email = 'info@argostudioadv.it', name = 'ARGO STUDIO S.R.L.', date_upd = NOW() WHERE id_supplier = '53' 29/08/2022 03:11:19 pm >> UPDATE ps_supplier_lang SET description = '', meta_title = '', meta_description = '' WHERE id_supplier = '53' 29/08/2022 03:14:23 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571245' AND id_product != '111' AND ean13 != '' 29/08/2022 03:14:24 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788899571245', date_upd = NOW() WHERE id_product = '111' 29/08/2022 03:14:24 pm >> UPDATE ps_product_lang SET name = 'I NONNI SONO UN TESORO', description = '

Il compito educativo dei nonni è molto importante quando i genitori non sono in grado di assicurare un\'adeguata educazione ai figli.

La festa dei nonni fissata da Papa Francesco e questo libretto vogliono essere un omaggio ai nonni e un dono per i nipoti

' WHERE id_product = '111' 29/08/2022 03:14:24 pm >> UPDATE ps_product SET wholesale_price = '0.33', on_sale = '0', price = '1.8' WHERE id_product = '111' 29/08/2022 03:14:24 pm >> UPDATE ps_product_shop SET wholesale_price = '0.33', price = '1.8', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '1', date_upd = NOW() WHERE id_product = '111' 29/08/2022 03:14:24 pm >> DELETE FROM ps_specific_price WHERE id_product = '111' 29/08/2022 03:14:24 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '111' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 29/08/2022 03:14:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571238' AND id_product != '110' AND ean13 != '' 29/08/2022 03:14:32 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788899571238', date_upd = NOW() WHERE id_product = '110' 29/08/2022 03:14:32 pm >> UPDATE ps_product_lang SET name = 'SE MI AMI NON PIANGERE', description = '

Perdere una persona\r\ncara genera uno dei dolori più grandi che si\r\npossano provare nella vita.

La morte sembra\r\nla fine di tutto, sembra il distacco totale da chi\r\nabbiamo amato e continuiamo ad amare.

Questo\r\nlibretto, in base alla visione di\r\napertura e di speranza legate alla Risurrezione, vuole dire, a chi ha\r\nperduto delle persone care, alcuni\r\npensieri e poche ma essenziali preghiere di conforto
\r\nspirituale.

' WHERE id_product = '110' 29/08/2022 03:14:32 pm >> UPDATE ps_product SET wholesale_price = '0.30', on_sale = '0', price = '1.8' WHERE id_product = '110' 29/08/2022 03:14:32 pm >> UPDATE ps_product_shop SET wholesale_price = '0.30', price = '1.8', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '1', date_upd = NOW() WHERE id_product = '110' 29/08/2022 03:14:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '110' 29/08/2022 03:14:32 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '110' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 29/08/2022 03:14:43 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788899571313' AND id_product != '117' AND ean13 != '' 29/08/2022 03:14:43 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788899571313', date_upd = NOW() WHERE id_product = '117' 29/08/2022 03:14:43 pm >> UPDATE ps_product_lang SET name = 'La preghiera delle cinque dita n.e.', description = '

Un piccolo testo sulla preghiera \"delle cinque dita\"di Papa Francesco, per avvicinare i più piccoli alla\r\npreghiera.

Pregare, secondo le intenzioni che ci suggerisce Papa Francesco,\r\nti aiuterà a comprendere meglio l\'importanza degli altri nella\r\ntua vita, ad aiutare gli altri attraverso la preghiera.

' WHERE id_product = '117' 29/08/2022 03:14:43 pm >> UPDATE ps_product SET wholesale_price = '0.32', on_sale = '0', price = '1.8' WHERE id_product = '117' 29/08/2022 03:14:43 pm >> UPDATE ps_product_shop SET wholesale_price = '0.32', price = '1.8', id_tax_rules_group = '4', id_category_default = '2', id_argoment_default = '', id_internal_category = '', on_sale = '0', on_showcase = '1', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '117' 29/08/2022 03:14:43 pm >> DELETE FROM ps_specific_price WHERE id_product = '117' 29/08/2022 03:14:43 pm >> INSERT INTO ps_specific_price ( id_specific_price_rule , id_cart , id_product , id_shop , id_shop_group , id_currency , id_country , id_group , id_customer , id_product_attribute , price , from_quantity , reduction , reduction_tax , reduction_type , `from` , `to`) VALUES ( '0' , '0' , '117' , '1' , '0' , '0' , '0' , '0' , '0' , '0' , '-1' , '1' , '0.05' , '1' , 'percentage' , '0000-00-00' , '0000-00-00' ) 29/08/2022 03:14: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 ( '31' , '342' , '2022-08-11' , '' , '0' , '53' , '2648' , 'VIA TERRE RISAIE 13 84131 SALERNO' , '' , '' , '0.36' , '3' , '0' , '0' , '0' , '' , '3' , '0' , '1497.60' , '1440.00' , NOW() , NOW() ) 29/08/2022 03:14: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 = '5402' 29/08/2022 03:14:51 pm >> DELETE FROM ps_document_detail WHERE id_document = '5402' 29/08/2022 03:14: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 ( '5402' , '111' , 'I NONNI SONO UN TESORO' , '3000' , '3000' , '3' , '0.2116' , '0.20346153846154' , '4' , '10' , '594.1728' ) 29/08/2022 03:14:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '111' AND id_supplier = '53' 29/08/2022 03:14:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '111' , '53' , '1' ) 29/08/2022 03:14: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 ( '5402' , '110' , 'SE MI AMI NON PIANGERE' , '3000' , '3000' , '3' , '0.2116' , '0.20346153846154' , '4' , '10' , '594.1728' ) 29/08/2022 03:14:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '110' AND id_supplier = '53' 29/08/2022 03:14:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '110' , '53' , '1' ) 29/08/2022 03:14: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 ( '5402' , '117' , 'La preghiera delle cinque dita n.e.' , '1000' , '1000' , '3' , '0.33' , '0.31730769230769' , '4' , '10' , '308.8800' ) 29/08/2022 03:14:51 pm >> DELETE FROM ps_product_supplier WHERE id_product = '117' AND id_supplier = '53' 29/08/2022 03:14:51 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '117' , '53' , '1' ) 29/08/2022 03:18:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '1514' AND id_document != '57252' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-13') 29/08/2022 03:18:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1514', document_date = '2022-05-13', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'P.ZZA S. MICHELE 83029 SOLOFRA', 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 = '170.00', price_tax_excluded = '139.34', date_upd = NOW() WHERE id_document = '57252' 29/08/2022 03:18:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57252' 29/08/2022 03:18:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '57252' 29/08/2022 03:18:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57252' , '15921' , 'SERVIZIO MESSA LINO 100% - 74301' , '1' , '-1' , '1' , '115.0000' , '94.262295081967' , '22' , '0' , '115.00' ) 29/08/2022 03:18:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15921' AND id_supplier = '' 29/08/2022 03:18:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15921' , '' , '1' ) 29/08/2022 03:18:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57252' , '3098' , 'CROCE SAGOMATA BRINATO ARG. STRASS CM 21' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 29/08/2022 03:18:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3098' AND id_supplier = '' 29/08/2022 03:18:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3098' , '' , '1' ) 29/08/2022 03:18:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57252' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 29/08/2022 03:18:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 29/08/2022 03:18:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 29/08/2022 03:20:01 pm >> SELECT document_num FROM ps_document WHERE document_num = '1235' AND id_document != '55891' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23') 29/08/2022 03:20:01 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1235', document_date = '2022-04-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '500.00', price_tax_excluded = '409.84', date_upd = NOW() WHERE id_document = '55891' 29/08/2022 03:20:01 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 = '55891' 29/08/2022 03:20:01 pm >> DELETE FROM ps_document_detail WHERE id_document = '55891' 29/08/2022 03:20:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55891' , '17404' , 'CASULA RIGATA' , '1' , '-1' , '1' , '270.0000' , '221.31147540984' , '22' , '0' , '270.00' ) 29/08/2022 03:20:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17404' AND id_supplier = '' 29/08/2022 03:20:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17404' , '' , '1' ) 29/08/2022 03:20:01 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55891' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '15.9000' , '13.032786885246' , '22' , '0' , '31.80' ) 29/08/2022 03:20:01 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19147' AND id_supplier = '' 29/08/2022 03:20:01 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19147' , '' , '1' ) 29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55891' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55891' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55891' , '794' , 'ASTUCCIO 3 BOTTIGLIE CC125 - 964' , '1' , '-1' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '95.00' ) 29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '794' AND id_supplier = '' 29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '794' , '' , '1' ) 29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55891' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '6.2' , '5.0819672131148' , '22' , '0' , '6.20' ) 29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55891' , '18247' , 'CLERGY JEANS NIDO DAPE MM - M' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18247' AND id_supplier = '' 29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18247' , '' , '1' ) 29/08/2022 03:20:02 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '55891' , '12689' , 'IMMAGINI 50X70' , '1' , '-1' , '1' , '4.50' , '3.6885245901639' , '22' , '0' , '4.50' ) 29/08/2022 03:20:02 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12689' AND id_supplier = '' 29/08/2022 03:20:02 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12689' , '' , '1' ) 29/08/2022 03:23:25 pm >> SELECT document_num FROM ps_document WHERE document_num = '2478' AND id_document != '59959' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-09') 29/08/2022 03:23:25 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2478', document_date = '2022-08-09', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '37.00', price_tax_excluded = '30.33', date_upd = NOW() WHERE id_document = '59959' 29/08/2022 03:23:25 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '59959' 29/08/2022 03:23:25 pm >> DELETE FROM ps_document_detail WHERE id_document = '59959' 29/08/2022 03:23:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59959' , '15208' , 'ANELLO DECINA CON CRISTALLI - ARG 925' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 29/08/2022 03:23:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15208' AND id_supplier = '' 29/08/2022 03:23:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15208' , '' , '1' ) 29/08/2022 03:23:25 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59959' , '2963' , 'CROCE DA COLLO - CM 9 - OGGETTI' , '1' , '-1' , '1' , '18' , '14.754098360656' , '22' , '0' , '18.00' ) 29/08/2022 03:23:25 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2963' AND id_supplier = '' 29/08/2022 03:23:25 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2963' , '' , '1' ) 29/08/2022 03:24:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '1673' AND id_document != '58470' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 29/08/2022 03:24:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1673', document_date = '2022-05-27', 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 = '148.50', price_tax_excluded = '121.72', date_upd = NOW() WHERE id_document = '58470' 29/08/2022 03:24:34 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 = '58470' 29/08/2022 03:24:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '58470' 29/08/2022 03:24:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58470' , '7924' , 'PERGAMENE - BATTESIMO MOD. A' , '65' , '-65' , '1' , '0.5000' , '0.40983606557377' , '22' , '0' , '32.50' ) 29/08/2022 03:24:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7924' AND id_supplier = '' 29/08/2022 03:24:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7924' , '' , '1' ) 29/08/2022 03:24:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58470' , '15774' , 'INCENSO NARJAN - 500G' , '2' , '-2' , '1' , '25.0000' , '20.491803278689' , '22' , '0' , '50.00' ) 29/08/2022 03:24:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15774' AND id_supplier = '' 29/08/2022 03:24:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15774' , '' , '1' ) 29/08/2022 03:24:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58470' , '3073' , 'CROCE PRIMA COMUNIONE - LEGNO SCURO - 713/15' , '5' , '-5' , '1' , '1.2000' , '0.98360655737705' , '22' , '0' , '6.00' ) 29/08/2022 03:24:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '3073' AND id_supplier = '' 29/08/2022 03:24:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '3073' , '' , '1' ) 29/08/2022 03:24:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58470' , '13562' , 'CORONCINA IN STOFFA CON ROSE E FOGLIOLINE - 3311' , '3' , '-3' , '1' , '6.0000' , '4.9180327868852' , '22' , '0' , '18.00' ) 29/08/2022 03:24:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13562' AND id_supplier = '' 29/08/2022 03:24:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13562' , '' , '1' ) 29/08/2022 03:24:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58470' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '3.5' , '2.8688524590164' , '22' , '0' , '42.00' ) 29/08/2022 03:24:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 29/08/2022 03:24:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 29/08/2022 03:26:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '1235' AND id_document != '55891' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-04-23') 29/08/2022 03:26:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1235', document_date = '2022-04-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '500.00', price_tax_excluded = '409.84', date_upd = NOW() WHERE id_document = '55891' 29/08/2022 03:26: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 = '55891' 29/08/2022 03:26:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '55891' 29/08/2022 03:26: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 ( '55891' , '17404' , 'CASULA RIGATA' , '1' , '-1' , '1' , '270.0000' , '221.31147540984' , '22' , '0' , '270.00' ) 29/08/2022 03:26:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17404' AND id_supplier = '' 29/08/2022 03:26:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17404' , '' , '1' ) 29/08/2022 03:26: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 ( '55891' , '19147' , 'CANDELINE NON GOCCIOLANTI GRECHE' , '2' , '-2' , '1' , '15.9000' , '13.032786885246' , '22' , '0' , '31.80' ) 29/08/2022 03:26:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19147' AND id_supplier = '' 29/08/2022 03:26:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19147' , '' , '1' ) 29/08/2022 03:26: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 ( '55891' , '11384' , 'VINO BIANCO DOLCE - 102' , '3' , '-3' , '1' , '7.5000' , '6.1475409836066' , '22' , '0' , '22.50' ) 29/08/2022 03:26:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 29/08/2022 03:26:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 29/08/2022 03:26: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 ( '55891' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 29/08/2022 03:26: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 ( '55891' , '794' , 'ASTUCCIO 3 BOTTIGLIE CC125 - 964' , '1' , '-1' , '1' , '95.0000' , '77.868852459016' , '22' , '0' , '95.00' ) 29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '794' AND id_supplier = '' 29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '794' , '' , '1' ) 29/08/2022 03:26: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 ( '55891' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '5.5' , '4.5081967213115' , '22' , '0' , '5.50' ) 29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/08/2022 03:26: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 ( '55891' , '18247' , 'CLERGY JEANS NIDO DAPE MM - M' , '1' , '-1' , '1' , '40.0000' , '32.786885245902' , '22' , '0' , '40.00' ) 29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18247' AND id_supplier = '' 29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18247' , '' , '1' ) 29/08/2022 03:26: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 ( '55891' , '12689' , 'IMMAGINI 50X70' , '1' , '-1' , '1' , '4.5000' , '3.6885245901639' , '22' , '0' , '4.50' ) 29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12689' AND id_supplier = '' 29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12689' , '' , '1' ) 29/08/2022 03:26: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 ( '55891' , '18222' , 'ROSARIO COLORATO - R316' , '1' , '-1' , '1' , '0.70' , '0.57377049180328' , '22' , '0' , '0.70' ) 29/08/2022 03:26:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18222' AND id_supplier = '' 29/08/2022 03:26:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18222' , '' , '1' ) 29/08/2022 03:26:49 pm >> SELECT document_num FROM ps_document WHERE document_num = '1604' AND id_document != '57867' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-20') 29/08/2022 03:26:49 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1604', document_date = '2022-05-20', 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 = '45.00', price_tax_excluded = '36.89', date_upd = NOW() WHERE id_document = '57867' 29/08/2022 03:26:49 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57867' 29/08/2022 03:26:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '57867' 29/08/2022 03:26: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 ( '57867' , '19594' , 'POLO JERSEY COTONE 100%' , '1' , '-1' , '1' , '35.0000' , '28.688524590164' , '22' , '0' , '35.00' ) 29/08/2022 03:26:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19594' AND id_supplier = '' 29/08/2022 03:26:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19594' , '' , '1' ) 29/08/2022 03:26: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 ( '57867' , '18554' , 'MADONNA ROSARIO BABY - 023 MDR/9 BB' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 29/08/2022 03:26:49 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18554' AND id_supplier = '' 29/08/2022 03:26:49 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18554' , '' , '1' ) 29/08/2022 03:27:23 pm >> SELECT document_num FROM ps_document WHERE document_num = '1633' AND id_document != '57900' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-23') 29/08/2022 03:27:23 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1633', document_date = '2022-05-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '217.00', price_tax_excluded = '180.61', date_upd = NOW() WHERE id_document = '57900' 29/08/2022 03:27:23 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57900' 29/08/2022 03:27:23 pm >> DELETE FROM ps_document_detail WHERE id_document = '57900' 29/08/2022 03:27: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 ( '57900' , '18426' , 'CAMICE BENEDETTINO MISTO LINO - 378' , '1' , '-1' , '1' , '130.0000' , '106.55737704918' , '22' , '0' , '130.00' ) 29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18426' AND id_supplier = '' 29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18426' , '' , '1' ) 29/08/2022 03:27: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 ( '57900' , '12670' , 'CAMICE AVORIO - MISTO COT. 160' , '1' , '-1' , '1' , '55.0000' , '45.081967213115' , '22' , '0' , '55.00' ) 29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12670' AND id_supplier = '' 29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12670' , '' , '1' ) 29/08/2022 03:27: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 ( '57900' , '15474' , 'CUORE A CUORE - M. RATTA' , '1' , '-1' , '4' , '4.0000' , '4' , '0' , '5' , '3.80' ) 29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15474' AND id_supplier = '' 29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15474' , '' , '1' ) 29/08/2022 03:27: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 ( '57900' , '8383' , 'PREGHIERE PER LADORAZIONE EUCARISTICA - 8141' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '8383' AND id_supplier = '' 29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '8383' , '' , '1' ) 29/08/2022 03:27: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 ( '57900' , '1350' , 'BRACCIALETTO CON CROCE - 29002 03' , '1' , '-1' , '1' , '3.0000' , '2.4590163934426' , '22' , '0' , '3.00' ) 29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1350' AND id_supplier = '' 29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1350' , '' , '1' ) 29/08/2022 03:27: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 ( '57900' , '15097' , 'CORONA MATRIMONIO - ORO' , '2' , '-2' , '1' , '6.9' , '5.655737704918' , '22' , '0' , '13.80' ) 29/08/2022 03:27:23 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15097' AND id_supplier = '' 29/08/2022 03:27:23 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15097' , '' , '1' ) 29/08/2022 03:27:44 pm >> SELECT document_num FROM ps_document WHERE document_num = '1576' AND id_document != '57834' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-18') 29/08/2022 03:27:44 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1576', document_date = '2022-05-18', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '48.40', price_tax_excluded = '44.14', date_upd = NOW() WHERE id_document = '57834' 29/08/2022 03:27:44 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 = '57834' 29/08/2022 03:27:44 pm >> DELETE FROM ps_document_detail WHERE id_document = '57834' 29/08/2022 03:27:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57834' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '2' , '-2' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '7.00' ) 29/08/2022 03:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 29/08/2022 03:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 29/08/2022 03:27:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57834' , '16689' , 'OSTIA PAN DI CENA mm80' , '2' , '-2' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '4.00' ) 29/08/2022 03:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 29/08/2022 03:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 29/08/2022 03:27:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57834' , '15924' , 'OSTIA 3MM - 03M-25' , '1' , '-1' , '3' , '6.0000' , '5.7692307692308' , '4' , '0' , '6.00' ) 29/08/2022 03:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15924' AND id_supplier = '' 29/08/2022 03:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15924' , '' , '1' ) 29/08/2022 03:27:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57834' , '18920' , 'LUCE IN FONDO - L. EPICOCO' , '1' , '-1' , '4' , '12.0000' , '12' , '0' , '5' , '11.40' ) 29/08/2022 03:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18920' AND id_supplier = '' 29/08/2022 03:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18920' , '' , '1' ) 29/08/2022 03:27:44 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57834' , '18390' , 'BRACCIALE 10 ESSENZE' , '1' , '-1' , '1' , '20' , '16.393442622951' , '22' , '0' , '20.00' ) 29/08/2022 03:27:44 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18390' AND id_supplier = '' 29/08/2022 03:27:44 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18390' , '' , '1' ) 29/08/2022 03:28:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '1591' AND id_document != '57852' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-19') 29/08/2022 03:28:04 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1591', document_date = '2022-05-19', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '79.00', price_tax_excluded = '72.27', date_upd = NOW() WHERE id_document = '57852' 29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '57852' 29/08/2022 03:28:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '57852' 29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57852' , '16163' , 'PARTICOLE TAGLIO CHIUSO - PAN DI CENA' , '10' , '-10' , '3' , '3.5000' , '3.3653846153846' , '4' , '0' , '35.00' ) 29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16163' AND id_supplier = '' 29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16163' , '' , '1' ) 29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57852' , '16689' , 'OSTIA PAN DI CENA mm80' , '5' , '-5' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '10.00' ) 29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57852' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '2' , '-2' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '8.00' ) 29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57852' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '4.5' , '3.6885245901639' , '22' , '0' , '4.50' ) 29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57852' , '5230' , 'INCENSO RAPHAEL ' , '1' , '-1' , '1' , '19.0000' , '15.573770491803' , '22' , '0' , '19.00' ) 29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5230' AND id_supplier = '' 29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5230' , '' , '1' ) 29/08/2022 03:28:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '57852' , '15481' , 'CROCE IHS - 2389/CZ' , '1' , '-1' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '2.50' ) 29/08/2022 03:28:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15481' AND id_supplier = '' 29/08/2022 03:28:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15481' , '' , '1' ) 29/08/2022 03:28:58 pm >> SELECT document_num FROM ps_document WHERE document_num = '1641' AND id_document != '58426' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-24') 29/08/2022 03:28:58 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1641', document_date = '2022-05-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 = '48.60', price_tax_excluded = '40.49', date_upd = NOW() WHERE id_document = '58426' 29/08/2022 03:28:58 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 = '58426' 29/08/2022 03:28:58 pm >> DELETE FROM ps_document_detail WHERE id_document = '58426' 29/08/2022 03:28:58 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58426' , '12402' , 'TENERO ABBRACCIO - 16X9' , '1' , '-1' , '1' , '18.0000' , '14.754098360656' , '22' , '0' , '18.00' ) 29/08/2022 03:28:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12402' AND id_supplier = '' 29/08/2022 03:28:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12402' , '' , '1' ) 29/08/2022 03: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 ( '58426' , '19413' , 'CARI SPOSI E SPOSE SCRIVO A VOI' , '2' , '-2' , '4' , '1.8000' , '1.8' , '0' , '0' , '3.60' ) 29/08/2022 03:28:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19413' AND id_supplier = '' 29/08/2022 03:28:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19413' , '' , '1' ) 29/08/2022 03: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 ( '58426' , '18391' , 'CATENINA ACCIAIO 10 ESSENZE' , '1' , '-1' , '1' , '21.5' , '17.622950819672' , '22' , '0' , '21.50' ) 29/08/2022 03:28:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18391' AND id_supplier = '' 29/08/2022 03:28:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18391' , '' , '1' ) 29/08/2022 03: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 ( '58426' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '5.50' , '4.5081967213115' , '22' , '0' , '5.50' ) 29/08/2022 03:28:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 29/08/2022 03:28:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 29/08/2022 03:29:18 pm >> SELECT document_num FROM ps_document WHERE document_num = '1685' AND id_document != '58482' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-05-27') 29/08/2022 03:29:18 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1685', document_date = '2022-05-27', 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 = '60.00', price_tax_excluded = '51.25', date_upd = NOW() WHERE id_document = '58482' 29/08/2022 03:29: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 = '58482' 29/08/2022 03:29:18 pm >> DELETE FROM ps_document_detail WHERE id_document = '58482' 29/08/2022 03:29: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 ( '58482' , '547' , 'AMPOLLINE E VASSOIO IN VETRO - 506' , '1' , '-1' , '1' , '29.5000' , '24.180327868852' , '22' , '0' , '29.50' ) 29/08/2022 03:29:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '547' AND id_supplier = '' 29/08/2022 03:29:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '547' , '' , '1' ) 29/08/2022 03:29: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 ( '58482' , '17277' , 'BRACCIALE PIETRE DURE - 4633' , '1' , '-1' , '1' , '4' , '3.2786885245902' , '22' , '0' , '4.00' ) 29/08/2022 03:29:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17277' AND id_supplier = '' 29/08/2022 03:29:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17277' , '' , '1' ) 29/08/2022 03:29: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 ( '58482' , '5251' , 'INCONTRI EUCARISTICI' , '5' , '-5' , '4' , '2.3000' , '2.3' , '0' , '0' , '11.50' ) 29/08/2022 03:29:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5251' AND id_supplier = '' 29/08/2022 03:29:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5251' , '' , '1' ) 29/08/2022 03:29: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 ( '58482' , '13733' , 'DECINA - 356/14' , '3' , '-3' , '1' , '1.7000' , '1.3934426229508' , '22' , '0' , '5.10' ) 29/08/2022 03:29:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13733' AND id_supplier = '' 29/08/2022 03:29:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13733' , '' , '1' ) 29/08/2022 03:29: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 ( '58482' , '13364' , 'CORONA MM 6 ' , '1' , '-1' , '1' , '2.7000' , '2.2131147540984' , '22' , '0' , '2.70' ) 29/08/2022 03:29:18 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13364' AND id_supplier = '' 29/08/2022 03:29:18 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13364' , '' , '1' ) 29/08/2022 03:29: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 ( '58482' , '11384' , 'VINO BIANCO DOLCE - 102' , '1' , '-1' , '1' , '7.2000' , '5.9016393442623' , '22' , '0' , '7.20' ) 29/08/2022 03:29:19 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11384' AND id_supplier = '' 29/08/2022 03:29:19 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11384' , '' , '1' ) 29/08/2022 03:30:10 pm >> SELECT document_num FROM ps_document WHERE document_num = '1754' AND id_document != '58570' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-03') 29/08/2022 03:30:11 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1754', document_date = '2022-06-03', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '10.00', price_tax_excluded = '8.20', date_upd = NOW() WHERE id_document = '58570' 29/08/2022 03:30:11 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 = '58570' 29/08/2022 03:30:11 pm >> DELETE FROM ps_document_detail WHERE id_document = '58570' 29/08/2022 03:30:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58570' , '7911' , 'PERGAMENE - 1A COMUNIONE MOD. B' , '4' , '-4' , '1' , '0.50' , '0.40983606557377' , '22' , '0' , '2.00' ) 29/08/2022 03:30:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7911' AND id_supplier = '' 29/08/2022 03:30:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7911' , '' , '1' ) 29/08/2022 03:30:11 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58570' , '7193' , 'NUPTIAE DECORO VETRATA ' , '1' , '-1' , '1' , '8.00' , '6.5573770491803' , '22' , '0' , '8.00' ) 29/08/2022 03:30:11 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7193' AND id_supplier = '' 29/08/2022 03:30:11 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7193' , '' , '1' ) 29/08/2022 03:30:59 pm >> SELECT document_num FROM ps_document WHERE document_num = '2421' AND id_document != '59882' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-01') 29/08/2022 03:30:59 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2421', document_date = '2022-08-01', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '59.00', price_tax_excluded = '49.17', date_upd = NOW() WHERE id_document = '59882' 29/08/2022 03:30: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 = '59882' 29/08/2022 03:30:59 pm >> DELETE FROM ps_document_detail WHERE id_document = '59882' 29/08/2022 03:30: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 ( '59882' , '6663' , 'MIE PREGHIERE' , '2' , '-2' , '4' , '1.5000' , '1.5' , '0' , '0' , '3.00' ) 29/08/2022 03:30:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '6663' AND id_supplier = '' 29/08/2022 03:30:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '6663' , '' , '1' ) 29/08/2022 03:30: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 ( '59882' , '4129' , 'FELICE ANNIVERSARIO' , '1' , '-1' , '4' , '1.5000' , '1.5' , '0' , '0' , '1.50' ) 29/08/2022 03:30:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4129' AND id_supplier = '' 29/08/2022 03:30:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4129' , '' , '1' ) 29/08/2022 03:30: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 ( '59882' , '16964' , 'PALLA IN S/MOIRE - 7885M' , '1' , '-1' , '1' , '54.5' , '44.672131147541' , '22' , '0' , '54.50' ) 29/08/2022 03:30:59 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16964' AND id_supplier = '' 29/08/2022 03:30:59 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16964' , '' , '1' ) 29/08/2022 03:32:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2536' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 03:32:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2536' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '13.20' , '10.82' , NOW() , NOW() ) 29/08/2022 03:32:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60533' 29/08/2022 03:32:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '60533' 29/08/2022 03:32:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60533' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '2' , '-2' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '6.60' ) 29/08/2022 03:32:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 29/08/2022 03:32:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 29/08/2022 03:32:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60533' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '2' , '-2' , '1' , '3.30' , '2.7049180327869' , '22' , '0' , '6.60' ) 29/08/2022 03:32:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 29/08/2022 03:32:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 29/08/2022 03:34:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '2471' AND id_document != '59952' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-08') 29/08/2022 03:34:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2471', document_date = '2022-08-08', 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 = '1.00', price_tax_excluded = '1.00', date_upd = NOW() WHERE id_document = '59952' 29/08/2022 03:34: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 = '59952' 29/08/2022 03:34:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '59952' 29/08/2022 03:34: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 ( '59952' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 29/08/2022 03:34:20 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '' 29/08/2022 03:34:20 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' ) 29/08/2022 03:34:34 pm >> SELECT document_num FROM ps_document WHERE document_num = '2445' AND id_document != '59924' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-05') 29/08/2022 03:34:34 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2445', document_date = '2022-08-05', 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 = '36.00', price_tax_excluded = '36.00', date_upd = NOW() WHERE id_document = '59924' 29/08/2022 03:34:34 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 = '59924' 29/08/2022 03:34:34 pm >> DELETE FROM ps_document_detail WHERE id_document = '59924' 29/08/2022 03:34:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59924' , '5887' , 'LITURGIA DELLE ORE - VOL. I - PER SACERDOTI E RELIGIOSI' , '1' , '-1' , '4' , '35.0000' , '35' , '0' , '0' , '35.00' ) 29/08/2022 03:34:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5887' AND id_supplier = '' 29/08/2022 03:34:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5887' , '' , '1' ) 29/08/2022 03:34:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59924' , '19138' , 'ATTO DI ABBANDONO - D. D. RUOTOLO' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 29/08/2022 03:34:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19138' AND id_supplier = '' 29/08/2022 03:34:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19138' , '' , '1' ) 29/08/2022 03:36:55 pm >> SELECT document_num FROM ps_document WHERE document_num = '2061' AND id_document != '58921' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-27') 29/08/2022 03:36:55 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2061', document_date = '2022-06-27', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA DALMAZIA 6 84121 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 = '71.12', price_tax_excluded = '60.95', date_upd = NOW() WHERE id_document = '58921' 29/08/2022 03:36:55 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '58921' 29/08/2022 03:36:55 pm >> DELETE FROM ps_document_detail WHERE id_document = '58921' 29/08/2022 03:36:55 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58921' , '1914' , 'CERA DELLA LITURGIA' , '12' , '-12' , '1' , '4.7000' , '3.8524590163934' , '22' , '0' , '56.40' ) 29/08/2022 03:36:55 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1914' AND id_supplier = '' 29/08/2022 03:36:55 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1914' , '' , '1' ) 29/08/2022 03:36:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58921' , '9593' , 'SANTA MONICA - R.PICCOLOMINI' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 29/08/2022 03:36:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9593' AND id_supplier = '' 29/08/2022 03:36:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9593' , '' , '1' ) 29/08/2022 03:36:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58921' , '15816' , 'CHI HA REDENTI CON IL TUO SANGUE - L. EPICOCO ' , '1' , '-1' , '4' , '8.7200' , '8.72' , '0' , '0' , '8.72' ) 29/08/2022 03:36:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15816' AND id_supplier = '' 29/08/2022 03:36:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15816' , '' , '1' ) 29/08/2022 03:36:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '58921' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 29/08/2022 03:36:56 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 29/08/2022 03:36:56 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 29/08/2022 03:38:20 pm >> SELECT document_num FROM ps_document WHERE document_num = '2103' AND id_document != '58970' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-30') 29/08/2022 03:38:20 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2103', 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 = '116.20', price_tax_excluded = '101.19', date_upd = NOW() WHERE id_document = '58970' 29/08/2022 03:38: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 = '58970' 29/08/2022 03:38:20 pm >> DELETE FROM ps_document_detail WHERE id_document = '58970' 29/08/2022 03:38: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 ( '58970' , '18321' , 'IO ROSA - 8022' , '1' , '-1' , '4' , '2' , '2' , '0' , '0' , '2.00' ) 29/08/2022 03:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18321' AND id_supplier = '' 29/08/2022 03:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18321' , '' , '1' ) 29/08/2022 03:38: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 ( '58970' , '7311' , 'OSTIA SOTTILE 74MM' , '8' , '-8' , '3' , '1.9000' , '1.8269230769231' , '4' , '0' , '15.20' ) 29/08/2022 03:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7311' AND id_supplier = '' 29/08/2022 03:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7311' , '' , '1' ) 29/08/2022 03:38: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 ( '58970' , '15387' , 'VESTINA BATTESIMALE ' , '20' , '-20' , '1' , '2.5000' , '2.0491803278689' , '22' , '0' , '50.00' ) 29/08/2022 03:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '15387' AND id_supplier = '' 29/08/2022 03:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '15387' , '' , '1' ) 29/08/2022 03:38: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 ( '58970' , '19107' , 'INCENSO GRANI 3A' , '1' , '-1' , '1' , '30.0000' , '24.590163934426' , '22' , '0' , '30.00' ) 29/08/2022 03:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19107' AND id_supplier = '' 29/08/2022 03:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19107' , '' , '1' ) 29/08/2022 03:38: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 ( '58970' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '4' , '-4' , '4' , '5.00' , '5' , '0' , '5' , '19.00' ) 29/08/2022 03:38:21 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 29/08/2022 03:38:21 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 29/08/2022 03:39:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '2537' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 03:39:38 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2537' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '57.00' , '47.08' , NOW() , NOW() ) 29/08/2022 03:39:38 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 = '60534' 29/08/2022 03:39:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '60534' 29/08/2022 03:39:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60534' , '16461' , 'CLERGY NIDO D\'APE ML - C 22' , '1' , '-1' , '1' , '55.00' , '45.081967213115' , '22' , '0' , '55.00' ) 29/08/2022 03:39:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16461' AND id_supplier = '' 29/08/2022 03:39:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16461' , '' , '1' ) 29/08/2022 03:39:38 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60534' , '19805' , 'DESIDERIO DESIDERAVI' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 29/08/2022 03:39:38 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19805' AND id_supplier = '' 29/08/2022 03:39:38 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19805' , '' , '1' ) 29/08/2022 03:40:15 pm >> SELECT document_num FROM ps_document WHERE document_num = '2336' AND id_document != '59770' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-23') 29/08/2022 03:40:15 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2336', document_date = '2022-07-23', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '77.60', price_tax_excluded = '76.37', date_upd = NOW() WHERE id_document = '59770' 29/08/2022 03:40:15 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 = '59770' 29/08/2022 03:40:15 pm >> DELETE FROM ps_document_detail WHERE id_document = '59770' 29/08/2022 03:40: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 ( '59770' , '16691' , 'PARTICOLE PER CELIACI 25pz' , '3' , '-3' , '3' , '4.0000' , '3.8461538461538' , '4' , '0' , '12.00' ) 29/08/2022 03:40:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16691' AND id_supplier = '' 29/08/2022 03:40:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16691' , '' , '1' ) 29/08/2022 03:40: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 ( '59770' , '16689' , 'OSTIA PAN DI CENA mm80' , '10' , '-10' , '3' , '2.0000' , '1.9230769230769' , '4' , '0' , '20.00' ) 29/08/2022 03:40:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16689' AND id_supplier = '' 29/08/2022 03:40:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16689' , '' , '1' ) 29/08/2022 03:40: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 ( '59770' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '12' , '-12' , '4' , '3.8' , '3.8' , '0' , '0' , '45.60' ) 29/08/2022 03:40:15 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 29/08/2022 03:40:15 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 29/08/2022 03:41:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '2289' AND id_document != '59711' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 29/08/2022 03:41:45 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2289', document_date = '2022-07-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 = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '59711' 29/08/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 = '59711' 29/08/2022 03:41:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '59711' 29/08/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 ( '59711' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '3.75' , '3.75' , '0' , '0' , '3.75' ) 29/08/2022 03:41:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 29/08/2022 03:41:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 29/08/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 ( '59711' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 29/08/2022 03:41:46 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 29/08/2022 03:41:46 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 29/08/2022 03:42:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '2289' AND id_document != '59711' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-07-16') 29/08/2022 03:42:12 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2289', document_date = '2022-07-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 = '18.00', price_tax_excluded = '18.00', date_upd = NOW() WHERE id_document = '59711' 29/08/2022 03:42: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 = '59711' 29/08/2022 03:42:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '59711' 29/08/2022 03:42: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 ( '59711' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '1.95' , '1.95' , '0' , '0' , '1.95' ) 29/08/2022 03:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '11151' AND id_supplier = '' 29/08/2022 03:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '11151' , '' , '1' ) 29/08/2022 03:42: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 ( '59711' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '3' , '-3' , '4' , '5.0000' , '5' , '0' , '5' , '14.25' ) 29/08/2022 03:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 29/08/2022 03:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 29/08/2022 03:42: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 ( '59711' , '19413' , 'CARI SPOSI E SPOSE SCRIVO A VOI' , '1' , '-1' , '4' , '1.80' , '1.8' , '0' , '0' , '1.80' ) 29/08/2022 03:42:12 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19413' AND id_supplier = '' 29/08/2022 03:42:12 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19413' , '' , '1' ) 29/08/2022 03:44:16 pm >> SELECT document_num FROM ps_document WHERE document_num = '107' AND id_document != '59992' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-11') 29/08/2022 03:44:16 pm >> UPDATE ps_document SET id_document_type = '21', document_num = '107', document_date = '2022-08-11', document_letter = '', id_customer = '618', id_supplier = '', id_address = '4671023', address1 = 'S. ANGELO 84085 MERCATO S. SEVERINO', address2 = '', note = 'COPIE OMAGGIO AUTORE', 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 = '0.00', price_tax_excluded = '0.00', date_upd = NOW() WHERE id_document = '59992' 29/08/2022 03:44:16 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 = '59992' 29/08/2022 03:44:16 pm >> DELETE FROM ps_document_detail WHERE id_document = '59992' 29/08/2022 03:44:16 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '59992' , '19727' , 'LITURGIA IN FRAMMENTI - A. SORRENTINO' , '100' , '-100' , '4' , '35.0000' , '35' , '0' , '100' , '0.00' ) 29/08/2022 03:44:16 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19727' AND id_supplier = '' 29/08/2022 03:44:16 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19727' , '' , '1' ) 29/08/2022 04:35:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2538' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 04:35:06 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2538' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '14.25' , '14.25' , NOW() , NOW() ) 29/08/2022 04:35: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 = '60535' 29/08/2022 04:35:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '60535' 29/08/2022 04:35: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 ( '60535' , '19622' , 'SULLA TUA PAROLA - SETT/OTT 2022' , '3' , '-3' , '4' , '5.00' , '5' , '0' , '5' , '14.25' ) 29/08/2022 04:35:06 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19622' AND id_supplier = '' 29/08/2022 04:35:06 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19622' , '' , '1' ) 29/08/2022 04:35:43 pm >> SELECT document_num FROM ps_document WHERE document_num = '2539' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 04:35:43 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2539' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '123.50' , '101.23' , NOW() , NOW() ) 29/08/2022 04:35:43 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60536' 29/08/2022 04:35:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '60536' 29/08/2022 04:35:43 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60536' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '123.5' , '101.22950819672' , '22' , '0' , '123.50' ) 29/08/2022 04:35:43 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/08/2022 04:35:43 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/08/2022 04:40:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '2539' AND id_document != '60536' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 04:40:57 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '2539', document_date = '2022-08-29', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = '', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '0', id_causal = '0', price_tax_included = '123.50', price_tax_excluded = '101.23', date_upd = NOW() WHERE id_document = '60536' 29/08/2022 04:40:57 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '60536' 29/08/2022 04:40:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '60536' 29/08/2022 04:40:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60536' , '16118' , 'CLERGY GRIGIO JEANS - M' , '1' , '-1' , '1' , '42.00' , '34.426229508197' , '22' , '0' , '42.00' ) 29/08/2022 04:40:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '16118' AND id_supplier = '' 29/08/2022 04:40:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '16118' , '' , '1' ) 29/08/2022 04:40:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60536' , '18252' , 'CLERGY BLU NIDO DAPE MM - M' , '1' , '-1' , '1' , '40.00' , '32.786885245902' , '22' , '0' , '40.00' ) 29/08/2022 04:40:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18252' AND id_supplier = '' 29/08/2022 04:40:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18252' , '' , '1' ) 29/08/2022 04:40:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60536' , '2168' , 'CLERGY BASIC - ML - B&P' , '1' , '-1' , '1' , '34.00' , '27.868852459016' , '22' , '0' , '34.00' ) 29/08/2022 04:40:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '2168' AND id_supplier = '' 29/08/2022 04:40:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '2168' , '' , '1' ) 29/08/2022 04:40:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '60536' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '7.5' , '6.1475409836066' , '22' , '0' , '7.50' ) 29/08/2022 04:40:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/08/2022 04:40:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/08/2022 05:33:50 pm >> SELECT document_num FROM ps_document WHERE document_num = '2540' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 05:33:50 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '2540' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.35' , '31.35' , NOW() , NOW() ) 29/08/2022 05:33:50 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61048' 29/08/2022 05:33:50 pm >> DELETE FROM ps_document_detail WHERE id_document = '61048' 29/08/2022 05:33:50 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61048' , '9255' , 'SACRA BIBBIA SIMILP BIANCA - 8642' , '1' , '-1' , '4' , '33.00' , '33' , '0' , '5' , '31.35' ) 29/08/2022 05:33:50 pm >> DELETE FROM ps_product_supplier WHERE id_product = '9255' AND id_supplier = '' 29/08/2022 05:33:50 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '9255' , '' , '1' ) 29/08/2022 05:37:56 pm >> SELECT document_num FROM ps_document WHERE document_num = '110' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 05:37:56 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '110' , '2022-08-29' , '' , '3898' , '' , '4674767' , 'Via Ilario Paglierani , 1A 47922 Rimini Lasciare pacco in giardino, dietro al cancello grazie!' , '' , '' , '' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '91.39' , '91.39' , NOW() , NOW() ) 29/08/2022 05:37:56 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61049' 29/08/2022 05:37:56 pm >> DELETE FROM ps_document_detail WHERE id_document = '61049' 29/08/2022 05:37:56 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 29/08/2022 05:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1883' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1883' , '' , '1' ) 29/08/2022 05:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 29/08/2022 05:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 29/08/2022 05:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5643' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5643' , '' , '1' ) 29/08/2022 05:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5644' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5644' , '' , '1' ) 29/08/2022 05:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5645' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5645' , '' , '1' ) 29/08/2022 05:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12253' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12253' , '' , '1' ) 29/08/2022 05:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '-1' , '4' , '1.9' , '1.9' , '0' , '5' , '1.80' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' ) 29/08/2022 05:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '4' , '9' , '9' , '0' , '5' , '8.55' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18491' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18491' , '' , '1' ) 29/08/2022 05:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '4' , '9' , '9' , '0' , '5' , '8.55' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18492' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18492' , '' , '1' ) 29/08/2022 05:37:57 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61049' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '4' , '9' , '9' , '0' , '5' , '8.55' ) 29/08/2022 05:37:57 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18493' AND id_supplier = '' 29/08/2022 05:37:57 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18493' , '' , '1' ) 29/08/2022 05:40:33 pm >> SELECT document_num FROM ps_document WHERE document_num = '111' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 05:40:33 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '21' , '111' , '2022-08-29' , '' , '3898' , '' , '4674767' , 'Via Ilario Paglierani , 1A 47922 Rimini Lasciare pacco in giardino, dietro al cancello grazie!' , '' , '' , '5.00' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '105.33' , '105.33' , NOW() , NOW() ) 29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61050' 29/08/2022 05:40:33 pm >> DELETE FROM ps_document_detail WHERE id_document = '61050' 29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1883' AND id_supplier = '' 29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1883' , '' , '1' ) 29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5643' AND id_supplier = '' 29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5643' , '' , '1' ) 29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5644' AND id_supplier = '' 29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5644' , '' , '1' ) 29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:40:33 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5645' AND id_supplier = '' 29/08/2022 05:40:33 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5645' , '' , '1' ) 29/08/2022 05:40:33 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12253' AND id_supplier = '' 29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12253' , '' , '1' ) 29/08/2022 05:40:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '-1' , '1' , '2.3180' , '1.9' , '22' , '5' , '2.20' ) 29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = '' 29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' ) 29/08/2022 05:40:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '1' , '10.9800' , '9' , '22' , '5' , '10.43' ) 29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18491' AND id_supplier = '' 29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18491' , '' , '1' ) 29/08/2022 05:40:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '1' , '10.9800' , '9' , '22' , '5' , '10.43' ) 29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18492' AND id_supplier = '' 29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18492' , '' , '1' ) 29/08/2022 05:40:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '1' , '10.9800' , '9' , '22' , '5' , '10.43' ) 29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18493' AND id_supplier = '' 29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18493' , '' , '1' ) 29/08/2022 05:40:34 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61050' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 29/08/2022 05:40:34 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 29/08/2022 05:40:34 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 29/08/2022 05:40:49 pm >> DELETE FROM ps_document WHERE id_document = '61050' 29/08/2022 05:40:49 pm >> DELETE FROM ps_document_detail WHERE id_document = '61050' 29/08/2022 05:44:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '111' AND id_document != '' AND id_document_type LIKE '21' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 05:44: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 ( '21' , '111' , '2022-08-29' , '' , '3898' , '' , '4674767' , 'Via Ilario Paglierani , 1A 47922 Rimini Lasciare pacco in giardino, dietro al cancello grazie!' , '' , '' , '5.00' , '0' , '0' , '0' , '0' , '' , '1' , '0' , '105.33' , '105.33' , NOW() , NOW() ) 29/08/2022 05:44: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 = '61051' 29/08/2022 05:44:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '61051' 29/08/2022 05:44: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 ( '61051' , '1882' , 'CELEBRAZIONI PER L\'ANNO CATECHISTICO' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1882' AND id_supplier = '' 29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1882' , '' , '1' ) 29/08/2022 05:44: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 ( '61051' , '1883' , 'CELEBRAZIONI PER L\'ANNO PASTORALE' , '1' , '-1' , '4' , '11.0000' , '11' , '0' , '5' , '10.45' ) 29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '1883' AND id_supplier = '' 29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '1883' , '' , '1' ) 29/08/2022 05:44: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 ( '61051' , '4494' , 'GESÙ RESTA CON NOI 3 - GUIDA' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4494' AND id_supplier = '' 29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4494' , '' , '1' ) 29/08/2022 05:44: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 ( '61051' , '4495' , 'GESÙ RESTA CON NOI 3 - SCHEDE' , '1' , '-1' , '4' , '3.5000' , '3.5' , '0' , '5' , '3.33' ) 29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '4495' AND id_supplier = '' 29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '4495' , '' , '1' ) 29/08/2022 05:44: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 ( '61051' , '5643' , 'LEGGERE,... LA PAROLA - ANNO A' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5643' AND id_supplier = '' 29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5643' , '' , '1' ) 29/08/2022 05:44: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 ( '61051' , '5644' , 'LEGGERE,... LA PAROLA - ANNO B' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5644' AND id_supplier = '' 29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5644' , '' , '1' ) 29/08/2022 05:44: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 ( '61051' , '5645' , 'LEGGERE,... LA PAROLA - ANNO C' , '1' , '-1' , '4' , '10.0000' , '10' , '0' , '5' , '9.50' ) 29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5645' AND id_supplier = '' 29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5645' , '' , '1' ) 29/08/2022 05:44: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 ( '61051' , '12253' , 'MIO LIBRO DI PREGHIERE' , '1' , '-1' , '4' , '2.8000' , '2.8' , '0' , '5' , '2.66' ) 29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '12253' AND id_supplier = '' 29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '12253' , '' , '1' ) 29/08/2022 05:44: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 ( '61051' , '17580' , 'NUOVO MESSALINO PER RAGAZZI' , '1' , '-1' , '1' , '2.3180' , '1.9' , '22' , '5' , '2.20' ) 29/08/2022 05:44:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17580' AND id_supplier = '' 29/08/2022 05:44:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17580' , '' , '1' ) 29/08/2022 05:44:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61051' , '18491' , 'UNA STORIA CHE SALVA VOL. 1' , '1' , '-1' , '1' , '10.9800' , '9' , '22' , '5' , '10.43' ) 29/08/2022 05:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18491' AND id_supplier = '' 29/08/2022 05:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18491' , '' , '1' ) 29/08/2022 05:44:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61051' , '18492' , 'UNA STORIA CHE SALVA VOL. 2' , '1' , '-1' , '1' , '10.9800' , '9' , '22' , '5' , '10.43' ) 29/08/2022 05:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18492' AND id_supplier = '' 29/08/2022 05:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18492' , '' , '1' ) 29/08/2022 05:44:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61051' , '18493' , 'UNA STORIA CHE SALVA VOL. 3' , '1' , '-1' , '1' , '10.9800' , '9' , '22' , '5' , '10.43' ) 29/08/2022 05:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18493' AND id_supplier = '' 29/08/2022 05:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18493' , '' , '1' ) 29/08/2022 05:44:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61051' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.90' , '2.90' , '' , '0' , '2.90' ) 29/08/2022 05:44:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '' AND id_supplier = '' 29/08/2022 05:44:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '' , '' , '1' ) 29/08/2022 05:53:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '1818' AND id_document != '58645' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-06-07') 29/08/2022 05:53:52 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '1818', document_date = '2022-06-07', 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 = '25.00', price_tax_excluded = '20.49', date_upd = NOW() WHERE id_document = '58645' 29/08/2022 05:53:52 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 = '58645' 29/08/2022 05:53:53 pm >> DELETE FROM ps_document_detail WHERE id_document = '58645' 29/08/2022 05:53: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 ( '58645' , '5655' , 'LEGGIO IN PLEXIGLASS - 40986' , '1' , '-1' , '1' , '25' , '20.491803278689' , '22' , '0' , '25.00' ) 29/08/2022 05:53:53 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5655' AND id_supplier = '' 29/08/2022 05:53:53 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5655' , '' , '1' ) 29/08/2022 06:01:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '2541' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 06:01:07 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' , '2541' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '45.00' , '36.89' , NOW() , NOW() ) 29/08/2022 06:01:07 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 = '61052' 29/08/2022 06:01:07 pm >> DELETE FROM ps_document_detail WHERE id_document = '61052' 29/08/2022 06:01: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 ( '61052' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '45' , '36.885245901639' , '22' , '0' , '45.00' ) 29/08/2022 06:01:07 pm >> DELETE FROM ps_product_supplier WHERE id_product = '7202' AND id_supplier = '' 29/08/2022 06:01:07 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '7202' , '' , '1' ) 29/08/2022 06:15:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '63/A' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 06:15:48 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '24' , '63/A' , '2022-08-29' , 'A' , '1156' , '0' , '4671056' , 'VIA BANZANO DI MONTORO 83020 BANZANO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '150.00' , '150.00' , NOW() , NOW() ) 29/08/2022 06:15: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 = '61053' 29/08/2022 06:15:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '61053' 29/08/2022 06:15: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 ( '61053' , '' , 'completo calice +pisside' , '1' , '-1' , '0' , '150' , '150' , '' , '0' , '150.00' ) 29/08/2022 06:26:03 pm >> SELECT document_num FROM ps_document WHERE document_num = '2542' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 06:26: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' , '2542' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '7.60' , '7.60' , NOW() , NOW() ) 29/08/2022 06:26: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 = '61054' 29/08/2022 06:26:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '61054' 29/08/2022 06:26: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 ( '61054' , '19788' , 'MESSA MEDITAZIONE - SET. 2022' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 29/08/2022 06:26:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19788' AND id_supplier = '' 29/08/2022 06:26:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19788' , '' , '1' ) 29/08/2022 06:26: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 ( '61054' , '19789' , 'MESSA MEDITAZIONE - OTT. 2022' , '1' , '-1' , '4' , '4.00' , '4' , '0' , '5' , '3.80' ) 29/08/2022 06:26:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '19789' AND id_supplier = '' 29/08/2022 06:26:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '19789' , '' , '1' ) 29/08/2022 07:18:21 pm >> DELETE FROM ps_product WHERE id_product = '9250' 29/08/2022 07:18:21 pm >> DELETE FROM ps_product_shop WHERE id_product = '9250' 29/08/2022 07:18:21 pm >> DELETE FROM ps_product_lang WHERE id_product = '9250' 29/08/2022 07:18:21 pm >> DELETE FROM ps_stock_available WHERE id_product = '9250' 29/08/2022 07:18:26 pm >> DELETE FROM ps_product WHERE id_product = '9251' 29/08/2022 07:18:26 pm >> DELETE FROM ps_product_shop WHERE id_product = '9251' 29/08/2022 07:18:26 pm >> DELETE FROM ps_product_lang WHERE id_product = '9251' 29/08/2022 07:18:26 pm >> DELETE FROM ps_stock_available WHERE id_product = '9251' 29/08/2022 07:18:36 pm >> DELETE FROM ps_product WHERE id_product = '9254' 29/08/2022 07:18:36 pm >> DELETE FROM ps_product_shop WHERE id_product = '9254' 29/08/2022 07:18:36 pm >> DELETE FROM ps_product_lang WHERE id_product = '9254' 29/08/2022 07:18:36 pm >> DELETE FROM ps_stock_available WHERE id_product = '9254' 29/08/2022 07:18:53 pm >> DELETE FROM ps_product WHERE id_product = '9256' 29/08/2022 07:18:53 pm >> DELETE FROM ps_product_shop WHERE id_product = '9256' 29/08/2022 07:18:53 pm >> DELETE FROM ps_product_lang WHERE id_product = '9256' 29/08/2022 07:18:53 pm >> DELETE FROM ps_stock_available WHERE id_product = '9256' 29/08/2022 09:01:04 pm >> SELECT document_num FROM ps_document WHERE document_num = '2543' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2022-08-29') 29/08/2022 09:01:04 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' , '2543' , '2022-08-29' , '' , '' , '' , '' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '130.00' , '106.56' , NOW() , NOW() ) 29/08/2022 09:01:04 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '61055' 29/08/2022 09:01:04 pm >> DELETE FROM ps_document_detail WHERE id_document = '61055' 29/08/2022 09:01:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61055' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '10' , '-10' , '1' , '3' , '2.4590163934426' , '22' , '0' , '30.00' ) 29/08/2022 09:01:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '5903' AND id_supplier = '' 29/08/2022 09:01:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '5903' , '' , '1' ) 29/08/2022 09:01:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61055' , '13049' , 'LITURGICO ART. 60LT BIANCO SUPER' , '20' , '-20' , '1' , '3' , '2.4590163934426' , '22' , '0' , '60.00' ) 29/08/2022 09:01:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '13049' AND id_supplier = '' 29/08/2022 09:01:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '13049' , '' , '1' ) 29/08/2022 09:01:04 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '61055' , '18020' , 'PORTACANDELA ' , '2' , '-2' , '1' , '20.00' , '16.393442622951' , '22' , '0' , '40.00' ) 29/08/2022 09:01:04 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18020' AND id_supplier = '' 29/08/2022 09:01:04 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18020' , '' , '1' )