15% searches made on Google everyday which are new and never ever searched on Google before. In 2007, new keyword searches were 20% to 25% on Google search. While 2013 it was same as of this year. Google is handling mor...
I like using VR Headset. But I worry if by chance the smartphone blasts or get caught with fire. Then there is a huge chance of losing eyes from blast. If it burns your hand then you can manage it somehow by throwing awa...
Researchers have got a way to improve battery life using recycled glass bottles. They made nanosilicon anodes, an important component of battery. This gives more power with fewer charging for lithium ion batteries. More ...
2in1 devices like Surface Pro 4, Galaxy Book which have good processor and both are light weight. Surface Pro 4 comes with Core M, Core i5, Core i7 processor. But this new Galaxy Book 12 inch have Core i5 with built in...
If you park car and forget where parked, then this will help without buying any hardware. First you have to tap on "Save your parking". Then it will show a label where you have parked you car or bike or any other vehicl...
Sudden jump in response time to a too low level of 6 days from a good response time of nearly 6 hours. Anyone else facing similar problems like me? I have been watching this response time jumping from around 6 hours to...
There are many hosting with low database upload size limit like 1MB or 2MB. Don't take such hosting. When you want to transfer a WordPress website with database like 80MB, you or your WordPress assistant will have to spl...
If you add date in permalink structure of your WordPress post, then people will visit it more when it's new. But when your post gets old, chances will decrease even if you have old post which can benefit readers some wa...
I watched these two movies after checking IMDB rating and liked these three. Bone Tomahawk (2015) Dances with Wolves (1990) Mad Max: Fury Road (2015) Actually I'm searching for movies like these. I've kept them i...
Microsoft announced that it will stop giving update to the first version of Windows 10 which was released in July 2015. If you running the Windows 10 1507 build in your system then you should upgrade it to the new Win...
People who have Kaby Lake and Ryzen PCs are facing this problem of being blocked to updates if using Windows 7 or Windows 8.1 . Microsoft says Windows 10 is the only platform which will be supported in computers with the...
If your website or blog getting comments which are no way related to the content of the post, then it's not good. You should remove those comments for the seo safety of your website or blog. If you won't remove those un...
You should use all of the followings to get in touch with your clients Name of your companyAddress of your companyCompany phone numberCompany email idContact form Google map Direction Social Media presence linked wi...
If you use WordPress blog to publish content. You can change permalink structure with WordPress from http://example.com/p?=218 to http://example.com/this-is-post/ You can add seo friendly titles for your contents. Yo...
You may have heard this term "Content is the King". So the content of your post matters and is the crucial element of strategy. Choose the right keywords on which the content will be written. Here the idea to represent t...
Meta description is one of the crucial or major factor in onpage search engine optimization. Meta description content should be around 135 to 160 characters. It may contain structured content and should match the page or...
Apart from SSD hosting upgrade, these are the method to take care to optimize your WordPress website. Choose a good WordPress theme, test all the plugins you need before using, optimize images per page or post, install ...
Do you use WordPress themes and plugins from sources other than WordPress.org or premium theme sources? Some people use WordPress themes and plugins where there is lots of chances of infection. I have seen some themes h...
I'm still using Xampp to test php websites or WordPress website. There are other alternative softwares of Xampp. Which are wamp, lamp, etc. Basically I use PHP, mysql function. Other than these two, I don't use Filezill...
In my country, it was slow & costly before. But now a company Reliance Jio providing us 1GB 4G data per day for 28 days for less than $5 and 2GB 4G data per day for 28 days for less than $8 only. So it's providing 28...
You can get additional traffic with the same content of your blog with little more effort. Create PDF ebooks using your content from your blog. Don't forget to add links inside ebook to your website using tags inside po...
What you prefer for your hosting? Normal HDD hosting or SSD hosting. With SSD hosting your website loads faster than with normal HDD hosting. If you have used SSD in your laptop or desktop, then you can feel how it will ...
To get your WordPress website indexed faster than normal, you have to submit your website to Google webmaster tools. Then create sitemap of your WordPress website and add to Google webmaster tools. Also crawl your websi...
If your https website is showing warning on your browser. Then you may have left some files like CSS, images, javascript, etc. which still loads from http link. That's why you are getting warning. You need to change thos...
Installing free SSL of Let’s Encrypt is now got simpler with some websites like zerossl or gethttpsforfree Also cPanel inc have included a plugin to activate Let's Encrypt free SSL. I asked my webhosting service prov...
I think there should be some settings to change default timezone in orders & conversations. I'm feeling bad seeing the timestamp different than my timezone. I always have to convert it using online converter to know ...
How to unfollow seoclerks deleted user? I have followed some members whose profile can't be accessed. I can't unfollow these two profiles. https://www.seoclerks.com/user/illdo123 https://www.seoclerks.com/user/mcdrec...
Is the minimum withdrawal amount is now $10? I think it was $15 before.
Can I make $1 gigs after I get level 2 ? I know I can make less than $5 gigs when I get level 2. Wondering if to make $1 gig level 2 or level 3 is needed.
How to find the WTB link when you have bidded, but haven't bookmarked the link?
My client's website got hit by Google Panda for spammy link building. So he want to recover & asked for tips from me. Tell me something what you know.
| Match | Count | SQL | Script |
| SELECT * FROM seoclerks.members WHERE username='Aplau' AND status='1' | 1 | SELECT USERID FROM seoclerks.members WHERE username='Aplau' AND status='1' | /opt/clerks-staging/docroot/include/functions/includes/member.php 627 GetUseridFromUsername() () |
| SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=12836 LIMIT 1 | 1 | SELECT count(A.quesid) as total FROM questions A, categories_faq B, seoclerks.members C
where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=12836 LIMIT 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM questions A, categories_faq B, seoclerks.members C where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=12836 ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40 | 1 | SELECT A.*, C.username, C.userlevel FROM questions A, categories_faq B, seoclerks.members C
where A.status='1' AND A.catid=B.CATID AND A.userid=C.USERID AND A.userid=12836
ORDER BY A.sticky DESC, A.date_asked DESC LIMIT 0, 40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * from questions as A where A.status='1' | 1 | SELECT count(A.quesid) as total from questions as A
where A.status='1' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM answers as A where A.status='1' | 1 | SELECT count(A.ansid) as total
FROM answers as A where A.status='1' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM members_ledger WHERE (script='/opt/clerks-staging/docroot/faq.php' OR script='/opt/clerks-staging/docroot/viewfaq.php') AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE (script='/opt/clerks-staging/docroot/faq.php'
OR script='/opt/clerks-staging/docroot/viewfaq.php')
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM seoclerks.members WHERE USERID='12836' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='12836' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
