text:
Q: WordPress - order by meta value if it exists, else date I'm trying to allow my users to sort search results by different custom fields I have.
I'm using the pre_get_posts filter and everything works fine except for one thing.
The problem I'm having is that when a custom field is used to sort by, only the posts that have that custom field set will show up in the search.
Obviously this is not acceptable as the number of search result changes when the user changes how to sort them.
What I want instead is that the posts that have the custom field show up first, in order, and then the rest of the posts show up sorted on date.
Here's the relevant code I have:
<?php
add_filter('pre_get_posts', 'h5b_search_pre_get_posts');

function h5b_search_pre_get_posts ($qry) {
    $validOrders    = array('price', 'date', 'popularity');
    $orderBy        = (isset($_GET['myorder']) and in_array($_GET['myorder'], $validOrders)) ? $_GET['myorder'] : 'price';

    if ($qry->is_main_query() and $qry->query_vars['s'] != '') {
        # This only includes the posts that have "item_price" set
        if ($orderBy == 'price') {
            $qry->set('orderby', 'meta_value_num date');
            $qry->set('order', 'ASC DESC');
            $qry->set('meta_key', 'item_price');
        }
        # This works fine and includes all posts (obviously)
        elseif ($orderBy == 'date') {
            $qry->set('orderby', 'date');
            $qry->set('order', 'DESC');
        }
    }
}

Edit: Here's what the actual MySQL Query looks like. How can I change this so that it sorts on wp_postmeta.meta_value if it exists - if not, sort on date?
SELECT
    SQL_CALC_FOUND_ROWS wp_posts.ID
FROM
    wp_posts
INNER JOIN
    wp_postmeta
ON
    (wp_posts.ID = wp_postmeta.post_id)
WHERE
    1=1 AND
    ((
        (wp_posts.post_title LIKE '%lorem%') OR
        (wp_posts.post_content LIKE '%lorem%')
    )) AND
    wp_posts.post_type IN ('post', 'page', 'attachment', 'items', 'locations') AND
    (wp_posts.post_status = 'publish' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private') AND
    (wp_postmeta.meta_key = 'item_price' )
GROUP BY
    wp_posts.ID
ORDER BY
    wp_postmeta.meta_value+0,wp_posts.post_date DESC LIMIT 0, 6

Preferably I'd solve it using the WP_Query methods but if I have to I might consider running my own SQL.
Edit2: I have a feeling I need to use something like IF NOT NULL - how would you do that with WP_Query? Is it even possible?
Edit (again): Here's the same question (I think :P): https://wordpress.stackexchange.com/questions/28409/way-to-include-posts-both-with-without-certain-meta-key-in-args-for-wp-query

A: Problem here is not that data is not sorted by date column, problem is that there is no data with empty meta_value returned.
The reason why you do not see entries with no meta specified, is that it may be filtered out by INNER JOIN for those cases, where wp_postmeta.post_id is null. Change join to be LEFT OUTER JOIN.
SELECT
    SQL_CALC_FOUND_ROWS wp_posts.ID
FROM
    wp_posts

LEFT OUTER JOIN

    wp_postmeta
ON
    (wp_posts.ID = wp_postmeta.post_id)
WHERE
    1=1 AND
    ((
        (wp_posts.post_title LIKE '%lorem%') OR
        (wp_posts.post_content LIKE '%lorem%')
    )) AND
    wp_posts.post_type IN ('post', 'page', 'attachment', 'items', 'locations') AND
    (wp_posts.post_status = 'publish' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private') AND
    (wp_postmeta.meta_key = 'item_price'  OR wp_postmeta.meta_key is NULL )
GROUP BY
    wp_posts.ID
ORDER BY
    wp_postmeta.meta_value+0,wp_posts.post_date DESC LIMIT 0, 6

UPDATE
To change join type in WP_Query use $join property to set posts_join filter as described in Plugin API/Filter Reference/posts join
See also WP_Query Class reference.

A: It's not going to be pretty (or optimized), but I think you can use an IF or CASE here:
ORDER BY
CASE wp_postmeta.meta_value WHEN IS NOT NULL THEN wp_postmeta.meta_value END ASC,
CASE wp_postmeta.meta_value WHEN IS NULL THEN wp_posts.post_date END DESC

Note: I haven't tried this out myself, so there might be a syntax error, but it should work in theory
Further reading:
Can you add an if statement in ORDER BY?

A: I know, this thread is around 6 months old already, but it seems there never was a sufficient answer. I was just running into the exactly same problem as the original author of the problem. So this is my final SQL query I found to work and return the desired result:
SELECT SQL_CALC_FOUND_ROWS *
FROM wp_posts
INNER JOIN wp_term_relationships ON (wp_posts.ID = wp_term_relationships.object_id)
LEFT JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id AND mt1.meta_key = 'showPostInBanner' AND mt1.meta_value='1')
LEFT JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id)
WHERE 1=1 AND ( wp_term_relationships.term_taxonomy_id IN (34,47,51,50,68,78,82,90,97,155,227,253,285,294,314,373,425,436,452,456,521,627,667,680,694,710,730,741,751) )
AND wp_posts.post_type = 'post' AND (wp_posts.post_status = 'publish' OR wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY mt1.meta_value+0 DESC, wp_posts.post_date DESC LIMIT 0, 4

Based on this (my query was trying to get a slightly different result) your query should look like this to make it work (if I didn't include any new errors - but my query definitely works now):
SELECT SQL_CALC_FOUND_ROWS *
FROM wp_posts
LEFT JOIN wp_postmeta AS mt1 ON (wp_posts.ID = mt1.post_id AND mt1.meta_key = 'showPostInBanner' AND mt1.meta_value='1')
LEFT JOIN wp_postmeta AS mt2 ON (wp_posts.ID = mt2.post_id)
WHERE 1=1 AND ((
        (wp_posts.post_title LIKE '%lorem%') OR
        (wp_posts.post_content LIKE '%lorem%')
    )) AND
AND wp_posts.post_type IN ('post', 'page', 'attachment', 'items', 'locations') AND
    (wp_posts.post_status = 'publish' OR wp_posts.post_author = 1 AND wp_posts.post_status = 'private')
GROUP BY wp_posts.ID
ORDER BY mt1.meta_value+0 DESC, wp_posts.post_date DESC LIMIT 0, 6

A: For Edit2:
Yes it is possible using meta_query. Try
'meta_query' => array(
    array(
                        'key' => 'meta_key',
                        'value' => 'some value', //try to put null here
                        'compare' => '!='
                        )
    ),

A: I think i have a solution..
use two meta_key, one that all posts have (like "_thumbnail_id"),
and the meta_key you wish use as filter..
 so your args:
$qry->set(
'meta_query',
 array(
 'relation' => 'OR',
 array( 'key' => 'item_price', 'value' => '', 'compare' => 'EXISTS' ),
 array( 'key' => '_thumbnail_id', 'value' => '', 'compare' => 'EXISTS' )
 ));

$qry->set('orderby', 'meta_value date');
$qry->set('order', 'ASC DESC');
$qry->set('meta_key', 'item_price');


Lexus Ireland has announced Irish prices for its first-ever seven-seater, the three-row RX 450hL. The new model, revealed at the Detroit motor show earlier this year, gets a 110mm stretch to accommodate the extra row of seats, while the rear styling is also much more upright and a little taller, so as to give those sitting there a little more space.
The centre row of seats now also slides, by up to 150mm, and if you go for the Premium model, they're heated, too.
The price for all of this? Some €82,450 for the Luxury model, or €92,550 for a Premium version. What's the difference? A Luxury RX 450hL comes with 20-inch wheels, parking sensors, power tailgate, the Lexus Safety System (which incorporates autonomous emergency braking), electric adjustment for the steering wheel, three-zone climate control, leather upholstery, electric adjustment for the front seats (eight-way), heated and ventilated front seats, electro-chrome mirrors, 'Lexus Premium' navigation, 12-speaker Pioneer stereo and a 12.3-inch screen infotainment system.
Upgrading to Premium spec gets you a different design of 20-inch wheels, adaptive suspension, heated steering wheel and back seats, semi-aniline leather, a 15-speaker Mark Levinson sound system, a head-up display, 10-way adjustable front seats, adaptive high-beam headlights, wood inlays and sunshades for the rear windows.
Ian Corbett, Head of Lexus Ireland, commented: "We are delighted to welcome the first seven-seater Lexus model to our retailers in Ireland, bringing with it a new range of Lexus customers. The RX 450hL is perfect for families who want a premium self-charging hybrid but who require that third-row seating for children and still have room in the boot for luggage and all that comes with a bigger family. The RX 450hL has a range of unique advantages to enhance the comfort of seven passengers as well as our latest Lexus Safety System technology which has a five star Euro NCAP rating."


The best prices for Caravan Insurance in Orense, we carry out a comparison service of Caravan Insurance in Orense to offer our clients the economic and economic Caravan Insurance. LThe best options to hire the best deals of Caravan Insurance in Orense and its 92 towns, Ourense, Verín, Carballino, Barco de Valdeorras, El, Barbadás, Xinzo de Limia, Pereiro de Aguiar, Allariz, Celanova, Ribadavia, San Cibrao das Viñas, Rúa, Coles, Viana do Bolo, etc. f you want to hire the best Caravan Insurance in Orense fill out the following questionnaire and you will get the complete Caravan Insurance.
If you are looking for complete and complete Caravan Insurance , www.generalinsurance.es offers you Caravan Insurance comparators, where you will find the best prices for hiring quote Caravan Insurance. Comparing prices of Caravan Insurance is very fast and simple. Access the Caravan Insurance calculator and fill out the application form with Caravan Insurance details, in a few minutes you will get best deals on Caravan Insurance.
Now best prices for hiring Caravan Insurance in Orense the complete and Cheap, use the search engines of Caravan Insurance in Orense and hire the Caravan Insurance most cheap in the entire province of Orense.


The Medical Arts Program invites you to attend a performance of 8980: Book of Travelers followed by a dessert reception and opportunity to have a discussion with the artist, vocalist and composer Gabriel Kahane.
The morning after the 2016 presidential election, singer-songwriter Gabriel Kahane packed a suitcase and set out for a two-week train trip across the US with no phone or internet, embracing 8,980 miles of a reclusive Amtrak existence. Alone at the piano, Kahane draws from dining car conversations with dozens of strangers to sing of his own upended assumptions about the body politic as revealed through his unplugged railroad exile. The highly anticipated follow-up to his acclaimed stage piece, The Ambassador, Gabriel Kahane's Book of Travelers is a meditation on the beautiful terror of getting lost in an unfamiliar landscape. You can view more info here.


text:
using System;
using System.Collections.Generic;
using System.Data.Entity;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Backend.Entities;

namespace Backend.Utils
{
    public class Context: DbContext
    {
        public DbSet<Employee> Employees { get; set; }
        public DbSet<Project> Projects { get; set; }
        public DbSet<Salary> Salaries { get; set; }
        public DbSet<Site> Sites { get; set; }
        public DbSet<Vacation> Vacations { get; set; }

        public T Get<T>(int id) where T : Entity
        {
            // @gmrukwa .ToList enforces local calls
            return Get<T>().ToList().First(e => e.GetId() == id);

            //if (typeof(T) == typeof(Employee))
            //    return Get<Employee>().First(e => e.EmployeeId == id) as T;
            //if (typeof(T) == typeof(Project))
            //    return Get<Project>().First(p => p.ProjectId == id) as T;
            //if (typeof(T) == typeof(Salary))
            //    return Get<Salary>().First(s => s.SalaryId == id) as T;
            //if (typeof(T) == typeof(Site))
            //    return Get<Site>().First(s => s.SiteId == id) as T;
            //if (typeof(T) == typeof(Vacation))
            //    return Get<Vacation>().First(v => v.VacationId == id) as T;
            //throw new TypeAccessException(typeof(T).AssemblyQualifiedName);
        }

        public DbSet<T> Get<T>() where T : Entity
        {
            if (typeof(T) == typeof(Employee))
                return Employees as DbSet<T>;
            if (typeof(T) == typeof(Project))
                return Projects as DbSet<T>;
            if (typeof(T) == typeof(Salary))
                return Salaries as DbSet<T>;
            if (typeof(T) == typeof(Site))
                return Sites as DbSet<T>;
            if (typeof(T) == typeof(Vacation))
                return Vacations as DbSet<T>;
            throw new TypeAccessException(typeof(T).AssemblyQualifiedName);
        }

        protected override void OnModelCreating(DbModelBuilder modelBuilder)
        {
            base.OnModelCreating(modelBuilder);
            modelBuilder.Entity<Vacation>().HasRequired(v => v.Employee).WithMany().WillCascadeOnDelete();
            //modelBuilder.Entity<Site>().HasOptional(s => s.Boss).WithMany().WillCascadeOnDelete();
            //modelBuilder.Entity<Project>().HasOptional(p => p.Manager).WithMany().WillCascadeOnDelete();
            modelBuilder.Entity<Salary>().HasRequired(s => s.Employee).WithMany().WillCascadeOnDelete();
            modelBuilder.Entity<Salary>().HasRequired(s => s.Project).WithMany().WillCascadeOnDelete();
        }
    }
}

redpajama_set_name: RedPajamaGithub


An Iranian senior official said cooperation in the steel, oil and gas industries, as well as car manufacturing would contribute to boosting the trade turnover between Iran and Azerbaijan.
Talking to Trend News Agency, Iran's deputy industry minister for mining and mineral industries, Jafar Sarqini, called for close cooperation with Azerbaijan in steel, oil and gas, as well as car-making sectors in order to help boost the trade turnover between the two neighboring countries.
Elaborating on plans regarding the cooperation in steel sector, he said the two countries have already discussed the ways of increasing the level of this cooperation.
He speculated that Iranian private sector may collaborate with Azerbaijani steel companies in the future.
The deputy minister further called for cooperation in oil and gas sector, saying the two countries have already engaged in cooperation in the sector, but its level is not satisfactory.
Describing oil and gas sector as important for both countries, he added that Iranian companies enjoy proper capabilities in the maintenance of oil refineries and equipment, as well as the construction of oil facilities.
Jafar Sarqini also touched upon the two countries' decision to establish a joint venture for producing cars in Azerbaijan, adding that in addition to a car manufacturing factory, new companies will be created in Azerbaijan for providing auto parts.
The deputy minister added that the volume of trade turnover between the two countries has soared by 70 percent over the first seven months of the current year.
According to Azerbaijani officials, Iranian companies have invested $2.6 billion in Azerbaijan's economy. About $145 million of the total amount has gone to the non-oil sector. This is while some 450 companies with Iranian share operate in Azerbaijan.
Trade turnover between Azerbaijan and Iran amounted to $122.08 million in January-August 2016, $30.66 million of which accounted for the export of Azerbaijani goods to Iran, according to the State Customs Committee of Azerbaijan.
In the meantime, Hossin Esfahbodi, another Iranian deputy minister of industry, mine and trade, told Trend News Agency that the volume of trade turnover between the two countries currently stands at about $100 million and it must surpass $300 million in the near future.


text:
Netta ebook
Fred M White
Netta Sherlock was a great singer. It was always important for the singer to have a healthy and sonorous voice. And their fear was to lose it. So it happened to Netta. She lost her ringing voice. A difficult path she has to go.
The Riddle of the Rail
The Secret of the Sands
The Weight of the Crown
The Devil's Advocate
The Seed of Empire
The Sentence of the Court
The Shadow of the Dead Hand
The Slave of Silence
The Lord of the Manor
The Master Criminal
The Midnight Guest. A Detective Story
Secret of the River
A Shadowed Love
A Broken Memory
The Salt of the Earth
The Scales of Justice
The Romance of the Secret Service Fund
The Silver Stream. An Idyl of the Wye
The Sundial
The Turn of the Tide
I. THE WHITE LADY
II. THE STORM
III. THE VOICE IN THE NIGHT
IV. BEFORE THE DAWN
V. SHOULD SHE SPEAK?
VI. THE CHAMBER OF THE DEAD
VII. THE TWO DICE
VIII. AFTER LUNCHEON
IX. AFTER DINNER
X. HALF-CONFIDENCES
XI. UNDER THE GAS LAMPS
XII. WHAT DID HE KNOW?
XIII. A MIDNIGHT GUEST
XIV. A DIFFERENCE OF OPINION
XV. ADVENTURE
XVI. A MAN OF SCIENCE
XVII. ANOTHER SURPRISE
XVIII. FACE TO FACE
XIX. COMPLICATIONS
XX. IN SOCIETY
XXI. IN THE NAME OF CHARITY
XXII. IN THE DARK
XXIII. PUT TO THE QUESTION
XXIV. A NEAR THING
XXV. RAYMOND BOND
XXVI. THE CAUSE OF THE MISCHIEF
XXVII. A HOUSE OF REFUGE
XXVIII. A SUDDEN RESOLUTION
XXIX. IN THE HEART OF THE CAMP
XXX. ANOTHER FOE
XXXI. NETTA'S ADVENTURE
XXXII. NOT THIS TIME
XXXIII. THREADS IN THE STORY
XXXIV. THE MISSING COAT
XXXV. DANGER
XXXVI. ON THE TRACK
XXXVII. AN UNEXPECTED MEETING
XXXVIII. "THE VERY BUTTON"
XXXIX. CLEARING THE WAY
XL. A PINCH OF SNUFF
XLI. TREMULLION TAKES THE LEAD
XLII. IN THE WINE CELLAR
XLIII. BAFFLED
XLIV. THE COAT AGAIN
XLV. WHEN ROGUES FALL OUT
XLVI. A WARNING TO THE "36"
XLVII. GOOD LUCK
XLVIII. FOUND
XLIX. BEATEN
L. LAST WORDS
NETTA SHERLOCK'S unsteady voice dropped to a hoarse, unsteady whisper. Her long, slender fingers dragged the travelling cloak from about her neck, and she panted like one who has been hard put to it to escape from imminent danger.
"Quick!" she said. "Give me some water, bathe my head with eau-de-Cologne. I hope they noticed nothing in the hall. How stiflingly hot it is, Amy."
Amy Burke discreetly said nothing. Her mistress lay back on the couch in the luxuriously-appointed bedroom, her dark, stormy eyes half closed. She reclined there for some time till the trembling fit passed away and the white bosom ceased to heave so violently. Then she looked around with scorn on her face.
"So we have got here at last, Amy," she said. "I am an honoured guest at Loudwater Priory! Just think of it, Amy! Two years ago I was fiddling for my living in the streets, outside public-houses, jeered at and pitied and insulted! And now!"
And now she was in a bedroom a young duchess might have envied.
"I have schemed and lied and plotted to get here," she went on. "I forced them to ask me. If Sir John and Lady Langworthy only knew the truth!"
"It was a dangerous thing to do," the maid murmured. "Especially just now, seeing that we are so close to Coalend. If any of the people recognize you–"
"But I had to come, Amy. The inaction was slowly driving me mad. For Reggie's sake–oh, I could do anything for Reggie's sake! You don't know everything. Amy; indeed, it would be impossible to tell you. But the secret is here in this house, the key may be in this room for all I know, and if I can find it, then the disgrace will be lifted from my lover's name. Amy, I must succeed."
The little maid with the firm lips and steady eyes smiled. If Netta Sherlock made up her mind to succeed, she would assuredly do so. Had not that indomitable will and genius taken her far already? It was the old story of talent struggling for life amidst the most sordid surroundings. A happy home in childhood, the death of the mother followed by the breakdown and the pathetic end of the father, a soldier and a gentleman–these had been the chief landmarks in her brief career.
Bad as it was, there had been worse to follow. Love had entered into Netta's life to save her from utter despair. Time was when Reggie Masters had been a friend of the family. Reggie had found Netta out, and told the old, old story. Then the cloud of disgrace burst suddenly, exposure and humiliation and flight had followed with the rapidity of lightning, and Netta was alone again.
Reggie was innocent, Netta was sure of that. He had forwarded to her certain disjointed papers to read in Paris, where he had sent her to study. At first she had found them beyond her grasp, but gradually she mastered them. If she had only had money and influence, if people would only recognize her genius and individuality. But doubtless she would play her fiddle in the streets till she died.
Netta was rehearsing it all again dreamily–that dreadful night when she had eaten nothing all day; the fainting fit and the kindly old German who had asked questions; an engagement or two at a concert and enthusiastic paragraphs in the papers, It was a dream, it must have been. It seemed impossible that such great events could have happened in four and twenty brief months. And yet here was Netta now, the spoilt darling of Society. She had been interviewed in a score of papers, her photographs had sold freely, she had only to name her price for a performance and the money was there. Virtually it had been a romance in real life.
Netta paced up and down the room, quite herself again by this time.
"I'm dreadfully nervous and excited," she said, "I, who hardly know the meaning of the word except when I first go on the platform. But I shall be all right at dinner. And afterwards I shall play to them, as nobody has ever heard me play before."
"We don't stay here to-night?" Amy asked.
"I must be in town by the last train," Netta replied. "Early to-morrow morning–but you know nothing of that. Sir John has offered his motor car to drive me over to the junction to catch the 11.15 up train. Now, help me to dress for dinner. I'll have black lace and white roses. No, I'll have black alone without any relief. There will be no chance of my dress betraying me then."
Netta surveyed herself presently in the long cheval glass with a sigh of satisfaction. The dead black suited her dark eyes and soulful face to perfection.
"She couldn't recognize me," Netta murmured. "Who would recognize in Netta Sherlock the timid little Nellie Landon?"
Amy rushed into the room and closed the door. Her eyes were gleaming with excitement and something like fear.
"I have seen a ghost," she whispered. "Who do you suppose is here as a servant in a trusted position? But you will never guess, miss. It's Lucille Ganton!"
"She did not recognize you?" Netta asked, swiftly. "But that would be impossible. You were a mere child in Coalend when Lucille Ganton was tried and acquitted on a charge of poisoning her husband. But if she knows me again–"
A troubled frown gathered on Netta's face. She had come to Loudwater Priory on a difficult, not to say dangerous, mission. Indeed, but for the strong love she bore Reggie Masters she had never dared to come at all.
"I shall have to risk it," she said aloud. "Danger I apprehended, but not so soon as this. If that woman knows me, she will discover pretty well what I am doing here."
"You have greatly changed," Amy suggested. "I don't see how that woman–"
"She was in my mother's service years ago," Netta said quietly. "Her infamous partner in crime, Neil Jackman, was my father's valet. Strangely enough, Jackman found his way into the service of my lover before his misfortunes began. The secret of Mr. Masters's trouble lies in this house. Is it not strange, then, to find Lucille Ganton here? Depend upon it, Neil Jackman is not far off."
The hall with its lantern roof was a dream of beauty. Netta stood quite lost in it.
"Pardon me, miss, but are you doubtful of the way?" a respectful voice asked. "The door on the left leads to the drawing-room."
Netta concealed a start successfully. How vividly, those silky tones brought back the past!
"I was admiring the hall," Netta said, "I know my way. Why do you look at me like that?"
"Your face made me think of Coalend, miss," came the subtle reply.
"A place close by, is it not?" Netta asked carelessly. "I once had to stay there for a few hours. Why should I remind you of it?"
The woman muttered something; she was evidently baffled by the calm inquiry of Netta's eyes. A bell rippled in the distance, and the trim maid hurried away. But there was a queer, grim smile on her face as she vanished.
"Am I right or wrong?" she muttered. "The girl is so famous, and the other one... yet I see the likeness. Any way, Jackman will know."
To a certain extent the skirmish yielded victory to neither side. Neither Netta nor the maid Ganton was sure of her ground. With the doubt still in her mind Netta entered the drawing-room, which seemed to be pretty well filled with guests. Sir John Langworthy was a fine type of English sportsman, tall and well-knit, with an open, bronzed face and a kindly smile. He had a passion for music, and played the violin excellently for an amateur.
"You are rather late," he said. "You have not seen my wife yet; she was riding when you came. Oh! this is Mr. Falmer–Gordon Palmer–who will take you in to dinner. He is terribly learned from a musical point of view, and a most severe critic."
A tall man with a shining bald head and wonderfully massive dark eyebrows was bending over Netta's hand. There was something strong and commanding about Gordon Falmer, she thought. In age he might have been anything between forty and sixty. It was only when he smiled that a sinister expression clouded his face.
"Is it too much to ask you to play?" he suggested.

redpajama_set_name: RedPajamaCommonCrawl


text:
Q: page visit every 50+ number url i need to visit 50+ page
example
$page=1
$page=51
$page=101
$page=151
my php function visit $page=1 then $page=2 - can any help me?
function start(){
        $page=1;
        do{
            $ss=getpagecontent('http://www.domain.com/?pagenumber='.$page);
            for($i2=0, $i2Count=count($ss);$i2<$i2Count;$i2++){
                $jk=getDk($ss[$i2]);
                if(!saveDD($jk, $msg)){

                }
            }
            $page++;
        }while(!empty($ss));
    }

A: All you need to do is increment $page by 50 each iteration. So you'd change this:
$page++;

To:
$page += 50;

A: function start(){
        $page=1;
        do{
            $ss=getpagecontent('http://www.domain.com/?pagenumber='.$page);
            for($i2=0, $i2Count=count($ss);$i2<$i2Count;$i2++){
                $jk=getDk($ss[$i2]);
                if(!saveDD($jk, $msg)){

                }
            }
            $page+=50;
        }while(!empty($ss));
    }

redpajama_set_name: RedPajamaStackExchange


text:
Former dancer makes money moves selling Stripper Kicks
by TorCouture
Photo Credit: Steven Novakk
The first three words that come to mind when describing Karisma Boss are fearless, humble, and trendsetter. That's exactly what she is, a fearless and humble trendsetter. Through being a full-time mother and serial entrepreneur, she has personified the term "girl boss."
Stripper Kicks was the first of Karisma's many businesses. She started out selling the exotic dancer type shoes to girls at the strip club where she worked. Many people often downplayed her for selling the "stripper" heel, but she credited that to how small minded some people can be because women all over actually wore these shoes as performance pumps or club attire. Despite the negative feedback, Boss kept at her goals and didn't allow naysayers to box her in. She was an exotic dancer who used her occupation as motivation and funding to start selling shoes.
"Everyone who was selling dance shoes at the time were overcharging us," Boss said. So, she took advantage of that window of opportunity. The notebook she used to take orders in has now expanded into four remunerative businesses: @KarismasKlosetDetroit, which is a women's shoe/clothing boutique and beauty bar (the boutique and beauty bar make two) where she still carries @StripperKicks as well as her own Indian Hair line @MyHeirCollection.
Photo Credit: @KarismasKlosetDetroit
Rolling out caught up with Boss and here's what she had to say:
What motivated you to become an entrepreneur?
I worked one thousand jobs and every time I worked I would find something that I didn't like, whether it was my boss, them telling me how to do my job, being on time, clocking in, just the whole process of me working for someone else. I just didn't like it, so I knew I had to make my own money and work for myself because I couldn't keep getting into it with people who were superior to me. I had to listen to what they said and I didn't like that.
Can you talk more about your business when it first started?
When I opened my first store I was only selling shoes. Once a lot of boutiques around the city started seeing me selling shoes, they started trying to feature shoes into their boutique, which made me feel like, "OK, if you're going to sell shoes now, let me feature clothes," so then I started selling clothes. It was basically trying to keep up with competition because they were trying to cut me out. People would steal my pictures and sell the same shoes as me.
Knowing how harsh of a city Detroit can be, how do you feel about doing business here overall? What motivated you to say regardless of what's going on around the city, I'm still going to step out and start my business?
People always have negative comments but I just keep going. If you don't like me you'll eventually order something offline if you don't want to come in the store or you'll eventually send somebody in the store as you keep seeing me around for years to come.
When you first started, do you feel like you had all of the resources you needed to be successful or did you have to make a miracle?
I had a lot more resources starting out because I was still dancing and I was saving my money up, putting it into my store versus now I'm using the money that I'm making to buy more inventory, to keep it flowing. Things are still good, though. I'm still making a good profit. At one point, I took a part of my savings from this location and used it to open a second location, I thought it would do good and double my income when basically I just wasted all of my savings because the store just wasn't doing good. I regret it financially but it was a learning experience.
What sets you apart from other business owners in your market?
I go and search for things that other boutiques don't have. I try my hardest not to order the same things. People will come in and ask me to order something that they saw at someone else's store and I'll say, "No. Go get it from them." I don't want to have anything that anybody else has. That's the whole point of being a boutique; you're supposed to have special pieces that you aren't going to find in the mall or anywhere else. Now if someone out of town has it, okay, but nothing like anybody that I can easily drive or walk to.
Do you feel like it's still hard to be taken seriously as a female entrepreneur or is it the new norm?
I haven't really had any problems when it comes to being a woman, but I have been belittled when it comes to me being a dancer. "Oh, you don't know what you're talking about. All you know about is dancing; you're just a stripper," stuff like that. And it would come more from women than men. Men would promote and congratulate me then women would come up with anything from "…her stuff is too expensive," to "I don't like her." Whatever the case may be.
How has your life as an entrepreneur impacted your life as a mother?
Well now, my son, all he talks about is how he's going to open up his own business. He wants to make games, his own system, his own video games, and he wants to open a game store and says he wants to be like me. So, it's basically like I'm motivating my son, which I'm proud of because when he does go and gets his degree or whatever he decides to do, I don't want him to work for anybody. I want to have some type of foundation set so he'll be okay.
How do you use your platform to be a positive influence?
I try to give back often. I usually do something in October for Breast Cancer Awareness and my team and [I] always come together to donate our used clothes.
Follow Karisma on Instagram and Facebook @KarismasKlosetDetroit
Tags: Detroit, Entrepreneur, Karisma Kloset, MyHeirCollection, Stripper Kicks
TorCouture
"Be fearless in the pursuit of what sets your soul on fire." Mother. Writer. Dreamer.
TorCouture October 16, 2017


text:
Clinton's Opportunity
Benjamin M. Friedman
December 3, 1992 Issue
President-elect Clinton faces a situation in which US economic policy and the US economy have reached a standoff. Business is sluggish in part because it must carry the weight of past mistakes, both public and private, but also in part because it has been receiving little help from what in other circumstances would be standard policies used by the federal government to stimulate the economy. At the same time, such policy measures have been largely absent because so many of the usual measures that are appropriate during a time of stagnation—tax cuts, boosts in spending, genuinely deep cuts in interest rates—apparently fly in the face of the need to begin resolving the mess left by the excesses of the last ten years.
All this is not to say that it is impossible to improve the economy in its current condition, or to address the problems created by past errors or, indeed, to do both. There are in fact measures that the nation can take to encourage business today and to foster advances in productivity and competitiveness in the future. There are ways to reverse the trend to low investment and high consumption of the last decade without plunging the economy into a yet deeper shortfall from its potential output. But combining these objectives in a workable policy will require serious dedication, including a willingness to take actions that inevitably will be distasteful to one interest group or another, as well as a degree of legislative ingenuity that, at least in recent years, neither the President nor the Congress has been able to muster. In short, the challenge is very great. But then so is the need.
That 1993 presents a critical opportunity to take action on our economy has by now become a cliché. But this does not make the point less true. The economic history of our time has been radically different because Ronald Reagan in 1981 used his election mandate to support the tough measures, including record high interest rates, that Paul Volcker carried out at the Federal Reserve System in order to brake double-digit inflation. Three years later, voters rewarded the President for having done so, forgiving if not forgetting the record high unemployment that had temporarily ensued.
The economic history of our time would have been radically different in yet other ways if President Reagan in 1985 had followed his reelection victory by imposing some combination of spending cuts and tax increases sufficient to eliminate the very large budget imbalance his earlier policies had created. But he chose not to do so, and we thereby lost the chance to correct this problem while our economy was strong. In 1989 George Bush too missed his opportunity. Perhaps because he believed he could not violate his "Read my lips" campaign pledge, President Bush adopted an approach to our economy's mounting problems that consistently amounted to too little, too late.
It is now Mr. Clinton's turn. Because of the mounting economic damage done along the way, the easier…
—— December 3, 1992 ——
Who Was Edmund Burke?
Alan Ryan
Pilgrim's Progress
Robert M. Adams
Sighing Fields
Gabriele Annan
Bashing Japan?
Pat Choate


text:
The challenges and possible pitfalls of data journalism, and how you can you avoid them
By Samantha Sunne March 9, 2016
Now that we've gained some basic data knowledge and are putting it to use, we need to take care not to get entangled in a mistake or misunderstanding. The downsides to data reporting are, for the most part, identical to those of regular reporting: misleading or biased sources, honest error, and so on.
Data, however, does require some bulletproofing not necessary for more traditional projects. This section will address how data presents both new and traditional challenges for journalists.
Ethical concerns for reporting with data
The Associated Press recently announced it would be incorporating data standards into the 2017 AP Stylebook, further signaling data's formal role in 21st century journalism. Significantly, these standards won't be limited to language and style, but will include ethical standards.
The ethics standards of journalism – don't break laws, don't lie, lessen harm – all still apply to data use, Arizona State University professor Steve Doig said. "The data is just another source," he said. "It doesn't absolve you of the same kind of ethical considerations that you're supposed to be taking."
Just like stealing mail from a mailbox isn't ethically acceptable, stealing data from a website isn't, either.
One of the most important edicts for using data, Doig said, is to not use it out of context. As all the practitioners liked to drive home, you have to think critically about your data. One paper he cited had published some data on infant mortality in their city: the mortality rate was astronomically higher in one low-income neighborhood.
But after publishing it, he said, they found that that neighborhood housed a large teaching hospital, where sick infants were brought from all over the state. You have to do your shoe-leather reporting, Doig said.
[Data] doesn't absolve you of the same kind of ethical considerations that you're supposed to be taking.
Talking to the human sources behind the data is a must, practitioners told me. Doig shared an example from his own experience: his outlet had published data showing that a small number of convicted criminals had received no jail time. The reporters later found out from the court clerks that that simply meant the criminals had been assigned community service instead, they just hadn't entered it into the database.
All data, particularly the kind used for journalism, has its root in human sources. As a result, it is subject to human error, biases and fallacies.
Data also always requires context.
Alberto Cairo, Knight Chair at the University of Miami, recommends going a step further and talking to experts who are experienced in analyzing the data. "It's not just a matter of asking a couple of researchers some questions while you write a blog post," he wrote for Nieman Lab. "It's also a matter of doing your reporting in collaboration with those researchers, as they're the ones that know the data really well."
This isn't a particularly groundbreaking notion: The publications who regularly conduct solid data and investigative journalism nowadays, like ProPublica, work this way on a regular basis."
Earlier, we noted that one of the advantages of data is it lets reporters process very large sets of information. But when it comes to using data as a source, the single most important thing to remember is that the data comes from and involves human beings. It is unwise, often inaccurate, and potentially unethical to simply obtain numbers and publish them. Former New York Times developer Jacob Harris addressed this in an essay called "Connecting with the dots."
"It's super easy to put dots on a map at this point," Harris said in an interview with API. "It's easy to forget that they're still people."
When Cheryl Phillips worked at the Seattle Times, a devastating mudslide killed 43 people. They could easily and quickly have mapped the houses affected by the disaster, but that could have come across as callous, she said.
"You have to remember there are individuals in those data points," she said. Even though the Seattle Times published the map a full week after the disaster, it included on-the-ground reporting with photos, profiles and stories of the victims.
Credit: Seattle Times
"We wanted to publish something more fully formed and that helped tell the story of the tragedy in a more sensitive way," Phillips said.
On the flip side, there are privacy and sensitivity issues in publishing a data set that displays every single individual.
Phillips gave the example of salary databases: while public salaries are public information and therefore liable to be published, journalists should think about whether there's a journalistic impetus to do so. The Seattle Times, she said, obtained the data but only published newsworthy items like excessive overtime or changes over time.
API's Jeff Sonderman wrote a piece for Poynter outlining the difference between what journalists can and should publish when it comes to data. A map of gun owners, published by a newspaper in New York, was a case in point.
"Data can be wrong, misleading, harmful, embarrassing or invasive," Sonderman wrote. "Presenting data as a form of journalism requires that we subject the data to a journalistic process."
The Guardian's digital editor Aron Pilhofer scorned what he called the "data porn" that freewheels on the Internet: word clouds, pretty pictures, dots splattered on a map.
"Journalism has to have a nut graf," Pilhofer said. "A reason for people to care."
Tips for avoiding disaster
Most of the flaws with data are the same as with human sources, too: error, bias, unreliability, misunderstandings.
The following distill the counsel of data veterans on how to avoid being led astray.
Don't jump to conclusions
Even after you think you've found a trend or a connection, continue to be as skeptical as possible. Think of FiveThirtyEight's story on Nigerian kidnappings: how could they have avoided it?
Once you've got the numbers nailed down, step outside the numbers and look at your findings critically. Could there be any confounding variables, or issues that could cause a change that appears to be caused by something else?
Practitioners suggest investigating data sources for biases, hidden variables, privacy or legality issues, or anything else that could possibly lead you to a wrong conclusion. "It's easy to believe in the pretty spreadsheet," Guardian data editor Helena Bengtsson said.
Most say you should also confer with an expert or another person who is familiar with the data. Like Steve Doig's story on criminals apparently getting off scot-free, there may be something in the data you never thought of. If the stakes are high enough – like if there may be legal liability – Pilhofer suggested sharing an entire finding and body of work with an expert or the source itself.
Investigate the data before you report on it
Aron Pilhofer, at the Guardian, insists journalists should know the data "inside and out" before they analyze it. Don't assume anything: what the column titles mean, what the outliers are, whether there are any parts missing.
Stanford's Cheryl Phillips recommended figuring out what she called the "shape of the data": blanks, outliers, patterns and limitations.
As always, 18F innovation specialist Jacob Harris said, vet the data like you would any human source: "You (would) think, maybe the source has an agenda, maybe the source is lying, maybe the source doesn't know what they're talking about," he said.
He also suggested keeping a detailed log of what you did with the data – what columns you moved, calculations you performed, and so on.
Clearly explain the data to your audience
While data may be something of a miracle source of information, it still has its flaws. Be frank with your viewers or readers about incomplete data, differing interpretations, margin of error or anything else that could affect their understanding of your conclusions. Don't overstate your case.
When it comes down to it, Pilhofer said, you and your data analysis are your own source. "And you better be right. And that can be kind of scary."
So many of these pitfalls sound obvious, Harris said, and yet, anyone could easily fall into their traps, even experienced data journalists. "I still think that skepticism and paranoia are the best two things you could have on your side," he said. "I know I could easily fall into similar mistakes myself."
Don't republish conclusions formed by someone else
Reporters should be extremely skeptical, Harris said, of surveys or studies that are given to them with the analysis and conclusions already done. Oftentimes, it's just a startup or PR company trying to get some exposure.
He wrote about a particularly cringeworthy one in Source: a range of publications ran a very dubious study claiming that Democrats watched more porn than Republicans. The source was a porn website.
Credit: Source
"Remember that skepticism is your truest friend if you want to call yourself a journalist," he wrote. "It's not hard to see the flaws in a flimsy study if you are predisposed to contemplate all the ways in which the data is probably bad rather than tacitly accepting it as good."
Ideally, he said, journalists would obtain the raw data behind each survey and study and do their own analysis, as well as investigating the source.
Most importantly, do the groundwork reporting
All data journalists stressed that you can't do a single project with just data and not journalism. Hitting the pavement, making phone calls, talking to sources are always necessary.
Freelancer Hilary Niles said when she did her bulletproofing on her public radio story, the state's disarray when it came to understanding their own data became part of the story. "The conventional reporting required in order to compile the database also revealed real gaps in accountability," she said. "I think this also illustrates the importance of coupling data reporting with traditional reporting in order to draw the most complete picture possible."
As always, the key to reporting with data is that it's simply reporting. And with data becoming ever more omnipresent, it's no longer something that can be demarcated as a separate method to more old-fashioned reporting.
Luckily, the proliferation of tools and of data itself makes this kind of reporting easier and easier. API's Strategy Study on encouraging innovation in the newsroom quoted the legendary 20th Century journalist Hodding Carter: "This is the most exciting time ever to be a journalist – if you are not in search of the past."
READ MORE FROM: Strategy Studies
MORE ARTICLES ABOUT: Data reporting and visualization
Diving into Data Journalism
The rise of data reporting
How data journalism is different
How to get started with data journalism
How to establish data reporting newsroom-wide
Challenges of data journalism
View as Single Page


Orient take on Crewe looking to pull clear of the League 1 relegation zone. Alexandra were bottom of the table for the majority of the campaign so far but have jumped above Yeovil after an upturn in form in recent weeks.
Orient did the double over Crewe last season, and will be hoping to get their first home League win after tasting victory in E10 last week against Northampton Town in the Johstone's Paint Trophy.
In terms of team news, Mauro Milanese welcomed back Romain Vincelot and David Mooney at Gillingham whilst Jack Price has returned to the club and is over the illness which kept him out of the trip to Priestfield. More worrying for the O's boss was Shane Lowry and Jay Simpson limping off during the 3-2 defeat and he will wait on the fitness of both. Jobi McAnuff has returned from international duty though is rated as unlikely to play after four games for Jamaica in the last week.
There will be cash turnstiles available in the East and South Stand whilst the North Stand is close to selling out. For ticket collection and queries head to the West Stand Ticket Office.
Away supporters will be situated in the East Stand on Brisbane Road.
The referee will be Stephen Martin.
The game has been dedicated to dementia awareness with volunteers from the Alzheimer's Society and Redbridge Living Well team handing out information and speaking with supporters before the game.
Make sure you pick up a copy of our matchday programme upon your arrival at The Matchroom Stadium tomorrow.
• Josh Wright reveals how it feels to be back enjoying his football again.
• Cyril Lea discusses his time at Orient and promotion to the First Division.
• Jay Simpson looks back on his favourite pair of football boots.
• Dean Cox reveals which sportsman he would swap roles with.
• Former West Bromwich Albion striker Jason Roberts reveals a new project regarding O's legend Laurie Cunningham.
• Notes from manager Mauro Milanese and Chief Executive Alessandro Angelieri.
• Our man abroad Nik Roche returns with his EurO View and Dave Victor provides a View from the Press Box.
• Fitness coach Lee Southernwood is back with his column, which focuses on nutrition.
• All the lowdown on our opponents Crewe Alexandra and we look back at Middlesbrough's previous stadium Ayresome Park.
As part of Waltham Forest Council's 'Buy it Local' campaign there will be a variety of activities in Coronation Gardens from 11am through until kick off including stiltwalkers, balloon modelling, an interactive hula hoop show, live music, comedy and stalls.
We also are welcoming several local schools in the East Stand with free face painting on offer.


As the Deputy Director-General Myn has responsibility for Programmes including Grants. She led the Foundation in developing its Strategic Framework for 2012-16 and 2017-2020; integrating results-based management across the organisation.
Myn comes to the Commonwealth Foundation with extensive and multidisciplinary experience in International Development and Communication. Her areas of expertise are participatory governance, peacebuilding, gender, cultural diversity, communications for development, capacity development and knowledge management. She was the Director-Development of the Global Affairs Canada (GAC) funded Afghanistan Technical Assistance Program and was based in Kabul, Afghanistan. Previous to this she was the Canadian Field Programme Manager of GAC's flagship governance programme Local Governance Support Program in the Autonomous Region of Muslim Mindanao in Southern Philippines. Myn has also worked as a Programme Manager at the Laurier Institution, a non-governmental Canadian policy think tank examining the economic and social impact of cultural diversity and peace. She has worked with national and local governments, civil society organisations, international organisations, academia, media and the private sector in Canada, the Philippines, Sri Lanka, Afghanistan and the wider Commonwealth.
Myn has an MA in Communication and Development from Simon Fraser University School of Communication in British Columbia, Canada, and has authored, edited and published a number of books on governance, capacity development and knowledge management. Vancouver, Canada is home. Some of her interests include pilates, cycling, snorkelling, films, theatre, books and travelling. Vancouver, Canada is home.


"At 2:36:53 PM, I started my right foot down the stairs, turned two lefts down the stairwell, reached the ground floor on my right foot again after climbing down 47 steps, opened the right hydraulically-operated door with both hands, scampered 184 steps with a headwind blowing in my face, passed a Bentley Arnage, a Ford GT, a late-model Range Rover, and a Kawasaki motorcycle before turning left, nearly tripping on the drainage gutter when the edge hit my right ankle at 2:41:25 PM, and finally landing on the driveway with my left foot at 2:42:08 PM."
So if I told you the condensed form, THEN I'D BE LYING!!! *lol* To tell the truth, we'd have to narrate a novel each day!
We'd be more guilty of lying by omission than George Dubya is of lying outright.
(Addendum:) The Bible only touches on lying (outright.) Where does it make any mention of lying by omission? I think we only invented this "lie of omission" concept just so we would be told everything we ask about, though what could result is receiving more information than is needed.


Bridging Two Worlds provides teachers, school administrators and counsellors with the knowledge and practical resources to deliver more informed and culturally responsive career development and guidance to newcomer and refugee youth from Kindergarten to Grade 12. This book and the study upon which it is based grew out of the Canadian spirit of cultural diversity and inclusivity. Bridging Two Worlds offers data-informed curriculum development and instructional ideas that recognize and address educational gaps as well as cultural or experiential differences that impede progress.
In the first section, the book considers issues that relate to school-based learning and teaching. While not all newcomers to Canada face the cumulative effects of trauma, interrupted learning and new-language acquisition, all educators should be aware of how these affect human development and learning. The second section focuses on educator competency – preparing and training teachers and counsellors to work with newcomer and refugee children and youth. It includes relevant core competencies from the Career Development Guidelines and Standards of Practice and 30 sample lessons for educators. The book concludes with a section devoted to student learning outcomes for life/work development. Learning outcomes from the Blueprint for Life/Work Designs are provided with accompanying suggestions for instruction across all elementary and secondary grade levels.
Purchase bulk copies (10 or more) through CERIC at 30% off. Contact sales@ceric.ca with any questions.
Dr Jan Stewart is a Professor in the Faculty of Education at The University of Winnipeg. With over 30 years of teaching, research and field experience, Dr Stewart has achieved expertise working with children and youth who have been affected by conflict, trauma, violence, abuse, mental health issues, neglect and human rights violations. She has led international research and teacher development programs in Zimbabwe, South Sudan and Uganda, and she has conducted national and international seminars and conferences around the world. She is the author of The Anger Workout Book for Teens, The Tough Stuff Series, The STARS Program and Supporting Refugee Children: Strategies for Educators.
Dr Lorna Martin is a President Emerita of the Canadian Counselling and Psychotherapy Association (CCPA) and has held positions in the Faculty of Education at both the University of Winnipeg and the University of Manitoba. She has supported counselling and psychotherapy initiatives for more than 25 years, consulting with health, justice and family services representatives. She is an author and editor of multiple books and resources focusing on counselling and psychotherapy, supervision, ethics, standards of practice, suicide prevention and postvention, and education.
Bridging Two Worlds brings to bear the power of original research and the insight of its experienced authors on the crucial issue of educating newcomers. With the world witnessing an ever-growing number of refugees – many coming to our shores with expectations of a better life – education is the key. Equally, the new arrivals must learn about their new land and how they can make Canada a better place. Fortunately, this guide creates understanding and provides the tools that will enable the building of bridges to take place.
Grounded in solid research and underpinned by values of diversity and inclusivity, this timely publication is brimming with practical lesson plans and instructional resources. This is an absolute must-read for educators and others seeking to welcome and support newcomers and refugee families.
New Brunswick educators have benefitted from Dr. Stewart's work and we believe that her unique experiences, vast insight and depth of knowledge in this area is unparalleled in our country. The comprehensive information and data-informed materials, including lesson plans to build teacher capacity and case studies for analysis, will be essential resources for educational leaders across the country as they plan for their increasingly diverse classrooms and schools.
A well-researched and much-needed resource for educators and school counsellors who support newcomers and refugee youth. A must-have book for the toolkit of those working with newcomer and refugee youth or for those who need to understand this emerging career decision-making area.
Jan Stewart and Lorna Martin have written a comprehensive guide for cultural sensitivity in Canadian school systems. Bridging Two Worlds: Supporting Newcomer and Refugee Youth provides practical information that builds the capacity of teachers to support newcomers and refugees in the classroom. Organizations such as ours can use this guide as a resource to develop the core competencies needed for inclusive settlement work. I truly believe this well-written and informative book should be essential reading for government, teachers and settlement practitioners across Alberta and the country.
Bridging Two Worlds excels in clearly connecting research with practical, culturally responsive career development activities. It is a tremendous resource for deepening my own understanding as an educator and supporting learners with their career development.
Bridging Two Worlds is a well-written, articulate and comprehensive guide for all education professionals who work with newcomer and refugee children and youth. From creating a welcoming classroom to incorporating strategies like storytelling to career development planning, this resource covers all the bases in providing professionals a relevant and useful tool to help ensure the successful integration of this population of students. This book will become a staple resource for my team as we support our schools in their work with newcomer and refugee learners.
With the growing number of newcomer and refugee children and youth settling in Canada who have experienced trauma, this book represents an excellent resource to those current and future educators, settlement workers and healthcare practitioners who are working, or will be working, with such a vulnerable population. I recommend it highly.
Bridging Two Worlds: Supporting Newcomer and Refugee Youth is an invaluable guide to curriculum implementation and integration based on a rigorous, three-year research program. Importantly, the guide includes 30 detailed lesson plans designed to foster core competencies to help teachers effectively address the needs of newcomer and refugee children and youth. These include a powerful "privilege walk" designed to heighten awareness of the social and economic inequality faced by newcomers. If you are interested in building culturally responsive bridges in the school system, this book will be an invaluable resource.
Bridging Two Worlds: Supporting Newcomer and Refugee Youth is a much-needed volume that presents a Canadian research-based perspective on supporting the adjustment challenges and mental health needs of students from immigrant and refugee backgrounds. School administrators, guidance counsellors and teacher educators will especially appreciate the rich section of lesson plans to build teacher capacity in supporting newcomer and refugee students. Thoughtfully structured teacher development activities cover topics ranging from supporting the needs of students with interrupted learning and using restorative practices to support refugee students to looking at gaps among students created by privilege and fostering peace education. This book will be welcomed by all Canadian educators who want to better serve the needs of newcomer and refugee youth.


text:
KEVIN ERIKSSON POSITIVE ABOUT OMSE UPGRADES
Friday 3rd of August 2018
Sweden's Kevin Eriksson is entering the seventh round of the FIA World Rallycross Championship at Trois-Rivieres this weekend in confident mood following a successful test for the Olsbergs MSE team in Canada yesterday (on Thursday).
Eriksson has finished ninth overall twice in 2018 in OMSE's new Ford Fiesta ST Supercar, while his team mate Robin Larsson has seventh in Belgium. The 2016 World RX of Germany winner is hoping changes made to the Fiesta will lift him into the final places. "We had a good test, we've been working very hard during the summer break, there's been no holiday for us but if it's worth it, it's perfect. The car felt very good yesterday and I really hope we will see that as well on Saturday and Sunday," said Eriksson. "It's mainly the engine we have been working on. I actually like our chassis – we have a very different chassis to the other teams and it feels good but we've been lacking power. You can see that quite clearly, it's been a disadvantage when we've gone to every track, especially here in Canada when it would be the biggest disadvantages."
The Trois-Rivieres circuit has the longest straight of the year, where the Supercars reach over 200 KPH. "It's quick and it's a very long straight, but I don't think about it too much when I'm driving. 160 KPH or 200 KPH doesn't make so much difference to me, it's more the acceleration where you get blown away with these cars," he continued. "We have taken another step before this weekend, we will see if we can catch the rest or if it's just another step closer, but it felt good anyway."
The former RX Lites (the previous name for the RX2 International Series) Champion is planning to return to the final and podium in World RX as soon as possible. "I want to fight for the final, that's always my goal. If I'm not there I'm looking to be there, I don't really want to fight for 10th to 12th place. I can't just give up, but my goal is to fight for a final and the podium. I was fourth here last year, I know I'm quick at this track, so I will aim for that once again."


text:
Rising Susquehanna affecting construction of Thruway bridge
Published: Jul. 23, 2018, 6:29 p.m.
John Beauge | Special to PennLive
WINFIELD - High water is affecting the construction of the nearly mile-long bridge that will carry the Central Susquehanna Valley Thruway over the West Branch of the Susquehanna River in the Winfield area.
Before the rising river crests later in the week, water is expected to top the causeway built from the west bank, Jeremiah Gonzalo, project engineer for the Pennsylvania Department of Transportation, said Monday.
Huge cranes used to construct the concrete piers, some of which are 180 feet high, and to erect steel girders are being moved to shore, he said.
The causeway, which goes halfway across the river, has been topped several other times since construction of the bridge began, but this appears to be the worst, Gonzalo said. It will need to be inspected for damage before it can be reused, he added.
If weather would have cooperated, plans were to begin removing the causeway next week and build one from the eastern side of the river, he said.
READ MORE: Where are the areas in Pa. hardest hit by flooding?
The high water also is expected to flood the area where construction of pier 9 in the middle of the river has started, Gonzalo said. If that occurs, water will have to be pumped out before work can resume, he said.
Construction of piers 2 through 8 is complete and a cap must be poured for pier 1 that is located on the west shore. Erection of the remaining steel girders will resume when weather improves, he said.
Once the causeway is built from the east bank, construction of more piers in the river can begin. The new causeway also will provide access to pier 9, he said.
The 4,545-foot-long bridge is part of a 12.4-mile-long thruway that will connect the northern end of the Selinsgrove bypass with Route 147 south of Montandon. It will allow Routes 11/15 to bypass Hummels Wharf and Shamokin Dam.
The thruway's northern section, which includes the bridge, is scheduled for completion in 2022.
Final design of a two-mile section of the southern section has been delayed because PennDOT discovered the four-lane, limited-access highway could not be built over two fly ash basins as originally thought.
PennDOT, which is awaiting Federal Highway Administration approval of the revised location, still lists 2024 as the completion date for the entire thruway.


Watch Egypt vs Swaziland, Africa Cup of Nations Qualifier, live streaming online free HD on Friday, October 12 at 1:00pm ET. Football matches on this day we will present to you. Because many football streaming sites broadcast online, which already provided some games.


text:
Leadership Columns
Lower School Principal
Middle School Principal
Upper School Principal
Arts Director
College Counseling Director
Libraries Director
Parent Association President
Horizons Director
Inclusivity Director
On CAmpus Newsletter
Competing in Computer Science
Sadie Christlieb June 5, 2018 AcademicsOn CAmpus NewsletterUpper School204 views
While many Colorado Academy students took a break over Memorial Day weekend, one of CA's teams was sweating out its toughest competition of the year. When you hear about a competition, you might not immediately think about programming or coding. But top Upper School computer science students Eric Bear, Cooper Bedin, Alena Holbert, Alex Kim, and Will Smart traveled to Providence, R.I. to compete in the American Computer Science League (ACSL) National All-Star Competition. They came in fifth out of 20 teams, the highest that CA has ever placed in the tournament.
This year's All-Star Competition caps Bear's three years of competing for CA in ACSL. As he looks back, he sees the incredible opportunity it provided to "compete alongside students who share a passion for computer science and problem-solving."
'A way to apply what I've learned'
Qualifying for the All-Star Competition doesn't come without putting in extra time and effort. On every C day after school, students in ACSL meet with Computer Science Department head Kimberly Jans and practice for the upcoming competitions. They cover Boolean Algebra, programming, logic, and other topics that aren't covered in class.
"Competitions are an awesome way for the students to celebrate their talents," says Jans. "They help take knowledge outside of the classroom."
Eric Bear and Cooper Bedin represented CA at Lockheed Martin's CodeQuest.
ACSL competitions consist of a written and a programming portion and provide students with sample questions beforehand so they know what to expect. After all the time and work they put in to learn the material, Holbert says "competitions give a sort of end goal, a way to apply what I've learned."
For Bedin, competitions are a place to challenge oneself and to meet people with the same interests. "You learn how to make a solitary passion into a team passion," he says. "You get to learn a lot of topics you don't get to learn in class."
'It's really fun'
ACSL is just one of the many competitions that CA students have participated in this year. They have also competed in an online Girls Go Cybersecurity contest, HP's CodeWars, the Colorado School of Mines Programming Competition, and Lockheed Martin's CodeQuest.
Each of these events required students to work as part of a team, helping to buck the stereotype that computer science is an individual activity. "I didn't really know what I was getting into, but it's really fun," Holbert admits. "I like to work through the problems and work as a team."
Eric Bear, Alex Kim, and Will Smart working as a team at the All-Star Competition.
With each year that he has been at CA, Bedin has noticed that more students have become interested in computer science. Holbert acknowledges that as the program grows, they are "breaking stereotypes. There's a lot of diversity in the kids who are interested in it."
"Computer science can be really fun," Bedin says. "It's really magical to make things that work but that are also kind of you."
'It's inspiring'
Since the inception of the computer science program at CA 17 years ago, one of Jans's number-one goals has been to get girls involved. Holbert is the first and only girl to have represented CA at the ACSL All-Star competition, which CA has qualified for since 2012. "In the computer science field it's mostly men," says Holbert, "so it's really cool to have Ms. Jans be so good at it. It's inspiring."
Jans, a Master Teacher, has spent her career at CA establishing the computer science program and encouraging students to become interested in it. The success of the computer science program she started is highlighted every time another student signs up for a class or joins ACSL, and the profile of CA's program is raised when students do well at competitions.
CA took fifth in the ACSL All-Star Competition this year.
"I love seeing them excited about coding," says Jans with a smile as she points to the trophies on display in the corner of her classroom. "It's been my life's work."
At this year's All-Star competition, only five points separated the top five teams, showing how competitive CA's computer science program is at the international level. The CA students who participate in ACSL and other coding competitions may not have a jersey, gear, or a designated field to practice on, but they are a team. They apply themselves in practice and showcase their hard work and what they know at competitions. And oftentimes, they come home with a trophy.
Computer scienceOn CAmpus June 2018
Previous ArticleFifth Grade Continuation 2018
Next ArticleKindergarten, Fifth, and Eighth Grade Continuations 2018
Colorado Academy announces entertainment lineup for April benefit concert
Rebecca Risch January 17, 2020
Vicki Hildner December 20, 2019
Practicing Spanish in Spain
Communications December 19, 2019
An exchange with Scotland
School 'with a big heart' offers hope
Renee Rockford December 19, 2019
2019 CA Annual Holiday Dinner
Colorado Academy Website
© 2019 Colorado Academy


text:
Bloomingdale Library attack survivor meets Winter the Dolphin
By FOX 13 News staff
CLEARWATER (FOX 13) - Winter the Dolphin had a very special visitor Saturday; a young woman whose daily life is a struggle after being brutally attacked in 2008.
Queena Phu was given the VIP treatment at the Clearwater Marine Aquarium, complete with some one-on-one time with Winter.
Queena's story touched many in the Bay Area. She was left paralyzed and unable to see or speak after a brutal attack that robbed her of some of life's biggest moments. But on Saturday, she gained a memory few can claim.
During Queena's visit to CMA, she was surprised one of the Dolphin Tale movie stars, Nathan Gamble, who plays the character Sawyer in Dolphin Tale and Dolphin Tale 2.
Queena's family says her connection with Winter the Dolphin is a joy and they hope the community who has supported them all these years feels the same.
Her family says she is doing well, adding that moments like the one with Winter remind them how precious a gift her life is.
Florida lawmakers propose 'constitutional carry' bill to allow concealed weapons without licenses


At Voeller Construction, we specialize in new luxury home construction from the ground up to completion. No matter how large or small the project, you can always expect world-class service, from a dedicated team, who work hard to ensure your home building experience is second to none.
We provide the highest quality custom home design-build construction services in Florida. We have earned a reputation for superior quality and craftsmanship. Give us a call if you would like to discuss the home building process or have any questions, we'll be available.


text:
Q: I want to continue with my program after opening the .bat file I want to open .bat file and then continue the code but python is waiting for the end of file so I need to close the file and then it continue. But I want to open the file and continue with the code and don't close the file. thanks
import os

os.system("scrcpy-console.bat")

print("continue")


text:
Q: Error while fetching data from WhereScape red I have created on load table. However, while viewing data I'm getting error below:

[Microsoft][ODBC SQL Server Driver][SQL Server] Invalid object name 'LOAD_TAL_Tablename'

May I know what is the problem? How to resolve this?

A: Very old topic, but still worth to answer.
The reason is invalid syntax, as mentioned above. I received the same error and then investigated in logs that although I am loading data between different databases, Wherescape did not add reference to appropriate source database in generated SQL code. So, by default, it was referring to target database when looking for source table.
To fix this, see below steps:

*

*Find your soruce connection and open it's Properties

*On Properties tab, in Source System section make sure that the field Database ID is filled in with name of your database. If not - put it there

*Try to load tables and look at SQL used to load the table in logs. Make sure your reference to source table is three-part (this time it should point to correct database).

A: Check whether the object exists (natch!) and more specifically what schema it is located in. By default RED will expect to see it in the dbo schema and I have seen in the past that if you are using AD and groups for authentication/authorisation objects may get created under the default schema of the automatically-created user (if that is the case, delete them manually in SSMS and set the Default Schema mapping for the user to "dbo")
Of course, you have actually /created/ the table haven't you? Just defining it in RED will only create tyhe meta data definition. Make sure you have right-clicked and chosen Create/ReCreate etc... (though to be fair if this is where you are stuck ...)
HTH,
Mark

A: Can you post the code that you used to create the table as well as the code you are running when you get the error. It just sounds like a syntax issue.


There are many books that focus on the conservation of natural areas and contain interesting and entertaining descriptions of the natural world. Here are some that we particularly like. See below for a list of periodicals that contain articles on conservation that are science-based but written for the non-scientist.


When working with the overflow: scroll; attribute, the -webkit-overflow-scrolling: touch; attribute can be very useful on mobile sites. It basically changes the awkward scrolling behavior into the normal, expected behavior.
This entry was posted in General on 1. October 2014 by Patrick Muff.


Atlantis Whirlpools Venetian series bathtubs resemble simplicity set in classic design. A rectangular, minimalism-inspired design turns simplicity of square forms into perfection of symmetry.
All In-stock items will ship in 1 to 3 business days. Average ship times for in-stock items take 1-7 days to your home. Tracking information will be sent to your email.


In an unfortunate incident, a bus carrying the Afghan National soccer team crashed in Maldives. Captain Mustafar Azadzoy, Islamuddin Amiri and Faisal sakhizad are reported to have been seriously injured in the accident.
Coordinator for the National team, Ali Askar Lali said, "Several vehicles were involved in this crash and the bus carrying the players was headed back to the hotel right after a match with Laos." The game had ended in a draw 0-0.
Sources say that the condition of Amiri and Sakhizada is critical.


We report the effectiveness of the surface modified γ-Al2O3 which is reusable, efficient, catalytic, safe and environmentally acceptable procedure for the conversion of both alkyl and aryl nitriles into the corresponding 5-substituted-1H-1,2,3,4-tetrazoles via [3+2] cycloaddition with sodium azide in excellent yields at mild reaction conditions (50 °C). The catalyst also afforded 1-substituted-1H-1,2,3,4-tetrazoles by the reaction of amines, sodium azide and triethyl orthoformate. The catalyst could be recycled and was reused eleven runs without losing its activity.


text:
Q: Python - sending unicode characters (prefixed with \u) in an HTTP POST request I'm writing a program which fetches and edits articles on Wikipedia, and I'm having a bit of trouble handling Unicode characters prefixed with \u. I've tried .encode("utf8") and it isn't seeming to do the trick here. How can I properly encode these values prefixed with \u to POST to Wikipedia? See this edit for my problem.
Here is some code:
To get the page:
url = "http://en.wikipedia.org/w/api.php?action=query&format=json&titles="+urllib.quote(name)+"&prop=revisions&rvprop=content"
articleContent = ClientCookie.urlopen(url).read().split('"*":"')[1].split('"}')[0].replace("\\n", "\n").decode("utf-8")

Before I POST the page:
data = dict([(key, value.encode('utf8')) for key, value in data.iteritems()])
data["text"] = data["text"].replace("\\", "")
editInfo = urllib2.Request("http://en.wikipedia.org/w/api.php", urllib.urlencode(data))

A: You are downloading JSON data without decoding it. Use the json library for that:
import json

articleContent = ClientCookie.urlopen(url)
data = json.load(articleContent)

JSON encoded data looks a lot like Python, it uses \u escaping as well, but it is in fact a subset of JavaScript.
The data variable now holds a deep datastructure. Judging by the string splitting, you wanted this piece:
articleContent = data['query']['pages'].values()[0]['revisions'][0]['*']

Now articleContent is an actual unicode() instance; it is the revision text of the page you were looking for:
>>> print u'\n'.join(data['query']['pages'].values()[0]['revisions'][0]['*'].splitlines()[:20])
{{For|the game|100 Bullets (video game)}}
{{GOCEeffort}}
{{italic title}}
{{Supercbbox
| title =100 Bullets
| image =100Bullets vol1.jpg
| caption = Cover to ''100 Bullets'' vol. 1 "First Shot, Last Call". Cover art by Dave Johnson.
| schedule = Monthly
| format =
|complete=y
|Crime       = y
| publisher = [[Vertigo (DC Comics)|Vertigo]]
| date = August [[1999 in comics|1999]] – April [[2009 in comics|2009]]
| issues = 100
| main_char_team = [[Agent Graves]]
 [[Mr. Shepherd]]
 The Minutemen
 [[List of characters in 100 Bullets#Dizzy Cordova (also known as "The Girl")|Dizzy Cordova]]
 [[List of characters in 100 Bullets#Loop Hughes (also known as "The Boy")|Loop Hughes]]
| writers = [[Brian Azzarello]]
| artists = [[Eduardo Risso]]
Dave Johnson
| pencillers =
| inkers =
| colorists = Grant Goleash
[[Patricia Mulvihill]]


In the late 1990s, Olivier Godechot set to work at the trading desk of a financial brokerage firm in Paris, beginning a period of fieldwork that would result in an early contribution to the then-inchoate social studies of finance. The editors of the Journal of Cultural Economy are pleased to publish in translation one piece of that research.
Originally published in 2000 as "Le Bazar de la Rationalité" in Politix (13:52, 17-57), Godechot's article represents one of the first efforts to think through the rationalities of finance using the sociological lessons of Bourdieu. Godechot's Forward — composed specifically for this translation — lays out the implications of this work for a contemporary social studies of finance oriented to the sociotechnical systems and performative repertoires through and with which human beings-as-market actors reason. Godechot's piece underlines the continued importance of understanding intersecting lines of difference and inequality — of class and rank, race and status, gender and sexuality, education and family background — that unite and divide the persons who populate financial markets.
While refusing to "re-embed" finance in some overarching social domain, Godechot's work nonetheless reminds us of the interrelational dispositions and subject positions of the actors who — alongside and interwoven with technological prostheses, systems for accounting and payment, legal and institutional architectures — make the markets. For a field that still, at times, takes financial calculation for granted, it remains important to remember that the seeming neutrality of the particular knowledges that ground such calculation is itself a product of patterned relations of power and privilege. Indeed, much of what Godechot describes is about a struggle not only to find a way to turn a profit — the pragmatic experimentation with "winning strategies" — but also to validate one's chosen method in the eyes of others.
This is a classic — dare I say it? — social problem, one that has occupied anthropologists since Malinowski's observations of the role of prestige in Trobriand Islanders' battles over kula valuables and political economists since Adam Smith wrung the discipline's first questions out of a moral philosophy concerned with how others judged — valued and evaluated — one's actions. Such contests are sites of political struggle between persons who are formed and informed by the histories Godechot is at pains to account for. Perhaps it is time that we return to these foundational questions, now fortified with the lessons of the sociotechnical and the performative.