SEOClerks

create an entertainment blog replica to the url i provide

create an entertainment blog replica to the url i provide

Good day, i need an entertainment blog design that's a replica of http://saharareporters.com/ but with a different ccs/color design that will be very user engaging.

And having User Rank/Achievements so to know the top users by comments, Post share on social media etc

and also an easy way to update music for users to download.

please do not bit higher than stated and do not bit if you cant finish project as stated i dont mind using any theme so long i get a replica of the url above


Requirements

SEO optimization
FAST LOAD

Pages: Music/Mp3, Contact, Advertise, Guest Post, Privacy


Skills Required

Wordpress Php Css3 Googlewebmaste Html5

Bids

hello there,
this is jasim. an expert wordpress developer and working with solid knowledge since last 4years. please contact me with your example website. i'm waiting for your response. looking forward to hearing from you.


best regards
modasser jasim
my portfolio: https://modasser-jasim.com

hello i'm php and wordpress developer and i will create for you your blog design similar and better than http://saharareporters.com
this website was designed using drupal (php cms) but i will create yours using wordpress cms because it's better and i can customize anything you want

  1. get responsive and seo friendly website[

hello
sir,
we have done more than 100 websites blogs please check it.
webseosmm.net
martinamotwani.com
webfortuners.com
bestoneline.in
freebiesindia.org
freengo.website
https://divinedianamakeoverstudio.com/
many more. inbox me when you want to start work.
thanks
martina motwani
https://www.seoclerk.com/user/martina

hello,
i can build you a fully functional news/blog website, which will be a replica of saharareporters.com/, with responsive design for mobile devices (act like app on mobiles, so no need any expensive mobile app), social media integration, user review/rating and so on.

video management will hurt you!! so you need to discuss it with me!!

fo

Bid On Listing Created 8 years ago in Programming

Other jobs by jeffproxy

Order Now
Process Time: 0.17119693756104

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='63651' 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='63651' AND A.category=B.CATID AND A.USERID=C.USERID

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

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

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

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 63651 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Wordpress Php Css3 Googlewebmaste Html5%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 63651 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Wordpress Php Css3 Googlewebmaste Html5%' ) LIMIT 4

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

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

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

SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='63651' 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='63651' 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='63651'1UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='63651'

/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='63651' 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='63651' ORDER BY w.bidid ASC

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

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

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

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

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

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

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

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

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

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

/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=2182381SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=218238

/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='315659'1SELECT profilepicture FROM seoclerks.members WHERE USERID='315659'

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

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

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

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

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

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

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

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

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

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

/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.1097931SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 63651 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Wordpress Php Css3 Googlewebmaste Html5%' ) LIMIT 40.1097930.109793
0.0972161SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%artcile%') ORDER BY total_recommendations desc LIMIT 0,400.0972160.097216