Display Back in Stock Items WooCommerce
Learn the hack to show Back in stock items in a WooCommerce store.
Must have plugins for WordPress
These are must have plugins for any kind of WordPress website from security to marketing, we have covered everything.
Getting started with WordPress Themes and Plugins
WordPress is an open framework that enables you to customize the CMS to your business instead of customizing your business to the CMS, as you would with closed, proprietary systems. When web is water on the earth, WordPress(from here I call it “WP”) is an ocean, Yes it powers around 30%-35% of the websites across …
Getting started with WordPress Themes and Plugins Read More »
Remove Bounced Emails in bulk from Moosend Email list
We had collected the email subscribers from Feedburner (Google discontinued this service) and haven’t much communicated with them since long. We re-launched the service and wanted to make use of our subscribers. We migrated to Moosend (The ultimate email marketing software and marketing automation platform that will not break your bank. Get Moosend now! for better …
Remove Bounced Emails in bulk from Moosend Email list Read More »
Write a SQL query to display alternate records from a table?
For even rows: SELECT *FROM (SELECT e.*,MOD(ROWNUM,2) rn FROM employees E)WHERE rn =0; For odd rows: SELECT *FROM (SELECT e.*,MOD(ROWNUM,2) rn FROM employees E)WHERE rn =1;
Write a query to display manager and employees under them?
select manager,count(employee), rtrim(xmlagg(xmlelement(e,employee||’,’)).extract(‘//text()’),’,’) as “Employees under the Manager” from (select e2.first_name manager,e1.first_name employee from employee e1,employee e2 where e1.reporting_to=e2.employeeid) group by manager;