SEOClerks

Approve/deny images via my cms system, write titles, descriptions and keywords

Approve/deny images via my cms system, write titles, descriptions and keywords

I have a wordpress website with a content management system integrated. I need someone who has great English and a good understanding of memes/fail pictures to manage content on a batch by batch basis.

Simply, a batch contains 500 images. Some images are good, some are bad. If the image is good you must give it a title, a description, a few APPROPRIATE keywords, and put it in the correct category, then click approve. If it is bad then you must simply click delete instead of approve.

This will be regular so I will test people as content is very important, if what you think is funny doesn't align with the website then you will not get the job.

As I said some images will be good, some will not be, also do not expect to delete 50% of a batch and claim you have finished it. Further details will follow, but be expected to be tested if you bid on this, and know that if you do not have great English then you won't be accepted.


Requirements

  • Fantastic English Writing Skills
  • Humourous mind
  • Knowledge of memes/fails
  • Ability to write appropriate descriptions, titles and keywords
  • Partial knowledge of seo is an advantage


Skills Required

Correct english Seo Articlewrite Humour Writing

Bids

i have a great sense of humor, and i make my own memes, which have been shared and tweeted! in the us, very active online, and i am an seo superhero. i've got some spare time, and will be glad to try this out.

i have good english writing skills, i visit meme websites a lot, and i have some websites so no problem with title, description and keywords..

the price is for each batch?
contact me if interested. thank you

hi jjaysunn,
i would be glad to contribute in this regard. i have been running a couple of facebook pages myself since college years and have woven a lot of content around trolls and memes. this job sounds so refreshing to me that i am certain of contributing my best to it.
ping me with queries if any.
happy to help!
regards

i can do your job..i guess i have a creative mind as well as a good angle of vision on anything..so if u are interested,i would like to work for you..thanks

i'm electronics telecom engineer with skills in html,php,css,wordpress,joomla,photoshop,online marketing,smm website,customising & updating content,seo,php,making website ,fixing pc problem online.feel free to contact me
http://share-ask.com
http://gigs.share-ask.com/
http://konarkindex.com/
www.konarkwaterdoc.com
my seo wo

Bid On Listing Created 12 years ago in Article Writing

Other jobs by jjaysunn

Order Now
Process Time: 0.16333603858948

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT querystring, added FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400

/opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once()

SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='9637' AND A.category=B.CATID AND A.USERID=C.USERID1SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating, C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='9637' AND A.category=B.CATID AND A.USERID=C.USERID

/opt/clerks-staging/docroot/viewwant.php 163 () ()

SELECT * FROM ratings_buyer WHERE USERID=311111SELECT sum(good) as thumbup, sum(bad) as thumbdown FROM ratings_buyer WHERE USERID=31111

/opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9637 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Correct english Seo Articlewrite Humour Writing%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9637 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Correct english Seo Articlewrite Humour Writing%' ) LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 551 () ()

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9637 AND A.category=B.CATID AND A.active=1 AND A.USERID=31111 LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9637 AND A.category=B.CATID AND A.active=1 AND A.USERID=31111 LIMIT 4

/opt/clerks-staging/docroot/viewwant.php 568 () ()

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='9637' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc1SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture FROM wantcomments a, seoclerks.members b WHERE a.PID='9637' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc

/opt/clerks-staging/docroot/viewwant.php 835 () ()

UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='9637'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='9637'

/opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() ()

SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='9637' ORDER BY w.bidid ASC 1SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='9637' ORDER BY w.bidid ASC

/opt/clerks-staging/docroot/viewwant.php 1192 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=962081SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=96208

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=1133211SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=113321

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=887431SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=88743

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=1089111SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=108911

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM seoclerks.members as m WHERE m.USERID=280071SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations FROM seoclerks.members as m WHERE m.USERID=28007

/opt/clerks-staging/docroot/viewwant.php 1258 () ()

SELECT * FROM categories_wanttobuy1SELECT * FROM categories_wanttobuy

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

SELECT * FROM posts WHERE USERID=311111SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=31111

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()

SELECT * FROM categories1SELECT * FROM categories

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache()

select * from categories_software order by name asc1select * 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 asc1select * 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 asc1select * 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='96208'1SELECT profilepicture FROM seoclerks.members WHERE USERID='96208'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='113321'1SELECT profilepicture FROM seoclerks.members WHERE USERID='113321'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='88743'1SELECT profilepicture FROM seoclerks.members WHERE USERID='88743'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='108911'1SELECT profilepicture FROM seoclerks.members WHERE USERID='108911'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='28007'1SELECT profilepicture FROM seoclerks.members WHERE USERID='28007'

/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage()

SELECT * FROM seoclerks.members WHERE USERID='31111'1SELECT profile_data FROM seoclerks.members WHERE USERID='31111'

/opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include()

Invalid SQL

count(*)sql1error_msg

Expensive SQL

Tuning the following SQL could reduce the server load substantially
LoadCountSQLMaxMin

Suspicious SQL

The following SQL have high average execution times
Avg TimeCountSQLMaxMin
0.1079471SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 7027 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%diaspora rubyonrails%' ) LIMIT 40.1079470.107947
0.1021311SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 9637 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Correct english Seo Articlewrite Humour Writing%' ) LIMIT 40.1021310.102131