text:
Clapham Junction Action Group Report to the Planning Committee
by Kate Williams
The Clapham Junction Action Group has published its report to the Planning Officer on Metro's Revised Plans. The aim of our report is to ensure that the views of the community are properly represented and summarised, and we have therefore conducted a detailed review not only of Metro's proposals, but also of the hundreds of letters published on Wandworth Council's website. The letters of objection greatly outnumber those in support, and whilst the former are detailed with reasons given as to why the proposals should be rejected, the 'letters' of support are mostly in response to the developers' postcard campaign or are in identical terms copied to the developers' PR agents. Campaigns such as this do not call for reasoned arguments and as one local resident put it:
"I am aware that whilst residents have been sent questionnaires asking for views on the improvements needed at the station … I do not recall one asking for confirmation of agreement to a 42 storey tower. It is therefore misleading to state that the development has incorporated meaningful consultation."
You can read the full report here (click to download), and read Metro's summary of its revised proposals for the station improvements (which is published in seven parts) by following the links below:
Station improvement proposals – part1
Summary of CJAG's Report
Whilst the full submission from Metro consists of many hundreds of pages, it is clear that very little has changed since its original application. The proposal still contains plans for two 42 storey towers, and a 23,000m2 shopping centre to compete with local shops.
CJAG's main objection is to the appearance of the development and its lack of any human scale. Our report refers to planning guidelines which require tall buildings to be in context to the local environment and take account of the character of the area. MSF's plans, by contrast, compete so violently with the surrounding area as to overwhelm and change its character entirely. The small footprint of the site is set to be developed beyond its reasonable capacity with the addition of 556 new flats and 23,000m2 of retail space, representing an urban density far in excess of anything that exists currently within over a mile of the site.
No independent analysis appears to have been commissioned on the impact of the towers on protected viewing corridors, and it is clear that their prominent location on the crest of the London Escarpment means that they would be highly visible from all parts of Battersea and most parts of London.
Our report draws on the overwhelming opposition within the community (615 objections on Wandsworth Council's site (up to 23rd April)). Notwithstanding the Council's policy on tall buildings (which CJAG believes should be reconsidered), the Council has a duty to take these objections into account and consider this to be the predominant case for rejection of the current proposals.
In addition, there are a great many other reasons why Metro's proposals should be rejected when they are considered by the Council's Planning Committee on 20th May. These include:
Loss of Amenity:
Clapham Junction Station: Metro's plans for Clapham Junction station do not go anywhere near far enough, and may result in a situation worse than at present. Metro's 'improvements' concern only the entrances to the station and do not impact on the problems of access to or overcrowding of the platforms. Nor do they create any extra capacity within the station: instead, the plan is simply to reverse the present situation whereby local people enter the station via the underpass, whilst those changing trains are directed to the over-pass. Placed in context, it is apparent that the gain to local residents is minimal and that if real improvements are to be made, we must look elsewhere.
Walking Distances: Metro has produced no evidence to back up its claim that the majority of station users will enjoy reduced walking distances to the station. In fact, when waling distances across the much longer over-bridge are taken into account, most travellers will have further to go to catch their trains.
Bus Facilities: At present, Metro's proposals relating to bus facilities extends only so far as suggesting the relocation of a number of bus stops to bring them closer to the new station entrances. Although it now appears that Network Rail will provide a modicum of additional space for an integrated bus interchange in Grant Road, this relies upon future development and funding by the Council and TfL. An integrated bus/train interchange facility should be central to any plan to redevelop the site and not 'parked' for future consideration.
Traffic: Metro's claims are entirely contradictory. If the development is to attract shoppers who are currently shopping outside of Clapham Junction town centre, then it is obvious that there will be an increase in traffic around the site. It appears extremely naïve to assume that a huge new shopping centre can be built, but that this will generate no significant increase in traffic or pressure on town centre car parking spaces.
Parking: Metro base their parking proposals on two assumptions, both of which are flawed. First, they state that restrictions on local street parking 'will ensure' that visitors do not use residential bays. This is incorrect. The majority of local parking allows for visitors to 'pay and display' on meters which allow for up to two hours. Second, Metro support their case by reference to vacant spaces in car parks owned or operated by Asda, LidL and Boots. We have spoken with the managers of each of these outlets and understand that none has been consulted about these proposals. Furthermore, they would object most strongly if shoppers were to use their facilities to shop elsewhere.
Medical Facilities: Initially Metro proposed to include an additional medical surgery within the development. It has since transpired, following a highly embarrassing letter from the Primary Care Trust, that this is to be a private medical facility and that Metro made no efforts to consult with the PCT regarding local needs.
Schools: Metro consider that there is plenty of capacity in local schools. In fact the issue of school places (particularly at reception and secondary school level) is of extreme concern to local people.
Retail Impact
The proposed retail development is considered to be unnecessary and having the potential to overwhelm the existing retail centres on St John's Road and Northcote Road with numbers of predominantly chain outlets. Northcote Road currently enjoys a status as London's most popular shopping street, whilst St John's Road is attracting new 'status' outlets all the time. The area enjoys a wide range of shopping from cheap discount outlets right through to expensive boutiques, high quality independent food shops and a department store. No fewer than 7 supermarkets currently operate in the immediate vicinity.
It is therefore difficult to see what case can be made for such extensive additional retail provision at Clapham Junction. No independent retail capacity study appears to have been carried out. Metro's own Retail Impact Assessment does not adequately demonstrate that the proposed shopping centre development would not cause further detriment on the vitality of the existing shopping and local market areas within St Johns Hill, Battersea Rise, Northcote Road and Battersea High Street – providing competition with these local retail centres and re-aligning pedestrian movements away from the principal cross-roads, discouraging movement in to Northcote Road.
Loss of Jobs and Failed Opportunity for Business
Metro's proposal involves the compulsory purchase of offices belonging to the only significant office employer in the area, the Public and Commercial Sector Union (PCS). With such great accessibility to Central London, both airports, and the highly skilled and qualified workforce of South West London and Surrey, this location could easily attract a major international company as an occupier, lifting up the business profile of Wandsworth as a whole. The scheme completely fails to take full advantage of the site location, and in doing so represents an irreversible blight on that opportunity.
Inadequacy of Section 106 Commitments
Since the current station is set to be destroyed, it can be no part of Metro's Section 106 commitments that a new station will be provided. These matters should be discounted and other Section 106 commitments required. A sizeable provision of affordable housing, in line with Wandsworth's Council's guidelines should be committed. Provision of affordable housing might to some extent, alleviate the demographic impact of starter homes for executives and buy-to-let investments being the sole focus of the site.
Insufficient affordable space in Clapham Junction also presents an issue for supporting more arts and creative industries in the area; essential for incubating independent trade and providing the context to create more cultural activity in the area. This would be important for creating a town centre with a point of difference.
[more information on section106 here]
Wind tunnelling
Metro's wind tunnelling analysis considers insufficient locations on the station platforms, but demonstrates that in two out of the four locations measured, wind conditions are considered to be 'unacceptable'. Unacceptable conditions will also be felt on the cross roads outsider the Falcon Pub and Arding and Hobbs. This situation is completely insupportable. One has only to visit Canary Wharf to experience the effects of wind tunnelling. On raw winter days the effects are miserable, and barely less so at other times of the year.
Disruption and Planning Blight
Whilst Metro has not seen fit to comment on the viability of the scheme under the present economic climate, it is noted that the Council does not consider that the development is likely to proceed in the near future. This matter will blight properties in the area for the foreseeable future. In addition, it is not at all clear whether present proposals including the Exemplar Scheme, South West Trains' proposal to open a third entrance to Clapham Junction Station and plans for a further medical facility in the area, will proceed if the scheme is approved. These much needed improvements would be of real and immediate benefit and should not be put on hold pending a highly speculative development which may not proceed at all.
It is simply not sensible to approve an application which has no economic viability in the near future, and far more sensible to consider such proposals at times when they are more likely to proceed immediately. Such an approach would limit the impact on local residents, whilst allowing time for alternative and more popular proposals to emerge.
What is called for is a complete rethink of the strategy for Clapham Junction and the uses that the site might best be put to. Given the hiatus which exists as a result of the present economic climate, there may well be an unprecedented opportunity now to do so. Whatever plans emerge from such a process should be sympathetic in scale and directed to the needs of the local community. They should take as their starting point the creation of a proper station that reflects Clapham Junction's strategic importance, the benefits of local work opportunities, and the need for affordable homes.
At the present time, however, the Council has a duty to reject Metro's proposal for all of the reasons stated above. The community has spoken in unprecedented numbers and their views deserve to be recognised.
Tall buildings and planning policy – Martin Linton
Overshadowing
Clapham Junction Action Group co-founder.
Dual qualified as a solicitor and barrister, and has 20 years' experience negotiating contracts and specialising in construction law and disputes. She lived in Clapham Junction area for 10 years and is now based in the UAE.
NORTHCOTE WARD E-bulletin May 2009
Planning Committee Meeting 20 May 2009
Jack Wallington says:
This is very interesting – thank-you for the article. I wrote about the proposed towers on my site http://www.loveclapham.com, but I had no idea of the extent or background. If you want to use my site to spread your message, please let me know.
Jack> I left a comment on the scheme regarding the hotel 155 Falcon Road. I rather disagree with your statement finding it: "a state of the art hotel" and will go through the plan later (with the poor information available – as once again the residents are the last to know).
Reader have to remember that originally the scheme for the station was made of 3 towers. Following some "protest" it was reduced to to… and it seems the left over just crossed the street… not really appealling.
The future of the project will much depend on the decision of hte Clapham Juncuion station redevelopment. However, with the huge opposition on tall buildings it will be difficult to explain that a tall building in 155 Falcon Road is acceptable, but a tall building 5 yards further, accross the road, is not.
I did not find your article on the scheme for Clapham Junction on your site (very well designed by the way!).
You can write something about it using our leaflets:
http://towerscj.wordpress.com/2009/04/28/leaflet-distribution-2/
http://towerscj.wordpress.com/2008/12/18/leaflet-distribution/
and of course feel free to use all the material of this website.
You have another example of a development in Clapham Junction here:
http://towerscj.wordpress.com/2009/02/17/another-redevelopment-in-clapham-junction/
architecturerosemont says:
See my comments on the http://www.loveclapham.com website regarding the extensive consulation that has already taken place on the hotel project since November 2007, including a public presentation to the Clapham Junction Town Centre Partnership and two exhibition days in April 2008.
The hotel at 155 Falcon Road has been designed carefully to meet the perceived demand (after careful research) for a town centre hotel on this site. There is very well established demand for such a hotel and this is likely to increase after recent announcements on the East London Line and the Borough's new diplomatic quarter.
The location of the proposed hotel offers connections with public transport unequalled in any other existing or proposed hotel in the area. In addition the hotel is designed to be at the more affordable end of the market. Informed opinion is that this is the right product on the right site.
Could I please correct Mr Richert's statement that a hotel is proposed at 155 Mossbury Road. I assume that this is a typographic error.
Readers may wish to see our own blog at http://www.newhotelclaphamjunction.wordpress.com which also gives details of the planning application numbers. The full design rationale of the hotel scheme may be seen in the Design and Access Statement on the Wandsworth Council website
architecturerosemont> I replied on the http://www.loveclapham.com website regarding your statement about the extensive consultation. For the readers, I will copy below this part.
As a resident of Mossbury Road, I have not received any information (nor my neighbours I checked with). The usage of "extension consultation" is therefore unappropriate. There is a possibility that the consultation happened in other places (such as Wandsworth town) and you missed the close vicinity for some reason though.
However if you provide me with all the information regarding your plan, it will help to draft our article on the scheme, rather than using the few information available here and there. I will of course pay a specific attention to your website, that I have added in our list of links for the debate.
As a resident, should an application been logged, the Council has the obligation to inform. This has clearly not been done. Do you know why?
Regarding your statement "The hotel at 155 Falcon Road has been designed carefully to meet the perceived demand (after careful research) for a town centre hotel on this site.", this is what the designers of the two 42 storey skyscapers accross the street have replied too. However I think we have shown, along with the planning officer, that a lot of concerns were raised.
PS the mention of 155 Mossbury was my mistake of course, as the building's address is 155 Falcon Rd. I corrected in my comment.
Kate Williams says:
Hello Jack, thank you very much for your comments on the article. Yes of course we would be very pleased if you would use your site to give the issue further publicity and please do feel free to copy both the article and the long submission which it is linked to.
Regarding the hotel proposal, I will reserve judgment for the time being as the proposals have only gone up on Wandsworth's website today and do not appear to be downloading successfully yet. However, I should be very interested to hear from Rosemont architects about the developers' plans for further consultation. I note that leaflets were apparently distributed but am quite sure I did not receive one in Barnard Road – less than 200 yards from the proposed site. In general I would be in favour of a hotel in the area, which does at least create opportunities for local business and jobs. However, once again the scale of what is proposed is worrying. If the twin towers do not go ahead, then it will be by far the tallest building south of the tracks. If they do, then it appears only a short time before Clapham Junction will resemble Croydon with clusters of tall buildings. Whatever next?
We have to stand by our statement that extensive consultation took place on the hotel project for 155 Falcon Road.
This commenced with the public presentation of the first draft project at the Clapham Junction Town Centre Partnership in November 2007. Such meetings are advertised by the Council and are attended by a full range of local residents, businesses, organisations etc.
Later and after modifications to the scheme a director of the applicant company and his secretary personally hand delivered invitations to the April 2008 public exhibitions to all letter boxes in Mossbury Road and to other local addresses including businesses. The public exhibition was held on two occasions to allow people a choice. Quite a few residents and others attended and their names were recorded as a visitor's book was signed.
Since then the hotel design has been changed and refined in response to the comments raised. The applicants and the designers recognise the need for public participation in the process.
There is a very large amount of information relating to the application and we think it best if all the information is seen before comments are made, rather than knee jerk reactions based on your own statement that you have not seen all the information. The information should be freely available from Wandsworth Council. Please contact them if you are unable to access the information. We know that the applications have been registered.
With regard to the demand for a hotel we have submitted a full analysis with the application. Much of such analysis is available from The Mayor for London.
We would also like to clarify that the hotel application has no connection at all with the station application. The hotel applicant is a family business that has been active locally for many years.
As I said, in the next days, I will try to draft an article on the subject on this website.
With the interest raised here, surely we will have the opportunity to carry on with the debate.
Albeit you state that there is no link with the station application, the decision of that scheme will surely have consequences in the vicinity.
… hopefully only a few days to wait.
I would really hope that the debate about the hotel project should be totally separate from the debate about Clapham Junction Station.
Maybe you should set up a separate website to assist clarity of debate. Of course starting a website with your own opinion doesn't definitively mean that there is openess of debate.
At the end of the day the debate that matters is that of the elected councillors on the planning applications sub committee.
Kate Williams has at least indicated support for a hotel use. She is not the first to do so; in fact as we haven't found anybody against the principle of a hotel here.
Personally I would have grave misgivings about entering into a debate on a website already apparently giving an opinion that is "No to towers etc……." as it starts by lumping in two 42 storey buildings on higher ground with a single 16 storey and slimmer building on lower ground. Hopefully when you get into the detail of the application and understand some of the design rationale things will be seen differently.
If there is to be a debate about the hotel project we would therefore argue that it should not be on the coat tails of opinions already formed on any other project.
In our opinion the debate must also take on board the issue of regeneration as well as architecture. In today's climate securing the delivery of real regeneration is difficult, but all the adopted planning and economic policies for the area recognise that they must go together. Such policies were themselves adopted after very extensive consultation by the Council. Wandsworth Council is known for the rigour of its consultation processes and in the past established local partnerships have achieved great successes in this field.
Clapham Junction has a town centre partnership for this reason, and that is why they were our first consultee on the hotel project. The consultation process continues.
I am happy to hear that "The consultation process continues." When I look at the debate around Nine Elms and the future of Battersea Power station, it looks (at first impression) as if eventually a better deal was possible to achieve for everyone.
I am not opposed to hotels in the neighbourhood either, and actually welcome favourably the facilities for business. However I would argue that any development in the vicinity should consider the environment and surrounding area, keeping in mind the guidance provided in PPG15 (Local highway and planning authorities should take great care to avoid or minimise impacts on the various elements of the historic environment and their settings).
http://towerscj.wordpress.com/2009/05/01/tall-buildings-and-planning-policy-martin-linton/
As Kate mentioned, should we consider this scheme in the current area, this would be the tallest building this side of the railway, overwhelming the current iconic Arding&Hobbs and Falcon pub buildings, which define the character of the Junction.
The applicants and their professional team are of course well aware of PPG15 and have considered the requirements of that in making the proposal that has been submitted for consent. We agree that care needs to be taken in Conservation Areas and when you eventually read the design rationale we hope that you will at least see that we have done so.
We certainly don't agree that our proposal will "overwhelm" the Arding and Hobbs and Falcon buildings, both unadjacent.
It should be noted that the current guise of Arding and Hobbs is not what was originally built on the site and it's later rather exuberant rococo corner is in fact rather different to the general design of buildings in the town centre. Similarly the "Fitness First" building is not typical either. Infact when you look around while there is a general character there is considerable diversity, especially in the existing unsatisfactory buildings in Falcon Road.
One of the beauties of English town centres is the considerable diversity which also adds to the vitality. One could therefore argue that a slavish extension of the more typical characteristics of the Conservation Area to Falcon Road simply wasted the opportunity given by the site.
We know that the hotel application if built would be the tallest building south of the railway. However the final scheme at the station needs to be agreed, and the hotel proposal needs to be seen in the overall context, including that of buildings to the north which you have acknowledged are already at least 16 stories. The Design and Access Statement shows that this has also been considered in arriving at the applications submitted.
James Samuelson says:
2 very different views there.
As a local resident I'll just put in my thoughts.
The towers in the falcon road estate can not really be seen from the key approach roads into Clapham Junction so in effect to anyone not approaching from the north are not there. When you do see them at the top of St Johns hill I agree they are already there and are, in anyone's view, quite an overwhelming eyesore. I think they should be a great example of what should never be done again and they are no way near 42 stories.
A 42 story building in the centre of the city is a bold statement of the intention to be a key financial and business centre. This is not appropriate for other areas and especially not for residential areas.
The argument about an overall context is a little flawed. Just because a taller building comes along which is really bad doesn't mean one a few floors smaller is appropriate.
Would an argument like that in court when being on trial for speeding stand up "I know I was doing 105 in a 70 but the guy behind me was doing 120"? Can't imagine any judge saying "fair point..sorry for keeping you". Inappropriate is inappropriate whatever the context. Yes if the majority of buildings in the area are 30-40 stories as in Canary wharf but that is not the case in the south Falcon and Northcote region.


CONAKRY, July 17 (Reuters) - Guinea deployed security forces to towns in the southeast on Wednesday in a bid to stem three days of ethnic violence in the West African country in which at least 17 people have been killed, officials said.
Guinea's second city of Nzerekore and the surrounding region near the border with Ivory Coast have been gripped by clashes between local communities after a man accused of being a thief was lynched on Sunday.
Government spokesman Damantang Albert Camara said the toll rose to 17 after a death was reported on Wednesday in Beyla, a town near Nzerekore. About 90 people have been injured, he said.
"We fear that this toll will rise," Camara added.
After several days of fighting between ethnic gangs, residents said security forces arrived in Nzerekore, Beyla and nearby Koule, where the initial killing took place.
"The soldiers are trying to stop people from leaving their homes so they can try to control the situation," Nzerekore resident Ousmane Balde told Reuters.
The violence came shortly after Guinea's rival political parties agreed to hold legislative elections on Sept. 24 after months of deadlock and street protests, which often degenerated into ethnic clashes.
The poll is meant to be the final step in the return to civilian rule after a 2008 coup.
President Alpha Conde won a 2010 presidential election but his rivals accuse him of seeking to rig the legislative vote. Conde draws support from Guinea's second-largest ethnic group, the Malinke, while the opposition is backed by the Peul, who account for around 40 percent of the population.


Moss Chemists, Dispensing chemists, listed under "Dispensing Chemists" category, is located at 3-5 The Centre Colchester Essex, CO5 0HF, United Kingdom and can be reached by (01621) 815432 phone number. Moss Chemists has currently 0 reviews.
Browse all Dispensing Chemists in Colchester Essex.


text:
CannyInsights.com > News > 2021 > Iceland's new convenience format makes a Swift impact
Under normal circumstances, the opening of a brand-new grocery concept would have analysts and journalists flocking, Amazon Fresh style, to the launch.
However, these aren't normal times, and Iceland's choice of Newcastle for the unveiling of its first Swift convenience store yesterday meant that retail observers were well outnumbered by real customers.
It's fairly rare that the North East is the site of a new retail format, so it was a pleasure and a novelty to be one of the first analysts on the scene, making the short hop across the Tyne from Gateshead – while suitably masked and distanced, of course.
Swift sits within a suburban parade on a busy road
On the face of it, Newcastle's Benton Road is an unprepossessing location for the launch of a brand-new retail fascia. The store sits in an unremarkable 1930s parade, serving a residential community that straddles High Heaton in Newcastle, and the neighbouring areas of Benton and Longbenton across the border in North Tyneside.
Meanwhile, the store itself – converted from a long-established Iceland – is, at 1,700 sq ft, the smallest in the company's entire 1,000-strong estate. It wasn't an obviously well-loved store, either – as recently as 2010, it was still bearing the old-style logo that the company had retired a decade earlier.
Look a little deeper, though, and the appeal of this location for a new retail concept becomes more obvious. As Matt Downes, Iceland's Head of Format Development told me, Four Lane Ends might be the chain's smallest store, but traffic monitoring had revealed that it was the 33rd busiest in terms of passing vehicles.
Combine that with a hospital and HMRC campus up the road, a major transport interchange nearby, plenty of free parking in front of the shopping parade, and that large residential catchment, and the rationale for a modern convenience store here makes sense.
Equally, the presence of full-size Farmfoods and Heron stores at Longbenton's main shopping centre, less than a mile away, surely reinforced the case for this mini-Iceland's reinvention.
The Swift brand is bold and modern
Iceland HQ had clearly gone to town with the promotion of the new store – Swift posters adorned every available space at Four Lane Ends Metro station, with further banners and bollard sleeves in the vicinity of the store itself.
https://www.cannyinsights.com/wp-content/uploads/2022/03/swift_four_lane_ends_station.mp4
The brand looks really good too – the Swift logo is bold and hard to miss, while the blue and yellow colour scheme looks fresh, modern and appealing. Finally, the frontage is framed by light-blue tiles, a stylistic device that continues inside the store.
On Twitter, some wags have argued that the new store's name and styling could make people think it was a bike repair shop rather than a grocery store, and questioned why Iceland had chosen an entirely new brand rather than a Local or Express-style suffix. Certainly, as with any new fascia, there will be work to do in building brand recognition – though, judging from the local advertising blitz, Iceland has that one nailed.
Meanwhile, it's clear that Swift is much more than just a mini-Iceland – certainly not the local delivery hub that some had envisaged from the name, but instead a viable and interesting convenience store operation that includes some of Iceland's best bits alongside a much broader offer.
As you would expect from a convenience store, the new opening hours – from 7am to 10pm, seven days a week – are also now much extended compared to when it was Iceland.
Instore welcome
Instore messaging at Swift
Alongside the requisite hand sanitiser, the entrance to Swift is bright and welcoming, with the logo and store's location set against a darker tiled background, and a poster that pushes Swift's "Fast – Fresh – Local" messaging. The "We Love North Tyneside" image, against a picture that is obviously Newcastle Quayside, is clearly designed to cover all bases of the store's border-straddling location.
At the entrance, customers are also introduced to the shop's colour-coded categories – from bright green for "Fruit & Veg" to dark pink for "Beer & Wine" – which are carried through in both the handy and visible high-level signage, and the shelf-edge labels throughout the store.
Chilled aisle at Swift
It's no mean feat that Swift has managed to double the former Iceland's store range – from 1,500 lines to 3,000 – without making the space feel overwhelmed.
The most obvious change is the new vertical fridge and freezer cabinets that replace the old chest freezers, and the tweaking of the layout to squeeze in an extra aisle. From a practical point of view right now, this makes it a little challenging to pass someone in an aisle while maintaining social distancing, but customers will no doubt be asked to wait outside if there is ever a time when the store risks getting too crowded. Certainly, the 12-strong team – all of whom have transferred from the former Iceland – seemed to be on the money in helping customers and greeting them like old friends.
https://www.cannyinsights.com/wp-content/uploads/2022/03/swift_walkthrough_01.mp4
Aesthetically, the store also looks impressive. As well as the tiling throughout, which ties everything together and gives the shop a classy feel, the crisp lighting and dark finishes to the fixtures all convey a look that is modern and smart. Only the supermarket-standard speckled floor tiles, which look to be inherited from the former Iceland, are a slight disappointment, though customers will likely be too interested in their shopping to pay too much attention to where they are walking.
One of Swift's most interesting innovations is the way it has merchandised key ranges by product type rather than, as is more traditional, separating frozen from chilled. So, in other words, if you want pies, the frozen and chilled versions are next to each other in adjacent cabinets, with the colour-coded shelf-edge labels signposting which is which. It's a logical approach – after all, a customer heading to a convenience store is likely going there with a particular meal in mind for later that day, so finding the right foodstuff is arguably more important than where that product is stored.
Elsewhere, tobacco products are stowed away in the kiosk at the front of the store, and there is also a small selection of greetings cards. Newspapers and magazines are not stocked, though.
Greggs cabinet inside Swift
At the back of the store, eyecatching Greggs and TGI Fridays cabinets continue two of the partnerships that Iceland has become known for in its eponymous stores, while the convenience retailer staple of the Costa Express machine is present and correct. Again, placing the high-level Costa Express logo against the tiled background that runs throughout the store does a surprisingly effective job of unifying different logotypes.
As you would expect, Swift also makes an effort to help the customer shop by highlighting various meal deals. The "Meal for 2" promo – comprising two Iceland pizzas, a tub of Ben & Jerry's ice cream, and either beer, wine or Shloer – is eye-catching value for £8. Meanwhile, positioned at the front of the store by the tills, the "On the Go!" offer – featuring a sandwich, snack and drink for £3.50 – seems intended to hook in all that passing traffic that was mentioned.
Interestingly, quite a few customers were coming into the store expecting to be able to buy hot breakfasts and lunches – a misreading, perhaps, of a headline used in the local press. Still, if Iceland wants to consider competing more squarely with the nearby Greggs, it perhaps represents an opportunity for future range expansion.
"Don't miss deals" near the store entrance
One obvious question is whether Swift, as a convenience concept, means that customers are now paying more than they used to when the store was Iceland. Matt Downes' answer was a clear "no" – most prices are the same as in a regular Iceland store, while some are a little more, and some even a little cheaper, depending on the local competitor situation.
In a location like Four Lane Ends – where Today's Local and Tesco Express have established shops just a few doors away – this price competitiveness is likely to stand Swift in good stead, especially where customers already know and trust the Iceland own-brands that Swift stocks.
Matt Downes was also clear that Swift will not be a store that is awash with offers. The shelf ends nearest the entrance feature some "Don't Miss Deals" – currently Easter themed – but the focus, much like Iceland, will be on offering what he described as "great value" all year round.
Swift has a manned kiosk alongside self-serve checkouts
Contrary to some expectations in advance of the opening, Swift certainly isn't Iceland's answer to Amazon Fresh – and it's unlikely that such a concept would be entirely welcomed in a community that seems to include a lot of older residents, and where shoppers were clearly delighted to catch up with the friendly instore team after the shop's four-week makeover.
Equally, there's no attempt here to bring in other tech that is often talked about, but less rarely implemented, in UK grocery retail, such as electronic shelf-edge labels.
The introduction of two self-scan tills alongside one manned kiosk – replacing the three manned tills in the old store – is just about as techy as it gets. Swift, clearly, is about being the best "fast, fresh and local" convenience store it can be, not a hotbed for tech innovation or new modes of delivery.
Where will Swift love next?
The obvious question is whether this first Swift is likely to be a one-off experiment or the start of something bigger.
Iceland's own press release about the launch teases the latter, pointing out that the company's "last 'one store trial' of a new store format was The Food Warehouse in 2014 and we now have 140 stores". Iceland's MD, Richard Walker, goes on to suggest that, if successful, "there is potential to expand it both within the existing Iceland store estate and beyond to expand our existing network of stores". In other words, Swift could represent a new way to not only maximise the impact of smaller Iceland stores like Four Lane Ends, but also to give the company a toehold in new locations not suitable for a full-size Iceland or Food Warehouse.
Matt Downes, who is the brains behind the Swift format, was perhaps a little more cautious. He told me: "There is an opportunity to think about how we grow in a smaller unit, but first we have got to see if customers like it. Only then will we make a decision on more".
So, based on the overwhelmingly positive feedback from customers on the opening day, and the overall strength and appeal of this new convenience format, don't be surprised if we yet see a rollout beyond Newcastle that is Swift in both name and nature.
All photographs and videos by Graham Soult
Category : 2021, News, Soult's Retail View Convenience Stores, Four Lane Ends, Iceland, Longbenton, Matt Downes, Newcastle, Supermarkets, Swift
← High streets without toilets could loos business
The Shape of the Future High Street: Speech by Graham Soult to The Clothworkers' Company Court & Livery Dinner, 20 July 2021 →
One thought on "Iceland's new convenience format makes a Swift impact"
Pingback: Retail Week Live 2022: The five speakers we're most excited about at #RWL2022 - CannyInsights.com
Got something to add? Post a comment
This plain-English explainer looks at what's going on with the High Streets Task Force, Future High Streets Fund and Towns Fund, and how they are different. Read more...

redpajama_set_name: RedPajamaCommonCrawl


Despite concerted attention drawn to the Anacostia River during the "Year of the Anacostia," we are paying its climate impacts no mind. DC is likely to see record flooding by 2040. Already, the Potomac and Anacostia Rivers have risen roughly 11 inches in the past century, putting thousands of residents at risk.
Earlier this week, Chairman Mendelson introduced a bill that would increase the District's Renewable Portfolio Standard (RPS) for clean electricity to 100% by 2050. First enacted in 2005 and expanded in 2016, the Renewable Portfolio Standard applies to all retail electricity sales in the District.
Although the Renewable Portfolio Standard has been instrumental in reducing carbon emissions in the District, a 100% by 2050 RPS policy alone will not help the District achieve its 2032 climate and energy goals. Its shortfalls are many but principally twofold.
First, the Sustainable DC Plan sets a goal for the District to reduce climate pollution 50% below 2006 levels by 2032 and 80% by 2050. We are not on track to meet either target, but Chairman Mendelson's RPS bill does nothing in the short-term to curb District energy use. It would not take effect until 2033.
Second, the Renewable Portfolio Standard only applies to electricity. A 100% by 2050 RPS 'fix' does nothing to address climate pollution from transportation and other fossil-fuel bases sources in DC, including gas and home heating oil. To call that a glaring omission would be the understatement of the week.
Vehicular emissions alone account for nearly a quarter of greenhouse gas emissions in the District, and EPA Administrator Scott Pruitt's decision last month to roll back fuel-efficiency targets for 2022-2025 (so-called "CAFE standards") means higher than forecasted tailpipe emissions are on their way to the District.
All of this is to say that any real, concrete, and inclusive policy that will take us closer to achieving carbon neutrality must be comprehensive, and Chairman Mendelson's 100% by 2050 RPS plan is not.
While a strengthened RPS can and should be pursued, without comprehensive and equitable carbon pricing we will not be able to substantively close the gap on our 2032 goals.
A carbon fee-and-rebate policy is both intuitive in practice and implementation. District residents pay to send their trash to landfills. Putting a price on carbon simply mandates that corporations who pollute the air do the same. After all, it's only fair.
This carbon fee-and-rebate already has broad support from over 70 local businesses and advocacy organizations here in the District. Since the fall of 2015, the "Put a Price on It Coalition" has worked closely with hundreds of business and community leaders as well as thousands of District residents to develop a detailed legislative proposal.
Under the coalition's proposal, carbon would be taxed at a rate of $20 per ton beginning in 2019 – bringing in an additional $196 million in revenue to DC – and moving up to $150 per ton in 2032.
Seventy-five percent of this money would be rebated to DC residents. This is especially important because it is essential we protect low-income residents, who often have a smaller carbon footprint than average, from increased energy costs and prevent the policy from becoming regressive. The other twenty-five percent of revenue would be returned to the community via investments in green infrastructure and tax credits for local businesses.
In an era in which President Trump and opponents in Congress seek to institutionalize climate denial, Washington, D.C. – our nation's capital – has a unique chance to lead.
We appreciate the intent of Chairman Mendelson's bill and commend the vision of a 100% renewable energy future by 2050. But we also need to drastically reduce carbon emissions right now. We also must ensure that DC's low-income residents are protected in the transition to a clean energy economy. We know that a comprehensive carbon price would not only help DC achieve its climate goals but would set a shining example for other states considering their own carbon prices across the country.
Chairman Mendelson has repeatedly said that the "District of Columbia takes seriously the critical issue of climate change." It's time to get serious by taking serious action right now.


text:
Join our email listservs
Maryknoll Office for Global Concerns
Representing Maryknoll Fathers & Brothers, Maryknoll Sisters, and Maryknoll Lay Missioners
F-E-E
NewsNotes
Middle East Notes
Home » Our focus
Maryknoll missioners around the world feel the impact of social injustice and see its effects in the communities were they live and work. Flowing from their ministries of presence and accompaniment, as well as from the concrete programs and projects in which Maryknollers participate, we engage in the hard work of identifying root causes of social and economic injustice. With a particular focus on the geographical regions where Maryknoll is present, as well as on structural or systemic injustice affecting women, children, indigenous peoples, migrants and refugees and people with HIV and AIDS, we join with others of like mind to identify potential pathways to social transformation and to move our world in that direction.
Faith Leaders Call on Congress to Certify Election Results
The Maryknoll Office for Global Concerns signed a public letter calling for Congress to fulfill its legal duty to confirm the U.S. presidential election results on January 6, 2021.
Read more about Faith Leaders Call on Congress to Certify Election Results
Ramos v. Wolf Decision Permits a 'Moral Failure' in TPS Termination
The Maryknoll Office for Global Concerns issued the following statement on September 15, 2020, regarding the Ninth Circuit Court's decision to allow for the termination of TPS for four countries.
Read more about Ramos v. Wolf Decision Permits a 'Moral Failure' in TPS Termination
Catholic Leaders Statement in Support of Free the Families and End Family Detention
Statement calling for the immediate release of children and their parents from immigrant detention centers.
Read more about Catholic Leaders Statement in Support of Free the Families and End Family Detention
Catholic Leaders Call to Free the Families and End Family Detention
Children need to be released from detention immediately and they need to be released with their parents.
Read more about Catholic Leaders Call to Free the Families and End Family Detention
DACA Recipients Can Dream On
The Maryknoll Office for Global Concerns issued the following statement on June 18, 2020, in response to the Supreme Court's decision to uphold the Deferred Action for Childhood Arrivals (DACA) program.
Read more about DACA Recipients Can Dream On
A Call for Anti-Racist Transformation in the United States
Maryknoll joint leadership issued the following statement on the killing of George Floyd and the need for transformation in the United States.
Read more about A Call for Anti-Racist Transformation in the United States
Public Charge Rule: Inhumane and Unfair
The following statement was released on January 29, 2020 regarding the Supreme Court's decision to uphold the changes to the public charge rule which bars immigrants who are recieving certain government benefits from gaining legal immigration status.
Read more about Public Charge Rule: Inhumane and Unfair
First Anniversary of the Death of Jakelin Caal Maquin
The Maryknoll Office for Global Concerns remembers Jakelin and calls on the U.S. government to end the inhumane treatment of migrants.
Read more about First Anniversary of the Death of Jakelin Caal Maquin
Just peace in Bolivia requires constructive dialogue and reconciliation
The Maryknoll Office for Global Concerns released the following statement on the political crisis in Bolivia on November 27, 2019.
Read more about Just peace in Bolivia requires constructive dialogue and reconciliation
Statement on the U.S. Decision to Slash Refugee Resettlement in 2020
The plan to admit only 18,000 refugees in 2020 is a moral failure for the United States.
Read more about Statement on the U.S. Decision to Slash Refugee Resettlement in 2020
Trump Administration's Latest Actions on Central America Will Fuel Migration, Not Address It
The Maryknoll Office for Global Concerns joins over 40 U.S.-based faith, human rights, foreign policy, humanitarian, immigrant rights and border-based civil society organizations in a statement to express deep concern over the Trump Administration's latest actions on Central America including the wholesale cutoffs of assistance to Guatemala, Honduras, and El Salvador.
Read more about Trump Administration's Latest Actions on Central America Will Fuel Migration, Not Address It
No to State of Emergency on the Border, Yes to Human Rights
The Maryknoll Office for Global Concerns condemns President Trump's emergency declaration and calls on Congress to enact immigration policies that protect human rights.
Read more about No to State of Emergency on the Border, Yes to Human Rights
Facing the Crisis: A Catholic Offer of Wisdom and Courage to Congress
With great concern for the state of the U.S. democracy, eleven national and international Catholic social justice organizations sent the following statement to Congress on the occassion of Martin Luther King Day.
Read more about Facing the Crisis: A Catholic Offer of Wisdom and Courage to Congress
Civil Society calls for Protection of Human Rights in Development Interventions
The Maryknoll Office for Global Concerns joined thirty organizations calling on the U.S. government to protect human rights in development interventions.
Read more about Civil Society calls for Protection of Human Rights in Development Interventions
Faith Community to Congress: Reduce Funding for Unchecked Immigration Enforcement
The Maryknoll Office for Global Concerns joined thirty-six national, faith-based organizations calling on Congress to rein in funding for unchecked, unaccountable detention, deportation, and border enforcement policies.
Read more about Faith Community to Congress: Reduce Funding for Unchecked Immigration Enforcement
Articles, alerts, events
Zimbabwe: Church can lead healing process
In the first election in Zimbabwe since long-time leader Robert Mugabe was ousted from power, the ruling ZANU-PF party has managed to hold onto control of the presidency and Parliament. But society remains fractured.
Read more about Zimbabwe: Church can lead healing process
United Nations: Review of the 2030 Agenda
Sister Marvie L. Misolas, MM, NGO Representative to the UN for the Maryknoll Office for Global Concerns, writes about the recent review of six of the 17 sustainable development goals at the United Nations.
Read more about United Nations: Review of the 2030 Agenda
Palm oil: Thriving on collusion
This article is the second in a three-part series examining problems with palm oil production.
Read more about Palm oil: Thriving on collusion
Nicaragua: Speaking truth to power
Catherine "Kitty" Madden reports on the crisis in Nicaragua. Madden has lived and worked in Nicaragua since 1986, some of that time as a Maryknoll Lay Missioner and many years as a Maryknoll Affiliate.
Read more about Nicaragua: Speaking truth to power
Crafting the Global Compact for Migration
UN member states are scheduled to hold their last round of negotiations for the Global Compact for Migration July 9-13 with the goal of producing a final draft document for adoption at the International Migration Conference in Morocco in December.
Read more about Crafting the Global Compact for Migration
This week's reflection is written by Sr. Euphrasia Nyaki, who lives and works in João Pessoa, Brazil.
Read more about Pentecost Sunday
CIDSE, an international alliance of Catholic development agencies working together for global justice
Gapminder.org: For a fact-based world view
Infographic: The New Economy
JustFaith Ministries
On all our shoulders: A Catholic call to protect the endangered common good
© 2015 Maryknoll OGC


I am going through some sort of pre-VVC vid farr. I don't even know. DONNA.
Here from fan_eunice's rec--when someone who's as fantastic a vidder as she is says something's awesome and should be watched immediately? I hop to. And I'm glad I did. That is just indescribably gorgeous and perfect.
Oh, God. Donna. Oh, my heart.
The last 30 seconds pretty much killed me dead. I've rarely seen effects used so well, so to the point. Also! Laura Veirs! I adore her. What a fantastic song choice it is for the story you've told.
This is lovely and beautifully edited and so painful. Thank you.
Wow, perfect song for Donna and just an awesome vid.
OH god, way to make me cry.
Fabulous. Thank you SO MUCH for this.
Oh, god. I love Donna. I love her absolutely to bits, and your vid just made me cry because she's so, so awesome. God. LOVE. Seriously.
Turn left, Donna! TURN LEFT!
Here via vonnie_k, giandujakiss and about four others on the reading list.
I feel as though I should alter this icon so it says something like "you > all" because that vid brought a lump to my throat. I thought it was cut with wit and velocity and structured brilliantly, from the set-up in the first bars to Donna's narrative in the first verse, then Donna's first loss of her life in "Turn Left", then the brilliance of the final section where you use effects to show the real loss in Journey's End.
Here via giandujakiss's rec and just had to say how much this blew me away - perfect song, perfect timing and juxtaposition of clips, and it made my heart ache just a little.


Strong, sturdy and built to last, this Heavy Duty Workbench is ideal for a wide range of purposes. Featuring two chipboard shelves supported by a sturdy steel frame, you will be impressed by the workbench's high load capacity. This means you will be able to use it to work on bulky and heavy items without worrying about whether it will be up to the task.
At 15mm in thickness, you can be certain that each chipboard level should be more than robust enough for whatever task it is you have in mind. Plus, when purchasing one of our workbenches, you will be receiving a product of the highest construction quality that is made from UK manufactured steel. Delivered direct from our factory to your door, you can rest assured that any ShelvingDirect product will more than live up to your expectations.
This version also features a Louvred Back panel, designed to accommodate pick bins/TC storage boxes. This feature will make organising all your tools, materials and components as straightforward as possible. Not only that, but mounted pick bins ensure that you will have everything you need immediately accessible as you work at your workbench. These pick bins are also incredibly useful for removing clutter from your home workspaces or garage, allowing even the smallest components to be neatly organised instead of littering surfaces or rolling around loose in drawers. The panels are strong and feature reinforced corners on every Louvre which gives extra strength and durability. This is a sign of the quality of a ShelvingDirect product that many of our competitors, who sell cheap, imported products, cannot match. Assembly of your workbench is straightforward, quick and boltless, saving you time and keeping effort to a minimum. The orange and blue colour adds extra charm to the practicality of the workbench and its adjustable height bottom shelf is certain to come in handy. These attractive touches are what make this workbench great for home workshop or garage use when it is important that these spaces are just as stylish as the rest of your home. These workbenches are 937mm in height as standard to allow a flush finish between the chipboard and steel uprights. However, a range of widths and depths are available to suit your needs. Whether you work on small-scale model making projects at home, or are perhaps an amateur mechanic who tinkers with larger components, the range of sizes on offer and the load capacity of the workbench really do make it suitable for almost any purpose. A high quality product that will be right at home in your shed, workshop or garage, this workbench is a must have.


Combing through documents, I've discovered some curious things.
It seems sometime in the distant past the N'zeer were defeated and nearly all trace of them was blotted from human history and culture.
It isn't clear to me if it was a simultaneous global eradication or extinguishment, but I cannot begin to imagine how that would be accomplished: How is an idea or energy removed from the world? When I contemplate it, I summon images of the defacement of monuments and a Fahrenheit 451 type destruction of literature on a mass scale almost unimaginable in the ancient world. That having been said, the ancient world did not have the proliferation of art and literature that we are used to. Such things were contained to specific places of power. So perhaps it was easier.
I see scant evidence of armed conflict. Rather, I see evidence of what I would almost call spiritual warfare. Though, I cannot rule out the possibility that this larger trans-dimensional war was the underlying cause of Earthly conflicts.
I wish I could share more. It is absolutely fascinating. But for now I can tell you this much. As with the Shapers, there is no clear visual depiction of the N'zeer, though there are depictions of various forms of monstrous human beings and other images that defy the normal, sometimes they are terrifying. I do not get the impression that the ancient chroniclers believed that these creatures roamed our plane, moreover I believe that they were their hallucinations of the Julian Jaynes variety which interrupted the thought stream and entered our culture through memory. But I must be aware that my own cultural bias would probably prevent me from considering the alternative.
Surely were there such bizarre creatures walking the earth we would have archaeological trace of them--unless of course those traces were eradicated by the same people who redacted the historical and literary traces of the N'zeer. But I will leave you with one other thought.
Perhaps the shell of our universe is more porous than we think.


This course familiarizes students with the major concepts, frameworks, and central debates animating transgender studies scholarship and politics. In the first half of the semester, we will critically examine the term "transgender" through two units: one focused on classification and naming practices, and one focused on how different institutions -- such as medicine, law, and prisons -- produce and manage the category of transgender. The remainder of the course is dedicated to understanding transgender political critiques and related social movement work. Throughout, we will pay particular attention to questions of nationalism, citizenship, race, labor, and embodiment.


There is nothing in the Neanderthal research that has anything to do with the bigfoot phenomenon. "... we know Neanderthals and Modern humans were both very physically different, but according to the DNA evidence we would never know to what degree without fossil evidence." DNA is not used to show physical differences.
"If DNA can be so similar, nearly identical, between two species, it may be hard to distinguish Bigfoot DNA." You have no evidence for this. They obviously were able to distinguish Neanderthal from modern human DNA.
This is a type of fallacy known as special pleading. ie bigfoot gets to break all the rules. In this case, it is bigfoot's DNA that gets to be special. It can disguise itself as human DNA.
Okay seesdifferent, we respect your skepticism, but in your anxiousness to show how critical you can think you have missed our point.
1st DNA can reveal different physical traits in the biology of organisms.
3rd our point was, without a Bigfoot body, there is not much we can do with the "evidence" we may or may not have.
I see Gilgamesh is still winning fights. Some things never change.
"In recent years, fossils with both Neanderthal and modern human features have been found suggesting the two species interbred but previous scans of Neanderthal genes reveal Neanderthal DNA to have a very different make-up to modern man's."
Now, in this article, I read that "The first revelation is both DNA's, Neanderthals and Modern Humans, are nearly identical."
Before you fire anyone, please realize I am not criticizing the articles, nor impugning the journalistic integrity of the BLC. "Doin' IT" was posted in 2009, "Different Species, Identical DNA" in 2010, and in between, presumably, Science occurred, which can and does often lead to discrepancies of content in articles and posts on cutting-edge information outlets.
What interests me in this case is the possibility that both statements may actually be true...and therein lies my question. It is often said that the DNA of a chimpanzee is "nearly identical" to that of humans, the difference is some tiny fraction less than two percent. Then again, if looked at in another way, the DNA of chimps and humans are vastly different, on the order of about sixty million base pairs--that being about two percent of the total number of base pairs.
Is it possible that this is the origin of this apparent discrepancy? Simply a different perspective on what constitutes as "identical" (comparing the entire genome) or "different" (considering the amount of information that does not match)?
Disclaimer: Time travel may be impossible, do not try this at home.


text:
How to Watch Every Episode of Game of Thrones Outside the US
Lot has happened over the seven seasons of this fantasy TV series. Before the airing of the eighth one, you might want to refresh your memory about the seven kingdoms.
And for our new GoT fans who want to know the story of Mother of Dragons, here's how to watch Game of Thrones outside of the US.
This adaptation of "A Song of Ice and Fire" airs on HBO and you can catch it up online with HBO Now.
How to watch HBO online?
HBO Now is the go-to service to watch HBO online. If you already have a subscription, you are ready to watch online Game of Thrones and other fantastic content available there. Apart from the live content, you have access to their vast archives of previous TV shows. You can watch all the Game of Thrones episodes there, right from season 1.
There are many movies and also the HBO Originals which you can watch on a range of supported devices.
Not only the Android and iOS devices, but you also get HBO Now on your Amazon devices and gaming consoles, among others. Support for PC browsers is also there, and all this is for $14.99 per month.
If you haven't subscribed to it yet, you're up for a free trial. HBO offers 30-day free trial to those who subscribe to HBO Now for the first time. But if you don't want to, there are other places where you can watch Game of Thrones online.
If you don't want to subscribe to HBO Now, there are many other ways to watch Game of Thrones. You can get it through Sling TV or DirecTV and also available is the PlayStation Vue and many other TV streaming services.
Sling TV and DirecTV offer package-based live TV streaming services. There are various modular packages offering a group of TV channels, or you can buy single add-on channels.
Then there are streaming services like Hulu, Amazon Prime and PS Vue where you can find ways to watch Game of Thrones. You won't need to register a separate account.
Just pay for the subscription, and you will be able to stream HBO. The only problem is the geo-restriction. All these services mentioned above are available only to the people in the US.
There are ways though to get past this blocking. I will tell about it next but let's see the other options you have, apart from HBO.
Where can I watch Game of Thrones without HBO?
If you want to skip HBO altogether, there isn't much option. But there are streaming sites which can let you watch episodes of Game of Thrones on demand.
You can install third-party addons for Kodi to watch amazing content from all over the world including Game of Thrones. If you don't know, Kodi is a media player software.
There are many addons available for Kodi to watch almost any streaming service available around the world. You can also install PS Vue for Kodi to watch the channels you have paid for with your PS Vue account.
Then there are websites like Putlocker and 123Movies with a never ending database of movies and TV shows. They don't host the content available there but only link you to them, most (maybe all) of which are from pirated sources.
So, the regulatory agencies thus, have blocked them. But they keep coming up with new domains. I will recommend you to use VPN services before you access Putlocker, 123Movies or even Kodi. While the official ones are legal, third-party Kodi addons, at times, stream from illegal sources.
Benefits of using a VPN
VPNs offer you privacy. When you connect to a VPN server of, say, NordVPN, it encrypts the network connection. It has a robust encryption system, and with that, your activity won't link back to you.
No one will know what you are browsing, and the possible illegal streams are hidden from the spying eyes.
If you don't want to pay for the premium NordVPN service, you can get the best free VPN available. Although we recommend you to get paid VPNs for a reliable service, the free CyberGhost VPN is providing excellent service for quite some time now.
With a VPN, you also can bypass the geo-restriction we earlier talked about. Along with encryption, VPNs provides a local IP address of the server's location.
Both the NordVPN and CyberGhost has servers in the US. You can connect with them and enjoy Game of Thrones just like a US resident.
The Best VPN Services for 2020
How to Get Unbanned from Omegle
How to Install 123 movies on Kodi
ExpressVPN Review
What is Flixtor and How to Use this Streaming Service (Flixtor review)
What is Putlockers New Site 2020?


text:
Saint-Éloi es una comuna francesa, situada en el departamento de Nièvre, en la región de Borgoña.

Demografía

Referencias

Enlaces externos
 Saint-Éloi en la web del Institut géographique national
 INSEE
 Saint-Éloi en la web de Quid
 Localidades próximas a Saint-Éloi

 Plano de Saint-Éloi en Mapquest

Saint Eloi

redpajama_set_name: RedPajamaWikipedia


Find Vehicle Self Storage Near You!
Homes without adequate space for recreational vehicles, classic cars, and trailers present storage challenges for today's families. Many homeowners and apartment dwellers enjoy taking vehicles like boats and RVs out on a seasonal basis, but don't have extra room in the driveway for those vehicles in the off-season. Condos and apartments present even bigger challenges when it comes to extra parking spots and storage for vehicles that aren't used more than a few times a year.
If you're experiencing space challenges at your home and worry that you might have to sell your RV, boat, or extra vehicle, you may want to investigate storage units designed for housing vehicles of all types.
If you're not convinced self-storage is the way to go, here are some valuable benefits you will receive when you rent a storage unit or space to house your classic car, boat, RV, motorcycle, or extra vehicle.
Vehicle storage solves your space issues.
Not surprisingly, one of the biggest benefits of self-storage for vehicles is the opportunity to own extra vehicles even if you don't have room at your residence. Perhaps you live in a cozy apartment, but your landlord only provides a single space for your vehicle.
Maybe you live in a house with a small driveway where storage of more than one vehicle is impractical. Perhaps you don't have a garage that's large enough to house your RV during the off-season. Vehicle storage helps you keep your beloved classic car by giving you extra space.
What Kind of Vehicles Can I Store?
With the variety of different storage units available for lease today, you can store virtually any vehicle imaginable. It's quite popular for owners of classic cars and motorcycles to seek out storage units during the winter to house their investments, but RVs, boats, and trailers are fair game, too.
Here's just a few of the vehicles you can store in self-storage units.
Do you own a giant motorhome and live in a condo with no parking? Do you take your classic car out for cruises but store it in the winter? Do you have an extra vehicle you want to give to your child when he reaches 16? Self-storage solves your parking and storage problems.
RV storage helps you avoid HOA problems.
Traveling the countryside in an RV is a treasured activity for so many families, but RV storage can become difficult if your homeowners association has rules on vehicle size and height. Further, some city ordinances can be problematic when you have no choice but to leave your RV on the street when you're not using it.
Storage for large vehicles like boats and RVs is convenient when you don't have enough space for your vehicle, as well as to avoid the hassles of HOA rules and city rules.
Car storage keeps your possessions safe.
With features like video surveillance, secured access, and other security measures, your classic car is probably safer when it's stored in a car storage unit than when it's parked in your driveway.
If you live in a place where it freezes and snows in the winter, parking your seasonal vehicles and boats in storage keeps them protected from the weather, as well as from thieves who might want to take advantage of an unguarded vehicle.
A storage unit is an ideal location for a valuable vehicle. Over time, your car can fade, the tires might disintegrate or crack, and bird droppings might start to accumulate. Boat, RV, or trailer storage can help you make the most of your investment by keeping it in good condition for as long as possible.
Further, enclosed self-storage units are a terrific way to fight against rodents and animals that might crawl under the hood to make nests and gnaw on the wires and hoses. Finding the source of an electrical problem is a huge hassle at a mechanic's shop, so avoiding the problem entirely makes self-storage an appealing option.
Today's modern storage units are built with a variety of features, and their rising popularity has made it easy to find a unit that offers you exactly what you need. For example, you might require covered boat storage for your speedboat when you're not using it at the lake in the summer.
Or, you might need fully enclosed storage for your valuable classic car where the winter weather can't damage it and to reduce the chance that the vehicle could be stolen while parked outside your home.
Flexible leases for temporary or long-term storage.
Convenient locations in most towns around the country.
24-hour secured access with electronic gated access.
Affordable rates and specials during lease or agreement signing.
Virtually any size for any vehicle, boat, or motorcycle storage need.
When you compare facilities in your region, you can find a storage unit that matches your exact needs for size, price, and location.


Kai Clashscorn is the Renown Heart NPC found at Twin Sisters Crossing. Aid Legion and Ebon Vanguard soldiers against ogres, and she will begin offering items as a karma merchant.
It's good to see capable soldiers working together. We've got a problem with ogres, and I'm here to invite a few Ebonhawke troops to back up the legions. You got the time to help?
We're short-handed. Not the ideal situation, but joining forces with the Ebon Vanguard has helped in our battle with the ogres. But we still need any assistance you can offer.
Is there anything else I should know before I go?
The legions and Ebon Vanguard are working together, but both sides are tense. If you catch any soldiers from either side squabbling with the other, could you remind them why we're here?
Can you tell me more about the ogres?
The brutes have been relentlessly attacking Splintercrest and Foewatch. They're keen to take our land. We're determined to fight, but it seems every time we fell one ogre, two more take its place.
Anything else I should know about them?
They've set up flagstands and supply crates around Splintercrest and Foewatch. There's always an ogre or two keeping watch, but every one you destroy ruins their day just a little bit more.
You actually want humans to back you up?
Less "want" than "need." Between Steeleye Span pulling reinforcements from our ranks and our war with the ogres, we can either live with them, or die alone.
Winning is everything. I understand.
You helped to hold a fragile alliance together. Thank you, on behalf of the Vanguard and the legions.
This page was last edited on 13 July 2018, at 04:07.


The item Justifying genocide : Germany and the Armenians from Bismarck to Hitler, Stefan Ihrig represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Cleveland Public Library.
7. "Interlude of the Gods"


text:
Q: Codeigniter 3.1.4 post request not receive form-data parameter $_POST return empty value.
GET request parameter are print.
but not print POST parameter which are returned as empty.
It's working before 6 months.

A: *

*Use (Profiler in CI) :

https://codeigniter.com/user_guide/general/profiling.html

*

*check your php.ini file and comment out the following line enable_post_data_reading = Off
or set it to On
;enable_post_data_reading = Off

A: Change to http to https in a config file.base_url variable.
Example
$config['base_url'] = 'https:// example.com/';

redpajama_set_name: RedPajamaStackExchange


Students at Ardingly follow a range of IGCSE and GCSE courses which are carefully selected to provide a rigorous academic foundation from which to move on to success at IB, A Level or BTEC.
For their core GCSEs, all students will study English Language, English Literature, Mathematics and all three Sciences.
By the end of their IGCSE courses each student will have a firm understanding of their subjects, allowing them to be well prepared for the demands of the A Level, IB or BTEC courses.
Students also follow a programme of PSHE in which personal, social, health and economic educational topics are addressed both in class and through a variety of workshops delivered by external speakers. Through this we aim to equip students with the information and skills they will need to make mature, well-informed decisions for themselves both now and in the future.


text:
Q: How to pass data as intent from child activity to parent activity I have an Activity -> MasterActivity and one more Activity ChildActivity which extends from Master Activity
Now the author of Master activity is expecting some values to come with the intent and parses these in the onCreate of Master activity:
override fun onCreate(savedInstanceState: Bundle?) {
        super.onCreate(savedInstanceState)
        setContentView(R.layout.activity_view)
        origUrl = intent.getStringExtra(EXTRA_URL)
        if (origUrl == null) throw RuntimeException("did you forget to put extras?")
}

And I start the intent to my ChildActivity like:
 context?.startActivity(Intent(context, TerminationWebview::class.java).apply {
                putExtra(ChildActivity.EXTRA_URL, it)

Now the question is how do I pass this data to parent? So that parent can parse it in onCreate?
This question does not deal with returning data from an activity, it deals with passing the data to parent activity through intent and hence is not . a duplicate

A: You could do this by getting your intent data directly from the MasterActivity#onCreate
You might also want to change the tag to kotlin instead of java.


text:
Chen Kaige (; born 12 August 1952) is a Chinese film director and a leading figure of the fifth generation of Chinese cinema. His films are known for their visual flair and epic storytelling. Chen won the Palme d'Or at 1993 Cannes Film Festival and the International Federation of Film Critics (FIPRESCI) Award in 1993 for directing Farewell My Concubine.

In recent years, Chen directed the war film The Battle at Lake Changjin and its sequel with Tsui Hark and Dante Lam, with the two films characterized by his signature storytelling and made in cooperation with the Chinese Communist Party.

Early life
Chen Kaige was born in Beijing, China into a family of Changle, Fuzhou origin, and grew up with fellow Fifth Generation alumnus Tian Zhuangzhuang as a childhood friend. His father  was a well-known director in his own right. His mother Liu Yanchi () was a senior screenwriter. During the Cultural Revolution, Chen joined the Red Guards. As a teenage member of the Red Guards, Chen, like many other youths, denounced his own father, a fateful decision he eventually learned to regret. Indeed, this period of his life continues to influence much of his work today, notably in the unblinking depictions of the Cultural Revolution in Farewell My Concubine, and in the father-son relationship in Together. In 1969, Chen became a sent-down youth in Xishuangbanna Agricultural Reclamation Bureau for a short while before enlisting the People's Liberation Army (PLA) next year. In 1975, Chen was discharged from the army and returned to Beijing, where he worked as a worker in Beijing Film Printing Factory. Chen in 1978 joined the Beijing Film Academy, where he graduated in 1982 as part of the so-called Fifth Generation of Chinese filmmakers.

Directorial career
Upon graduating, Chen was assigned to the Guangxi Film Studio, along with a fellow graduate, Zhang Yimou. His first movie, Yellow Earth (1984), established itself as one of the most important works of Fifth Generation filmmaking; though simple, its powerful visual imagery (courtesy of cinematography by Zhang) and revolutionary storytelling style marked a sea change in how films were seen and perceived in the People's Republic of China. The Big Parade (1986) and King of the Children (1987) expanded on his filmic repertoire. In 1987, he was awarded a fellowship by the Asian Cultural Council and served as a visiting scholar at the New York University Film School. Early in 1989, he did further experimenting in a music video for the song "Do You Believe In Shame" by Duran Duran.  Later that year, he made Life on a String, a highly esoteric movie which uses mythical allegory and lush scenery to tell the story of a blind sanxian musician and his student. In the same year, he was a member of the jury at the 39th Berlin International Film Festival.

His most famous film in the West, Farewell My Concubine (1993), nominated for two Academy Awards and winner of the Palme d'Or at 1993 Cannes Film Festival, follows two Beijing opera stars through decades of change in China during the twentieth century.  Chen followed up the unprecedented success of Farewell My Concubine with Temptress Moon (1996), another period drama starring Leslie Cheung and Gong Li. Though it was well received by most critics, it did not achieve the accolades that Concubine did, and many were put off by the film's convoluted plot line. Almost as famous is his The Emperor and the Assassin (1999), an epic involving the legendary King of Qin and the reluctant assassin who aims to kill him.

In 2002, Chen made his first, and to-date only, English-language film, Killing Me Softly, a thriller starring Heather Graham and Joseph Fiennes, though it proved to be both a critical and popular disappointment. His more recent Together (2002) is an intimate film about a young violinist and his father. In 2005, he directed The Promise, a fantasy wuxia picture. The Promise saw Chen shifting to a more commercial mindset, a shift regarded by some as a "radical stylistic turn" from his previous works.

In 2006, he was awarded the Lifetime Achievement Award at the 28th Moscow International Film Festival.

In 2008, Chen directed the semi-biography Forever Enthralled, which is a return for him in the sense of directing a film based on Chinese opera. He later went on to direct Sacrifice (2010), which is a re-imagining of the famous play The Orphan of Zhao. The film was a box-office hit and many critics saw it as his "return to form".

Chen has also acted in several films, including Bernardo Bertolucci's The Last Emperor (1987) and his own The Emperor and the Assassin and Together.

His 2012 film Caught in the Web was selected as the Chinese entry for the Best Foreign Language Oscar at the 85th Academy Awards, but it did not make the final shortlist.

Personal life
Chen's first wife was Sun Jialin (), whom he met while working at the Beijing Film Factory, between 1975 and 1978; they married in 1983. That union ended and he later remarried, to Hong Huang, the daughter of Zhang Hanzhi, a diplomat who had worked as an English translator for Mao Zedong. She graduated from Vassar College in New York and is the current CEO of China Interactive Media Group. In the early 1990s, after their divorce, Chen lived with Ni Ping, a female television personality. In 1996, Chen married actress Chen Hong.

Chen Kaige is the holder of a green card to the United States.

Filmography

Film (as director)

Television (as director)

Actor

Writer

Producer

Awards and nominations

International

Domestic

See also

 Zhang Yimou
 Tian Zhuangzhuang

Notes

External links
 Chen Kaige at They Shoot Pictures, Don't They?

Chen Kaige: "Freedom Above All Else"''
Chen Kaige – Star of Chinese Fifth-Generation Cinema Directors
Chen Kaige at the Hong Kong Movie Database

1952 births
Living people
Asian Cultural Council grantees
Filmmakers who won the Best Foreign Language Film BAFTA Award
Beijing Film Academy alumni
Film directors from Beijing
Sent-down youths
Beijing No. 4 High School alumni
Directors of Palme d'Or winners
Members of the 12th Chinese People's Political Consultative Conference


text:
Chelsea managers under Roman Abramovich
by Press Association
Maurizio Sarri lifts the Europa League trophy after Chelsea's win in Baku (Adam Davy/PA)
Maurizio Sarri has become the latest manager to leave Chelsea after he was named Juventus boss.
Sarri was the 13th managerial appointment made by owner Roman Abramovich since he took over the club in the summer of 2003, with Jose Mourinho and Guus Hiddink each having two spells.
Here, Press Association Sport looks at how those men have fared.
Claudio Ranieri – Sep 2000-May 2004
Claudio Ranieri's days were numbered under Roman Abramovich (Phil Noble/PA)
The Italian was at the helm when Abramovich arrived at Stamford Bridge. After heavy spending he led Chelsea to a second-placed finish in the Premier League and the Champions League semi-finals but faced persistent speculation about his job and was sacked at the end of the season.
Jose Mourinho – Jun 2004-Sep 2007
The Portuguese established himself as a Chelsea hero, winning back-to-back league titles in his first two seasons, one FA Cup and two League Cups. His departure only a month into his fourth season by 'mutual consent' was unexpected.
Avram Grant – Sep 2007-May 2008
(PA Graphic)
A friend of Abramovich, Israeli Grant had been appointed technical director in the summer of 2007. He was controversially made manager after Mourinho's departure and lasted only one season, which saw Chelsea finish second and lose in the Champions League final to Manchester United. He had the best win percentage of any of Abramovich's managers.
Luiz Felipe Scolari – Jul 2008-Feb 2009
Luiz Felipe Scolari's time in charge did not go as planned (Dave Thompson/PA)
Brazilian Scolari was the first World Cup-winning coach to manage in the Premier League but a poor run of form saw him sacked before the end of his first season.
Guus Hiddink – Feb 2009-May 2009
Hiddink was appointed until the end of the season and combined his duties with his post as Russia manager. He lost only one match and won the FA Cup but could not be persuaded to stay.
Carlo Ancelotti – Jul 2009-May 2011
Carlo Ancelotti lifts the Premier League trophy (Nick Potts/PA)
The Italian enjoyed a dream first season, leading Chelsea to a first ever league and FA Cup double, with his side becoming the first to score more than 100 Premier League goals in one campaign. He was sacked hours after finishing second in his second campaign.
Andre Villas-Boas – Jun 2011-Mar 2012
Hailed as the new Mourinho, Villas-Boas' tenure at Stamford Bridge was not a happy one. After talk of a player revolt, he was sacked with Chelsea outside the Champions League places.
Roberto Di Matteo – Mar 2012-Nov 2012
Roberto Di Matteo is saluted by his Chelsea players after FA Cup victory (Nick Potts/PA)
The former Chelsea midfielder had been Villas-Boas' assistant and was made interim manager until the end of the season. FA Cup and Champions League wins earned him a permanent contract but the following season did not go nearly as well and he was sacked.
Rafael Benitez – Nov 2012-May 2013
Benitez was the club's latest interim manager, and unpopular with Chelsea fans because of his Liverpool past. The Spaniard won the Europa League and led the team to a third-place finish in the league.
Jose Mourinho – Jun 2013-Dec 2015
Jose Mourinho, left, was able to celebrate another title (Mike Egerton/PA)
'The Special One' returned to win a third Premier League title in 2014-15 as well as the League Cup but, after signing a new contract, a dismal start to the following season saw him leave the club for a second time.
Guus Hiddink – Dec 2015-May 2016
Hiddink's second caretaker spell could not match the impact of his first but he did manage to stabilise the club.
Antonio Conte – Jul 2016-Jul 2018
Antonio Conte's early success gave way to a difficult second season (Mike Egerton/PA)
The Italian enjoyed a terrific debut season, with Chelsea dominating the Premier League and winning the title by seven points, but entered his second under a cloud after appearing to criticise the club's transfer policy. The Blues finished fifth in the Premier League, missing out on a Champions League place, and even an FA Cup win could not save Conte.
Maurizio Sarri – Jul 2018-Jun 2019
The club won Sarri's first five league games at the helm and were unbeaten in 12, but a relative dip early in the new year put their Champions League qualification in doubt and saw Sarri's tactics questioned. They recovered to finish third, reached the League Cup final and won the Europa League but still find themselves seeking a new manager.
Frank Lampard confident Chelsea do not need to strengthen squad this summer
Mason Mount signs new five-year Chelsea deal
Frank Lampard: Chelsea need to improve fitness
Chelsea and Manchester City move Women's Super League openers to men's grounds


text:
Q: How do I handle Kafka KStream unexpected state? I have a Kafka stream that is set up as follows:

*

*A message comes in on topic A with state "created"

*A remote REST endpoint is called to notify that the message was received

*The message is then transformed (state is set to "notified") and sent
back out on topic A

I know how to set this up for the happy path (REST endpoint returns HTTP 2xx).  My question is: if my endpoint returns 400, how do I configure my kstream to handle that and not emit a message?
Here's my KSteam config:
    final KStream<String, Message> stream = streamsBuilder.stream(topic,
            Consumed.with(Serdes.String(), messageJsonSerde));
    stream
            .filter((key, value) -> MessageType.CASE_MATCHED.equals(
                    value.getEventType()))
            .mapValues(notifierService::handleNotification) // calls REST endpoint
            .to(topic, Produced.with(Serdes.String(), messageJsonSerde));
    return stream;

A: I guess the simplest way would be, to add another filter after the mapValue that drops messages that got not successfully processed.
You could change the first mapValue to add this information to the record such that the filter can access it. Additionally, you can do a second mapValue after the second filter to remove this additional success flag to write an unmodified message back to Kafka.
Of course, this won't reprocess any failed message but only filter out failed messages from the output.


text:
Q: Archive some entities with inheritance I have a hard problem to solve and I don't know how to do it.
I want to archive some entities and then delete them from initial tables. Problem is these entities are linked together. I have a code which is close to working but I think it's not a clean way to do it. It's composed of SQL queries which copy rows with their IDs to new tables.
Another problem is that I don't need some fields to archive so archive entities are not exactly the same as initial entities.
I'm using raw SQL query and not DQL because of the size of my tables.
I want to archive these entities : Colle, ColleQC, QC, PasserColle, Reponse, ReponseQC, StatistiqueColle, StatistiqueQuestion, RepartitionColle, RepartitionQuestion, Tuteur
TO
BanqueColle, BanqueColleQC, BanqueQC, BanquePasserColle, BanqueReponse, BanqueReponseQC, BanqueStatistiqueColle, BanqueStatistiqueQuestion, BanqueRepartitionColle, BanqueRepartitionQuestion, AncienAdherent.
I'll use these archive for another part of my app.
Sample of table structure :
(Tuteur and AncienAdherent extend User)
Here's a part of the code I made to archive but I don't think it's a clean way to do it :
public function archiveTuteurs() {
    $db = $this->em->getConnection();
    $query = "INSERT INTO ancien_adherent (id)
              SELECT u.id
              FROM user u
              WHERE discr = 'tuteur'";
    $stmt = $db->prepare($query);
    $stmt->execute();

    $query2 = "UPDATE user
              SET user.discr = 'ancien'
              WHERE discr = 'tuteur'";
    $stmt = $db->prepare($query2);
    $stmt->execute();

    return true;
}

public function archiveColles() {
    $db = $this->em->getConnection();
    $query = "INSERT INTO banque_colle (id, typeColle, nom, temps_epreuve, matiere_id, dateCreation, ordre, discr)
              SELECT colle.id, colle.typeColle, colle.nom, colle.temps_epreuve, colle.matiere_id, colle.dateCreation, colle.ordre, colle.discr
              FROM colle";
    $stmt = $db->prepare($query);
    $stmt->execute();

    $query2 = "INSERT INTO banque_colle_qc (id)
               SELECT colle_qc.id
               FROM colle_qc";
    $stmt = $db->prepare($query2);
    $stmt->execute();

    return true;
}

public function archiveQC() {
    $db = $this->em->getConnection();
    $query = "INSERT INTO banque_qc (id, titre, id_colle, ordre, qcPere, enonce, donnees, item1, item2, item3, item4,
                          item5, corrige_item1, corrige_item2, corrige_item3, corrige_item4, corrige_item5, item1_vrai,
                          item2_vrai, item3_vrai, item4_vrai, item5_vrai, item1_annule, item2_annule, item3_annule,
                          item4_annule, item5_annule, multiple_choices, inclu)
              SELECT qc.id, qc.titre, qc.id_colle, qc.ordre, qc.qcPere, qc.enonce, qc.donnees, qc.item1, qc.item2,
                     qc.item3, qc.item4, qc.item5, qc.corrige_item1, qc.corrige_item2, qc.corrige_item3, qc.corrige_item4,
                     qc.corrige_item5, qc.item1_vrai, qc.item2_vrai, qc.item3_vrai, qc.item4_vrai, qc.item5_vrai,
                     qc.item1_annule, qc.item2_annule, qc.item3_annule, qc.item4_annule, qc.item5_annule,
                     qc.multiple_choices, qc.inclu
              FROM qc
              ORDER BY qc.qcPere ASC";
    $stmt = $db->prepare($query);
    $stmt->execute();

    return true;
}

public function archivePassages() {
    $db = $this->em->getConnection();
    $query = "INSERT INTO banque_passer_colle (colle_id, dateDebut, note)
              SELECT passer_colle.colle_id, passer_colle.dateDebut, passer_colle.note
              FROM passer_colle";
    $stmt = $db->prepare($query);
    $stmt->execute();

    return true;
}

public function archiveReponses() {
    $db = $this->em->getConnection();
    $query = "INSERT INTO banque_reponse (id, discr)
              SELECT reponse.id, reponse.discr
              FROM reponse
              WHERE discr='reponseQC'";
    $stmt = $db->prepare($query);
    $stmt->execute();

    $query2 = "INSERT INTO banque_reponse_qc (id, question, A, B, C, D, E, note)
              SELECT reponse_qc.id, reponse_qc.question, reponse_qc.A, reponse_qc.B, reponse_qc.C, reponse_qc.D,
                     reponse_qc.E, reponse_qc.note
              FROM reponse_qc";
    $stmt = $db->prepare($query2);
    $stmt->execute();

    return true;
}

public function archiveStats() {
    $db = $this->em->getConnection();
    $query = "INSERT INTO banque_statistiquecolle (id, colle_id, effectif, moyenne, mediane, note100, major, minor)
              SELECT sc.id, sc.colle_id, sc.effectif, sc.moyenne, sc.mediane, sc.note100, sc.major, sc.minor
              FROM statistiquecolle_groupe scg
              LEFT JOIN  statistiquecolle sc ON sc.id = scg.statistiquecolle_id
              WHERE scg.groupe_id = 1
              AND sc.id NOT IN (SELECT sc1.id
                                FROM statistiquecolle_groupe scg1
                                LEFT JOIN  statistiquecolle sc1 ON sc1.id = scg1.statistiquecolle_id
                                WHERE scg1.groupe_id != 1)";
    $stmt = $db->prepare($query);
    $stmt->execute();

    $query2 = "INSERT INTO banque_statistiquequestion (id, question_id, moyenne, nbReponseTot, nbReponseA, nbReponseB,
                                                       nbReponseC, nbReponseD, nbReponseE)
              SELECT sq.id, sq.question_id, sq.moyenne, sq.nbReponseTot, sq.nbReponseA, sq.nbReponseB, sq.nbReponseC,
              sq.nbReponseD, sq.nbReponseE
              FROM statistiquequestion_groupe sqg
              LEFT JOIN  statistiquequestion sq ON sq.id = sqg.statistiquequestion_id
              WHERE sqg.groupe_id = 1
              AND sq.id NOT IN (SELECT sq1.id
                                FROM statistiquequestion_groupe sqg1
                                LEFT JOIN  statistiquequestion sq1 ON sq1.id = sqg1.statistiquequestion_id
                                WHERE sqg1.groupe_id != 1)";
    $stmt = $db->prepare($query2);
    $stmt->execute();

    $query3 = "INSERT INTO banque_repartitioncolle (id, statColle_id, note, nombre, percentOfEffectif)
              SELECT rc.id, rc.statColle_id, rc.note, rc.nombre, rc.percentOfEffectif
              FROM repartitioncolle rc
              WHERE rc.statColle_id IN (SELECT bsc.id
                                        FROM banque_statistiquecolle bsc)";
    $stmt = $db->prepare($query3);
    $stmt->execute();

    $query4 = "INSERT INTO banque_repartitionquestion (id, statQuestion_id, note, nombre, percentOfEffectif)
              SELECT rq.id, rq.statQuestion_id, rq.note, rq.nombre, rq.percentOfEffectif
              FROM repartitionquestion rq
              WHERE rq.statQuestion_id IN (SELECT bsq.id
                                        FROM banque_statistiquequestion bsq)";
    $stmt = $db->prepare($query4);
    $stmt->execute();

    return true;
}

A: I've been doing a database migration recently, and have found that the easiest method (for me) is to do everything in SQL. It's a bit laborious, but it worked okay for my project
First drop all the constraints
# Table1.field1
ALTER TABLE Table1 DROP FOREIGN KEY FK_Table1_field1;
ALTER TABLE Table1 DROP INDEX IDX_Table1_field1;

# Table1.field2
ALTER TABLE Table1 DROP FOREIGN KEY FK_Table1_field2;
ALTER TABLE Table1 DROP INDEX IDX_Table1_field2;

Then add all the SQL you have to move the data into the new tables.
Then drop all the old tables
DROP TABLE IF EXISTS Table1;
DROP TABLE IF EXISTS Table2;

Then Add all the constraints back in
ALTER TABLE Table1
    ADD INDEX IDX_Table1_field1 (field1 ASC);
ALTER TABLE Table1
    ADD CONSTRAINT FK_Table1_field1
    FOREIGN KEY (field1)
    REFERENCES OtherTable (xxxx)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION;

I kept each step in it's own sql file, so for this example there would be 4 sql files, might be easier to manage if you split up the data move step into more than one file as well.


text:
The Ultimate Sin — четвертий сольний альбом Оззі Осборна, який був випущений 22 лютого 1986 року.

Композиції
 The Ultimate Sin - 3:45
 Secret Loser - 4:08
 Never Know Why - 4:27
 Thank God for the Bomb - 3:53
 Never - 4:17
 Lightning Strikes - 5:16
 Killer of Giants - 5:41
 Fool Like You - 5:18
 Shot in the Dark - 4:16

Джерела
 The Ultimate Sin  allmusic
 The Ultimate Sin last.fm

Альбоми Ozzy Osbourne
Англомовні музичні альбоми
Альбоми Epic Records


text:
Experience and Qualifications
Client and Carrier Connection
Client Service Team
HR Connections and Added Broker Services
Market at a Glance
Stynchula, Herbert & Associates, Inc.
3921 Old Lee Highway #73 C Fairfax, VA 22030
johnherbert@financialguide.com
Printed from: www.stynherb.com
What Is the History of the Federal Estate Tax?
The history of estate taxes in America has been a long and winding road. Careful estate planning is still one of the most important ways to manage and protect your assets for your heirs.
The Stamp Act of 1797 was the first federal estate tax in the United States and was passed to help fund an undeclared war with France; it was repealed in 1802. The Revenue Act of 1862 reinstated the estate tax in order to fund the Civil War; it was abolished in 1870. To finance the Spanish American War, the War Revenue Act of 1898 was passed, and subsequently abolished in 1902. Due to the costs of World War I, the Revenue Act of 1916 reinstated an estate tax that, in some form or other, has been in effect ever since.
The Economic Growth and Tax Relief Reconciliation Act of 2001 gradually increased the federal estate tax exclusion, until finally repealing the federal estate tax altogether for the 2010 tax year only. The Tax Relief Act of 2010 reinstated the federal estate tax with a $5 million exclusion, indexing the exclusion for inflation after 2011. The provisions of the Tax Relief Act of 2010 expired on December 31, 2012.
The American Taxpayer Relief Act of 2012 increased the federal estate tax rate from 35% to 40%, but left in place the higher exclusion level, which reached $5.49 million in 2017; both provisions are now permanent. It also left in place the "portability" of any unused exclusion between spouses.
The latest major piece of tax legislation is the Tax Cuts and Jobs Act, which was signed into law on December 22, 2017. This Act doubled the federal estate tax exclusion to $11.18 million in 2018 (indexed annually for inflation) while retaining the 40% tax rate. The 2023 federal estate tax exclusion is $12.92 million (up from $12.06 million in 2022). In 2026, the exclusion is scheduled to revert to its pre-2018 level.
John Herbert is a registered representative of and offers securities though MML Investors Services LLC, Member https://www.sipc.org Supervisory Address: 530 Gaither Road, Suite 350, Rockville, MD 20850. Phone 301.355.5800. Stynchula, Herbert & Associates, Inc. is not a subsidiary or affiliate of MML Investors Services, LLC or its affiliated companies.
Use the john@stynherb.com john@stynherb.com email address for Group Health Benefits
CRN 202301-274910
The information contained in this article is for general use and while we believe all information to be reliable and accurate, it is important to remember individual situations may be entirely different. Therefore, information should be relied upon only when coordinated with professional tax and financial advice. Neither the information presented nor any opinion expressed constitutes a representation by us or a solicitation of the purchase or sale of any insurance or securities products and services. Written and published by EmeraldConnect.


The Festive season is here and thieves in town are hungry for your hard earned cash. Kenyans are being urged to mind their security during the festive season.
Well a Video has been making rounds on social for the better part of Tuesday as it reveals a notorious gang of a woman and a woman who are walking around Sarit centre and taking away with women's handbags when they are unaware as they go about their Christmas shopping.