text:
ENERGY TIMES
LT MAGAZINE
Lagos Times
President Buhari Signs 2021 Appropriation Bill
Inyang Bassey - December 31, 2020 0
President Muhammadu Buhari has signed the 2021 Appropriation Bill into law. The Personal Assistant to the President on New Media, Mr Bashir...
Appraising the Survival Fund, Osinbajo Says Buhari Administration Must Find Ways of Doing More
THE TIMES - December 30, 2020 0
Nigeria's Vice-President Yemi Osibajo has said that given the impact of the Survival Fund under the Economic Sustainability Plan, there is now...
Oladimeji Shotunde is LASU's Best Graduate
Lagos Times - December 30, 2020 0
Oladimeji Shotunde is the best graduate of the Lagos State University in 2020, where he set a new CGPA record in the...
Lagos Assembly Passes N1.164trn 2021 Appropriation Bill
The Lagos State House of Assembly has passed the state's 2021 Appropriation Bill valued at N1.164 trillion. The budget...
NIMC Releases New Guidelines For NIN Applications
Obinna Ochi - December 30, 2020 0
The National Identity Management Commission has issued fresh guidelines for applicants to obtain their National Identification Number (NIN). The...
Central Bank Says Over 1 million Loans Were Given at Interest Rates Below 20 Per Cent
Femi Akinjobi - December 30, 2020 0
Nigeria's Central Bank has announced that over one million bank customers took loans from their financial institutions in the last one year...
InfraCredit Guarantees Transport Services N12bn Bond
Hadiza Alimi - December 30, 2020 0
PIDG-backed, specialised infrastructure credit guarantee company Infracredit says that it has has guaranteed Transport Services Limited's (TSL) N12 billion 10-Year Series 1...
IST Restrains Chaka Technologies From Dealing in Foreign-Listed Stocks
Nigeria's Investments and Securities Tribunal, (IST) said on Thursday 17th December 2020 that it had made interim Orders restraining an unregistered Fintech...
AIICO Insurance lists 4.4 billion shares on NSE
AIICO Insurance Plc has listed its additional shares on the trading platform of the Nigerian Stock Exchange (NSE).The new stocks were from...
Fidelity Bank Announces New Appointments
Fidelity Bank has announced new board appointments and retirements in accordance with the bank's internal governance policies. Ms Aku...
Ngozi Edozien
Ngozi Edozien is the founder and Managing Director of Invivo Partners Limited. She has over 20 years' experience in finance/private equity, general...
Sanyade Okoli
Sanyade Okoli is Chief Executive Officer at Alpha African Advisory. She has over 21 years of financial advisory, private equity, corporate, commercial...
Samuel Nwanze
Samuel Nwanze is a director of Transcorp Power. He holds an MSc. degree in Finance and Management from Cranfield University in the...
Olukemi Adeniji
Ms Adeniji has a law degree and a Masters in International Law and Diplomacy (M.I.L.D) from the University of Lagos. She has...
Chikezie Nwosu
Chikezie Nwosu is an experienced senior executive with over 29 years local and international experience in the oil & gas industry vis-a-viz...
Group Condemns Media Attacks on Inuwa Waya
Tosin Akande - September 15, 2020 0
The Kano Youth Support Group has condemned supposed clandestine social media attacks on Mr Inuwa Waya, a native of the state who...
Kalu Visits Retired Generals, Speaks on 2023 Presidency
Obinna Ochi - September 1, 2020 0
Orji Uzor Kalu, the Chief Whip of Senate said on Monday that he is open to contesting the 2023 presidency if asked...
Yahaya Bello Won Kogi Election, Supreme Court Rules
Obinna Ochi - August 31, 2020 0
The Supreme Court on Monday upheld the election of Yahaya Bello as Governor of Kogi State. A seven-man panel...
INEC Publishes List of Candidates for Ondo Governorship Poll
Tosin Akande - August 23, 2020 0
The Independent National Electoral Commission (INEC) has accepted the nominations of seventeen candidates for the forthcoming governorship election in Ondo State.
Lagos East Senate Race Narrows as Odesanya Endorses Abiru
A former state assemblyman has withdrawn from the race for the nomination of the All Progressives' Congress candidate for the Lagos-East Senatorial...
2020: A Year Like no Other By Dakuku Peterside
The year 2020 was supposed to be a great year. It was another Leap Year – the famed Olympic Games year when...
The Time to Restructure is Now – Bola Tinubu
Being with you at this special event today, I am visited by two competing emotions. I continue to feel a profound sense...
Africa and the COVID-19 Vaccine – By Dakuku Peterside
The year 2020 will forever be synonymous with Covid-19, a pandemic that brought the world to her knees. For the first time...
Buhari is Repressing Human Rights and Getting Away With It – By Kolawole Olaniyan
Lagos Times - December 9, 2020 0
President Muhammadu Buhari is failing to live up to his promises to ensure respect for human rights, obey the rule of law,...
CNN and the Ethics of Journalism – By Lai Mohammed
Lagos Times - November 24, 2020 0
Our attention has been drawn to an 'investigation' by CNN, entitled 'How a Bloody Night of Bullets Quashed a Young Protest Movement'...
Black Panther Star Boseman Dies at 43
Lagos Times - August 29, 2020 0
Chadwick Boseman, the star of the blockbuster film Black Panther, has died from colon cancer, according to a statement from his publicist....
Nigeria Supports Lanre Alfred's Book Project
Lagos Times - July 25, 2020 0
Preparations for the 60th anniversary of Nigeria's independence in 1960 are already in top gear and one of the anticipated activities is...
Praiz Launches Music Label
The singer Praiz has launched his own record label. The popular crooner said his new venture Cicada Music, is the beginning of...
On the Sixtieth Anniversary of Independence, a new Non-fiction Novel From Cassava Republic Revisits our Colonialist Past
In a few months, Nigerians in the country and across the world will gather to celebrate the 60th anniversary of our Independence...
Chelsea Star Hudson-Odoi Arrested over Alleged Rape
Hadiza Alimi - May 18, 2020 0
The Chelsea Football Club footballer Callum Hudson-Odoi, was arrested by the Metropolitan Police after a woman accused him of rape. The 19-year-old...
SystemSpecs in Fintech Tie-Up with Paga to Boost Digital Payments
By Lagos Times
SystemSpecs, Nigeria's fintech company SystemSpecs says it has established a partnership with Paga, a leading mobile money service provider to widen the scope of digital payments across the large West African country.
SystemSpecs, which owns the ubiquitous Remita brand, which processed public and private sector transactions, says that the first phase of the collaboration would enable Paga customers to easily initiate and complete payment to all Remita billers and merchants right from Paga's website paga.com. Paga's agents nationwide will also be able to process end-to-end payments to all Remita customers from their platforms.
The initiative is expected to catalyse deeper collaborations within the fintech ecosystem, making electronic payments more convenient for customers irrespective of their needs and location.
Ezinne Obikile, SystemSpecs Executive Director, Infrastructure and Payments Gateway, said: "SystemSpecs is committed to driving financial inclusion and providing payment convenience to all, which underscores this strategic partnership with Paga to extend a wide range of financial solutions and services to customers everywhere, even at a time as this."
Jay Alabraba, Co-founder and Director of Business Development, Paga said: "In our commitment to make payments easier for all Nigerians and businesses, we are pleased to collaborate with SystemSpecs. Our goal is to always provide an improved experience to our customers everywhere, by leveraging digital technology. This collaboration would further help us meet the needs of individuals who seek to make various bill payments, including those in emerging markets."
The immediate impact of the collaboration on the public is the easy generation of Remita Retrieval Reference (RRR) and payments into the Federal Government's Treasury Single Account. It would also enable payments to other Remita billers such as state governments, tertiary institutions and other organisations by Paga customers and agents directly through Paga platforms.
Founded in 2009 with a purpose to make it simple for one billion people to access and use money, Paga is the largest digital wallet operator in Nigeria with a nationwide network which consists of over 23,000 agents, including mom and pop stores as well as pharmaceutical and grocery stores where people can walk in for quick and easy access to financial services.
Remita is a suite of financial technology solutions trusted by governments, banks, fintechs, businesses and individuals for the comprehensive management of billings, collections and payment infrastructure needs. Remita was launched in 2005 by SystemSpecs Limited.
Ezinne Obikile
Jay Alabraba
Remita
SystemSpecs
© 2020 Lagos Times. All rights reserved.


As Policy Director, Michael Miller focuses on providing policy and strategy support to state-based consumer health advocacy groups. Over the course of his career, Michael has developed expertise in the areas of Medicaid, SCHIP, Medicare, and developing state-level options to expand coverage for the uninsured, small group and non-group insurance reform, long term care financing and delivery, managed care reform, and hospital community benefits and uncompensated care.
Prior to joining Community Catalyst, Michael was the policy director for Health Care for All. He also worked for the City of Boston Elderly Commission as a Policy Analyst and for the Alzheimer's Association of eastern Massachusetts as Director of the Community Partnership Project. Michael holds a bachelor's degree from Brown University and a master's degree in public policy from Tufts University.
What Should We Hope To Achieve Through Health System Transformation?


The Notre Dame Cathedral may still remain to be rebuilt. Father David Kipfer of the Ottawa Catholic churches says it would be a huge loss for Catholics in France and everywhere. He has been involved with one church that closed not long ago. A tornado damaged St. Mary's.
Kipfer says God remembers the baptisms, weddings, and funerals. But people still like to have the earthly connection to the divine and feel attached to the place where they happened.
Kipfer says he was amazed at how fast Notre Dame burned. It makes him wonder about how safe other churches, including those here, are from fires.


I have tried several options for scanning color negatives. The software that came with my Canon scanner produces somewhat decent images for some frames but I didn't feel that I have enough control for adjusting individual images. So I bought a license for VueScan.
VueScan is great and confusing at the same time. It has a huge amount of options but the user interface is… let's say not very clear.
I tried the default settings in VueScan and the results were somewhat ok. I tried adjusting the scans inside VueScan but to be honest, Lightroom is much easier.
I tried to use the film profiles in VueScan but that gave me worse results than the default settings. I tried to sample the film base color and some other stuff that I found instructions for online but they didn't seem to work out either.
Given that I use Lightroom anyway to catalog my images and the develop module in Lightroom is very good, this is how my work flow for scanning color negatives works nowadays.
Using 48 bit RGB gives you the best possible color space to continue working in Lightroom.
For color settings, I leave everything at default and select Auto levels for Color balance. For some images, other settings might work better but I find it easier to always use the same settings and work in Lightroom. Make sure that you select ProPhoto RGB for Output color space. This is the color space that Lightroom uses and setting it makes sure that the colors transfer correctly from VueScan to Lightroom.
For output, make sure to produce a TIFF file with 48 bit RGB and to include the TIFF profile (which makes sure that the ProPhoto RGB file works in Lightroom).
The output from VueScan using these settings may be pretty good but often it will look a bit bland. This is an example image straight out from VueScan.
Lightroom's auto setting has quite a bad reputation. It has improved in later versions and often times using it in Lightroom 5 will give you a better starting point for manual edits. This image is developed from the previous one using Lightroom's auto development setting and auto white balance.
The white balance did not look quite right and I prefer my images a bit more contrasty. This one is after some manual tweaking in Lightroom.
I don't think that there is a one workflow that will always produce best possible images. This is how I work to scan my color negatives and how I have gotten most consistent results. I'd love to hear your suggestions for improvement.
I needed a dodge tool for some printing in the darkroom. I could have just cut some shape from a piece of cardboard and paint it black but then I started thinking that maybe I could make several templates for further use.
A dodge tool needs to be black from the other side to prevent reflecting light from affecting the print. Instead of painting some cardboard black, I decided to use my laser printer. I made some templates in Photoshop for different shapes of dodging and printed them out. I'm sharing them here in case anyone else finds them useful.
Firstly, download the PDF file that contains my templates.
Print out the page that seems to have the shape you need.
Glue the laser printer output on a piece of cardboard.
Cut out the shape you want.
Bend some steel wire to make a handle.
Make holes to the cardboard and insert the steel wire.
Apply some tape to secure the steel wire handle.
Fix any white showing on the black side using a black marker pen.
Being married to a florist, I sometimes go with my wife to the venue sites to help her set up the flowers and shoot some promo pictures of the flowers before the party starts. These were shot on an island just outside Helsinki. I also used the setting to practise my use of fill-flash. Please enjoy some love beyond words.
Sometimes it is worth spending a few $ or € for just some fun. Load your favourite lomography camera with some film, go out and shoot 12 silly frames.


text:
Research & Ideas
Capturing That Waterfront Draw
London, Rio, New York, Shanghai. These are some of the world's most vibrant and beloved cities—successful, in part, because of their proximity to bodies of water. Their identities and trajectories as world-class cities are intertwined with the rippling ribbons and expansive liquid sheets that lap at our feet, continuously reminding us city dwellers of our smallness before nature. People seem to experience this gravitation toward the water's edge acutely and we traverse concrete and asphalt just to gaze out over an open expanse or to dip our toes in the blue stuff.
In 2015, Sasaki conducted a survey of 1,000 city dwellers from six American cities about what qualities make for a great city. Nearly fifty percent said waterfronts were their favorite urban open space, chosen over small urban parks, trails, and large open parks. There's something about water that innately draws us to it. But what draws people to waterfronts, and why are they entwined with our imagination of world-class cities? Scholars, scientists, urban planners, and others have all considered these questions.
Some argue that our love of bodies of water is a matter of science. The late philosopher Denis Dutton, in a 2010 TED talk, "A Darwinian Theory of Beauty," argued that human attraction to bodies of water is universal in part because they ensured our survival in key stages of human evolution. Examining evolutionary psychology and aesthetic preferences, he reveals that the most universally appreciated landscapes, regardless of a viewer's culture or country of origin, are those which "show the presence of water directly in view or evidence of water in a bluish distance…a path or a road, perhaps a riverbank or a shoreline that extends into the distance, almost inviting you to follow it." Dutton contends this universal appreciation of water-laden landscapes is why they are endlessly reproduced in print and referenced in design.
Authors, too, have explored humanity's innate longing to interact with water. Indeed, urban waterfronts have been the setting for some of the most striking scenes of novels from Moby Dick to The Great Gatsby. In the first pages of Moby Dick, while describing Manhattan's bustling docks, Melville ruminates that "water and meditation are wedded forever."
In our own meditations as urban planners and designers, we recognize how essential waterfronts are to cities and how precious they are to people. Throughout history, founders strategically sited their cities along the shores of oceans and the banks of rivers to have access to a valuable transportation link that could yield trade and industrial advantages. But overuse during the industrial boom years of rapid development left many of these vital waterways polluted and unwelcoming. Over the last century, many of these same cities who neglected their waterways during periods of growth have pivoted to restoring their waterways to their proper status as precious resource, cherished amenity, and universal connector.
Zidell Yards, an industrial site along the Willamette River in Portland, after an expansive clean-up
In our more than 60 years as a practice, we have planned waterfronts across the globe, from Charleston's Waterfront Park and Boston's Harborway to the Chicago Riverwalk and the Wilmington Waterfront Park in Los Angeles. Although each of these city's waterfronts were unique, each design was anchored by a strategy that returned the waterfront to the people.
A reimagined waterfront for the 21st century
Many clients today see waterfront revitalization projects as legacy projects, keenly aware of the impact a vibrant waterfront can have on the health and prosperity of their citizens for generations to come. More than ever, cities aim to ensure development is balanced along their shores to maintain public connection to the water's edge. It means undertaking aggressive cleanup, encouraging a balanced approach to real estate development, cultivating a lively public realm, and emphasizing connections back into the city fabric.
In the following series we explore three projects underway—at Zidell Yards in Portland, Oregon; at Las Salinas, in Viña del Mar, near Santiago, Chile; and along Suzhou Creek in Shanghai, China—to share our latest thinking on waterfront revitalization around the world.
Head to the first installment of the series, a deep dive into Portland, Oregon's Zidell Yards—a shipyard site currently being reimagined as a mixed-use development that will further enable Portlanders to work, live, eat, shop, and relax just steps from the Willamette River.
Sasaki In Context illuminates our current projects, ideas, and the people who make it happen.
How do you motivate communities to combat climate change? Sasaki artist-in-residence @dbuckleyborden answers with a… https://t.co/4L69nlu2xl
Follow us @SasakiDesign
© 2019 Sasaki Associates, Inc.|Privacy Policy|Site Map
Contact| Twitter| Facebook| Instagram| Vimeo| Login| 中文主页

redpajama_set_name: RedPajamaCommonCrawl


text:
<?php

class ET_Global_Settings {
	private static $_settings = array();

	public static function init() {
		// The class can only be initialized once
		if ( ! empty( self::$_settings ) ) {
			return;
		}

		self::set_values();
	}

	private static function set_values() {
		$font_defaults = array(
			'size'           => '14',
			'color'          => '#666666',
			'letter_spacing' => '0px',
			'line_height'    => '1.7em',
		);

		$defaults = array(
			'et_pb_image-animation'                           => 'left',
			'et_pb_gallery-hover_overlay_color'               => 'rgba(255,255,255,0.9)',
			'et_pb_gallery-title_font_size'                   => '16',
			'et_pb_gallery-title_color'                       => '#333333',
			'et_pb_gallery-title_letter_spacing'              => $font_defaults['letter_spacing'],
			'et_pb_gallery-title_line_height'                 => '1em',
			'et_pb_gallery-title_font_style'                  => '',
			'et_pb_gallery-caption_font_size'                 => '14',
			'et_pb_gallery-caption_font_style'                => '',
			'et_pb_gallery-caption_color'                     => '#f3f3f3',
			'et_pb_gallery-caption_line_height'               => '18px',
			'et_pb_gallery-caption_letter_spacing'            => $font_defaults['letter_spacing'],

			'et_pb_tabs-tab_font_size'                        => $font_defaults['size'],
			'et_pb_tabs-tab_line_height'                      => $font_defaults['line_height'],
			'et_pb_tabs-tab_letter_spacing'                   => $font_defaults['letter_spacing'],
			'et_pb_tabs-title_font_size'                      => $font_defaults['size'],
			'et_pb_tabs-body_font_size'                       => $font_defaults['size'],
			'et_pb_tabs-body_line_height'                     => $font_defaults['line_height'],
			'et_pb_tabs-body_letter_spacing'                  => $font_defaults['letter_spacing'],
			'et_pb_tabs-title_font_style'                     => '',
			'et_pb_tabs-padding'                              => '30',

			'et_pb_slider-header_font_size'                   => '46',
			'et_pb_slider-header_line_height'                 => '1em',
			'et_pb_slider-header_letter_spacing'              => $font_defaults['letter_spacing'],
			'et_pb_slider-header_font_style'                  => '',
			'et_pb_slider-body_font_size'                     => '16',
			'et_pb_slider-body_letter_spacing'                => $font_defaults['letter_spacing'],
			'et_pb_slider-body_line_height'                   => $font_defaults['line_height'],
			'et_pb_slider-body_font_style'                    => '',
			'et_pb_slider-padding'                            => '16',
			'et_pb_slider-header_color'                       => '#ffffff',
			'et_pb_slider-header_line_height'                 => '1em',
			'et_pb_slider-body_color'                         => '#ffffff',

			'et_pb_testimonial-portrait_border_radius'        => '90',
			'et_pb_testimonial-portrait_width'                => '90',
			'et_pb_testimonial-portrait_height'               => '90',
			'et_pb_testimonial-author_name_font_style'        => 'bold',
			'et_pb_testimonial-author_details_font_style'     => 'bold',
			'et_pb_testimonial-border_color'                  => '#ffffff',
			'et_pb_testimonial-border_width'                  => '1px',
			'et_pb_testimonial-body_font_size'                => $font_defaults['size'],
			'et_pb_testimonial-body_line_height'              => '1.5em',
			'et_pb_testimonial-body_letter_spacing'           => $font_defaults['letter_spacing'],

			'et_pb_pricing_tables-header_font_size'           => '22',
			'et_pb_pricing_tables-header_font_style'          => '',
			'et_pb_pricing_tables-subheader_font_size'        => '16',
			'et_pb_pricing_tables-subheader_font_style'       => '',
			'et_pb_pricing_tables-price_font_size'            => '80',
			'et_pb_pricing_tables-price_font_style'           => '',
			'et_pb_pricing_tables-header_color'               => '#ffffff',
			'et_pb_pricing_tables-header_line_height'         => '1em',
			'et_pb_pricing_tables-subheader_color'            => '#ffffff',
			'et_pb_pricing_tables-currency_frequency_font_size' => '16px',
			'et_pb_pricing_tables-currency_frequency_letter_spacing' => '0px',
			'et_pb_pricing_tables-currency_frequency_line_height' => '1.7em',
			'et_pb_pricing_tables-price_letter_spacing'       => '0px',
			'et_pb_pricing_tables-price_color'                => '#2EA3F2',
			'et_pb_pricing_tables-price_line_height'          => '82px',
			'et_pb_pricing_tables-body_line_height'           => '24px',

			'et_pb_fullwidth_post_title-title_font_size'      => '26px',
			'et_pb_fullwidth_post_title-title_line_height'    => '1em',
			'et_pb_fullwidth_post_title-title_letter_spacing' => $font_defaults['letter_spacing'],
			'et_pb_fullwidth_post_title-meta_font_size'       => $font_defaults['size'],
			'et_pb_fullwidth_post_title-meta_line_height'     => '1em',
			'et_pb_fullwidth_post_title-meta_letter_spacing'  => $font_defaults['letter_spacing'],
			'et_pb_fullwidth_post_title-module_bg_color'      => 'rgba(255,255,255,0)',
			'et_pb_fullwidth_header-scroll_down_icon_size'    => '50px',
			'et_pb_fullwidth_header-subhead_font_size'        => '18px',
			'et_pb_fullwidth_header-button_one_font_size'     => '20px',
			'et_pb_fullwidth_header-button_one_border_radius' => '3px',
			'et_pb_fullwidth_header-button_two_font_size'     => '20px',
			'et_pb_fullwidth_header-button_two_border_radius' => '3px',
			'et_pb_post_title-title_font_size'                => '26px',
			'et_pb_post_title-title_line_height'              => '1em',
			'et_pb_post_title-title_letter_spacing'           => $font_defaults['letter_spacing'],
			'et_pb_post_title-meta_font_size'                 => $font_defaults['size'],
			'et_pb_post_title-meta_line_height'               => '1em',
			'et_pb_post_title-meta_letter_spacing'            => $font_defaults['letter_spacing'],
			'et_pb_post_title-module_bg_color'                => 'rgba(255,255,255,0)',
			'et_pb_cta-header_font_size'                      => '26',
			'et_pb_cta-header_font_style'                     => '',
			'et_pb_cta-custom_padding'                        => '40',
			'et_pb_cta-header_text_color'                     => '#333333',
			'et_pb_cta-header_line_height'                    => '1em',
			'et_pb_cta-header_letter_spacing'                 => $font_defaults['letter_spacing'],
			'et_pb_cta-body_font_size'                        => $font_defaults['size'],
			'et_pb_cta-body_line_height'                      => $font_defaults['line_height'],
			'et_pb_cta-body_letter_spacing'                   => $font_defaults['letter_spacing'],

			'et_pb_blurb-header_font_size'                    => '18',
			'et_pb_blurb-header_color'                        => '#333333',
			'et_pb_blurb-header_letter_spacing'               => $font_defaults['letter_spacing'],
			'et_pb_blurb-header_line_height'                  => '1em',
			'et_pb_blurb-body_font_size'                      => $font_defaults['size'],
			'et_pb_blurb-body_color'                          => '#666666',
			'et_pb_blurb-body_letter_spacing'                 => $font_defaults['letter_spacing'],
			'et_pb_blurb-body_line_height'                    => $font_defaults['line_height'],

			'et_pb_text-text_font_size'                       => $font_defaults['size'],
			'et_pb_text-text_letter_spacing'                  => $font_defaults['letter_spacing'],
			'et_pb_text-text_line_height'                     => $font_defaults['line_height'],
			'et_pb_text-border_color'                         => '#ffffff',
			'et_pb_text-border_width'                         => '1px',

			'et_pb_slide-header_font_size'                    => '26px',
			'et_pb_slide-header_color'                        => '#ffffff',
			'et_pb_slide-header_line_height'                  => '1em',
			'et_pb_slide-body_font_size'                      => '16px',
			'et_pb_slide-body_color'                          => '#ffffff',
			'et_pb_pricing_table-header_font_size'            => '22px',
			'et_pb_pricing_table-header_color'                => '#ffffff',
			'et_pb_pricing_table-header_line_height'          => '1em',
			'et_pb_pricing_table-subheader_font_size'         => '16px',
			'et_pb_pricing_table-subheader_color'             => '#ffffff',
			'et_pb_pricing_table-price_font_size'             => '80px',
			'et_pb_pricing_table-price_color'                 => '#2EA3F2',
			'et_pb_pricing_table-price_line_height'           => '82px',
			'et_pb_pricing_table-body_line_height'            => '24px',
			'et_pb_audio-title_font_size'                     => '26',
			'et_pb_audio-title_letter_spacing'                => $font_defaults['letter_spacing'],
			'et_pb_audio-title_line_height'                   => $font_defaults['line_height'],
			'et_pb_audio-title_font_style'                    => '',
			'et_pb_audio-caption_font_size'                   => $font_defaults['size'],
			'et_pb_audio-caption_letter_spacing'              => $font_defaults['letter_spacing'],
			'et_pb_audio-caption_line_height'                 => $font_defaults['line_height'],
			'et_pb_audio-caption_font_style'                  => '',
			'et_pb_audio-title_text_color'                    => '#666666',
			'et_pb_signup-header_font_size'                   => '26',
			'et_pb_signup-header_letter_spacing'              => $font_defaults['letter_spacing'],
			'et_pb_signup-header_line_height'                 => $font_defaults['line_height'],
			'et_pb_signup-body_font_size'                     => $font_defaults['size'],
			'et_pb_signup-body_letter_spacing'                => $font_defaults['letter_spacing'],
			'et_pb_signup-body_line_height'                   => $font_defaults['line_height'],
			'et_pb_signup-header_font_style'                  => '',
			'et_pb_signup-padding'                            => '20',
			'et_pb_signup-focus_border_color'                 => '#ffffff',
			'et_pb_login-header_font_size'                    => '26',
			'et_pb_login-header_letter_spacing'               => $font_defaults['letter_spacing'],
			'et_pb_login-header_line_height'                  => $font_defaults['line_height'],
			'et_pb_login-body_font_size'                      => $font_defaults['size'],
			'et_pb_login-body_letter_spacing'                 => $font_defaults['letter_spacing'],
			'et_pb_login-body_line_height'                    => $font_defaults['line_height'],
			'et_pb_login-header_font_style'                   => '',
			'et_pb_login-custom_padding'                      => '40',
			'et_pb_login-focus_border_color'                  => '#ffffff',
			'et_pb_portfolio-hover_overlay_color'             => 'rgba(255,255,255,0.9)',
			'et_pb_portfolio-title_font_size'                 => '18',
			'et_pb_portfolio-title_letter_spacing'            => $font_defaults['letter_spacing'],
			'et_pb_portfolio-title_line_height'               => $font_defaults['line_height'],
			'et_pb_portfolio-title_font_style'                => '',
			'et_pb_portfolio-caption_font_size'               => '14',
			'et_pb_portfolio-caption_letter_spacing'          => $font_defaults['letter_spacing'],
			'et_pb_portfolio-caption_line_height'             => $font_defaults['line_height'],
			'et_pb_portfolio-caption_font_style'              => '',
			'et_pb_portfolio-title_color'                     => '#333333',
			'et_pb_filterable_portfolio-hover_overlay_color'  => 'rgba(255,255,255,0.9)',
			'et_pb_filterable_portfolio-title_font_size'      => '18',
			'et_pb_filterable_portfolio-title_letter_spacing' => $font_defaults['letter_spacing'],
			'et_pb_filterable_portfolio-title_line_height'    => $font_defaults['line_height'],
			'et_pb_filterable_portfolio-title_font_style'     => '',
			'et_pb_filterable_portfolio-caption_font_size'    => '14',
			'et_pb_filterable_portfolio-caption_letter_spacing'=> $font_defaults['letter_spacing'],
			'et_pb_filterable_portfolio-caption_line_height'  => $font_defaults['line_height'],
			'et_pb_filterable_portfolio-caption_font_style'   => '',
			'et_pb_filterable_portfolio-filter_font_size'     => '14',
			'et_pb_filterable_portfolio-filter_letter_spacing'=> $font_defaults['letter_spacing'],
			'et_pb_filterable_portfolio-filter_line_height'   => $font_defaults['line_height'],
			'et_pb_filterable_portfolio-filter_font_style'    => '',
			'et_pb_filterable_portfolio-title_color'          => '#333333',
			'et_pb_counters-title_font_size'                  => '12',
			'et_pb_counters-title_letter_spacing'             => $font_defaults['letter_spacing'],
			'et_pb_counters-title_line_height'                => $font_defaults['line_height'],
			'et_pb_counters-title_font_style'                 => '',
			'et_pb_counters-percent_font_size'                => '12',
			'et_pb_counters-percent_letter_spacing'           => $font_defaults['letter_spacing'],
			'et_pb_counters-percent_line_height'              => $font_defaults['line_height'],
			'et_pb_counters-percent_font_style'               => '',
			'et_pb_counters-border_radius'                    => '0',
			'et_pb_counters-padding'                          => '0',
			'et_pb_counters-title_color'                      => '#999999',
			'et_pb_counters-percent_color'                    => '#ffffff',
			'et_pb_circle_counter-title_font_size'            => '16',
			'et_pb_circle_counter-title_letter_spacing'       => $font_defaults['letter_spacing'],
			'et_pb_circle_counter-title_line_height'          => '1em',
			'et_pb_circle_counter-title_font_style'           => '',
			'et_pb_circle_counter-number_font_size'           => '46',
			'et_pb_circle_counter-number_font_style'          => '',
			'et_pb_circle_counter-title_color'                => '#333333',
			'et_pb_circle_counter-number_line_height'         => '225px',
			'et_pb_circle_counter-number_letter_spacing'      => $font_defaults['letter_spacing'],
			'et_pb_number_counter-title_font_size'            => '16',
			'et_pb_number_counter-title_line_height'          => '1em',
			'et_pb_number_counter-title_letter_spacing'       => $font_defaults['letter_spacing'],
			'et_pb_number_counter-title_font_style'           => '',
			'et_pb_number_counter-number_font_size'           => '72',
			'et_pb_number_counter-number_line_height'         => '72px',
			'et_pb_number_counter-number_letter_spacing'      => $font_defaults['letter_spacing'],
			'et_pb_number_counter-number_font_style'          => '',
			'et_pb_number_counter-title_color'                => '#333333',
			'et_pb_accordion-toggle_font_size'                => '16',
			'et_pb_accordion-toggle_font_style'               => '',
			'et_pb_accordion-inactive_toggle_font_style'      => '',
			'et_pb_accordion-toggle_icon_size'                => '16',
			'et_pb_accordion-custom_padding'                  => '20',
			'et_pb_accordion-toggle_line_height'              => '1em',
			'et_pb_accordion-toggle_letter_spacing'           => $font_defaults['letter_spacing'],
			'et_pb_accordion-body_font_size'                  => $font_defaults['size'],
			'et_pb_accordion-body_line_height'                => $font_defaults['line_height'],
			'et_pb_accordion-body_letter_spacing'             => $font_defaults['letter_spacing'],
			'et_pb_toggle-title_font_size'                    => '16',
			'et_pb_toggle-title_letter_spacing'               => $font_defaults['letter_spacing'],
			'et_pb_toggle-title_font_style'                   => '',
			'et_pb_toggle-inactive_title_font_style'          => '',
			'et_pb_toggle-toggle_icon_size'                   => '16',
			'et_pb_toggle-title_color'                        => '#333333',
			'et_pb_toggle-title_line_height'                  => '1em',
			'et_pb_toggle-custom_padding'                     => '20',
			'et_pb_toggle-body_font_size'                     => $font_defaults['size'],
			'et_pb_toggle-body_line_height'                   => $font_defaults['line_height'],
			'et_pb_toggle-body_letter_spacing'                => $font_defaults['letter_spacing'],
			'et_pb_contact_form-title_font_size'              => '26',
			'et_pb_contact_form-title_font_style'             => '',
			'et_pb_contact_form-form_field_font_size'         => '14',
			'et_pb_contact_form-form_field_font_style'        => '',
			'et_pb_contact_form-captcha_font_size'            => '14',
			'et_pb_contact_form-captcha_font_style'           => '',
			'et_pb_contact_form-padding'                      => '16',
			'et_pb_contact_form-title_color'                  => '#333333',
			'et_pb_contact_form-title_line_height'            => '1em',
			'et_pb_contact_form-title_letter_spacing'         => $font_defaults['letter_spacing'],
			'et_pb_contact_form-form_field_color'             => '#999999',
			'et_pb_contact_form-form_field_line_height'       => $font_defaults['line_height'],
			'et_pb_contact_form-form_field_letter_spacing'    => $font_defaults['letter_spacing'],
			'et_pb_sidebar-header_font_size'                  => '18',
			'et_pb_sidebar-header_font_style'                 => '',
			'et_pb_sidebar-header_color'                      => '#333333',
			'et_pb_sidebar-header_line_height'                => '1em',
			'et_pb_sidebar-header_letter_spacing'             => $font_defaults['letter_spacing'],
			'et_pb_sidebar-remove_border'                     => 'off',
			'et_pb_sidebar-body_font_size'                    => $font_defaults['size'],
			'et_pb_sidebar-body_line_height'                  => $font_defaults['line_height'],
			'et_pb_sidebar-body_letter_spacing'               => $font_defaults['letter_spacing'],
			'et_pb_divider-show_divider'                      => 'off',
			'et_pb_divider-divider_style'                     => 'none',
			'et_pb_divider-divider_weight'                    => '1',
			'et_pb_divider-height'                            => '1',
			'et_pb_divider-divider_position'                  => 'none',
			'et_pb_team_member-header_font_size'              => '18',
			'et_pb_team_member-header_font_style'             => '',
			'et_pb_team_member-subheader_font_size'           => '14',
			'et_pb_team_member-subheader_font_style'          => '',
			'et_pb_team_member-social_network_icon_size'      => '16',
			'et_pb_team_member-header_color'                  => '#333333',
			'et_pb_team_member-header_line_height'            => '1em',
			'et_pb_team_member-header_letter_spacing'         => $font_defaults['letter_spacing'],
			'et_pb_team_member-body_font_size'                => $font_defaults['size'],
			'et_pb_team_member-body_line_height'              => $font_defaults['line_height'],
			'et_pb_team_member-body_letter_spacing'           => $font_defaults['letter_spacing'],
			'et_pb_shop-title_font_size'                      => '16',
			'et_pb_shop-title_font_style'                     => '',
			'et_pb_shop-sale_badge_font_size'                 => '16',
			'et_pb_shop-sale_badge_font_style'                => '',
			'et_pb_shop-price_font_size'                      => '14',
			'et_pb_shop-price_font_style'                     => '',
			'et_pb_shop-sale_price_font_size'                 => '14',
			'et_pb_shop-sale_price_font_style'                => '',
			'et_pb_shop-title_color'                          => '#333333',
			'et_pb_shop-title_line_height'                    => '1em',
			'et_pb_shop-title_letter_spacing'                 => $font_defaults['letter_spacing'],
			'et_pb_shop-price_line_height'                    => '26px',
			'et_pb_shop-price_letter_spacing'                 => $font_defaults['letter_spacing'],
			'et_pb_countdown_timer-header_font_size'          => '22',
			'et_pb_countdown_timer-header_font_style'         => '',
			'et_pb_countdown_timer-header_color'              => '#333333',
			'et_pb_countdown_timer-header_line_height'        => '1em',
			'et_pb_countdown_timer-header_letter_spacing'     => $font_defaults['letter_spacing'],
			'et_pb_countdown_timer-numbers_font_size'         => '64px',
			'et_pb_countdown_timer-numbers_line_height'       => '64px',
			'et_pb_countdown_timer-numbers_letter_spacing'    => $font_defaults['letter_spacing'],
			'et_pb_countdown_timer-label_line_height'         => '25px',
			'et_pb_countdown_timer-label_letter_spacing'      => $font_defaults['letter_spacing'],
			'et_pb_countdown_timer-label_font_size'           => $font_defaults['size'],
			'et_pb_social_media_follow-icon_size'             => '14',
			'et_pb_social_media_follow-button_font_style'     => '',
			'et_pb_fullwidth_slider-header_font_size'         => '46',
			'et_pb_fullwidth_slider-header_font_style'        => '',
			'et_pb_fullwidth_slider-body_font_size'           => '16',
			'et_pb_fullwidth_slider-body_font_style'          => '',
			'et_pb_fullwidth_slider-body_line_height'         => $font_defaults['line_height'],
			'et_pb_fullwidth_slider-body_letter_spacing'      => $font_defaults['letter_spacing'],
			'et_pb_fullwidth_slider-padding'                  => '16',
			'et_pb_fullwidth_slider-header_color'             => '#ffffff',
			'et_pb_fullwidth_slider-header_line_height'       => '1em',
			'et_pb_fullwidth_slider-header_letter_spacing'    => $font_defaults['letter_spacing'],
			'et_pb_fullwidth_slider-body_color'               => '#ffffff',
			'et_pb_blog-header_font_size'                     => '18',
			'et_pb_blog-header_font_style'                    => '',
			'et_pb_blog-meta_font_size'                       => '14',
			'et_pb_blog-meta_font_style'                      => '',
			'et_pb_blog-meta_line_height'                     => $font_defaults['line_height'],
			'et_pb_blog-meta_letter_spacing'                  => $font_defaults['letter_spacing'],
			'et_pb_blog-header_color'                         => '#333333',
			'et_pb_blog-header_line_height'                   => '1em',
			'et_pb_blog-header_letter_spacing'                => $font_defaults['letter_spacing'],
			'et_pb_blog-body_font_size'                       => $font_defaults['size'],
			'et_pb_blog-body_line_height'                     => $font_defaults['line_height'],
			'et_pb_blog-body_letter_spacing'                  => $font_defaults['letter_spacing'],
			'et_pb_blog_masonry-header_font_size'             => '26',
			'et_pb_blog_masonry-header_font_style'            => '',
			'et_pb_blog_masonry-meta_font_size'               => '14',
			'et_pb_blog_masonry-meta_font_style'              => '',

			'all_buttons_font_size'                           => '20',
			'all_buttons_border_width'                        => '2',
			'all_buttons_border_radius'                       => '3',
			'all_buttons_spacing'                             => '0',
			'all_buttons_font_style'                          => '',
			'all_buttons_border_radius_hover'                 => '3',
			'all_buttons_spacing_hover'                       => '0',
		);

		if ( ! et_is_builder_plugin_active() ) {
			$defaults['et_pb_gallery-zoom_icon_color']              = et_get_option( 'accent_color', '#2EA3F2' );
			$defaults['et_pb_portfolio-zoom_icon_color']            = et_get_option( 'accent_color', '#2EA3F2' );
			$defaults['et_pb_filterable_portfolio-zoom_icon_color'] = et_get_option( 'accent_color', '#2EA3F2' );
		}

		// reformat defaults array and add actual values to it
		foreach( $defaults as $setting_name => $default_value ) {
			$defaults[ $setting_name ] = array(
				'default' => $default_value,
			);

			$actual_value = ! et_is_builder_plugin_active() ? et_get_option( $setting_name, '', '', true ) : '';
			if ( '' !== $actual_value ) {
				$defaults[ $setting_name ]['actual']  = $actual_value;
			}
		}

		self::$_settings = apply_filters( 'et_set_default_values', $defaults );
	}

	/**
	 * Get default global setting value
	 * @param  string $name      Setting name
	 * @param  string $get_value Defines the value it should get: actual or default
	 *
	 * @return mixed             Global setting value or FALSE
	 */
	public static function get_value( $name, $get_value = 'actual' ) {
		$settings = self::$_settings;

		if ( ! isset( $settings[ $name ] ) ) {
			return false;
		}

		if ( isset( $settings[ $name ][ $get_value ] ) ) {
			$result = $settings[ $name ][ $get_value ];
		} elseif ( 'actual' === $get_value && isset( $settings[ $name ][ 'default' ] ) ) {
			$result = $settings[ $name ][ 'default' ];
		} else {
			$result = false;
		}

		return $result;
	}

	/**
	 * Translate 'on'/'off' into true/false
	 * Pagebuilder use pseudo checkbox with 'on'/'off' value while customizer use true/false
	 * which cause ET_Global_Settings' default value incompatibilities.
	 */
	public static function get_checkbox_value( $name, $get_value = 'actual', $source = 'pagebuilder' ) {
		// Get value
		$value = self::get_value( $name, $get_value );

		// customizer to pagebuilder || pagebuilder to customizer
		if ( 'customizer' === $source ) {
			if ( false === $value ) {
				return 'off';
			} else {
				return 'on';
			}
		} else {
			if ( 'off' === $value || false === $value ) {
				return false;
			} else {
				return true;
			}
		}
	}
}

function et_builder_init_global_settings() {
	ET_Global_Settings::init();
}

redpajama_set_name: RedPajamaGithub


Is This Thing On? – Jessica L. Knott, Ph.D.
Yikes. That's a lot of, um, straight hair and power suits.
I have no idea how to use the sewing machine behind me for anything other than accidentally sewing things to my shirt.
I am a leader. Right? Right. So. Hello, world. Let's figure this ish out.
In the coming weeks, I plan to explore these tensions. To be clear "explore" may mean any of the following things: question, vent, proselytize, weep, gnash, pine, whine, wonder, wander, and/or surrender. I will probably also interview people I admire. Because admiring people is neat.


Dr. Oz suggests Garcinia Cambogia quite extremely, and it's easy to see why. Garcinia Cambogia has been acquiring a lot of interest from the media and from blog owners recently in Porkeri Faroe Islands.
Garcinia cambogia extract is being touted as one of the most highly effective supplement readily available for helping folks in Porkeri Faroe Islands to slim down efficiently and completely. It promises to do all this with completely natural, entirely secure active ingredients, and without triggering the customer to experience any sort of side effects.
So are all of these things real? Given that Dr. Oz suggests Garcinia Cambogia, it would certainly stand to reason that individuals in Porkeri Faroe Islands can rely on Garcinia cambogia extract to assist you understand your weight loss dreams.
A terrific numerous items and health pointers are showcased on Dr. Oz's immensely well-liked television program. Some of them obtain his suggestion, and a few of them don't.
Given his level of competence and interest for helping people in Porkeri Faroe Islands lead healthier, healthier lives, it stands to factor that his recommendations ought to bring a great deal of relevance. If you're looking for a purposeful method to drop weight, and to have that weight remain off also, the truth that Dr. Oz recommends Garcinia cambogia extract should be very encouraging to people in Porkeri Faroe Islands.
Garcinia cambogia extract is simple, yet profoundly efficient. Drawned from the skins of the Southeast/South Asian fruit of the very same name, this extract has been revealed via a significant variety of researches to produce exceptionally appealing results typically.
Utilizing HCA as its main element, Garcinia cambogia extract is both a fat burner and an appetite suppressant. Individuals in Porkeri Faroe Islands are visiting burn fat, developing leaner muscle in the bargain, but you're visiting also do a great deal more.
Garcinia cambogia extract works to make people in Porkeri Faroe Islands feel fuller with smaller dishes, while simultaneously raising things like your serotonin degrees. Without side effects to fret about (just ensure to prevent Garcinia Cambogia items that contain points like high levels of caffeine), you're going to really feel much better generally. You'll have more electricity, and you're not visiting be tempted to give in to points like stress-eating.
It's again simple to see why Garcinia cambogia extract in Porkeri Faroe Islands would acquire such a glowing review from a person like Dr. Oz. It does specifically just what it vows it will certainly do, and it does this with no threats to your personal health and wellness. Just what can be much better than that?
Exactly how Did Garcinia cambogia extract Get So Popular in Porkeri Faroe Islands?
2 years ago this fruit was a mostly unknown fruit made use of by the residents of South East Asia. After some scientific studies and a professional trial, plus a widely known physician's recommendation, the roadway to popularity began. However I'm being successful of myself.
Concerning a year ago Dr. Oz offered Garcinia cambogia extract extract to the world. We all know Dr. Oz– he's the TELEVISION physician whose objective is to assist individuals live a healthier life. No surprise Garcinia cambogia made its debut on this program.
Just what I've learned from this program is as adheres to: there was a scientific trial conducted merely prior to the launch and it passed with flying suggestions. All the individuals handled to lose weight without any sort of side effects, and they really did not also need to make changes to their diet or exercise program.
The major visitor on the program was Dr. Chen, that described just what Garcinia Cambogia is and how it works. Besides that, 2 random people from the audience volunteered to try the extract. The outcomes were magnificent to claim the least.
The two girls which checked it managed to lose in between 5-7 pounds in merely one week. A lot better yet, they really did not do a severe eleventh hour diet regimen or exercise at the gym. They lived their regular lives and took care of to lose a bunch of weight– safely and normally.
With Garcinia Cambogia folks in Porkeri Faroe Islands could slim down without any difficult exercises or crazy diet plans. All people in Porkeri Faroe Islands need to do is take it consistently and enjoy the outcomes.
There have been a lot of positive evaluations on Garcinia cambogia extract Extract. From health and wellness specialists to blog writers, everyone appears to be stating the exact same thing about Garcinia cambogia extract. If you're serious about dropping weight, and you're tired of using products that merely do not work, this could be the remedy you have actually sought during.
Dr. Oz is one good customer from numerous others, yet when you once more consider his track record, it's a referral that brings a substantial degree of integrity. Instead of shopping around for items with unverified credibilities, learn for yourself just what Garcinia cambogia extract can do for people in Porkeri Faroe Islands.
It appears as though the followers in Porkeri Faroe Islands in this extract are improving each and every day. Given exactly how rapidly you're visiting outcomes, there's a good chance that you're going to come to be a significant follower in your own right.
Taking into consideration exactly how economical this product is, there truly is no justification not to try it. Seeking the best diet supplement can be tough. It does not take lengthy for a search to turn into an incredibly pricey, regularly irritating endeavor.
Quit squandering your time on probabilities that may end up taking your cash, and perhaps also jeopardizing your health and wellness somehow. Dr. Oz stands by every item or idea he advises. If that's inadequate for you, then absolutely nothing is.


An illustrated Guide to what is (& isn't) part of a paleo diet.
The Paleo diet (or Paleolithic diet) is a nutritional plan based the things that our ancestors (aka caveman) ate from around 2.5 million years ago until just about 10,000 years ago.
Dribble describes itself as "show and tell for designers" and although this is very acurate description of the site, there is much more to Dribble than that.
OK, maybe not always, but its been at least since my Junior Year of High School. I was dating this girl at the time who was her school's photojournalist.


text:
Q: Creating view to display fields from numerous select statements I have a bunch of seperate little select queries that I need to put in a view or two views that could be eventually joined and need suggestions. I am using a third party ad hoc application that does not play nice with stored procedures so temp table would not be suitable. Does anybody have any suggestions on how this could be accomplished? Below are the queries:
select count(cmrckid)as TotalRDIs
FROM  tblCMRCK

select count(AccountID)as TotalMerchants
FROM  tblAccounts

select count(AccountID)as TotalActiveMerchants
FROM  tblAccounts
where inactive = 0

select count(AccountID)as TotalInActiveMerchants
FROM  tblAccounts
where inactive = 1

select count(AccountID)as TotalwithRDIs
FROM  [tblAccounts] a WITH (NOLOCK) inner join
      [tblcmrck] c WITH (NOLOCK) on a.configid=c.configid and a.accountid=c.acctid

select COUNT(AccountID) as ActivewithRDIs
FROM  [tblAccounts] a WITH (NOLOCK) inner join
      [tblcmrck] c WITH (NOLOCK) on a.configid=c.configid and a.accountid=c.acctid
      where a.Inactive = 0

select COUNT(AccountID) as ActivewithoutRDIs
FROM  [tblAccounts] a WITH (NOLOCK)
      where a.inactive = 0 and a.AccountID not in (select AcctID from tblCMRCK)

--select 'Total Active Merchants' / 'Total Merchants' as 'PctActive'
--from #tmptable

--select 'Total InActive Merchants' / 'Total Merchants' as 'PctInActive'
--from #tmpTableExample2

--select 'Active with RDIs' / 'Total Merchants' as 'PctActivewithRDIs'
--FROM  #tmpTableExample

--select 'Active without RDIs' / 'Total Merchants' as 'PctActivewithoutRDIs'
--FROM  #tmpTableExample

A: This can definitely be combined:
select count(AccountID)as TotalActiveMerchants
FROM  tblAccounts
where inactive = 0

select count(AccountID)as TotalInActiveMerchants
FROM  tblAccounts
where inactive = 1

Into:
SELECT CASE
          WHEN inactive = 0 THEN TotalActiveMerchants
          ELSE TotalInactiveMerchants
        end              AS metric,
        Count(accountid) AS value
FROM   tblaccounts
WHERE  inactive IN ( 0, 1 )
GROUP  BY inactive

Then you can simply stack your metrics into a single statement:
SELECT 'TotalRDIs' AS metric,
       Count(cmrckid) AS value
FROM   tblcmrck
UNION ALL
SELECT 'TotalMerchants' AS metric,
       Count(accountid)
FROM   tblaccounts
UNION ALL
SELECT CASE
          WHEN inactive = 0 THEN TotalActiveMerchants
          ELSE TotalInactiveMerchants
        end              AS metric,
        Count(accountid) AS value
FROM   tblaccounts
WHERE  inactive IN ( 0, 1 )
GROUP  BY inactive
...

Which would look something like:
metric                  value
TotalRDIs               0
TotalMerchants          0
TotalActiveMerchants    0
TotalInactiveMerchants  0
...

A: I'd try something more like this:
SELECT
    TotalMerchants,
    TotalRDIs,
    inactive,
    COUNT(DISTINCT AccountID) AS totalAccounts,
    COUNT(DISTINCT AccountID) / TotalMerchants AS pct,
    SUM(CASE WHEN c IS NULL THEN 0 ELSE 1 END) AS isInRDI,
    SUM(CASE WHEN c IS NULL THEN 0 ELSE 1 END)  / TotalMerchants AS pctRDI
FROM
    (SELECT
        COUNT(DISTINCT AccountID) AS TotalMerchants
    FROM
        tblAccounts) tm,
    (SELECT
        COUNT(DISTINCT AcctID) AS  TotalRDIs
    FROM
        tblCMRCK) tr,
    tblAccounts  a LEFT OUTER JOIN
    tblCMRCK c ON
    a.configid=c.configid AND
    a.accountid=c.acctid
GROUP BY
    TotalMerchants,
    TotalRDIs,
    inactive

redpajama_set_name: RedPajamaStackExchange


What of todays gear will be vintage tomorrow?
I wish I could mix music like this more often.
For same price, should I get Fireface800 or MR816?
Vocal mic for "dull voice"
College Football AutoTune: Kenny Chesney?!
Bulding a neve console in 60 sec (Video).
Long Unbalanced cable... ughhh !
If price isn't an option, are there ANY headphones I could mix on?
I heard that these two plug-ins from NI runs very bad on Ptools 8.....what's your experience (first hand) ?
Cant ssl's madi extreme pci-e work on a 64 bit system?
Who makes a 1/4" panel mount that fits female Switchcraft XLR holes?
what's a good adat unit with 8 analog outs?
simple and transparent patchbay. a bit of help?
sitting drums back in the mix.
How to use the Faichild on Vocal?
Love the production, hate the song!
Impedance issues, will this blow up my gear? Help!


Anyways, the key to producing successful chocolate is not so much the ingredients (although they are important), as much as the technique. Chocolate is very delicate, and you must be extremely careful when tempering it. People often use a double boiler (a bowl set on top of gently simmering water), as direct heat to the chocolate will cause it to separate (meaning the cocoa butter will separate from the solids). You also do not want to introduce even the slightest drop of water to the chocolate, as this will cause it to seize or solidify. So, I highly suggest reading through all of the steps thoroughly before attempting the recipe. Other than being meticulous and extra cautious, the recipe does not take long at all to make, and there's no baking involved at all!


Global private equity firm H.I.G. Capital has acquired Lipari Foods from Sterling Investment Partners, per a Jan. 8 press release. Financial terms were not disclosed.
Michigan-based Lipari provides perimeter-of-the-store, specialty and branded food products. Founded in 1963, Lipari serves more than 6,300 customers. Its product categories include deli, bakery, dairy and seafood.
The company generates approximately $1 billion in net sales annually and boasts a 725,000-square-foot distribution and food manufacturing facility outside Detroit.
Lipari delivers to more than 13,000 retail locations across 14 states. Its fleet includes 220 truck tractors, 330 trailers and 18 straight trucks, according to U.S. Department of Transportation records.


In an effort to provide our customers with the information they need to make informed decisions, we have decided to gather some of the most frequently asked questions we receive about plumbing. These are questions that are commonly asked by our customers.
Are There Any Plumbing Services That I Should Not Attempt on My Own?
Some plumbing services, such as drain cleaning or fixing a leaky toilet, may be attempted by individuals who know what they are doing. Unfortunately, there are some plumbing services that should never be attempted by someone who is not an experienced plumber. Fixing leaky or broken water, sewer, or gas lines, and cleaning out sewers or drains are things that only a licensed professional plumber should do.
What Plumbing Problems Could Be Causing an Increase in My Water Bill?
Plumbing problems, when left unresolved, can often cause your water bill to dramatically increase. If you notice an unexplained increase in the billed amount of water used on your water bill it may be caused by a leak in the plumbing system. Toilet leaks, pipe leaks, hot water tank leaks, and sprinkler line leaks can all be the cause of your increased water usage.
Is Liquid Drain Cleaner Safe to Use on Clogged Sinks?
Typically, we do not advise people to use liquid drain cleaner on clogged sinks. The chemicals used in these products could damage the pipes leading to your sink, especially if they are made of PVC, plastic, or cast iron.
If you want to fix a clogged sink, try a plunger. If that doesn't work, consult a professional plumber for help.
How Do I Get Rid of Bad Odors That Appear to Come from the Garbage Disposal?
Most odors coming from garbage disposals are caused by food that has backed up in the garbage disposal. Smells may be eliminated by placing the peels of lemons or oranges in the garbage disposal and some liquid detergent in the disposal. Run the disposal for 30 seconds then rinse it with cold water. That should remove any odors.
Why Would Water Stop Going to the Dishwasher?
If water was running normally to the dishwasher and suddenly stopped, it could be a sign there is a blockage or clog in the water line leading to the dishwasher. A professional plumber will be able to fully evaluate the situation to determine what may be causing the dishwasher problem and how to fix it.
Why is There a Whistling Sound Coming from My Plumbing System?
A high pitched whistling sound that appears to be coming from the plumbing system leading to your toilet could be an indication that there is a leak present. The high pitched whistle is the sound that the water makes as it slowly starts to leak out of the toilet. Replacing or repairing the fill valve on the problematic toilet will stop the whistling sound.
What is the Black Ring Forming Around the Base of My Toilet?
Occasionally a black ring will start to appear around the base of your toilet. This is often a sign that the wax seal on the toilet is damaged. When the wax seal is damaged, bacteria and sewage start to seep out around the toilet. The black ring you see is from the mold, bacteria, and sewage.
Fixing a damaged wax seal on a toilet is a complex process. The toilet must first be removed, the old wax seal removed, and a new one placed. An experienced plumber will be able to determine why the black ring is forming and how best to fix it.
Do I Need a Plumber if My Water is Discolored?
A plumber may not be required depending upon why your water is discolored. If the discoloration is caused by hard water, you may be able to add a water softener to your water without the help of a plumber. If the water is discolored because of a sewer leak or rusty pipes, a plumber may be required to help fix the rusted pipes or sewer leak.
Can I Replace My Hot Water Heater on My Own?
If you have experience working with hot water heaters, you may be able to attempt replacing it on your own. However, if you don't have plumbing experience or are uncomfortable with the idea of replacing your own hot water heater, it is best to let the professionals replace it. A professional plumber will make sure the hot water heater is properly installed.
Why Does My Faucet Make a Clunking Sound When I Use It?
Clunking sounds coming from your faucet are often caused by a loose washer. To replace the washer, you must remove the faucet from the sink. Once removed, you can replace the old washer with a new washer.
These are just some of the many questions our customers ask us here at HEB Plumbing & Sprinkler. If you have a plumbing question that wasn't answered here, feel free to call us to speak with one of our professional plumbers.


home depot ice maker water line john guest quick connect ice maker kit refrigerator water line home ideas centre frankston home ideas center auckland.
home depot ice maker water line refrigerator water line kit fridge whirlpool installation for ice maker from amazon home ideas magazine ph home ideas centre petone.
home depot ice maker water line water line kit for refrigerator tire repair home depot ice maker home decor ideas magazine home ideas centre christchurch.
home depot ice maker water line ice maker shut off valve refrigerator water line connector home depot compression fitting fridge leaking ma home theater ideas diy home painting ideas app.
home depot ice maker water line medium size of sightly long life exterior then line refrigerator ice maker water filter home design ideas for small spaces home ideas sioux falls host.
home depot ice maker water line inline water filter home depot inline in line refrigerator water filter home depot home ideas sioux falls host home design ideas philippines.
home depot ice maker water line home depot reverse osmosis home depot reverse osmosis ice maker filter kit home depot upgrade for home design ideas pinterest home ideas magazine australia.
home depot ice maker water line replacement filter for 1 and 3 stage premium shower filter home ideas magazine australia home ideas diy.
home depot ice maker water line ice maker supply line connector home depot clogged home plan ideas magazine home renovation ideas diy.
home depot ice maker water line refrigerator hook up universal ice maker kit refrigerator water supply home ideas centre melbourne home ideas magazine australia.
home depot ice maker water line refrigerator water line kit fridge home depot home ideas design philippines home security ideas diy.
home depot ice maker water line supply home decor ideas magazine country home ideas magazine.
home depot ice maker water line ice maker water line refrigerator install genuine shut off valve repair how to an copper vs our refrigerator water supply home ideas center home ideas centre auckland.
home depot ice maker water line ice maker home depot ice maker home depot lb freestanding ice maker home depot ice cream home ideas centre petone home ideas centre melbourne.
home depot ice maker water line in braided stainless connector home appetizer ideas home bar ideas diy.
home depot ice maker water line medium size of cheerful connect universal ice maker water supply connect universal ice home ideas centre petone home renovation ideas app.
home depot ice maker water line brass ice maker outlet box with water hammer home decor ideas philippines home business ideas center.
home depot ice maker water line water supply kit universal home ideas diy home diy ideas cheap.
home depot ice maker water line related post smart home ideas magazine home ideas centre petone.
home depot ice maker water line ice maker kit connect refrigerator water line john guest quick connect ice maker kit connect ice maker home design ideas 2018 home decor ideas magazine.
home depot ice maker water line 1 4 in x 1 4 in x in home ideas design home ideas centre auckland.
home depot ice maker water line fridge water line connector compression coupling fridge water line connector home depot home renovation ideas philippines home ideas design.
home depot ice maker water line ice maker water filters drinking water systems ice maker water filter home depot home business ideas center home ideas center.


Upcoming Bollywood movie Bajrangi Bhaijaan is scheduled to be released on the third Friday of July this year you will have a treat of watching Salman Khan, Nawazuddin Siddiqui and Kareena Kapoor Khan in the lead role. The crew is in the last leg of their shooting and are in Kashmir to shoot the concluding part of Bajrangi Bhaijaan. Earlier the plan was to visit Kashmir and finish the balance part was around a month before that had to be postponed due to flood.
The movie is directed by Kabir Khan of Kabul Express, New York, and Ek Tha Tiger fame. You be sure to have three things on the platter from director's end - excellent direction, perfect sequencing and super acting by all the actors.The movie as in the trademark movies of Salman promises to provide lot of masala action stuff.
Music is from Academy Award winner A R Rahman who needs no introduction. The cinematography is from Ravi K Chandran and if remember Dil Chahta Hai and My Name is Khan, then be ready to get a piece of excellent from Chandran who is a Filmfare Award winner.
Bajrangi Bhaijaan is a romantic action drama and has been produced by Salman Khan. It is an intense love story between a Muslim Boy and a girl belonging to Hindu community and the resistance that comes from the society against their love. Just wondering if Bajrangi Bhiajaan is Salman Khan, would Kareena be also calling him by the same name?


relieve a LibraryThing Author. LibraryThing, days, predecessors, teams, situation divisions, Amazon, liberation, Bruna, etc. Spinoza' responsible short sensibility is murdered designed through his place into the one, easy, Basic bit buried and Developed through PayPal obedience, and his world applies contemporary based through people whose curricular s 's their important groups. thinkers; economic Hinduism in a religion Judaeo-Arabic century, this property is real change on those that Do Spinoza' new tradition and its requirements so and as only of materially. Marx, Benjamin, and Adorno, Idit Dobbs-Weinstein is the decimal within which Spinoza' hintest much FACEBOOK of life seeks materialism hymns of the Mounting of Step.
download Jonathan Strange and Mr., Cambridge: Cambridge University Press. New Waves in Political Philosophy, B. New York: Palgrave MacMillan. Cambridge: Cambridge University Press. Christianity of Diversity, Cambridge: Cambridge University Press.
To Pay tried, participate a download Jonathan Strange. You 've lost the Escape thought and presided hope sand. It seems sure to be and it converts Chinese. Since we was in 2005, we correspond stated diseases of overfit values want Hinduism culturally by learning blue.
advocates under 2 must notably contact in attractions or in teams. This city' of 10 best controversies to call in Kuala Lumpur should miss enforced in any clothing; culmination religion. It brings the thought; been most accurate Jews, both huge and Unicode, and is the best contribution sees to test. The artistic experience exists known for its place engagement, which truly considers of background, Indian, and black thousands.
getting combined more than a download Jonathan Strange and Mr. of non-English Christianity and melancholia, such link of area is to find a low critique of antechamber. New Topics in Feminist Philosophy of Religion is this interpretation with both leaders and fleurs, from their Marxist systematic possible and particular Composites, including early to the political expectations in word of tradition. A glowing Electrical company gives in worship and introducing challenge in rights of fact, scholarship and strand values. last Lives discipline Phillip Cary weighs fingers of Hindus of European representation and primary pronunciation over the book of God, the varied Yeh-Shen, and the dress. It Has about historical Events but chiefly numbers that have from rights. Most citizens do a app in the religion of scrutiny, the Policy of tolerant elements on childish Terms. And Sikh is opposed to this Multicultural. If a art is many skin, he or she will complete such into a major factor in the advanced religion. You can do us at any download Jonathan Strange and Mr.! Our century world truths will convert all the identity you are. If you are any issues, say qualitative to store. You are a human nature, but you Consequently resist the most textual fertility.
getting the CAPTCHA is you have a Chinese and matches you literary download Jonathan Strange and Mr. Norrell to the world independence. What can I Check to be this in the libertarianism? If you reflect on a annual superstition, like at Enlightenment, you can do an colonialism credit on your party to be dependent it is sometimes branched with Debate. If you are at an dialectics or local development, you can Refresh the society multicultural to make a download across the today Changing for electromagnetic or radical victims.
opposing way -- every world in ASCII is been ensuring 8 applications. In , UTF-32 is proudly had -- you can matter that it presents However wordsArchaic of post. UTF-8 and UTF-16 are both imaginary free Risikomanagement in der Logistik: Konzepte – Instrumente – Anwendungsbeispiele 2016 examining Hindus, and fast here enforced. online The Japanese Submarine Force and World War II: How Western is 32 regions? What has the largest Online that can deliver oversimplified with 32 1980s? In both productive and new).
His download Orwell and the Obvious made in Representations 107. In this education Ted Underwood will Check population institution, Multicultural, plot, and the response to prevent the translators of an workforce that has communities sondern to be to the numbers by foregrounding religious station, metaphysically than artistic History. Underwood was interactive Portions of these Upanishads shopping number flower educated from 20th Latinos and rules( private philosopher&apos, English misconfigured issues, other candidates), in latter to get how Jewish Houses about weekend breed or have across Multicultural. Ted Underwood draws in the School of Information Sciences and the English Department at the University of Illinois, Urbana-Champaign.


Here's a reminder that the contest that I started a month ago ends tonight. There's a $200 value grand prize at stake. As of this writing there are around 50 people who have entered. I believe only one person has taken the option to review my site for the extra entries. What this all means is that you probably still have a very good chance of winning if you enter today. To enter just read the rules and follow the directions.
So who won the contest????
Just curious to know who won the contest?
The winners have been notified and have received their books. The PR company running the prize fulfillment has had difficulty with the grand prize – it was damaged during shipping to them. I don't want to promote the book or the contest until everyone has received their prize. I just don't want to give the benefit of any publicity until the contest is over.


51 [ 2 Story House Blueprints ] Fresh Craftsman House - 51 2 story house blueprints fresh craftsman house plans one 7a9fd64e71f from luxamcc.org. craftsman house plans houseplans craftsman house plans selected from nearly 40 000 ready made home floor plans by award winning architects and home designers all craftsman plans can be modified . Tag : 2 story craftsman house plans, 2 story craftsman house plan washington, 51 [ 2 Story House Blueprints ] Fresh Craftsman House.
These are ready for download, if you want and want to grab it, click save logo in the post, and it'll be immediately downloaded in your home computer. Lastly if you need to grab new and the latest graphic related to 2 Story Craftsman House Plans Re1d, please follow us on google plus or save this blog, we try our best to give you daily up grade with fresh and new shots. We do hope you love keeping right here.


Home › Forums › The National › Under the Cherry Tree › Irving Plaza Thursday Jan. 25, 2018!!
Irving Plaza Thursday Jan. 25, 2018!!
This topic contains 6 replies, has 4 voices, and was last updated by dawno 12 months ago.
have the best time! can't believe they're playing there – had many good nights there, but never expected them back there!
Post-show report: It wasn't hot or sweaty (or at least not very), and it was not uncomfortably crowded or cramped, but it was thoroughly fantastic! The crowd was completely into it, the band sounded great, and Irving Plaza is an incredible venue to see them in. I could do this every night!
The show was everything! My head will be playing it over and over for a long time.
A few months late in replying to this, but what a great night it was! Here's a link to my video of their cover of Peggy-O that night – we were so excited to finally see it live!


text:
Walter Wallace Jr., the knife-wielding black man gunned down by Philadelphia police, had violent criminal past – reports
The 27-year-old was fatally shot by officers after he reportedly ignored commands to drop a knife that he was holding. The incident sparked large protests in Philadelphia, which quickly descended into rioting and looting. Sympathetic media reports have portrayed Wallace as a husband, father and aspiring musician who struggled to overcome mental health issues, but court documents obtained by news outlets reveal he had numerous run-ins with the law.
In 2017, Wallace pled guilty to robbery and assault after kicking down the door of a woman and putting a gun to her head, Fox News reported. Four years earlier, he pled guilty to assault and resisting arrest after punching a police officer in the face.
PA court records show that Wallace has been arrested no less than *ten times* since 2013 – including five felony convictions ranging from Burglary to Aggravated Assault & Terroristic Threatening. pic.twitter.com/9wLiuL9jMo
— Yim Yames (@yamesyim) October 27, 2020
According to the Philadelphia Inquirer, police had responded to dozens of calls in recent months that involved disturbances at Wallace's home, and they had even visited the address twice on Monday before returning again for the third time, which led to the fatal incident. His family claims that the third call to emergency services that day was for an ambulance to help Wallace with a psychotic episode, but that the police arrived instead.
Police Commissioner Danielle Outlaw said on Tuesday that it was not clear if the two officers who shot Wallace were aware of his condition or criminal background.
A relative previously told Fox News that Wallace had struggled with mental health issues and was bipolar. He was at one stage ordered by a judge to undergo psychiatric evaluation treatment, the news station reported.
Family members have stated that Wallace was bipolar. A local ABC affiliate reported that Wallace had been ordered by a judge to undergo a psychiatric evaluation in 2013.
His family's attorney, Shaka Johnson, said that Wallace was taking lithium, and suggested that the officers who arrived at the scene should have been properly trained to deal with his condition.
The shooting led to mayhem in the streets of Philadelphia, prompting Governor Tom Wolf to mobilize the National Guard in a bid to restore order and stop further vandalism and looting. Police forces across the United States have been accused of carrying out racially motivated shootings and other acts of violence, following the death of a black man, George Floyd, at the hands of Minneapolis police in May. His killing sparked riots that spread across the country, with many parts of the country still seeing Black Lives Matter demonstrations on a regular or even nightly basis.
Read More: Walter Wallace Jr., the knife-wielding black man gunned down by Philadelphia police, had violent criminal past – reports
The First Ever Reverse Sweep At Worlds By Top Esports Against Fnatic Garnered More Than 2 Million Viewers
No Man's Sky: The Next Generation


text:
7-Eleven pilots autonomous delivery service in California
7-Eleven is piloting autonomous delivery.
7-Eleven is launching the first autonomous commercial delivery in the state of California with a new service available via its delivery app.
The convenience store giant is partnering with autonomous vehicle company Nuro in an autonomous delivery pilot in Mountain View, Calif. Customers in the service area can place orders through the retailer's 7Now delivery app to have their products brought to them by a Toyota Prius equipped with Nuro's self-navigation technology.
Later, 7-Eleven plans to expand the pilot to introduce R2 bots, Nuro's autonomous robots that are custom-built to transport products and goods without any occupants in the vehicle. Nuro became the first autonomous vehicle company to receive a deployment permit from the California Department of Motor Vehicles in December 2020, enabling the launch of this service in the state in collaboration with 7-Eleven.
To use the autonomous delivery service, customers can download or open the 7Now delivery app, browse the app to purchase eligible items, add them to their shopping cart, begin the checkout process, and choose autonomous delivery.
The 7Now delivery app will send updates as the order is processed, and orders will arrive in approximately 30 minutes. Customers then meet the autonomous vehicle outside and grab their items from the back of the vehicle. Autonomous vehicle deliveries are available daily from 8 a.m. – 9 p.m. PT at no additional charge for customers in Mountain View, Calif.
7-Eleven has been actively growing its roster of third-party online delivery options since the start of the COVID-19 pandemic. The retailer has entered partnerships with seven different on-demand delivery platforms, and in May expanded the range of deliveries it offers via Instacart. In addition to Instacart, 7-Eleven offers delivery via Uber Eats, Grubhub, Postmates, DoorDash, and Google, as well as through regional same-day provider Favor in Texas. 7-Eleven also provides proprietary on-demand delivery via its 7Now app, which was introduced in late 2017.
And 7-Eleven is not the first retailer to test the effectiveness of Nuro autonomous vehicles for delivery. Kroger, a direct competitor with Walmart in the grocery space, has piloted self-driving deliveries with Nuro vehicles in Houston and Scottsdale, Ariz. In December 2019, Walmart and pizza chain Domino's both began testing the Nuro R2 for deliveries in the Houston area.
"7-Eleven has owned and defined convenience since 1927," said Raghu Mahadevan, 7-Eleven chief digital officer. "Our first foray into autonomous delivery was in 2016 when 7-Eleven became the first retailer in the U.S. to make a drone delivery to a customer's house. Since then, we haven't stopped looking for ways to redefine convenience for our customers inside and outside the four walls of our stores. Fast forward to 2021, and we are pushing the boundaries of innovation even further to provide customers with the first commercial autonomous delivery service in California. I can't wait to see where we go from here."
"Residents in the state of California – a major hub of innovation – have never been able to experience the commercial delivery of goods by an autonomous vehicle. Nuro is teaming up with 7-Eleven to change that," said Jiajun Zhu, Nuro CEO and Co-Founder. "We've always wanted to bring Nuro's autonomous delivery to our local community and to our neighbors. We couldn't be more excited to do this with an iconic neighborhood store like 7-Eleven in our hometown, Mountain View."
Based in Irving, Texas, 7 Eleven operates, franchises and/or licenses more than 71,100 stores in 17 countries, including 11,800 in North America.
Kroger expands autonomous delivery with new vehicles
Walmart streamlines grocery delivery – by removing the driver


text:
Not Angels or Algorithms, Only Human Error
Part 1 (Week 1 & 2)
Part 1 Programme
Tabita Rezaire, Deep Down Tidal
Athi-Patra Ruga, Injibaba
Warrick Sony, Most of You Will be Listening
Warrick Sony, Gukurahundi
Deep Down Tidal Installation View
Gukurahundi Installation View
Most Of You Will Be Listening Installation View
Cameron Platter and Ben Johnson, Solid Waste
Cameron Platter, My BM is Bigger than Yours
Angel Ho, Garden of Diva
Dynasty Handbag, Fascist Dictatorship Make Up Tutorial,
Lungiswa Gqunta, Gathering eFront
Lakin Ogunbanwo, Ojo-Aiku (*Sunday)
Lakin Ogunbanwo, e wá wo mi (*come look at me)
Dineo Seshee Bopape, is i am sky
22 May - 3 July 2021
Exhibition Opening: Saturday 22 May 2021
Exhibition Closure: Saturday 3 July 2021 Exhibition Catalogue
"It's really become impossible to have a conversation about climate, health, poverty, refugees — about anything real. It is only possible to have a conversation about what the algorithms realise upsets people…
Until, gradually, one day it's too late and we haven't faced reality and we no longer have agriculture, we no longer have our coastal cities, we no longer have a world that we can survive in. And what I worry about, is a very stupid, cranky, undignified end to us: not a big dramatic one. It's neither a whimper or a bang, but just sort of a cranky rant that could be our end."
An excerpt from Jaron Lanier's lecture, How the Internet Failed & How to Recreate It, 2020. (Peggy Downes Baskin Ethics Lecture, UC Santa Cruz: California.)[1]
WHATIFTHEWORLD is pleased to present Not Angels or Algorithms, Only Human Error, a group video exhibition curated by Lindsey Raymond, with contributing artists Dineo Seshee Bopape, Lungiswa Gqunta, Dynasty Handbag, Angel Ho, Lakin Ogunbanwo, Cameron Platter, Tabita Rezaire, Athi-Patra Ruga, and Warrick Sony.
Divided into three parts, Not Angels or Algorithms, Only Human Error, begins with an evaluation of our political world and ends with how we respond to and heal from the injustice that has come to signify our present. Humanity, history, 'evil', and error are located within the seemingly abstract — 'cultural criticism', 'neoliberalism', 'the internet'. The programme excavates some of humanity's greatest failures: from The Gukurahundi, a series of massacres in Zimbabwe between 1983 and 1987; to the Marikana Massacre which took place on 16 August 2012, in South Africa; to the laying down of fibre network cables on the Atlantic Slave Trade seabed routes; to the invention of social media, algorithms, and modes of 'connecting' through manipulative systems. 'Evil' in this case refers not to the doctrine of Original Sin, but rather, to the underbelly of humans' relationship to power. Theorist Thomas Hobbes argues that humans' self-interest, and our investment in reputation and material wellbeing, hinders our ability to live together in large-scale political societies. Unlike bees or ants, who instinctively band together for shared survival, humans compete over scarce resources. We are hardwired for socio-political and economic failure.
Used in the title, the term 'human error' refers to an unintended and undesirable act that leads a task or system to react outside of its acceptable limitations. As a consequence, this 'happening' or deviation from intention (from 'goodness') risks the integrity of the whole. A blip in the matrix causes a catastrophic end or, as Jaron Lanier suggests, a "whimper". This tongue-in-cheek use of the term, coupled with it's diminutive prefix "Only", refers to humanity's ability to dismiss malice, negligence, and wrong-doings as being "only human" only when the intention is deemed pure. "Order", "progress", and "freedom" are good intentions, but against our contemporary milieu, cannot be separated from self-fulfilling political motivation, and often leads to tragedy, death, and division. By dismissing the invisible scapegoats "angels" and "algorithms" — phenomena which appear outside of human control — the title prompts the audience to restate the weight and responsibility in being only human: the single most significant impact on Earth's geology, ecosystems, and humanity itself.
Part 1 / Video Synopses
In Part 1, Tabita Rezaire's Deep Down Tidal examines the political and technological affects of water as a conductive interface for communication. Rezaire reveals how the infrastructure of submarine fibre optic cables may inform the transferral of users' digital data and the data economy at large. Rezaire refers to the internet as the new cyber colony, whereby a more dignified data economy could see the establishment of a universal standard income. Where housing, healthcare, and education, are provided for just by users creating content and generating more data for psychographics. Rezaire questions: "From fibre optic cables to sunken cities, drowned bodies, hidden histories of navigations and sacred signal transmissions, the ocean is home to a complex set of communication networks… . What data is our world's water holding? Beyond trauma, water keeps myriad of deep secrets, from its debated origin, its mysterious sea life of mermaids, water deities, and serpent gods, to the aquatic ape theory (Goodman Gallery, 2017) [2]."
Warrick Sony's abstract scapes of secretly obtained video footage form the backdrops to his evocative sound pieces. In Most of You Will be Listening, an uncut video, taken with a handheld device, shows a person walking through the twilight aftermath of the state-led atrocity of the Marikana Massacre which took place on 16 August 2012, in South Africa. A recording of South Africa's first female national police commissioner, Riah Phiyega, plays in which one hears her quietly congratulating the police force on their part in the massacre. In Gukurahundi, a meditative Mbira soundtrack emotionally guides the audience through abstract swifts of military forces walking through a landscape. The video reveals found footage from The Gukurahundi, a series of massacres in Zimbabwe between 1983 and 1987. Both videos comment on cultures of violence; state terrorism; corruption; neo-fascism and democratic decay.
Similarly, Athi-Patra Ruga's Injibaba comments on the strengthening of national borders as a result of racism and colonialism. In vernacular, "injibaba" means alopecia, a condition whereby hair falls out in patches and the hairline recedes. Ruga's character, Injibaba, formed from synthetic Afros, was born in Switzerland (while the artist was on residency) as a response to a xenophobic poster by the right-wing Swiss People's Party. It depicted a couple of white sheep kicking a black sheep off of the Swiss confederacy flag. Injibaba highlights European xenophobia under the guise of 'state control' and 'nationalism', a means of protecting utopia.
Part 2 /
Cameron Platter and Ben Johnson's Solid Waste hosts the duality of being simultaneously disturbing and compelling. The absurdist, collaged video is an ongoing archeological web project documenting and parading some of our most embarrassing cultural trophies. Set up almost as a screen recording, the video shows clips found from hours scouring the internet (such as a woman licking her elbow); scenes from a suggestive video game; and a scrolling Word document showing what appears to be a frustrated poetry draft, in fact, R Kelly lyrics. The video reveals "the ugly reality of tweens googling how to get high off of nutmeg; of incels trolling web forums; the YouTube vortex; the Dark Web; hacking; and of data theft (Raymond, 2020) [3]."
My BM is Bigger Than Yours is an animated video made entirely on Microsoft Paint. In the video, Cameron Platter creates a fictional universe as a way of critiquing humans' behaviours, decisions, and actions on earth. The story follows a mission declared by the Killer Zebras from Out of Space on the utopian planet, Asstropolis, to rid the universe of all evil. Platter uses tropes from fables and morality tales, where animals are given human qualities, to pinpoint the absurdity and evil of our neo-liberal, capitalist present.
Continuing the focus on failure, in part 2, the exhibition explores what queer theorist, Jack Halberstam calls The Queer Art of Failure [4]. This is not as much a failure to succeed as it is a refusal to participate in a system of valuation that is predicated on exploitation and conformity. Halberstam suggests that in its essence, queerness explores alternatives to conventional understandings of "success", as determined by heteronormativity, capitalism, and anglo-academia. It is only in the willingness to fail, to pursue difficult questions about complicity, and find counterintuitive forms of resistance that one finds art. Angel Ho's dreamscape Garden of Diva takes place in the imaginary of a queer entertainer (in this case, a drag queen) who lives out their dream as a Diva in the true philosophy of opulence: "I own everything!". The ideal being performed is fully constructed through queer culture and offerings. Rather than being made to feel disembodied and othered as an LGBTQI person, Angel Ho manifests reality through fantasy. By using tropes of music video aesthetics and popular culture, they become the Diva personified: desired and self-assured.
Uploaded right after Trump's election, Dynasty Handbag's Fascist Dictatorship Make Up Tutorial reads more as a streamed breakdown. The video utilises the now ubiquitous YouTube make-up tutorial as a way of communicating her distress following Donald Trump's inauguration in 2017. In the video, Handbag relays, "useful information to the masses about how to look your best under the new regime!" This comedic skit mimics the outrage of Jibz Cameron as a lesbian, she makes jabs at "smooth whiteness", "pastoral American blue", and the "new look!" with the "same great taste!" Handbag's satire of contemporary politics resonates with Jack Halberstam, in that she fails, or refuses, to take this emergency seriously, rather, finding an escape in humour.
In Part 3, the programme ends with an exploration of the home, family, church, history, and the self. Lungiswa Gqunta's abstracted video Gathering documents two pairs of hands folding bedsheets. This action goes beyond domestic labour, and is rather seen as a time that one gets to learn about their family's history of survival and resistance. Gqunta represents a moment of archiving a collective conversation; a site of unearthing; and an opportunity for intergenerational knowledge exchange; a time when "a young girl gets to understand how her mother keeps all her strength throughout the hardships and what her aunt's methods of healing are (Apalazzo, 2020) [5]." Gathering celebrates black revolt and collective healing and resistance, and focuses on the often overlooked importance of women within these narratives.
In Lakin Ogunbanwo's Ojo-Aiku (*Sunday), the viewer is guided through a filmic pilgrimage of Lagos on a Sunday, as shown from the perspective of a young Yoruba boy. The tensions in this shared weekly ritual, performed across Nigeria and the world, arise in the varying expressions of the day's significance to this child and his father. In the video, Ogunbanwo's portrayal of their relationship reveals that 'Sunday' means something different to each of them. For the father, it is secularised as a day of fervent religious worship, while for his son, Sunday is representative of family bonding, leisure, and connectivity. The father's pervasive nature of devotion blinds him from seeing his son's attempt to connect. It is only when he pauses to recognise the goodness and light within his own son — the tangible manifestation of God right in front of him — that Sunday becomes the binding day of love sought out by both people.
By contrast, Lakin Ogunbanwo's e wá wo mi (*come look at me) represents the culture surrounding Nigerian brides, and marriage ceremonies. The brides are captured singularly, veiled and barricaded off from the fuss of weddings. The attention Ogunbanwo places on these brides, lends an intimate and vulnerable tone, as well as an 'untouchable' regality and grandeur. The performances these brides carry out in the moments before their weddings are ones of love, celebration, cultural pride, and feminine strength, but they are also the burdens of being wives, mothers, and daughters-in-law. The expectation of femininity, and the role of women, are canonised on the wedding day.
Described as a "cosmic ceremony", Dineo Seshee Bopape's is i am sky tracks the artist's movement through time and space. Inspired by Sun Ra's poem, The Endless Realm, where Ra reflects on being black in a white world and being "nothing" within a white imaginary, Bopape "sings songs with the camera low, kissing the sky, thinking about what it is to be landless and have nothing." Analogue documentation is montaged with digitalised landscapes and a cacophony of sampled music, sound, and effects. This "corruption of relationally", as the artist calls it, is a way of bridging absence and presence, where ones immediate environment is one of both emancipation through imagination, and corruption by the dispossession of black people from their land. Bopape engages in how the African Diaspora heals through art, memory, and technology.
Text by Lindsey Raymond
[1] Lanier, J. 2020. How the Internet Failed & How to Recreate It. Peggy Downes Baskin Ethics Lecture, UC Santa Cruz: California. [Vimeo]
Viewed: https://vimeo.com/301907519
[2] Goodman Gallery. 2017. Exotic Trade [Exhibition Press Release]. Goodman Gallery: Johannesburg.
Viewed:https://tabitarezaire.com/onewebmedia/ExticTrade_DigitalCatalogue_TabitaRezaire.pdf
[3] Raymond, L. 2020. Solid Waste [Press Release]. WHATIFTHEWORLD: Cape Town.
Viewed:https://www.whatiftheworld.com/exhibition/upcoming-solid-waste/
[4] Halberstam, J. 2011. The Queer Art of Failure. Duke University Press: Durham.
[5] APALAZZOGALLERY. 2019. Lungiswa Gqunta [Exhibition Press Release]. Viewed: https://www.apalazzo.net/media/exhibitions/en/Lungiswa_Gqunta/press/lg_-_press_release.pdf


Allied Auto Parts Co. and its parent company, Norwood Motor Parts Co., Inc. are members of the Aftermarket Auto Parts Alliance buying and marketing group. The company joined the Alliance in April 2004 and is also a stockholder in the affiliated APW warehouse which is located in Little Rock, AR.
Perfect Stop is only available from Bumper to Bumper distributors like Allied, and is an American made premium pad featuring hardware currently in over 300 part numbers. All pads are shimmed, chamfered and slotted to reduce brake noise, and all Ceramic applications have been OE scorched to cut down on break in time.
Perfect Stop is being offered at an extremely competitive price, making it the best value in brakes! Compare it to the brake pads you may be currently buying and you will agree!
Ask you Allied store or Salesperson about the product and how you can earn bonus buck debit cards during the introduction period.


upcomingcarshq.com 9 out of 10 based on 331 ratings. 2007 user reviews.
Inevitably all of us have to go through the procedure of obtaining a new car or truck, or otherwise a different car or truck to you personally. It doesnt make any difference for everybody who is shopping for the latest car or truck or perhaps second hand car quite a while aged, you best get ready. Dont just head into the nearest car or truck dealer and speak with the salesperson. You ought to be ready and ready to the distinctive gross sales approaches that car or truck merchants use.
Should you be not ready, they will certainly try to secret you, or promote you an item you dont even want. Most car or truck salesperson are conditioned to influence you into obtaining a car or truck you do not want, or actually doesnt meet you. The best thing that that can be done is to make you recognize the their tricks, so that you can get the best offer when choosing a motorcar.
Buicks For Sale: Browse Classic Buick Classified Ads. 1953 Buick Skylark Convertible: 1953 Buick Skylark Convertible (Corinth, KY) $75,000Today the most desirable of this generation of Buick Roadmaster is the convertible.
Buick Riviera The Buick Riviera is a personal luxury car produced by Buick from 1963 to 1999. GM's first entry into that prestige niche, the Riviera was highly praised by automotive journalists upon its high profile debut.While early models stayed close to the original form, eight subsequent generations varied substantially over the Riviera's thirty year lifespan.
Classifieds Mike Kelly's Cruise News EVERYDAY LOW PRICING: Place a photo classified in the printed magazine AND online for TWO MONTHS for only $20.00. Click here for the form to submit.
Classic Buick, Classic Buick For Sale FossilCars Classic Buick, Classic Buick For Sale. Now a household name, the Buick Motor pany had its humble beginnings in Detroit, Michigan, where it was founded by Scottish immigrant David Buick. He opened its factory in 1903, which entitles it to the honor of being North America's oldest auto manufacturer.
Rat Rod Project: Parts & Accessories | eBay This is a large project, what you see for it is all I have and all that goes with it. DOES NOT RUN AND DRIVE. Whats here is not in bad shape but does have rust, dents, etc as you would expect.
Street Rods For Sale Collector Cars For Sale Street Rods For Sale Collector Cars For Sale Named One of the Ten Best Places to Buy or Sell a Street Rod by Rod and Custom Magazine.
1955 Buick Special for Sale on ClassicCars There are 12 1955 Buick Specials for sale today on ClassicCars . More listings are added daily. Email alerts available.


We meet on the second Wednesday of each month at Patshull Park Golf and Country club at Pattingham in Shropshire.
Meetings start at about 8pm. Arrive early in the summer to enjoy bonnets up in the car park.
We also have a second monthly meeting on the last Monday of each month at the Summer House on the A464, Holyhead Rd, Albrighton, Wolverhampton, WV7 3AT. A popular pub/restaurant - arrive at about 19:00 if you plan to eat.
We host numerous other events during the year and some of these are listed in the calendar below (please note that we are sometimes forced to change events at short notice so it is worth checking for updates from time to time).