SEOClerks

Need Social Network site with all Fixins

Need Social Network site with all Fixins

Am looking for Someone Who can Build Unique Social Network With Video, Music, Photo 's, text's posting. Account login with all Major Social Networks, Blogs, Forums, Job Posting and Search, Pch.com preferred Search or Ask or if can't then Google or Bing Site and Web Search! Also Need Matching 2 Banner ads, Store Front with Auction Capability, and it's own Social Currency with ways to earn. (TapJoy, Peanut Labs, TrialPay, Sponsor Pay, and credit purchase Ability! Instant Messenger, Gaming Section like Facebook, and member Email Registration and login!

Facebook Meets YouTube, meets MySpace, meets Amazon Meets Iwon.com, Meets Craigslist LoL

I know Obviously this is Large Job most likely Done in Sections, and More than $50 But am Looking for Permanent IT/Developer
-I need game Apps like Slot machines Where members
can Win Real Prizes and ability to have sponsorAdvertising!


Requirements

-Social Micro Lending Network like Kiva Or Paypals
-Instant Win Prizes Randomly
- Seo Clerk Shop
- Listia Type Auctions or Penny Auction Script/Section
- Ability for Business to have own Pages Like Linked-in and Directory Search
- Games like Iwon.com Especially a Prize Wheel
- Upkeep, Repair, Updates and Upgrades and Continuing Evolving Site and Apps

Am seeking Funding But need A Unique Creative Site with Business plan writing Assistance!
Am Becoming NoN-Profit so can't pay a lot till Recieve Funding but offer Unlimited Advertising capability and willing to give a Contract which will pay Yearly Salary upto $58,000 Yr Depending on Work!

Even Possibility of Being Board Member/Executive Depending on Experience, Quality


Skills Required

design websitedesign Programinh Database customize Socialnetworking MicrosoftOfficeL webDevloping

Bids

hi i can do it exactly as you said and its design will also be great.
but i can only work in next month i am very busy with my current clients this month.

Bid On Listing Created 13 years ago in Social Networks

Other jobs by Ikindness

Order Now
Process Time: 0.15513706207275

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

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

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

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

SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 8684 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%design websitedesign Programinh Database customize Socialnetworking MicrosoftOfficeL... webDevloping%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 8684 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%design websitedesign Programinh Database customize Socialnetworking MicrosoftOfficeL... webDevloping%' ) LIMIT 4

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

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

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

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

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

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

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

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

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

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

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

/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.1050651SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 8684 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%design websitedesign Programinh Database customize Socialnetworking MicrosoftOfficeL... webDevloping%' ) LIMIT 40.1050650.105065