text:
Mankato man reels in massive muskie from the Minnesota River
Nov 13, 2019 @ 3:02am
(Mankato, MN) – When Johnny Boutchee went fishing over the weekend – as he frequently does – he planned on catching walleye.
Prior to the Gopher football game, the Mankato man decided to hit up one of his favorite spots on the Minnesota River. "It's a beautiful spot for walleyes," Boutchee said of his place down the hill from the softball fields at Sibley Park. "I was using a ten-pound line and a rattle trap."
But it wasn't a walleye that Boutchee hooked. Instead, a 38-pound, 52-inch muskie had latched on to his line.
"When I first got it, I thought it was a buffalo fish, 'cause they're moving upriver right now," he said. "I was trying to jerk it off the hook, but then I finally got it close enough to me, and I said 'Damn! That's a big muskie!'"
Bouchee said in his nearly 60 years of fishing, he's caught one other muskie in the river off Judson Bottom Road. He described that fish as a "skinny little tiger that looked like a toothpick." His Saturday catch, he says, is the biggest muskie he's ever seen.
The fish took Boutchee about 45 minutes to reel in. "Usually, muskies…people are using 60 and 80-pound line. I was only using ten-pound line."
When the fish was reeled in, Boutchee and his companion took photos. The two used an official scale to weigh the muskie and measured the fish before releasing it back into the Minnesota River.
Muskies are typically regarded as a difficult fish to catch. Tony Sindt, a Minnesota River Specialist with the Minnesota Department of Resources says muskellunge – or muskies – were aptly described in an old saying as the "fish of 10,000 casts."
French Lake near Faribault and Fox Lake in the Windom area are two southern Minnesota lakes with a muskie population, according to Sindt. But muskie is otherwise more commonly found in the northern part of the state, and the Mississppi and St. Croix rivers.
"They prefer clearer water and vegetation," said Sindt, "So as far as the Minnesota River goes, it doesn't provide optimal habitat for them," said Sindt. "I don't know the population in the Minnesota River, but it's a very small number; there's very few in the river, so to catch one would be very rare."
Meanwhile, Boutchee will get a photo printed and framed to add to his collection of fishing memorabilia.
Boutchee said he began fishing at age 10 when his mother would tell him to go out and catch her a fish for dinner. The Mankato man, now nearly 67-year-old, says this fishing experience ranks number one in all of his fishing memories.
"I don't drink or anything," he said. "So it's like a drug to me. I just go fishing."
(Copyright © Southern Minnesota News. Alpha Media Mankato. All rights reserved. This material may not be published, broadcast, rewritten or redistributed.)


Function: Fuel pellet machinery is also named as biomass or wood pellet machine. It is designed to make biofuel / biomass fuel pellets for burning.
Suitable Raw Materials: It can process various kinds of biomass raw materials such as wood, sawdust, straw, rice husk, bamboo sawdust, peanut shell, bagasse and alfalfa, etc. If you are not sure how your materials perform in pelleting, you can send us some sample of the material and we can help you test the pelletizing process and send you the final products.
Application: Small pellet prodcution; homemade pellet process; Individual pelletizing uses.
Main Structure: While pelleting, the pellet die is rotatable and the roller is fixed. The driving gear is made of superior alloy steel. The gear surface processed via carburizing and quenching also has been fine-ground. Consequently, it embraces the advantages of steady transmission, low noise, excellent loading capacity, slow temperature rise, long service life and good pressure tolerance. It is featured with low productivity, movability, small size and low price, and these characteristics makes die-turned pellet machinery an ideal equipment for making wood fuel pellets at home for warming and cooking.
Main Feature: While pelleting, the roller is rotatable and the pellet die is fixed.The die compression ratio can be selected as per the specific material. Die service life can be prolonged if both sides of the die are used. The all-steel structure and the superior reducer inside can manufacture a variety of materials and will exert a better pelletization effect with lower noise during operation.
Application: Medium to large wood/sawdust pellet production; Large commercial pelleting process.
Main Feature: Both the rollers and the ring die operate on the vertical axis, and therefore the inner and outer edges of the rollers cover the same distance across the surface of the die. Therefore no skipping occurs, which means the life of the rollers and die are considerably longer.
Application: Large biomass pelletizing production.
Main Feature: It is an integrated plant with pellet machinery and other supporting equipments. This mobile small pellet plant is an all-in-one unit being highly efficient for pressing biomass and wood fuel pellets.
Application: Large fuel pellet production; automated wood pelleting line.
Main Feature: The productivity of wood pellet line is ajustable. GEMCO supply 250kg-350kg/h small pellet line, 1-4t/h medium scale wood pellet line and 5-6t/h large biomass pellet line. Feel free to contact us for detail informations. Complete pelletizing process mainly includes crushing, drying, pelleting, cooling and packing. Each project or pellet making plan will be built according to customer request and raw material.
I have question regarding pellet market in China.
I heard China now not imported wood pellet because oil and gas price down a lot, is it right?
How is wood pellet factory in China going on?
Recently,we didn't clearly know the pellets market situations from your country Indonesia,but we have new customers from Southeast Asian markets,such as Malays,Vietnam. As far as I know,now some of our engineers are stay in Malaysia,Vietnam,Morocco,England to help our customers for installing. Meantime,some of our engineers just back to office from Ghana for installing. Hereby,I am enclosing you some pictures for your reference in mail. Kindly find in the attachment.
Please suggest list of 1TPH Wood Pellet Production Line. In Malaysia,the customer pellet lines were matched with 2 sets pellet machines,and the capacity about 3Tons/Hour. Besides, we will visit to your reference factory in China before we buy machinery from you .
Mr. Ibnu,your pellet line with one set BPM420 Ring Die Pellet Mill is a small project for us. To be frankly,we have many oversea customers pellet projects were matched with 2 sets,3 sets,4 sets,6 sets,...16 sets Ring Die Pellet Mills with large capacities. May I know when do you plan to visit us? Beside our factory,we will try to arrange you visit our domestic customer pellet line.
We are interested in a turn key 500Kg/Hr pellet plant. We will be processing hardwood chips through packing the final product.
What's the size of hard wood chips? We need match suitable crushing system for you. And how many moisture of raw materials you will use? we need match suitable drying system by it. So that we can make the detailed quotation price sheet with the suitable equipments depending on your situation.


text:
package Model;
// Generated Jan 14, 2011 3:39:55 PM by Hibernate Tools 3.2.1.GA

import javax.persistence.Column;
import javax.persistence.Embeddable;

/**
 * HsPrSalaryCurrencyDetailId generated by hbm2java
 */
@Embeddable
public class HsPrSalaryCurrencyDetailId  implements java.io.Serializable {

     private String salGrdCode;
     private String currencyId;

    public HsPrSalaryCurrencyDetailId() {
    }

    public HsPrSalaryCurrencyDetailId(String salGrdCode, String currencyId) {
       this.salGrdCode = salGrdCode;
       this.currencyId = currencyId;
    }

    @Column(name="sal_grd_code", nullable=false, length=13)
    public String getSalGrdCode() {
        return this.salGrdCode;
    }

    public void setSalGrdCode(String salGrdCode) {
        this.salGrdCode = salGrdCode;
    }

    @Column(name="currency_id", nullable=false, length=3)
    public String getCurrencyId() {
        return this.currencyId;
    }

    public void setCurrencyId(String currencyId) {
        this.currencyId = currencyId;
    }

   public boolean equals(Object other) {
         if ( (this == other ) ) return true;
		 if ( (other == null ) ) return false;
		 if ( !(other instanceof HsPrSalaryCurrencyDetailId) ) return false;
		 HsPrSalaryCurrencyDetailId castOther = ( HsPrSalaryCurrencyDetailId ) other;

		 return ( (this.getSalGrdCode()==castOther.getSalGrdCode()) || ( this.getSalGrdCode()!=null && castOther.getSalGrdCode()!=null && this.getSalGrdCode().equals(castOther.getSalGrdCode()) ) )
 && ( (this.getCurrencyId()==castOther.getCurrencyId()) || ( this.getCurrencyId()!=null && castOther.getCurrencyId()!=null && this.getCurrencyId().equals(castOther.getCurrencyId()) ) );
   }

   public int hashCode() {
         int result = 17;

         result = 37 * result + ( getSalGrdCode() == null ? 0 : this.getSalGrdCode().hashCode() );
         result = 37 * result + ( getCurrencyId() == null ? 0 : this.getCurrencyId().hashCode() );
         return result;
   }

}

redpajama_set_name: RedPajamaGithub


The president of the International Olympic Committee has told colleagues at a meeting in the Chinese capital that he is "very concerned" about unrest in Tibet, as protests continue to flare in other parts of the country.
Jacques Rogge's statement - his strongest to date - comes in the wake of repeated attempts to disrupt the Olympic torch relay. Police in London arrested 37 people for public order offences as the flame passed through the city yesterday and protesters have already gathered along the route through Paris today.
But Rogge said there was "no momentum" for a boycott of the August event as he addressed the IOC and national Olympic committees in Beijing.
"I'm very concerned with the international situation and what's happening in Tibet," he told today's meeting.
"The torch relay has been targeted. The International Olympic Committee has expressed its serious concern and calls for a rapid peaceful resolution in Tibet," he said.
He said that violence "for whatever reason" was "not compatible with the values of the torch relay or the Olympic games".
"We need the unity of the Olympic movement to help us overcome the difficulties. Our major responsibility is for offering good games to the athletes who deserve them," he said.
Sun Weide, a spokesman for the Beijing Olympic organising committee, accused protestors in London of a "disgusting" form of sabotage. The government has accused the Dalai Lama of fomenting trouble in an attempt to damage the games and foster the cause of Tibetan separatism. But the Tibetans' spiritual leader in exile has said supporters should not disrupt the Olympics and insists he seeks only autonomy.
The president of the Association of National Olympic Committees said this weekend that any politician pushing for a boycott was committing a "serious error". Mario Vazquez Rana said even a partial boycott was out of the question.
Several politicians have floated the idea of staying away from the opening ceremony of the games, without suggesting athletes should withdraw.
IOC coordination commission member Alex Gilady said he believed protests would ease after the Paris and San Francisco sections of the relay.
"The important message is to tell our athletes that some people are trying to use them and to ride on their backs for solutions that the world has to find in other places like the United Nations," said Gilady, also a senior vice-president at NBC Sports, which holds Olympic broadcast rights in the US.
But the protests seem unlikely to fade in the run-up to the games, not least because unrest in Tibetan areas of China continues.
Exile groups say witnesses reported the wounding of 10 protesters after paramilitary police opened fire on a crowd of Tibetans demanding the return of the Dalai Lama this weekend.
Hundreds of pilgrims had gathered for a religious ceremony at Lingque temple in west Sichuan province on Saturday, but the rites were halted by police, apparently because of concerns that events might get out of hand. The security forces are reported to have opened fire to disperse the crowd after they refused to leave. The US government-funded Radio Free Asia said that the wounded were taken into custody, but released after warnings of further protests.
Reporters are unable to travel to the area and the Guardian has been unable to verify the story itself.
Yesterday state media claimed that Tibetans said to have died in the unrest and crackdown were still alive or had never existed. Xinhua Chinese news agency said a Lhasa police investigation found five were still alive or did not exist while another 35 on a list issued by the Dalai Lama's representatives were impossible to locate because there were insufficient details.
But the government's refusal to allow foreign journalists into areas of unrest means it is impossible to verify their claims or find out how the investigation was conducted.
"It is impossible to assess Beijing's challenge to details of deaths issued by the Tibetan government in exile under current conditions, when the climate of fear under the crackdown makes it too dangerous for Tibetans to speak out, even to tell us their loved ones have died," said Kate Saunders of the International Campaign for Tibet.
China says 22 people died in Lhasa while the Dalai Lama's supporters say around 140 people have died in the wider unrest, mainly at the hands of security forces.
As unrest continues, one Chinese insurer has begun offering riot coverage, local media reported today.
Seven companies had bought the policy from the Tibet branch of PICC Property & Casualty Co Ltd by last week, according to the Yangcheng Evening News. It said they had paid 75,600 yuan (£5,450) to underwrite 24.6m yuan (£1.8m).
"The product is quite new ... It was released after the incident in Lhasa last month," an employee on the company's service hotline told Reuters news agency.
Shops and other businesses were torched in the unrest in the Tibetan capital on March 14.


text:
<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated Sep 3, 2008 1:58:22 PM by Hibernate Tools 3.2.1.GA -->
<hibernate-mapping>
    <class name="org.gmod.gbol.simpleObject.generated.AbstractOrganism" table="organism">
        <meta attribute="chadoModule" inherit="false">organism</meta>

        <meta attribute="scope-class" inherit="false">public abstract</meta>

        <comment>The organismal taxonomic classification. Note that phylogenies are represented using the phylogeny module, and taxonomies can be represented using the cvterm
        module or the phylogeny module.</comment>

        <id name="organismId" type="java.lang.Integer">
            <column name="organism_id" />

            <generator class="sequence">
                <param name="sequence">organism_organism_id_seq</param>
            </generator>
        </id>

        <discriminator column="organism_id" insert="false" />

        <property name="abbreviation" type="string">
            <column name="abbreviation" />
        </property>

        <property name="genus" type="string">
            <meta attribute="use-in-equals" inherit="false">true</meta>

            <column name="genus" not-null="true" />
        </property>

        <property name="species" type="string">
            <meta attribute="use-in-equals" inherit="false">true</meta>

            <column name="species" not-null="true">
                <comment>A type of organism is always uniquely identified by genus and species. When mapping from the NCBI taxonomy names.dmp file, this column must be used where
                it is present, as the common_name column is not always unique (e.g. environmental samples). If a particular strain or subspecies is to be represented, this is
                appended onto the species name. Follows standard NCBI taxonomy pattern.</comment>
            </column>
        </property>

        <property name="commonName" type="string">
            <column name="common_name" />
        </property>

        <property name="comment" type="string">
            <column name="comment" />
        </property>

        <set name="organismProperties" inverse="true">
            <key>
                <column name="organism_id" not-null="true" />
            </key>

            <one-to-many class="org.gmod.gbol.simpleObject.OrganismProperty" />
        </set>

        <set name="organismDBXrefs" inverse="true">
            <key>
                <column name="organism_id" not-null="true" />
            </key>

            <one-to-many class="org.gmod.gbol.simpleObject.OrganismDBXref" />
        </set>
    </class>
</hibernate-mapping>


For emergency flooding, please call Dispatch at 507-537-7000.
The National Weather Service provides a map showing the current river levels. Click Here for more information.
Click Here to find out about fact sheets and videos with research-based tips on immediate and long-term flood issues.
A few simple precautions can help you avoid possible health risks during a flood. Click Here for more information.
For Road Closures on County and Local Roads Click Here.


Euromonitor International's Herbal/Traditional Products in Singapore report offers a comprehensive guide to the size and shape of the market at a national level. It provides the latest retail sales data 2014-2018, allowing you to identify the sectors driving growth. Forecasts to 2023 illustrate how the market is set to change.
Product coverage: Herbal/Traditional Cough, Cold and Allergy (Hay Fever) Remedies, Herbal/Traditional Dermatologicals, Herbal/Traditional Dietary Supplements, Herbal/Traditional Digestive Remedies, Herbal/Traditional Paediatric Dietary Supplements, Herbal/Traditional Sleep Aids, Herbal/Traditional Tonics, Herbal/Traditional Topical Analgesics.


text:
Q: Mysql get records more then 3 in interval of 1 minute, return group_concat ID Currently i have this dataset, i need to return grouped ids that are within the range of 60 seconds and have more than 3.

CREATE TABLE test
(
  `id` bigint NOT NULL AUTO_INCREMENT,
  created_date TIMESTAMP(1) NOT NULL,
  origin_url   VARCHAR (200) NOT NULL,
  client_session_id VARCHAR (50) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `UC_PRE_CHAT_TALKID_COL` (`id`)
);

✓

INSERT INTO test VALUES
(1,'2021-01-18 11:02:24.0', 'https://zendes.com/', 'znkjoc3gfth2c3m0t1klii'),
(2,'2021-01-18 11:02:35.0', 'https://zendes.com/', 'znkjoc3gfth2c3m0t1klii'),
(3,'2021-01-18 11:02:03.0', 'https://zendes.com/', 'znkjoc3gfth2c3m0t1klii'),
(4,'2021-01-18 11:11:28.0', 'https://rarara.com/', 'znkjoc3gfth2c3m0t1klii'),
(5,'2021-01-18 11:11:36.0', 'https://rarara.com/', 'znkjoc3gfth2c3m0t1klii'),
(6,'2021-01-18 11:11:05.0', 'https://rarara.com/', 'znkjoc3gfth2c3m0t1klii');

✓

db<>fiddle here
something like this:
ids     origin_url              client_session_id
1,2,3   https://testett.com/    znkjoc3gfth2c3m0t1klii
4,5,6   https://rarara.com/     znkjoc3gfth2c3m0t1klii

Edit some context:
I currently developed a cron that runs every 1 minute to analyze the last 60 seconds of the bot records in database, I need to group the conversation ID's that have more than 3 records within 60 seconds in the same url and client_session_id.
follows the SQL I'm running:
select
    count(session_id),
    client_session_id,
    GROUP_CONCAT(id) as talkIds,
    origin_url
from
    bot_talk
where
    created_date > now() - interval 60 second
group by
    client_session_id, origin_url
having
    count(session_id) >= 3

This query works as I expect, but sometimes my cron service is sometimes down, and I lose those repeated records.
I thought about making an SQL(Cron) at the end of the day to analyze the last 24 hours, and look for the records that are repeated according to the rule I mentioned above?

A: Here is the answer - see the fiddle. Another answer I wrote to a similar question may provide some clearer background and is a bit simpler - see here.
All I will say is that it gives some idea of the power of window functions.
I noticed in the comments that there was some debate about what constituted a group - in this example, I have constructed the SQL such that it picks out as a group where all subsequent sessions started within 180 seconds (i.e. 3 mins) of the first - you can change the 180 to 60 (or whatever) yourself.
I've added in some records for the purpose of testing and also added CONSTRAINTs to the table definition. It's always best to put as much as possible into the DDL - your database is your final bastion of defence for your data!
CREATE TABLE test
(
  id bigint NOT NULL,
  created_date TIMESTAMP(2) NOT NULL,
  origin_url   VARCHAR (200) NOT NULL,
  client_session_id VARCHAR (50) NOT NULL,
  CONSTRAINT test_id_pk PRIMARY KEY (id),
  CONSTRAINT test_cd_url_sess_id_uq UNIQUE (created_date, origin_url, client_session_id)
);

Always use named constraints - these provide more meaningful messages than: ... failed... CONSTRAINT xyz_000_43abc has been violated....
I populated it as follows:
INSERT INTO test VALUES

--
-- 1 lone record...
--

(1,'2021-01-18 10:30:24.0', 'https://zendes.com/', 'znkjoc3gfth2c3m0t1klii'), -- XX

--
-- 4 records within 180 seconds of the first one
--

(2,'2021-01-18 11:02:24.0', 'https://zes.com/', 'znkjoc'),
(3,'2021-01-18 11:02:35.0', 'https://zes.com/', 'znkjoc'),
(4,'2021-01-18 11:03:03.0', 'https://zes.com/', 'znkjoc'),  -- **
(5,'2021-01-18 11:04:15.0', 'https://zes.com/', 'znkjoc'),  -- YY

--
-- 3 records within 180s of the first one
--

(6,'2021-01-18 11:49:28.0', 'https://rararar.com/', 'znkjoc3gfth2c3m0t1klii'),
(7,'2021-01-18 11:49:48.0', 'https://rararar.com/', 'znkjoc3gfth2c3m0t1klii'), -- **
(8,'2021-01-18 11:50:13.0', 'https://rararar.com/', 'znkjoc3gfth2c3m0t1klii'), -- **

-- 1 lone record

(9,'2021-01-18 12:57:24.0', 'https://zendes.com/', 'znkjoc3gfth2c3m0t1klii'),  -- XX

(10,'2021-02-18 09:02:24.0', 'https://rar.com/', 'znkjoc3'), -- ZZ
(11,'2021-02-18 09:02:35.0', 'https://rar.com/', 'znkjoc3'), -- ZZ
(12,'2021-02-18 09:03:03.0', 'https://rar.com/', 'znkjoc3'), -- ZZ
(13,'2021-02-18 09:04:15.0', 'https://rar.com/', 'znkjoc3'); -- ZZ

-- -- XX - Added record > 1 minute from next or previous.
-- -- ** - Changed created_date to get groups within 180 seconds.
-- -- YY - Added record < 3 minutes from previous to give 4 records
-- -- ZZ - Added group of 4 records at the end.

It's always worth checking out for edge cases - single records at the beginning/end of your dataset + groups that you want to capture at the beginning and end also! I leave it to you to do more exhaustive testing!
I'll give the results first:
rn  st  sids                URL:                Session id: Session start time:            Session end time:
1   2   2,3,4,5             https://zes.com/    znkjoc      2021-01-18 11:02:24.00  2021-01-18 11:04:15.00
2   5   10,11,12,13         https://rar.com/    znkjoc3     2021-02-18 09:02:24.00  2021-02-18 09:04:15.00

There's a bonus - you've got the starts and ends of the multiple close-together sessions thrown in for free!
I do have one word of advice - you really shouldn't be using or gathering data as comma-separated lists - SQL wasn't designed for string manipulation and extracting meaningful information and knowledge from such lists is painful - better to have a single atomic datum in a single field - see 1st Normal Form!
I've left in the various "sub-fiddles" that I used to arrive at the final result - hopefully they'll help you to learn about window functions &c... My own preference for the results would be in this format (see the fiddle  - with one record/session - you can prune as you see fit):
sid created_date    st  min_cd  max_cd  f_ts    l_ts    c_ts_asc    c_ts_desc   o_url   c_sess_id
1   2021-01-18 10:30:24.00  1   2021-01-18 10:30:24.00  2021-01-18 10:30:24.00  1   1   1   1   https://zendes.com/ znkjoc3gfth2c3m0t1klii
2   2021-01-18 11:02:24.00  2   2021-01-18 11:02:24.00  2021-01-18 11:04:15.00  1   4   1   4   https://zes.com/    znkjoc
3   2021-01-18 11:02:35.00  2   2021-01-18 11:02:24.00  2021-01-18 11:04:15.00  2   3   2   3   https://zes.com/    znkjoc
4   2021-01-18 11:03:03.00  2   2021-01-18 11:02:24.00  2021-01-18 11:04:15.00  3   2   3   2   https://zes.com/    znkjoc
5   2021-01-18 11:04:15.00  2   2021-01-18 11:02:24.00  2021-01-18 11:04:15.00  4   1   4   1   https://zes.com/    znkjoc
6   2021-01-18 11:49:28.00  3   2021-01-18 11:49:28.00  2021-01-18 11:50:13.00  1   3   1   3   https://rararar.com/    znkjoc3gfth2c3m0t1klii
7   2021-01-18 11:49:48.00  3   2021-01-18 11:49:28.00  2021-01-18 11:50:13.00  2   2   2   2   https://rararar.com/    znkjoc3gfth2c3m0t1klii
8   2021-01-18 11:50:13.00  3   2021-01-18 11:49:28.00  2021-01-18 11:50:13.00  3   1   3   1   https://rararar.com/    znkjoc3gfth2c3m0t1klii
9   2021-01-18 12:57:24.00  4   2021-01-18 12:57:24.00  2021-01-18 12:57:24.00  1   1   1   1   https://zendes.com/ znkjoc3gfth2c3m0t1klii
10  2021-02-18 09:02:24.00  5   2021-02-18 09:02:24.00  2021-02-18 09:04:15.00  1   4   1   4   https://rar.com/    znkjoc3
11  2021-02-18 09:02:35.00  5   2021-02-18 09:02:24.00  2021-02-18 09:04:15.00  2   3   2   3   https://rar.com/    znkjoc3
12  2021-02-18 09:03:03.00  5   2021-02-18 09:02:24.00  2021-02-18 09:04:15.00  3   2   3   2   https://rar.com/    znkjoc3
13  2021-02-18 09:04:15.00  5   2021-02-18 09:02:24.00  2021-02-18 09:04:15.00  4   1   4   1   https://rar.com/    znkjoc3

Or another way might be (again, see the fiddle):
sid Session no. Start of sessions   End of sessions Session count   o_url   c_sess_id
2   2   2021-01-18 11:02:24.00  2021-01-18 11:04:15.00  4   https://zes.com/    znkjoc
10  5   2021-02-18 09:02:24.00  2021-02-18 09:04:15.00  4   https://rar.com/    znkjoc3

You have the starts and ends and the number of sessions... anyway, that's up to you. Take a look at this bit (easily missed):
MIN(created_date) OVER (PARTITION BY st ORDER BY created_date ASC) AS min_cd,
MAX(created_date) OVER (PARTITION BY st ORDER BY created_date DESC) AS max_cd,

This allows you to have an ASCending and a DESCedning list.
This means that you can then do this:
WHERE (v.f_ts + v.l_ts) >= 5

And the records where this  corresponds must be the ones of interest for the bunched sessions.
So now, the SQL, here it is (drum roll, trumpets sound in the distance...)! Go get a cup of coffee to read it - it's a monster (needs pruning - but that's an exercise for the OP and anybody else who's got this far):
SELECT
  ROW_NUMBER() OVER () AS rn,
  v.st,
  GROUP_CONCAT(v.sid SEPARATOR ',') as sids,
  o_url AS "URL:",
  c_sess_id AS "Session id:",
  min_cd AS "Session start time:",
  max_cd AS "Session end time:"
FROM
(
  SELECT
    sid,
    created_date, st,
    MIN(created_date) OVER (PARTITION BY st ORDER BY created_date ASC) AS min_cd,
    MAX(created_date) OVER (PARTITION BY st ORDER BY created_date DESC) AS max_cd,
    ROW_NUMBER() OVER (PARTITION BY st ORDER BY created_date ASC)  AS f_ts,
    ROW_NUMBER() OVER (PARTITION BY st ORDER BY created_date DESC) AS l_ts,
    COUNT(st) OVER (PARTITION BY st ORDER BY created_date ASC)  AS c_ts_asc,
    COUNT(st) OVER (PARTITION BY st ORDER BY created_date DESC) AS c_ts_desc,
    o_url,
    c_sess_id
  FROM
  (
    SELECT
      sid,
      created_date, YYY,
      SUM(testy) OVER (PARTITION BY testy ORDER BY created_date ASC) AS s,
      ROW_NUMBER()
        OVER (PARTITION BY testy ORDER BY created_date ASC) AS rn,
      SUM(testy) OVER y AS st,
      FIRST_VALUE(created_date) OVER (PARTITION BY testy ORDER BY created_date) AS fv,
      LAST_VALUE(created_date) OVER y AS lv,
      o_url,
      c_sess_id
    FROM
    (
      SELECT
        id AS sid,
        LAG(created_date, 1) OVER x AS lag_1,
        created_date,
        LEAD(created_date, 1) OVER x AS lead_1,

        UNIX_TIMESTAMP(LEAD(created_date, 1) OVER x) - UNIX_TIMESTAMP(created_date) AS XXX,

        UNIX_TIMESTAMP(created_date) - UNIX_TIMESTAMP(LAG(created_date, 1) OVER x) AS YYY,

        --
        -- The IMPORTANT one!
        --

        CASE
          WHEN (UNIX_TIMESTAMP(created_date) - UNIX_TIMESTAMP(LAG(created_date, 1) OVER x) > 180
          OR   UNIX_TIMESTAMP(created_date) - UNIX_TIMESTAMP(LAG(created_date, 1) OVER x) IS NULL)
          THEN 1
          ELSE 0
        END AS testy,

        FIRST_VALUE(created_date) OVER x AS f_val,

        UNIX_TIMESTAMP(created_date) - UNIX_TIMESTAMP(FIRST_VALUE(created_date) OVER x) AS c_f_diff,

        ABS(TIMESTAMPDIFF(MINUTE, created_date, LEAD(created_date, 1) OVER x)) AS min_diff,

        UNIX_TIMESTAMP(created_date) - UNIX_TIMESTAMP(LEAD(created_date, 1) OVER x) AS ut_d,

        origin_url AS o_url,
        client_session_id AS c_sess_id

      FROM test
      WINDOW x AS (PARTITION BY origin_url, client_session_id
                     ORDER BY created_date ASC, origin_url, client_session_id)
      ORDER BY created_date ASC
    ) AS t
    WINDOW y AS (ORDER BY created_date ASC ROWS BETWEEN UNBOUNDED PRECEDING
                                                    AND CURRENT ROW)
    ORDER BY created_date ASC
  ) AS u
  ORDER BY created_date ASC
) AS v
WHERE (v.f_ts + v.l_ts) >= 5
GROUP BY v.st, o_url, c_sess_id, min_cd, max_cd;

redpajama_set_name: RedPajamaStackExchange


text:
info@blaker.co.uk
Axle straightening
Plate rolling
Sandflo™ fluidised-bed separator
QUOTE OR ENQUIRY? EMAIL OUR TEAM
Over a hundred years of British engineering
Would you believe that Blaker has been in existence for well over 100 years?
Its earliest incarnation – Blaker Engineering Co. Ltd – was based in Islington, North London, and specialised in 'Motor Aero. and General Engineers'. Mr A.A. Blaker was responsible for the formation of The Hallé Spring Wheel Syndicate Ltd. which developed The Hallé Spring Wheel. This praised innovation won gold medal status at the Liége Universal Exhibition in 1905. On March 22nd, 1905, The Daily Mail wrote:
"The first is the Hallé Wheel, the principle is which of that of three parallel rulers bound together with parallel links, &c. The device is suitable for all kinds of motor work , and is, perhaps the most practical of all types of spring wheels that have been forthcoming so far."
The move to West Sussex
In the early 1930s the company purchased a blacksmith's shop and garage in Dial Post, West Sussex, as a new axle and chassis repair business. Changing its name to Blaker Specialist Welding Repairs Ltd. in 1935, the company grew steadily but really expanded towards the beginning of the second world war.
During the second world war, Blaker undertook a huge variety of essential war work. Click here to read more about our war effort.
The distinctive Blaker vans were seen all over the South of England on their travels doing mobile chassis repairs on site. By 1946 Blaker employed around 30 people from the local area and was the 'go-to' company for all machinery and vehicle repairs. 'Make do and Mend' was the national mantra.
A new workshop means bigger projects
A middle workshop was added to the premises in the early 1970s and was used for the repairs of large lorries / earth moving machinery and fabricating large pieces of equipment for the utility industry. As the vehicle preservation movement grew, Blaker became a reputable service for vintage restoration and repairs to historic vehicles.
A new premises in Billingshurst
Blaker became part of the Charles Muddle group of companies in July 2005 and moved to bigger premises in Billingshurst near Horsham, West Sussex.
We are proud of our heritage and keep up with many of the old traditions; supporting local suppliers, recruiting a local workforce and treating every job with the same level of importance. Whether it's repeat business with customers we've known for years, or the challenge of tackling unusual projects, including design and project management, we treat each job with the same level of care and attention.
We harbour a secret passion for repairing vintage and steam vehicles. With their superior build quality and masses of character, it's always a treat to see one of these beauties come into the workshop. Curious? See our case studies to see what we mean.
Pay us a visit to see our workshop in action. As well as enjoying good cup of tea and seeing the projects we have on, you'll notice the respect we have for our clients, our projects and each other. In common with those who worked in the original site back in the 1930s, we love what we do and always do our best.
What a project! We really enjoyed tracing the history of Blaker back to before 1900. Calling on the stories and memories of families of previous employees, it's been wonderfully enlightening to take a trip down memory lane and see how Blaker developed over time. Special thanks to Alan Davis.
For more information call or email our team: 01403 783634
Blaker Specialist Welding Repairs Ltd
Unit 1, The Yard
Adversane Lane
RH14 9EG
Registered office: The Yard, Adversane Lane, Billingshurst, West Sussex, RH14 9EG, UK.
Contact /Connect
Blaker is a Service Member of the BMRA
Looking for a quote? Or have a
question about our services?
© 2019. Blaker Specialist Welding Repairs Ltd
Anti Corruption

redpajama_set_name: RedPajamaCommonCrawl


Celebrate the start of the festive season on Redlands Coast with the lighting of Redland City's Christmas tree in Library Square, Cleveland on Friday, 30 November from 4-8pm.
This is a free family-friendly evening featuring live entertainment, roving performers, kids activities at the Redland Libraries Cleveland, land of course a visit from Santa himself! Have your photo taken with Santa before the lighting of the Christmas tree.


text:
Call &nbspQuotes
I stumbled into this format for 'Last Call with Carson Daly' that I really like, inspired by cable and Dave Attell's 'Insomniac.' I love being out on the street.
CallLast
I did 'Call of Duty Modern Warfare' as Gaz, then I did Ghost in 'Modern Warfare 2,' which has become one of the most iconic figures in the history of computer games.
CallGames
As he bent closer, he realized they were words — words his wife had carved into the cave ice with the last of her dying strength. As he read them, he felt them like three...
CallCallum-HuntKill
I'm terrified of missing my call time. I'll check my alarm several times before I fall asleep.
—J.D. Pardo
CallTimes
Hey, it's Col. I'm standing in a soybean field outside of Gutshot, Tennessee, which is a long story, and it's hot. K. I'm standing here sweating like I had hyperhidrosis, that disease where you sweat...
AbundanceCallDesperate
We want to do sweaters for dogs and call it 'Bark Jacobs.' If it works, great. If it doesn't, we'll drop it and do something different.
CallWorks
I had a white senator call me a rag head, and I had an African-American legislator call me a conservative with a tan.
CallHeadWhite
There's always been a separation between fashion and what I call my deeper work.
CallFashion
That which we call the Hindu religion is really the Eternal religion because it embraces all others.
CallOthers
Don't call me a mindless philosopher, you overweight glob of grease.
CallMindlessOverweight
I'm not what you'd call a Method actor.
CallMethod
The known propensity of a democracy is to licentiousness which the ambitious call, and the ignorant believe to be liberty.
—Fisher Ames
CallDemocracyLiberty
You have a direct line to Christ; He's waiting for your call". HS/el
—Evinda Lepins
CallDirectWaiting
I'm the guy to call. Look at the resume. I have kids of my own. I have dogs.
CallDogsGuy
Two days later I got a call that they wanted to try out the character for seven episodes. Eleven years and 22 Emmys later, Cliff was still sitting at that bar.
CallCharacterDays
Julius Caesar was an aristocrat who sided with the Roman people. He's not my hero, but he was one of a long line of what we'll call 'populares,' which were popular leaders who tried to...
CallFightingHero
All people who worship Allah, not each other, are equal before Him. We are entrusted to spread this message and to extend that call to all the people.
—Osama bin
AllahCallEach
Let's not call cancer patients as patients, they are cancer fighters. They are brave hearts.
—Vikrmn
BraveCallCancer
The Tax Code today is more complicated than ever, and the very people on the Republican side who denounce the Tax Code's complexity are the ones that put together what they now call a convoluted...
—Richard Neal
CallTodayTogether
I think legislation needs to put an end to doctors profiting on businesses to which they can funnel patients – that is business, not medicine. If you try to call it medicine, then it is...
CallCorruption
I think my message goes out to the entire spectrum of political parties. I'm supported by the Tea Party, the Conservative Party and the Republican Party. I come from a Democratic world. My world is...
CallPoliticalWhatever
I've always been a spontaneous singer. And all the stuff that you hear on the end of the songs, what they call the ad libs – that just comes out of my head. That's not...
CallHeadStuff
To finally get that call from the doctor that you're pregnant and you're having a baby…. It was just another world.
BabyCallDoctor
How could they call him wacko? He's sold more records than anybody in history.
AnybodyCall
They call them terrorists, I call them freedom fighters.
CallFighters
Normally, I'm the one fawning over the man, but in 'Call The Midwife,' I'm the experienced woman.
—Jessica Raine
CallNormallyWoman
I got a call to come in and meet Fox, and the rest is history.
CallRest
It is necessary to posit something which is necessary of itself, and has no cause of its necessity outside of itself but is the cause of necessity in other things. And all people call this...
CallItself
Would they call me a diva if I were a guy?
CallDivaGuy
I thought twenty was pretty scary, like, not being able to call myself a teenager anymore, and feeling like an adult – that kind of made me nervous.
—Adam Lamberg
CallFeelingPretty
It's a blessing to be given a variety of roles to what I call an iconic action actor like myself.
ActionCallGiven
My name, my real name, is Tracy. I always thought I was like a boy named Sue. So I made my friends call me 'Tray.'
CallFriendsName
I'd like to wade through all the people named Wade in this city, and personally call all of them to congratulate them on their fabulous name.
AbsurdCallCity
President George W. Bush is the first American president to call openly for two-states, Israel and Palestine, living side by side in peace and security.
—Lee H.
CallLiving
You can film me 24 hours a day and you'll get a very accurate picture of who I am. You see the funny side, I work hard, and I try to be honest and just...
Dover's cliffs call to mind the Roman invasion; the Battle of Britain; our proximity to, yet difference from, mainland Europe; and international trade and exploration, both fair and exploitative.
—Julian Baggini
BothCallMind
Risks are a measure of people. People who don't take them are trying to preserve what they have. Some risks have a future, and some people call them wrong. But being right may be like...
—Paul Arden
CallWrong
My eyes are wide open to the conflicts within the Church, but I don't think you can call it schism.
—Richard John
CallEyesWithin
'Really,' thought I, 'we call Baltimore the 'Monumental City' for its two marble columns, and here is Edinburg with one at every street-corner!'
CallCityHere
The people that call me to play on records call me because they think that I will suit their music. And the people whose music I suit are by and large people that I'm a...
—Benmont Tench
CallFan
I don't believe in God, though I'm not prepared to call myself an atheist either. You know the old phrase: 'There are no atheists in foxholes.' I've never been in a foxhole, and if I...
CallThough
A senator will come off Capitol Hill and they'll be barred from two years from lobbying in the Senate. So they'll pick the phone up and they'll call their buddy, the senator, their old buddies,...
CallHereLaw
I call it small government, grass-roots activism: The Tea Party activists are a part of it, FreedomWorks is part of it. FreedomWorks is the longest-standing, most active organization within this movement.
CallSmall
As he is one, so we call Him God, the Deity, the Divine Nature, and other names of the same signification.
—John Hales
I figure if I have my health, can pay the rent and I have my friends, I call it 'content.'
CallFriends
My nickname used to be Moses – still is Moses – for a long time, and people just call me Mo for short.
CallShort
What we now call the browser is whatever defines the web. What fits in the browser is the World Wide Web and a number of trivial standards to handle that so that the content comes.
—Ted Nelson
CallNumberWhatever
Call things by their right names – Glass of brandy and water! That is the current, but not the appropriate name; ask for a glass of liquid fire and distilled damnation.
CallFireWater
If I ever woke up with a dead hooker in my hotel room, Matt would be the first person I'd call.
CallDeadRoom
I come from a democratic world. My world is moderate Democrats, Reagan-type Democrats if you want, the blues or whatever you call them, the Blue Dogs. That's been my world, historically.
CallDogsWhatever
Copyright © 2017 - 2019 TR Marketing Group, Inc. All rights reserved.


text:
Blu Ray Home Theater with Wireless Rear Speakers: Panasonic SC-BT 100 and Samsung HT-BD 1250: What is the Best Blu Ray Home Theater System in a Box?
Home Theater Systems & Components, Electronics
Panasonic SC-BT 100 5.1 Home Theater System (3 out of 5)
Samsung HT-BD 1250 5.1 Home Theater System (4 out of 5)
Sony BDV E500W 5.1 Home Theater System (3 out of 5)
With many users complaining about the ugly cables running across the room in their home theater setups, manufacturers began to roll out products which do not include wires to the rear speakers. These products are complete sets, which have Blu Ray Players and 5.1 surround speakers, allowing the user to purchase one set as a complete solution for their home theater system.
Panasonic's SC-BT 100 set comes at $425 from Amazon.com, which is a budget rate for such a system. The rear speakers are light and easily mounted on the walls, whereas the front and center speakers are bigger. The subwoofer, unfortunately is a passive one, but it has a bamboo driver and delivers a very good sound. The set is compliant with Dolby TrueHD, Dolby Digital Plus, Dolby Digital, DTS HD Master Audio, DTS and Dolby Prologic II X decoders and the speakers are magnetically shielded, so you can expect a very clear overall sound output. The set is also compliant with BD-Video (Final Standard Profile), BD-MV (BD-RE Ver 3)/JPEG and BD-MV (BD-R Ver 2). And finally it has an iPod dock connection. If you already own a Panasonic TV set with Viera Link display, you will be happy to hear that SC-BT 100 supports the connection.
Here are the downsides: The system has its own proprietary connections, meaning that you will not be able to use any of your existing speakers/subwoofers by simply plugging them in unless you go for cable splicing. Second the passive subwoofer is not replaceable given that the proprietary wire is implanted in it plus there is no way of getting nonamplified subwoofer signals from the amplifier. Third, the connection types are very limited, there is only one TOSLINK/SPDIF output and one conventional component audio in.
The Panasonic Blu Ray Home Theater System, the SC-BT 100 is for users who want a simple solution. Unbox the set, connect as guided in the user manual, turn it on and do not consider modifications or new components for the system. Other than that, the system is excellent in both sound and display quality.
Samsung's Blu Ray Home Theater System, the HT-BD 1250 comes with similar specifications to Panasonic's SC-BT 100, at $450 from Amazon.com. Support for Dolby Digital Plus, DTS-HD decoder, Dolby TrueHD, Dolby Pro Logic II, Dolby Digital and DTS decoders are in-built. There is the iPod dock with video, audio and iPhone support. You will love to see that the system also has native USB support, which lets you copy your audio and video to a USB stick and effortlessly connect to your home theater system. The DVD upscaling feature is a real bonus. The system is wireless-ready, which means that with the optional purchase of a wireless dongle, which costs about $80 at Amazon.com, you can have wireless. The best thing for the U.S. users is the support for Pandora and Netflix out of the box. But remember that you will have to purchase the USB dongle. A note for the tech-savvy people here: you may get another wireless USB dongle working with the system, personally I haven't tried it, but I can safely say that Samsung's own WIS09ABGN dongle is configured in minutes without too much effort.
Here are the cons of this product: The Anynet+ capability, which is advertised as being able to control all home theater components with one remote, provides just basic capabilities to power on/off the system and volume/channel control. Do not expect to control more advanced features. Second, not all of the features of the iPod and iPhone are supported, for example the shuffle mode. Third, you cannot receive audio from both HDMI and the speakers. You have to choose one. Fourth, and maybe the most important, the connections are proprietary, meaning that you will not be able to add additional components to your system. Fifth, the connections are severely limited: no composite, no component, and no headphone connections are available.
Samsung's HT-BD 1250 is not an all-in-one solution. You will at least have to purchase an HDMI cable and one optical audio cable to get the system working. To run the system perfectly, you will need Samsung's dongle (to receive streaming video from the Internet) and one universal remote to cover what Anynet+ cannot. If these problems do not bother you and the system provides a total match for your needs, then we can safely say that the set is a good investment.
Sony's BDV E500W is the most expensive product on our list, coming in at $625 from Amazon.com. The decoder on the unit supports DTS-HD, DTS-HD MA, Dolby Digital Plus and TrueHD high-definition surround sound formats. The system also supports an iPod dock. This is the only player in our comparison that has BD Live support. The setup is easy with the on-screen instructions and you will be happy to hear that there is a microphone included which will start the automatic speaker calibration. No worries, after finishing the automatic calibration, you can tweak the results manually. Compared to the other systems in our review, Sony lets you connect up to three additional components to the system: TV, Satellite/Cable and one audio. The ports are two analog and two digital (one optical and one coaxial to be precise). Sony showed its brand quality in this product and it also has the DVD upscaling feature. Very well done. The rear speakers work as they should and there is no noise.
The downsides of the product are first, its higher price. Second, it has no support for streaming content from the Internet, such as Pandora, Netflix, Amazon Video on Demand etc.. This is very surprising because Sony's Bravia Internet Video Link already has support for the streaming content; how come this excellent system doesn't? I am really shocked.
Sony's BDV E500W is a very good choice for your Blu Ray home theater system if you don't care about streaming movies. If you are considering purchasing a Blu Ray home theater system in the near future, consider Sony's BDV E500W seriously.
It is obvious that you still have questions about which of these three products are the best. This changes depending on your requirements. Streaming video or not? Proprietary connections or the ability to connect more components? One-stop solution or expandable set? You have to evaluate all these and make your purchase accordingly.
What would I do in this scenario? Without any question, I would wait for Sony to roll out a product that has streaming video support and Bravia connection. When this product hits the shelves, I would go for a purchase, thinking less about my budget and more about the quality on offer.
electronics/home-theater/topics/entertainment-centers
Blu-ray Camcorders
Why You Should Buy a PS3
Hard Disk Multimedia Review
Can I Watch TV on My Computer With a Cable Modem?
Solid State Drives for Music Servers: The Intel X25-M & Transcend TS32GSSD25-M
What are the Best LCD Projectors for Home Viewing
Building a Home Theater


While Tammy and Acacia were taking a nap, I decided to sneak off to the shop and get some work done on the airplane. Since the trailing edge of the rudder was completed a few days ago, its time to finish it up, and that means bending the leading edge and threading in the mounting hardware. I started off by bending the leading edges, which is done exactly like the elevators in previous posts. I used Gorilla tape on the leading edges, and then a piece of wooden dowel rod as a rolling pin to roll the edges gently into a nice curved shape.
Once both sides have been rolled I had to finish the bends by hand to make sure the skins are lining up with the pre-punched holes, and to make the leading edge bend nice and neat and smooth. This is not a gentle process, and takes a lot of work to get the metal where I wanted it, but ultimately I got the bends to where I was happy. Then I used 3/32″ clecos in the #40 holes to hold the bends while I match drilled everything to a #30 hole for the AD-41-ABS blind rivets. As I drilled the holes, I replaced it with the larger 1/8″ cleco.
Once I had all the holes match drilled, It was time to deburr the holes. Since this part is hard to get to, I used a scotchbrite pad on all the surfaces I couldn't reach with my deburring tool and made sure they felt nice and smooth with my fingers before moving on. Once the holes were deburred, I clecoed it all back together using 1/8″ clecos and started the blind riveting process, one hole at a time. These came out looking pretty good!
I decided to go ahead and thread the eye bolts into the mount holes of the rudder and get them roughly into position. I picked through my hardware bags until I found the proper eye bolts, and their jam nuts, then I coated the threads with a good helping of Boelube to help with the platenuts. I threaded them all in, and got them to roughly where they need to be per the plans as far as depth. I will temporarily mount the rudder to the vertical stabilizer in a few days to do the final alignment of the eye bolts, and then tighten the jam nuts fully to set their position. I am happy with how the rudder came out!
Tagged Rudder, Leading Edge. Bookmark the permalink.


text:
using System;
using System.IO;
using System.Windows;
using System.Windows.Controls;
using AntYecai.Types;
using AntYecai.ViewModels;
using Microsoft.Win32;

namespace AntYecai.Views
{
    /// <summary>
    /// RegisterView.xaml 的交互逻辑
    /// </summary>
    public partial class RegisterView : UserControl
    {
        public event Action Cancel;
        public event Action Register;
        private RegisterViewModel RegisterViewModel { get; set; }

        public RegisterView()
        {
            InitializeComponent();
        }

        public void InitDataContext(RegisterViewModel registerViewModel)
        {
            RegisterViewModel = registerViewModel;
            this.DataContext = RegisterViewModel;

            radioButtonGenderSecret.IsChecked = true;
        }

        public void StartToDisplay()
        {
            RegisterViewModel.Clear();
            password.Password = repeatPassword.Password = String.Empty;
            loginNameError.Text = passwordError.Text = relatedUserIdError.Text = String.Empty;
        }

        private void Cancel_OnClick(object sender, RoutedEventArgs e)
        {
            if (Cancel !=  null)
            {
                Cancel();
            }
        }

        private void password_PasswordChanged(object sender, RoutedEventArgs e)
        {
            RegisterViewModel.Password = password.Password;
            ValidatePassword();
        }

        private void repeatPassword_PasswordChanged(object sender, RoutedEventArgs e)
        {
            RegisterViewModel.RepeatPassword = repeatPassword.Password;
            ValidatePassword();
        }

        private void register_Click(object sender, RoutedEventArgs e)
        {
            ValidateLoginName();
            ValidatePassword();
            ValidateRelatedUserId();

            String message;
            if (!RegisterViewModel.TryValidateLoginName(out message))
            {
                return;
            }

            if (!RegisterViewModel.TryValidatePassword(out message))
            {
                return;
            }

            if (!RegisterViewModel.TryValidateRelatedUserId(out message))
            {
                return;
            }

            if (Register != null)
            {
                Register();
            }
        }

        private void loginName_TextChanged(object sender, TextChangedEventArgs e)
        {
            ValidateLoginName();
        }

        private void textBoxRelatedUserId_TextChanged(object sender, TextChangedEventArgs e)
        {
            ValidateRelatedUserId();
        }

        private void ValidateLoginName()
        {
            loginNameError.Text = String.Empty;
            String message;
            if (!RegisterViewModel.TryValidateLoginName(out message))
            {
                loginNameError.Text = message;
            }
        }

        private void ValidatePassword()
        {
            passwordError.Text = String.Empty;
            String message;
            if (!RegisterViewModel.TryValidatePassword(out message))
            {
                passwordError.Text = message;
            }
        }

        private void ValidateRelatedUserId()
        {
            relatedUserIdError.Text = String.Empty;
            String message;
            if (!RegisterViewModel.TryValidateRelatedUserId(out message))
            {
                relatedUserIdError.Text = message;
            }
        }

        private void browserUser_Click(object sender, RoutedEventArgs e)
        {
            OpenFileDialog openFileDialog = new OpenFileDialog()
                {
                    Filter = string.Format("user.dat({0})|{0}|所有文件(*.*)|*.*", string.Join(";", new String[] {"*.dat"}))
                };
            openFileDialog.ShowDialog();
            string userDataFilePath = openFileDialog.FileName;
            if (File.Exists(userDataFilePath))
            {
                String userId = LoadUserData(userDataFilePath);
                RegisterViewModel.RelatedUserId = userId;
                ValidateRelatedUserId();
            }
        }

        private String LoadUserData(String userDataFilePath)
        {
            using (TextReader reader = new StreamReader(userDataFilePath))
            {
                return reader.ReadLine();
            }
        }

        private void buttonClearUserId_Click(object sender, RoutedEventArgs e)
        {
            RegisterViewModel.RelatedUserId = String.Empty;
            ValidateRelatedUserId();
        }

        private void genderSecret_Checked(object sender, RoutedEventArgs e)
        {
            RegisterViewModel.Gender = Gender.Unknown.ToString();
        }

        private void genderMale_Checked(object sender, RoutedEventArgs e)
        {
            RegisterViewModel.Gender = Gender.Male.ToString();
        }

        private void genderFemale_Checked(object sender, RoutedEventArgs e)
        {
            RegisterViewModel.Gender = Gender.Female.ToString();
        }
    }
}


text:
Piperton é uma cidade localizada no estado norte-americano de Tennessee, no Condado de Fayette.

Demografia
Segundo o censo norte-americano de 2000, a sua população era de 589 habitantes.
Em 2006, foi estimada uma população de 959, um aumento de 370 (62.8%).

Geografia
De acordo com o United States Census Bureau tem uma área de
25,4 km², dos quais 25,3 km² cobertos por terra e 0,1 km² cobertos por água.

Localidades na vizinhança
O diagrama seguinte representa as localidades num raio de 20 km ao redor de Piperton.

Ligações externas

Cidades do Tennessee

redpajama_set_name: RedPajamaWikipedia


IOTAP wins the Microsoft Oman Partner of the Year for demonstrating superior technical ability and innovation in the deployment of market-leading Microsoft-based solutions. The award recognizes IOTAP's innovative use of Microsoft technology to exceed customer expectations and solve business problems.
Muscat, Oman, August 05, 2013, 6:13 am -- /EPR NETWORK/ -- IOTAP today proudly announced it has won the 2013 Microsoft Country Partner of the Year Award for Oman. The company was honored among a global field of top Microsoft partners for demonstrating excellence in innovation and implementation of customer solutions based on Microsoft technology.
�We are proud that IOTAP has been honored with Microsoft Country Partner of the Year award for Oman in recognition of our ability to deliver successful results for clients on the Microsoft platform. Our solutions are cloud-ready! Unlike traditional partners we don't just sell Microsoft products but offer packaged solutions on Office 365, SharePoint and Dynamics CRM that are cost effective, easy to deploy and maintain , says Mr. Ebrahim Nalwala, Managing Director of IOTAP. �I am very thankful to our customers, Microsoft Oman and our team in helping us achieve this. IOTAP is looking forward to another year of helping customers save money, improve productivity and achieve key business goals�.
Awards were presented in multiple categories, with winners chosen from a set of more than 3,000 entrants from 106 different countries worldwide. IOTAP was recognized for providing outstanding solutions and services, as well as demonstrating excellent subsidiary engagement in Oman. The Microsoft Country Partner of the Year Awards honor partners at the country level that have demonstrated business excellence in delivering Microsoft solutions to multiple customers over the past year. This award recognizes IOTAP as succeeding in effective engagement with its local Microsoft office while showcasing innovation and business impact, driving customer satisfaction and winning new customers.
IOTAP provides IT Consulting and Software Services to enable companies to effectively Connect, Communicate and Collaborate with their internal as well as external customers and peer-groups. IOTAP is a Microsoft Gold Certified partner, and provides full life-cycle solutions for implementation of CRM, Collaboration solutions, Web Content Management Systems (internet, intranet and extranet) and Custom Application Development projects. The company provides services and consulting for technologies like SharePoint, Dynamics CRM, and Office 365. We have offices in Washington DC (US), Milton Keynes (UK), Muscat (Oman), Mumbai (India) and Chennai (India) and provide on-site as well as offshore support globally. For more information, please visit www.iotap.com or write to us at marketing@iotap.com.


A recently completed analysis of natural hazards that could impact the University of Mississippi, led by the Mississippi Mineral Resources Institute (MMRI), has developed hazard profiles to help guide UM to cost effective ways of reducing the vulnerability and mitigating the hazards. Tornadoes are one of the top three hazards of concern.
Tornados are considered a natural hazard that consistently ranks as one of the top three concerns of the University of Mississippi. These violent winds rotating around a central vortex are capable of wind speeds in excess of 300 miles per hour and can produce incredible amounts of damage. There were significant and noteworthy tornado events in 2011 that changed the way engineers think of tornados, the type damage they cause and potential ways to mitigate tornado damage. In particular, the tornado that devastated the town of Smithville, Mississippi, and the tornado that tracked through Tuscaloosa, Alabama. The devastation caused by both events caused engineers and emergency managers to review their procedures and allowed new information to be developed on what a tornado swath looks like as far as wind speed and the variable damage it causes the built environment. The Tuscaloosa event was significant not only because of densely populated urban area it affected, but also because it very nearly tracked across the University of Alabama campus.
Since 1952, at least 22 tornados have tracked through Lafayette County. Some of these tornados have ranked as high as F-3 on the Fujita Scale (EF) or approximately an EF-4 on the Enhanced Fujita Scale (EF) with wind speeds as high as 200 miles per hour. Tornado occurrence is not uniformly distributed throughout the year. Figure 1 is the frequency of tornado occurrence in Lafayette County throughout the year since 1950. It is evident that most tornados occur between February and May. Neither do tornados occur uniformly across any geographic area. This uneven geographic distribution of tornado occurrence is evident in scales varying from a nation-wide to local. While the midwestern U.S. is known as a tornado alley, Mississippi is equally vulnerable, only less well known, and the tornados are more difficult to see and analyze. Tornado distribution in Lafayette and adjoining counties also illustrate "tornado allies" on a local scale. Figure 2 illustrates that Oxford and the University of Mississippi are in an area of medium tornado vulnerability. Averaging 62 years of tornado occurrence, Lafayette County has approximately a 30 percent chance of a tornado occurring any given year. Within this period, five tornadoes have been EF-5 tornados, suggesting these destructive tornado events occur approximately once every 12 years. All of these data suggest that Lafayette County, Oxford, and the University of Mississippi have significant vulnerability to the tornado hazard.
The University of Mississippi, like the University of Alabama, has also had tornados track near the main campus. A well-documented tornado is the February 21, 1971; Mobile City tornado that tracked just to the north of campus resulted in an estimated $500,000 in damage (in 1971 dollars). The most recent example is the EF-3, College Hill Station tornado that occurred on February 5, 2008, and tracked through the Oxford Industrial Park. This tornado caused an estimated $35,000,000 in damage. The Ability Works building (Figure 3) was totally destroyed by the tornado and numerous other buildings and industrial park structures were heavily damaged.
The MMRI has estimated tornado losses on campus based on a theoretical EF-4 tornado event. The evaluations consider the tornado event, type of construction and date of construction, and the value of the structure and the building contents. The campus structures were classed as: 1) Critical, 2) High Priority, 3) Medium Priority, or 4) Low priority. In the Critical class of structures, the Lyceum was likely to sustain the highest dollar loss (due to its age) and in the High Priority Class, the J.D. Williams Library was likely to sustain the highest dollar loss due to the value of the building and its contents.
The study of the University's vulnerability to natural hazards and the potential loss due to them is a MMRI project that will result in an update of the University's Natural Hazard Mitigation Plan. The existing plan is available on the MMRI website and the updated plan will also be posted online. Check back for updates.


text:
Der Dezember ist der zwölfte und letzte Monat des Jahres des gregorianischen Kalenders und hat 31 Tage.

Geschichte
Im römischen Kalender war der December der zehnte Monat ( = zehn) des 354-tägigen Mondkalenders. Im Jahr 153 v. Chr. wurde der Jahresbeginn um zwei Monate vorverlegt, sodass die direkte Beziehung zwischen Namen und Monatszählung verloren ging. Dies wird manchmal bei der Übertragung früher verwendeter lateinischer Datumsangaben faktisch übersehen. Unter Kaiser Commodus wurde der Monat in Exsuperatorius umbenannt, nach dem Tod des Kaisers erhielt er allerdings wieder seinen alten Namen zurück.

Am 21. oder 22. Dezember ist der Tag der Sonnenwende. Die Sonne steht genau über dem Wendekreis des Steinbocks am südlichen Breitengrad von 23° 26,3′. Dieser Tag ist auf der Nordhalbkugel der kürzeste im Jahr, die Nacht ist die längste, auf der Südhalbkugel ist es umgekehrt.

Ein alter deutscher Name des Dezembers ist Julmond. Der Name kommt vom Julfest, der germanischen Feier der Wintersonnenwende.
Andere Namen für Dezember sind Christmonat, da Weihnachten – das Christfest – im Dezember gefeiert wird, oder auch Heilmond, da "Christus das Heil bringt". Letztere Namen kamen erst nach der Umwidmung des Julfestes im Zuge der Christianisierung auf.

Das christliche Kirchenjahr beginnt abweichend von der normalen Kalenderzählung mit dem ersten Adventsonntag. Dieser kann Ende November oder Anfang Dezember sein, je nachdem, auf welchen Wochentag Weihnachten fällt.

Der Dezember beginnt immer mit demselben Wochentag wie der September.

Die Tage zwischen Weihnachten und Neujahr werden umgangssprachlich oft als "zwischen den Jahren" bezeichnet.

Ist der 29., 30. oder 31. Dezember ein Montag, werden die Tage ab Montag der ersten Kalenderwoche des Folgejahres zugerechnet. In diesem Fall endet die letzte Kalenderwoche des Jahres nach der DIN-Norm mit dem letzten Sonntag des Dezembers. Ein solches Jahr hat dann immer 52 Kalenderwochen.

Gedichte
 Dezember Gedichte, ausgewählt von Evelyne Polt-Heinzl und Christine Schmidjell, Reclams Universal-Bibliothek Nr. 19122, Philipp Reclam jun. GmbH & Co. KG, Stuttgart 2013, ISBN 978-3-15-019122-4

Galerie

Siehe auch
 Liste von Gedenk- und Aktionstagen#Dezember
 Liste von Bauernregeln#Dezember

Weblinks

 Dezember (VfcG)

Einzelnachweise

Monat des gregorianischen und julianischen Kalenders


Ningbo Sine Magnetic Company Limited manufacture motor magnets including sintered & bonded neodymium magnets , ferrite & ceramic magnets, alnico magnets, samarium cobalt magnets (smco) which can be used as rotor or stator in different permanent magnet motors such as electric motors,Synchronous motor,Servo Motor, PM motors, AC motors, DC motors, Linear motors, Stepping motors, Brushless motors, etc.
The most widely used magnetic material for motors are sintered neodymium material and SmCo magnets material. Sintered neodymium magnet features great magnetic strength which can bring large torque for rotors and stators. Among sintered NdFeB grades, the H, SH, EH and UH series are popular in that they can withstand working temperature up to 100-200 degree C without losing magnetism.
However, as a considerable amount of motor types are to work under higher temperatures, SmCo magnet is preferred for its comparable magnetic strength with sintered neodymium N35 grade and its max working temperature which can be up to 250-300 degree C.
The application of bonded neodymium material in motors is wide spread too for its great flexibility of producible shapes and magnetization orientations. For example, we produced and magnetized a diameter 30mm ring shape bonded NdFeB magnet into 16 poles and 32 poles through diameter, which is not achievable for any other sintered permanent magnetic material.
If specified by customers, China Rare Earth Magnet Limited can customize ferrite, alnico and other permanent magnets for the application in motors.
Shapes and magnetization orientations of motor magnets: Ring shapes and arc segments magnetized through diameter are most common for motor magnets. According to specific demands and drawings from customers, China Rare Earth Magnet Limited can supply a variety shape of motor magnets including block, disc, wedge and heteromorphic shapes.
Coating: NiCuNi, Zn, Epoxy, Phosphate, Passivate and others.


text:
Ю́ки И́то (, 10 мая 1994 года, Симокава, Хоккайдо) — японская прыгунья с трамплина, двукратный серебряный призёр чемпионата мира в личном первенстве (2015 и 2017).

Спортивная карьера
Лучшими результатами Юки Ито являются победа в командных смешанных соревнованиях на чемпионате мира 2013 года в Валь-ди-Фьемме и серебряная медаль в личном первенстве на нормальном трамплине на чемпионате мира 2015 года в Фалуне. Через два года на чемпионате мира 2017 года в Лахти японка повторила свой лучший результат и стала двукратной вице-чемпионкой в личном первенстве. Участвовала в Олимпийских играх 2014 года в Сочи, где заняла 7 место.

Примечания

Ссылки

Прыгуны с трамплина Японии
Прыгуны с трамплина на зимних Олимпийских играх 2014 года
Прыгуны с трамплина на зимних Олимпийских играх 2018 года
Прыгуны с трамплина на зимних Олимпийских играх 2022 года


text:
toggle menu Menu Close
People Services News & Perspectives Offices People Services News & Perspectives Offices About Careers
News Publications and Presentations Blogs Upcoming Events Featured Topics Media Mentions
CFPB and DOJ Penalize Nonbank Lender for Discriminatory Mortgage Pricing
Arnold & Porter Advisory
By Michael B. Mierzewski Michael A. Mancusi Christopher L. Allen Kevin M. Toomey Anthony Raglani
On May 28, 2015, the Consumer Financial Protection Bureau (CFPB) and the Department of Justice (DOJ) (together, the Agencies) filed a joint complaint against Provident Funding Associates, L.P., a nonbank wholesale mortgage lender (Provident), for violations of the Equal Credit Opportunity Act, the Fair Housing Act (FHA), and their implementing regulations (collectively, the Fair Lending Laws) arising from alleged discriminatory mortgage pricing. Provident and the Agencies agreed to a proposed consent order that, subject to court approval, would require Provident to pay US$9 million in damages to affected minority borrowers and improve its fair lending training and broker monitoring programs. This joint action is the latest demonstration of federal regulators' coordination to penalize lenders exercising pricing discretion in violation of the Fair Lending Laws.
The Agencies' action is the culmination of an investigation commenced by the Federal Trade Commission in 2009, which was referred to the DOJ in 2011, and joined by the CFPB in 2012. The Agencies' complaint focuses on Provident's policies and practices for pricing mortgage loans and compensating brokers, alleging that, during the period of the investigation, Provident established a risk-based "par interest rate" for each loan applicant based on specified, objective credit characteristics. However, Provident then provided its brokers the discretion to establish a higher interest rate and set the amount of fees based on "subjective, unguided" criteria unrelated to the applicant's objective risk-based criteria or the terms of the proposed loan agreement. The complaint also alleges that Provident did not require its brokers to document their rationale for setting interest rates in excess of the par rate, nor did it monitor the assessment of broker fees, to determine whether such rates and fees were justified or varied significantly based on unlawful factors, such as race or national origin.
The complaint states that the Agencies' investigation revealed statistically significant disparities between the total broker fees (referring here to the combination of an excess interest rate, if applicable, and higher direct fees) charged to African-American and Hispanic borrowers relative to those charged to white borrowers.1 The complaint states that the higher interest rates and direct fees charged to minority borrowers "cannot be fully explained" based on creditworthiness or other objective factors related to borrower risk, and have not been justified by "the necessity to achieve one or more substantial, legitimate, nondiscriminatory business interests or a legitimate business need." Moreover, the Agencies alleged that Provident's policies and practices, in effect, led to discrimination against protected classes of persons and constituted violations under the Fair Lending Laws.
Although the precise theory of discrimination is not revealed in documents available to the public, it is likely that the Agencies' relied on the theory of "disparate impact." Under disparate impact theory, the government is required to demonstrate only that a lender's policy or practice has a disproportionate adverse impact on a class of persons protected by the Fair Lending Laws. Although various federal banking and consumer agencies have reaffirmed the use of disparate impact theory to bring claims of discrimination under the Fair Lending Laws, the continued viability of this theory in the fair lending context is uncertain.
Use of disparate impact theory under the Fair Lending Laws has been challenged in federal court on numerous occasions, most recently in the District Court for the District of Columbia, where the court vacated the Department of Housing and Urban Development's 2013 disparate impact rule (the Disparate Impact Rule), which formalized recognition of discriminatory effects liability under the FHA. The court held that the FHA allows only for disparate treatment liability (i.e., intentional discrimination), not disparate impact liability (i.e., facially neutral practices with discriminatory effects), and that the Disparate Impact Rule was "yet another example of an Administrative Agency trying to desperately write into law that which Congress never intended to sanction." In addition, a decision by the U S Supreme Court on the use of disparate impact theory under the FHA is pending and could further limit its use as a tool for the enforcement of the Fair Lending Laws.
As the financial services industry awaits the Supreme Court's decision, financial institutions and mortgage lenders should critically review their lending policies and procedures to determine whether discretionary, and potentially discriminatory, pricing is allowed. The Agencies, along with the federal banking agencies, have consistently demonstrated that financial institutions that allow for discretionary pricing without adequate, written justifications are ripe for remedial enforcement action.
*Anthony Raglani also contributed to this advisory. He is a graduate of The George Washington University School of Law employed at Arnold & Porter LLP. Mr. Raglani is not admitted to the bar.
The complaint states that, during the relevant time period, as compared to the total broker fees charged to white borrowers, African-American borrowers paid an average of $858 more in total broker fees for a loan of $220,000, while Hispanic borrowers paid an average of $615 more in broker fees for a loan of $246,000. The Agencies found these discrepancies to be statistically significant, meaning that there was a high likelihood that the discrepancies did not occur by chance.
Download Article (PDF)
Find more content tagged:
Financial Services Consumer Protection
Stay up-to-date with the latest topics from the firm.
Email Subscriptions RSS Feed (All Perspectives) RSS Feed (News Only)
Michael B. Mierzewski
michael.mierzewski@arnoldporter.com
Michael A. Mancusi
michael.mancusi@arnoldporter.com
Christopher L. Allen
christopher.allen@arnoldporter.com
Kevin M. Toomey
kevin.toomey@arnoldporter.com
Anthony Raglani
anthony.raglani@arnoldporter.com
NYDFS Requiring Submission of LIBOR Transition Plans by February 7
FDIC Proposal Offers Welcome Clarity On Brokered Deposits
Asset Management Law360, Banking Law360, Capital Markets Law360, Compliance Law360, Fintech Law360, Public Policy Law360, Securities Law360
FDIC Issues Proposed Rule on Brokered Deposits
Statement of Client's Rights
Employment Tribunal and Immigration Fees
SRA DIGITAL BADGE
LLP Status and Disclaimer
© Arnold & Porter Kaye Scholer LLP 2020 All Rights Reserved.
This site uses cookies to enhance functionality and performance. You may change your cookie settings at any time. If you do nothing, you are giving implied consent to the use of cookies on this website.