SEOClerks

Build me a good tipster site

Build me a good tipster site

Hello guys im looking for someone who can build me a site so i can sell my sports predictions
to make the site
add payments
100% to work without any bugs
Month memberships and weekly to be added
also that i can change the prices when ever i want
also that i can add my matches and edit them when ever i want as well

the price is max 50$ i wont give a cent over it,if you want to work the price is 50$ and only pro like sites will be accepted ,dont apply if you cant make the buisness


Requirements

to make the site
add payments
100% to work without any bugs
Month memberships and weekly to be added
also that i can change the prices when ever i want
also that i can add my matches and edit them when ever i want as well
adding the history button
caculating % of winning picks


Skills Required

Website Building

Bids

1. seo service
https://www.seoclerks.com/link-building/279627/seo-rush-first-page-on-google
2. website traffic
https://www.seoclerks.com/traffic/223047/5000-quality-traffic-clicks

hello
have a wonderful day.

i will use a free sub domain, a free hosting and a free template of woo commerce and will arrange all of your products on your website and you can change your product price any time. i have previous experience.

thanks
centurion

hello

i am a professional website builder and my website will help you to turn your business on the top
i am 100% sure you are really like my work i will do this work with my hard work please give me the order of this work

thanks

i will design your membership site

promote your business/products/service online..!! more people check the websites before doing transactions. make most out of the online world and boost your business.

don't spend time on setting up things one by one. let the expert do the job while you work on your business. i will create website for you to promote your business/service.

hi,
i can do your task with quality and time basis.

i looking forward to being hired by you.
thank you.

Bid On Listing Created 9 years ago in Other

Other jobs by Joca97

Order Now
Process Time: 0.29973411560059

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

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

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

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

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52609 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Website Building%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52609 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Website Building%' ) LIMIT 4

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

/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.0596531SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 52609 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Website Building%' ) LIMIT 40.0596530.059653