07/03/2024 09:51:51 am >> SELECT document_num FROM ps_document WHERE document_num = '672' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 09:51:51 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' , '672' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 07/03/2024 09:51:51 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90658' 07/03/2024 09:51:51 am >> DELETE FROM ps_document_detail WHERE id_document = '90658' 07/03/2024 09:51:51 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90658' , '7202' , 'ARTICOLI RELIGIOSI' , '1' , '-1' , '1' , '90' , '73.770491803279' , '22' , '0' , '90.00' ) 07/03/2024 09:55:38 am >> SELECT document_num FROM ps_document WHERE document_num = '673' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 09:55:38 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' , '673' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '140.00' , '114.75' , NOW() , NOW() ) 07/03/2024 09:55:38 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 = '90659' 07/03/2024 09:55:38 am >> DELETE FROM ps_document_detail WHERE id_document = '90659' 07/03/2024 09:55:38 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 ( '90659' , '16723' , 'TECA AGNELLO - 286' , '1' , '-1' , '1' , '130.00' , '106.55737704918' , '22' , '0' , '130.00' ) 07/03/2024 09:55:38 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 ( '90659' , '17160' , 'CARBONCINI ROSSI - CARRO' , '1' , '-1' , '1' , '10.00' , '8.1967213114754' , '22' , '0' , '10.00' ) 07/03/2024 10:02:49 am >> SELECT document_num FROM ps_document WHERE document_num = '674' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 10:02:49 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '674' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '98.80' , '82.93' , NOW() , NOW() ) 07/03/2024 10:02:49 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90660' 07/03/2024 10:02:49 am >> DELETE FROM ps_document_detail WHERE id_document = '90660' 07/03/2024 10:02:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90660' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '4' , '-4' , '1' , '22' , '18.032786885246' , '22' , '0' , '88.00' ) 07/03/2024 10:02:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90660' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 07/03/2024 10:02:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90660' , '8409' , 'PRENDETE E MANGIATE - GUIDA' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '0' , '5.00' ) 07/03/2024 10:02:49 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90660' , '8408' , 'PRENDETE E MANGIATE' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 07/03/2024 10:04:00 am >> SELECT document_num FROM ps_document WHERE document_num = '675' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 10:04:00 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' , '675' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '101.80' , '87.91' , NOW() , NOW() ) 07/03/2024 10:04:00 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90661' 07/03/2024 10:04:00 am >> DELETE FROM ps_document_detail WHERE id_document = '90661' 07/03/2024 10:04:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90661' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '3' , '-3' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '33.00' ) 07/03/2024 10:04:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90661' , '20778' , 'PASSIO N.E.' , '3' , '-3' , '4' , '6.00' , '6' , '0' , '5' , '17.10' ) 07/03/2024 10:04:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90661' , '18289' , 'SANTA MESSA DEGLI SPOSI - N.E.' , '1' , '-1' , '4' , '1.90' , '1.9' , '0' , '0' , '1.90' ) 07/03/2024 10:04:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90661' , '22080' , 'LI AMO SINO ALLA FINE - QA. RAMINA' , '1' , '-1' , '4' , '3.00' , '3' , '0' , '0' , '3.00' ) 07/03/2024 10:04:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90661' , '22148' , 'DICHIARAZIONE FIDUCIA SUPPLICANS' , '1' , '-1' , '4' , '2.80' , '2.8' , '0' , '0' , '2.80' ) 07/03/2024 10:04:00 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90661' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '22' , '18.032786885246' , '22' , '0' , '44.00' ) 07/03/2024 10:06:07 am >> SELECT document_num FROM ps_document WHERE document_num = '676' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 10:06:07 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' , '676' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '204.75' , '178.96' , NOW() , NOW() ) 07/03/2024 10:06:07 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 = '90662' 07/03/2024 10:06:07 am >> DELETE FROM ps_document_detail WHERE id_document = '90662' 07/03/2024 10:06:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90662' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '2' , '-2' , '1' , '22' , '18.032786885246' , '22' , '0' , '44.00' ) 07/03/2024 10:06:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90662' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '3' , '-3' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '33.00' ) 07/03/2024 10:06:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90662' , '17617' , 'IMMAGINI ISONZO X 100' , '20' , '-20' , '1' , '3.3' , '2.7049180327869' , '22' , '0' , '66.00' ) 07/03/2024 10:06:07 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90662' , '22149' , 'LEZIONARIO FERIALE TEMPI FORTI - N.E.' , '1' , '-1' , '4' , '65.00' , '65' , '0' , '5' , '61.75' ) 07/03/2024 10:06:59 am >> SELECT document_num FROM ps_document WHERE document_num = '677' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 10:06:59 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '677' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '28.50' , '28.50' , NOW() , NOW() ) 07/03/2024 10:06:59 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90663' 07/03/2024 10:06:59 am >> DELETE FROM ps_document_detail WHERE id_document = '90663' 07/03/2024 10:06:59 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90663' , '11305' , 'VIA CRUCIS DIALOGATA' , '30' , '-30' , '4' , '1.00' , '1' , '0' , '5' , '28.50' ) 07/03/2024 10:09:16 am >> SELECT document_num FROM ps_document WHERE document_num = '678' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 10:09:16 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' , '678' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '90.00' , '73.77' , NOW() , NOW() ) 07/03/2024 10:09:16 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 = '90664' 07/03/2024 10:09:16 am >> DELETE FROM ps_document_detail WHERE id_document = '90664' 07/03/2024 10:09:16 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 ( '90664' , '5903' , 'LITURGICO ART. 60LT ROSSO SUPER' , '30' , '-30' , '1' , '3' , '2.4590163934426' , '22' , '0' , '90.00' ) 07/03/2024 10:40:28 am >> SELECT document_num FROM ps_document WHERE document_num = '679' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 10:40:28 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' , '679' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '110.00' , '90.16' , NOW() , NOW() ) 07/03/2024 10:40:28 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 = '90665' 07/03/2024 10:40:28 am >> DELETE FROM ps_document_detail WHERE id_document = '90665' 07/03/2024 10:40:28 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 ( '90665' , '20791' , 'BOTTIGLIE PER ACQUA BENEDETTA - CONF. 100 PZ' , '5' , '-5' , '1' , '22' , '18.032786885246' , '22' , '0' , '110.00' ) 07/03/2024 10:55:08 am >> SELECT document_num FROM ps_document WHERE document_num = '680' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 10:55:08 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '680' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '17.10' , '17.10' , NOW() , NOW() ) 07/03/2024 10:55:09 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 = '90666' 07/03/2024 10:55:09 am >> DELETE FROM ps_document_detail WHERE id_document = '90666' 07/03/2024 10:55:09 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90666' , '20655' , 'ARTE DELLA BUONA BATTAGLIA - F. ROSINI' , '1' , '-1' , '4' , '18.00' , '18' , '0' , '5' , '17.10' ) 07/03/2024 11:15:57 am >> SELECT document_num FROM ps_document WHERE document_num = '681' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 11:15:57 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '681' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '34.50' , '28.28' , NOW() , NOW() ) 07/03/2024 11:15:57 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90667' 07/03/2024 11:15:57 am >> DELETE FROM ps_document_detail WHERE id_document = '90667' 07/03/2024 11:15:57 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90667' , '21080' , 'ROSARIO ARG. MADREPERLA - 328CAV' , '1' , '-1' , '1' , '34.50' , '28.27868852459' , '22' , '0' , '34.50' ) 07/03/2024 11:17:17 am >> SELECT document_num FROM ps_document WHERE document_num = '682' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 11:17: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' , '682' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '24.70' , '24.70' , NOW() , NOW() ) 07/03/2024 11:17: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 = '90668' 07/03/2024 11:17:17 am >> DELETE FROM ps_document_detail WHERE id_document = '90668' 07/03/2024 11:17:18 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 ( '90668' , '2549' , 'COMUNICAZIONE E MISSIONE' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 07/03/2024 11:17:18 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 ( '90668' , '22207' , 'ESPERIENZA RELIGIOSA - C. GRECO' , '1' , '-1' , '4' , '16.00' , '16' , '0' , '5' , '15.20' ) 07/03/2024 11:46:06 am >> SELECT document_num FROM ps_document WHERE document_num = '683' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 11:46:06 am >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '683' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '25.86' , '25.86' , NOW() , NOW() ) 07/03/2024 11:46:06 am >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90669' 07/03/2024 11:46:06 am >> DELETE FROM ps_document_detail WHERE id_document = '90669' 07/03/2024 11:46:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90669' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 07/03/2024 11:46:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90669' , '11305' , 'VIA CRUCIS DIALOGATA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 07/03/2024 11:46:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90669' , '22191' , 'PREGARE CON I SALMI' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 07/03/2024 11:46:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90669' , '22192' , 'PREGHIERA DI GESU' , '1' , '-1' , '4' , '8.50' , '8.5' , '0' , '5' , '8.08' ) 07/03/2024 11:46:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90669' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '1' , '-1' , '4' , '2.00' , '2' , '0' , '0' , '2.00' ) 07/03/2024 11:46:06 am >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90669' , '20870' , 'NEL VENTRE TUO - VIA MATRIS' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 07/03/2024 12:00: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 ( '33' , '178' , '2024-03-06' , '' , '0' , '118' , '4669176' , 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' , '' , '' , '13.5' , '1' , '0' , '0' , '0' , '' , '0' , '0' , '375.15' , '307.50' , NOW() , NOW() ) 07/03/2024 12:00: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 = '90670' 07/03/2024 12:00:03 pm >> DELETE FROM ps_document_detail WHERE id_document = '90670' 07/03/2024 12:00: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 ( '90670' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '1' , '1' , '54' , '44.262295081967' , '22' , '0' , '65.8800' ) 07/03/2024 12:00:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '14577' AND id_supplier = '118' 07/03/2024 12:00:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '14577' , '118' , '1' ) 07/03/2024 12:00: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 ( '90670' , '18426' , 'CAMICE BENEDETTINO MISTO LINO - 378' , '1' , '1' , '1' , '54' , '44.262295081967' , '22' , '0' , '65.8800' ) 07/03/2024 12:00:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '18426' AND id_supplier = '118' 07/03/2024 12:00:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '18426' , '118' , '1' ) 07/03/2024 12:00: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 ( '90670' , '20848' , 'CAMICE MONASTICO CON CAPPUCCIO - 21MON' , '2' , '2' , '1' , '93' , '76.229508196721' , '22' , '0' , '226.9200' ) 07/03/2024 12:00:03 pm >> DELETE FROM ps_product_supplier WHERE id_product = '20848' AND id_supplier = '118' 07/03/2024 12:00:03 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '20848' , '118' , '1' ) 07/03/2024 12:12:45 pm >> SELECT document_num FROM ps_document WHERE document_num = '684' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 12:12:45 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' , '684' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '87.00' , '71.31' , NOW() , NOW() ) 07/03/2024 12:12: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 = '90671' 07/03/2024 12:12:45 pm >> DELETE FROM ps_document_detail WHERE id_document = '90671' 07/03/2024 12:12: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 ( '90671' , '18962' , 'POLO MISTO VISCOSA ML ' , '1' , '-1' , '1' , '50' , '40.983606557377' , '22' , '0' , '50.00' ) 07/03/2024 12:12: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 ( '90671' , '19395' , 'CLERGY MISTO COTONE ML - C01' , '1' , '-1' , '1' , '37.00' , '30.327868852459' , '22' , '0' , '37.00' ) 07/03/2024 12:13:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '685' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 12:13: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 ( '11' , '685' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '1.00' , '1.00' , NOW() , NOW() ) 07/03/2024 12:13: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 = '90672' 07/03/2024 12:13:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '90672' 07/03/2024 12:13: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 ( '90672' , '11305' , 'VIA CRUCIS DIALOGATA' , '1' , '-1' , '4' , '1.00' , '1' , '0' , '0' , '1.00' ) 07/03/2024 12:15:31 pm >> SELECT document_num FROM ps_document WHERE document_num = '686' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 12:15:31 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '686' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '112.80' , '92.46' , NOW() , NOW() ) 07/03/2024 12:15:31 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90673' 07/03/2024 12:15:31 pm >> DELETE FROM ps_document_detail WHERE id_document = '90673' 07/03/2024 12:15:31 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90673' , '1914' , 'CERA DELLA LITURGIA' , '24' , '-24' , '1' , '4.7' , '3.8524590163934' , '22' , '0' , '112.80' ) 07/03/2024 12:23: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 ( '32' , '104' , '2024-03-07' , '' , '0' , '0' , '4669176' , 'VIALE EUROPA, 102 36075 MONTECCHIO MAGGIORE' , '' , '' , '13.50' , '1' , '0' , '0' , '0' , '' , '9' , '0' , '364.39' , '298.68' , NOW() , NOW() ) 07/03/2024 12:23: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 = '90674' 07/03/2024 12:23:43 pm >> DELETE FROM ps_document_detail WHERE id_document = '90674' 07/03/2024 12:23: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 ( '90674' , '14577' , 'CAMICE BENEDETTINO COCOLLE - MISTO LANA 328' , '1' , '0' , '1' , '54.0000' , '44.262295081967' , '22' , '3' , '63.9036' ) 07/03/2024 12:23: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 ( '90674' , '18426' , 'CAMICE BENEDETTINO MISTO LINO - 378' , '1' , '0' , '1' , '54.0000' , '44.262295081967' , '22' , '3' , '63.9036' ) 07/03/2024 12:23: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 ( '90674' , '20848' , 'CAMICE MONASTICO CON CAPPUCCIO - 21MON' , '2' , '0' , '1' , '93.0000' , '76.229508196721' , '22' , '3' , '220.1124' ) 07/03/2024 12:35:34 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '7910' 07/03/2024 12:35:47 pm >> UPDATE ps_product_shop SET active = '0' WHERE id_product = '7915' 07/03/2024 12:44:25 pm >> INSERT INTO ps_product ( ean13 , id_tax_rules_group , `date_add` , `date_upd` ) VALUES ( '' , '1' , NOW() , NOW() ) 07/03/2024 12:44:25 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22242' , '1' , '' , 'nuovo-prodotto' ) 07/03/2024 12:44:25 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , `date_add` , `date_upd` ) VALUES ( '22242' , '1' , '1' , '2' , NOW() , NOW() ) 07/03/2024 12:44:25 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) VALUES ( '22242' , '0' , '1' , '0' , '0' ) 07/03/2024 12:45:14 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807819483' AND id_product != '22242' AND ean13 != '' 07/03/2024 12:45:14 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788807819483', date_upd = NOW() WHERE id_product = '22242' 07/03/2024 12:45:14 pm >> UPDATE ps_product_lang SET name = 'SALVEZZA SENZA FEDE - S. NATOLI', description = '' WHERE id_product = '22242' 07/03/2024 12:45:14 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '10' WHERE id_product = '22242' 07/03/2024 12:45:14 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '10', id_tax_rules_group = '4', id_category_default = '359', id_argoment_default = '10', id_internal_category = '', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22242' 07/03/2024 12:45:14 pm >> DELETE FROM ps_specific_price WHERE id_product = '22242' 07/03/2024 12:45:15 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22242' 07/03/2024 12:45:15 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22243' , '1' , '' , 'nuovo-prodotto' ) 07/03/2024 12:45:15 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22243' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22242' 07/03/2024 12:45:15 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22243' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22242' 07/03/2024 12:46:09 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '9788807070556' AND id_product != '22243' AND ean13 != '' 07/03/2024 12:46:09 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '9788807070556', date_upd = NOW() WHERE id_product = '22243' 07/03/2024 12:46:09 pm >> UPDATE ps_product_lang SET name = 'DIECI MINUTI - C. GAMBERALE', description = '' WHERE id_product = '22243' 07/03/2024 12:46:09 pm >> UPDATE ps_product SET wholesale_price = '0.00', on_sale = '0', price = '14' WHERE id_product = '22243' 07/03/2024 12:46:09 pm >> UPDATE ps_product_shop SET wholesale_price = '0.00', price = '14', id_tax_rules_group = '4', id_category_default = '359', id_argoment_default = '10', id_internal_category = '7', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22243' 07/03/2024 12:46:09 pm >> DELETE FROM ps_specific_price WHERE id_product = '22243' 07/03/2024 12:46:11 pm >> INSERT INTO ps_product ( id_tax_rules_group , `date_add` , `date_upd` ) SELECT id_tax_rules_group , NOW() , NOW() FROM ps_product WHERE id_product = '22243' 07/03/2024 12:46:11 pm >> INSERT INTO ps_product_lang ( id_product , id_lang , name , link_rewrite ) VALUES ( '22244' , '1' , '' , 'nuovo-prodotto' ) 07/03/2024 12:46:11 pm >> INSERT INTO ps_product_shop ( id_product , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , `date_add` , `date_upd` ) SELECT '22244' , id_tax_rules_group , id_shop , id_category_default , id_argoment_default , id_internal_category , NOW() , NOW() FROM ps_product_shop WHERE id_product = '22243' 07/03/2024 12:46:11 pm >> INSERT INTO `ps_stock_available` ( id_product , id_product_attribute , id_shop , id_shop_group , quantity ) SELECT '22244' , id_product_attribute , id_shop , id_shop_group , '0' FROM ps_stock_available WHERE id_product = '22243' 07/03/2024 12:49:22 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '31' , '60442' , '2024-03-04' , '' , '0' , '109' , '4669106' , 'VIA G. VERDI, 8 20090 ASSAGO' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '312.00' , '312.00' , NOW() , NOW() ) 07/03/2024 12:49:22 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90675' 07/03/2024 12:49:22 pm >> DELETE FROM ps_document_detail WHERE id_document = '90675' 07/03/2024 12:49:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90675' , '22243' , 'DIECI MINUTI - C. GAMBERALE' , '20' , '20' , '4' , '14.00' , '14' , '0' , '0' , '280.0000' ) 07/03/2024 12:49:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22243' AND id_supplier = '109' 07/03/2024 12:49:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22243' , '109' , '1' ) 07/03/2024 12:49:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90675' , '22242' , 'SALVEZZA SENZA FEDE - S. NATOLI' , '1' , '1' , '4' , '10.00' , '10' , '0' , '0' , '10.00' ) 07/03/2024 12:49:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '22242' AND id_supplier = '109' 07/03/2024 12:49:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '22242' , '109' , '1' ) 07/03/2024 12:49:22 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90675' , '17467' , 'TEORIE DELLA COMUNICAZIONE DI MASSA- BENTIVEGNA/BOCCIA' , '1' , '1' , '4' , '22.00' , '22' , '0' , '0' , '22.00' ) 07/03/2024 12:49:22 pm >> DELETE FROM ps_product_supplier WHERE id_product = '17467' AND id_supplier = '109' 07/03/2024 12:49:22 pm >> INSERT INTO ps_product_supplier ( id_product , id_supplier , id_currency ) VALUES ( '17467' , '109' , '1' ) 07/03/2024 03:12:30 pm >> SELECT document_num FROM ps_document WHERE document_num = '687' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 03:12:30 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' , '687' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '30.40' , '30.40' , NOW() , NOW() ) 07/03/2024 03:12:30 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90676' 07/03/2024 03:12:30 pm >> DELETE FROM ps_document_detail WHERE id_document = '90676' 07/03/2024 03:12:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90676' , '22242' , 'SALVEZZA SENZA FEDE - S. NATOLI' , '1' , '-1' , '4' , '10.00' , '10' , '0' , '5' , '9.50' ) 07/03/2024 03:12:30 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90676' , '17467' , 'TEORIE DELLA COMUNICAZIONE DI MASSA- BENTIVEGNA/BOCCIA' , '1' , '-1' , '4' , '22.00' , '22' , '0' , '5' , '20.90' ) 07/03/2024 04:22:06 pm >> SELECT document_num FROM ps_document WHERE document_num = '438' AND id_document != '90335' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-02-14') 07/03/2024 04:22:06 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '438', document_date = '2024-02-14', document_letter = '', id_customer = '0', id_supplier = '', id_address = '0', address1 = 'VIA SAN FELICE IN FELLINE, 10 84134 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 = '34.25', price_tax_excluded = '28.93', date_upd = NOW() WHERE id_document = '90335' 07/03/2024 04:22: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 = '90335' 07/03/2024 04:22:06 pm >> DELETE FROM ps_document_detail WHERE id_document = '90335' 07/03/2024 04:22: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 ( '90335' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '5' , '4.75' ) 07/03/2024 04:22: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 ( '90335' , '1914' , 'CERA DELLA LITURGIA' , '5' , '-5' , '1' , '4.9000' , '4.016393442623' , '22' , '0' , '24.50' ) 07/03/2024 04:22: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 ( '90335' , '17939' , 'SAN GIUSEPPE -SER. PREGHIERA 62' , '25' , '-25' , '1' , '0.20' , '0.16393442622951' , '22' , '0' , '5.00' ) 07/03/2024 04:36:38 pm >> SELECT document_num FROM ps_document WHERE document_num = '688' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 04:36: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' , '688' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '440.00' , '386.35' , NOW() , NOW() ) 07/03/2024 04:36: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 = '90677' 07/03/2024 04:36:38 pm >> DELETE FROM ps_document_detail WHERE id_document = '90677' 07/03/2024 04:36: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 ( '90677' , '16686' , 'EVANGELIARIO' , '1' , '-1' , '4' , '150.00' , '150' , '0' , '5' , '142.50' ) 07/03/2024 04:36: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 ( '90677' , '8936' , 'ANTIVENTO PER TORCIA ORO DIAM. 4 - 33' , '2' , '-2' , '1' , '49' , '40.16393442623' , '22' , '0' , '98.00' ) 07/03/2024 04:36: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 ( '90677' , '22051' , 'FINTA CANDELA completa 4X30 - 1140' , '4' , '-4' , '1' , '25.00' , '20.491803278689' , '22' , '0' , '100.00' ) 07/03/2024 04:36: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 ( '90677' , '22196' , 'CLERGY VERSUS ML - C25' , '1' , '-1' , '1' , '49.90' , '40.901639344262' , '22' , '0' , '49.90' ) 07/03/2024 04:36: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 ( '90677' , '22045' , 'CLERGY REGULAR ML - C 24' , '1' , '-1' , '1' , '49.6' , '40.655737704918' , '22' , '0' , '49.60' ) 07/03/2024 04:41:21 pm >> SELECT document_num FROM ps_document WHERE document_num = '689' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 04:41:21 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '689' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '5.70' , '5.70' , NOW() , NOW() ) 07/03/2024 04:41:21 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90678' 07/03/2024 04:41:21 pm >> DELETE FROM ps_document_detail WHERE id_document = '90678' 07/03/2024 04:41: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 ( '90678' , '12842' , 'RICEVI IL SIGILLO DELLO SPIRITO SANTO' , '1' , '-1' , '4' , '6.00' , '6' , '0' , '5' , '5.70' ) 07/03/2024 05:02:45 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000003758' AND id_product != '22051' AND ean13 != '' 07/03/2024 05:02:45 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000003758', date_upd = NOW() WHERE id_product = '22051' 07/03/2024 05:02:45 pm >> UPDATE ps_product_lang SET name = 'FINTA CANDELA COMPLETA 4X30 - 1140', description = '' WHERE id_product = '22051' 07/03/2024 05:02:45 pm >> UPDATE ps_product SET wholesale_price = '9.98', on_sale = '0', price = '20.4918' WHERE id_product = '22051' 07/03/2024 05:02:45 pm >> UPDATE ps_product_shop SET wholesale_price = '9.98', price = '20.4918', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '22051' 07/03/2024 05:02:45 pm >> DELETE FROM ps_specific_price WHERE id_product = '22051' 07/03/2024 05:11:32 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000010787' AND id_product != '15768' AND ean13 != '' 07/03/2024 05:11:32 pm >> UPDATE ps_product SET id_supplier = '12', reference = '', ean13 = '1000000010787', date_upd = NOW() WHERE id_product = '15768' 07/03/2024 05:11:32 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO PER TORCIA ORO DIAM. 5 - 35', description = '' WHERE id_product = '15768' 07/03/2024 05:11:32 pm >> UPDATE ps_product SET wholesale_price = '19.48', on_sale = '0', price = '40.98360655737705' WHERE id_product = '15768' 07/03/2024 05:11:32 pm >> UPDATE ps_product_shop SET wholesale_price = '19.48', price = '40.98360655737705', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15768' 07/03/2024 05:11:32 pm >> DELETE FROM ps_specific_price WHERE id_product = '15768' 07/03/2024 05:12:59 pm >> SELECT ean13 FROM ps_product WHERE ean13 = '1000000010657' AND id_product != '15767' AND ean13 != '' 07/03/2024 05:12:59 pm >> UPDATE ps_product SET id_supplier = '', reference = '', ean13 = '1000000010657', date_upd = NOW() WHERE id_product = '15767' 07/03/2024 05:12:59 pm >> UPDATE ps_product_lang SET name = 'ANTIVENTO PER TORCIA NIKEL - DIAM. 5 - 34', description = '' WHERE id_product = '15767' 07/03/2024 05:12:59 pm >> UPDATE ps_product SET wholesale_price = '15.77', on_sale = '0', price = '40.98360655737705' WHERE id_product = '15767' 07/03/2024 05:12:59 pm >> UPDATE ps_product_shop SET wholesale_price = '15.77', price = '40.98360655737705', id_tax_rules_group = '1', id_category_default = '147', id_argoment_default = '42', id_internal_category = '3', on_sale = '0', on_showcase = '0', on_offer = '00', on_most = '00', date_upd = NOW() WHERE id_product = '15767' 07/03/2024 05:12:59 pm >> DELETE FROM ps_specific_price WHERE id_product = '15767' 07/03/2024 06:06:39 pm >> SELECT document_num FROM ps_document WHERE document_num = '690' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 06:06:39 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '690' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '15.50' , '12.70' , NOW() , NOW() ) 07/03/2024 06:06:39 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90679' 07/03/2024 06:06:39 pm >> DELETE FROM ps_document_detail WHERE id_document = '90679' 07/03/2024 06:06:39 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90679' , '19753' , 'INCENSO GLORIA' , '1' , '-1' , '1' , '15.50' , '12.704918032787' , '22' , '0' , '15.50' ) 07/03/2024 06:16:19 pm >> SELECT document_num FROM ps_document WHERE document_num = '691' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 06:16:19 pm >> INSERT INTO ps_document ( id_document_type , document_num , document_date , document_letter , id_customer , id_supplier , id_address , address1 , address2 , note , price_shipping , id_tax_shipping_rules , colli , peso , porto_e_imballo , mezzo_consegna , id_payment , id_causal , price_tax_included , price_tax_excluded , date_add , date_upd ) VALUES ( '11' , '691' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '78.95' , '77.65' , NOW() , NOW() ) 07/03/2024 06:16:19 pm >> INSERT INTO ps_document_detail_backup ( id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total ) SELECT id_document , id_product , name , qt , qt_mov , price_tax_included , price_tax_excluded , tax , id_tax_rules_group , discount , price_total FROM ps_document_detail WHERE id_document = '90680' 07/03/2024 06:16:19 pm >> DELETE FROM ps_document_detail WHERE id_document = '90680' 07/03/2024 06:16: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 ( '90680' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.60' , '2.9508196721311' , '22' , '0' , '7.20' ) 07/03/2024 06:16: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 ( '90680' , '21524' , 'LIBRO AGENDA CATTOLICO 2024' , '1' , '-1' , '4' , '10' , '10' , '0' , '0' , '10.00' ) 07/03/2024 06:16: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 ( '90680' , '22205' , 'VANGELO DI LUCA - S. GRASSO' , '1' , '-1' , '4' , '65.00' , '65' , '0' , '5' , '61.75' ) 07/03/2024 06:53:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '692' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 06:53:57 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' , '692' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '4.60' , '4.49' , NOW() , NOW() ) 07/03/2024 06:53: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 = '90681' 07/03/2024 06:53:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '90681' 07/03/2024 06:53: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 ( '90681' , '11151' , 'LIBRI' , '1' , '-1' , '4' , '4' , '4' , '0' , '0' , '4.00' ) 07/03/2024 06:53: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 ( '90681' , '18218' , 'DECINA LEGNO CHIARO - FR52' , '1' , '-1' , '1' , '0.60' , '0.49180327868852' , '22' , '0' , '0.60' ) 07/03/2024 07:10:48 pm >> SELECT document_num FROM ps_document WHERE document_num = '693' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 07:10: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 ( '11' , '693' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '31.55' , '28.85' , NOW() , NOW() ) 07/03/2024 07:10: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 = '90682' 07/03/2024 07:10:48 pm >> DELETE FROM ps_document_detail WHERE id_document = '90682' 07/03/2024 07:10: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 ( '90682' , '19150' , 'MOCCOLO 70X200' , '2' , '-2' , '1' , '7.50' , '6.1475409836066' , '22' , '0' , '15.00' ) 07/03/2024 07:10: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 ( '90682' , '22023' , 'SULLA TUA PAROLA - MAR/APR 2024 - 521' , '1' , '-1' , '4' , '5.00' , '5' , '0' , '5' , '4.75' ) 07/03/2024 07:10: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 ( '90682' , '11151' , 'LIBRI' , '2' , '-2' , '4' , '5.9' , '5.9' , '0' , '0' , '11.80' ) 07/03/2024 07:12:52 pm >> SELECT document_num FROM ps_document WHERE document_num = '694' AND id_document != '' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 07:12: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 ( '11' , '694' , '2024-03-07' , '' , '0' , '0' , '0' , '' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '0' , '0' , '11.00' , '9.02' , NOW() , NOW() ) 07/03/2024 07:12: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 = '90683' 07/03/2024 07:12:52 pm >> DELETE FROM ps_document_detail WHERE id_document = '90683' 07/03/2024 07:12: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 ( '90683' , '1427' , 'BUSTE PER PALMA BENEDETTA - PZ 200 ' , '1' , '-1' , '1' , '11.00' , '9.016393442623' , '22' , '0' , '11.00' ) 07/03/2024 07:24:24 pm >> UPDATE ps_address SET deleted='1' , active = '0' WHERE id_customer = '2988' 07/03/2024 07:24:24 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 ( '2988' , '10' , '188' , 'maranathà' , 'cossu' , 'isabella' , 'via parpaglia 68' , '' , '09170' , 'Oristano' , '' , '0783211094' , '3405561127' , '01054880958' , '' , NOW() , NOW() ) 07/03/2024 07:24:24 pm >> UPDATE ps_customer SET email = 'isa.cossu@tiscali.it', sdi = 'W7YVJK9', pec = '', date_upd = NOW() WHERE id_customer = '2988' 07/03/2024 07:28:57 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/E' AND id_document != '' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 07:28:57 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 ( '23' , '12/E' , '2024-03-07' , 'E' , '2988' , '0' , '4679285' , 'via parpaglia 68 09170 Oristano' , '' , '' , '0' , '4' , '0' , '0' , '0' , '' , '6' , '0' , '49.55' , '43.42' , NOW() , NOW() ) 07/03/2024 07:28: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 = '90684' 07/03/2024 07:28:57 pm >> DELETE FROM ps_document_detail WHERE id_document = '90684' 07/03/2024 07:28: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 ( '90684' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' , '2.00' , '2' , '0' , '15' , '3.40' ) 07/03/2024 07:28: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 ( '90684' , '15020' , 'PREGARE OGNI GIORNO' , '5' , '-5' , '4' , '1.00' , '1' , '0' , '15' , '4.25' ) 07/03/2024 07:28: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 ( '90684' , '7926' , 'PERGAMENE - BATTESIMO MOD. B' , '30' , '-30' , '1' , '0.50' , '0.40983606557377' , '22' , '15' , '12.75' ) 07/03/2024 07:28: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 ( '90684' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. B' , '50' , '-50' , '1' , '0.50' , '0.40983606557377' , '22' , '15' , '21.25' ) 07/03/2024 07:28: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 ( '90684' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '5' , '5' , '0' , '0' , '5.00' ) 07/03/2024 07:28: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 ( '90684' , '' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9' , '2.9' , '0' , '0' , '2.90' ) 07/03/2024 07:29:12 pm >> SELECT document_num FROM ps_document WHERE document_num = '12/E' AND id_document != '90684' AND id_document_type LIKE '2%' AND YEAR(document_date) = YEAR('2024-03-08') 07/03/2024 07:29:12 pm >> UPDATE ps_document SET id_document_type = '23', document_num = '12/E', document_date = '2024-03-08', document_letter = 'E', id_customer = '2988', id_supplier = '', id_address = '4679285', address1 = 'via parpaglia 68 09170 Oristano', address2 = '', note = '', price_shipping = '0.00', id_tax_shipping_rules = '4', colli = '0', peso = '0', porto_e_imballo = '0', mezzo_consegna = '', id_payment = '6', id_causal = '0', price_tax_included = '49.55', price_tax_excluded = '43.42', date_upd = NOW() WHERE id_document = '90684' 07/03/2024 07:29: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 = '90684' 07/03/2024 07:29:12 pm >> DELETE FROM ps_document_detail WHERE id_document = '90684' 07/03/2024 07:29: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 ( '90684' , '16666' , 'VIA LUCIS Dialogata per comunità parrocchiali' , '2' , '-2' , '4' , '2.0000' , '2' , '0' , '15' , '3.40' ) 07/03/2024 07:29: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 ( '90684' , '15020' , 'PREGARE OGNI GIORNO' , '5' , '-5' , '4' , '1.0000' , '1' , '0' , '15' , '4.25' ) 07/03/2024 07:29:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90684' , '7926' , 'PERGAMENE - BATTESIMO MOD. B' , '30' , '-30' , '1' , '0.5000' , '0.40983606557377' , '22' , '15' , '12.75' ) 07/03/2024 07:29:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90684' , '7916' , 'PERGAMENE - 1A RICONCILIAZIONE MOD. B' , '50' , '-50' , '1' , '0.5000' , '0.40983606557377' , '22' , '15' , '21.25' ) 07/03/2024 07:29:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90684' , '10133' , 'SPESE DI TRASPORTO' , '1' , '-1' , '4' , '5.0000' , '5' , '0' , '0' , '5.00' ) 07/03/2024 07:29:13 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90684' , '0' , 'CONTRASSEGNO' , '1' , '-1' , '4' , '2.9000' , '2.9' , '0' , '0' , '2.90' ) 07/03/2024 07:40:08 pm >> SELECT document_num FROM ps_document WHERE document_num = '691' AND id_document != '90680' AND id_document_type LIKE '11' AND YEAR(document_date) = YEAR('2024-03-07') 07/03/2024 07:40:08 pm >> UPDATE ps_document SET id_document_type = '11', document_num = '691', document_date = '2024-03-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 = '78.95', price_tax_excluded = '77.65', date_upd = NOW() WHERE id_document = '90680' 07/03/2024 07:40:09 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 = '90680' 07/03/2024 07:40:09 pm >> DELETE FROM ps_document_detail WHERE id_document = '90680' 07/03/2024 07:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90680' , '17617' , 'IMMAGINI ISONZO X 100' , '2' , '-2' , '1' , '3.6000' , '2.9508196721311' , '22' , '0' , '7.20' ) 07/03/2024 07:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90680' , '16665' , 'VIA CRUCIS Dialogata per comunità parrocchiali' , '10' , '-10' , '4' , '1.00' , '1' , '0' , '0' , '10.00' ) 07/03/2024 07:40:09 pm >> INSERT INTO ps_document_detail ( id_document , id_product , name , qt , qt_mov , id_tax_rules_group , price_tax_included , price_tax_excluded , tax , discount , price_total ) VALUES ( '90680' , '22205' , 'VANGELO DI LUCA - S. GRASSO' , '1' , '-1' , '4' , '65.0000' , '65' , '0' , '5' , '61.75' )