USASocialMedia

USASocialMedia has no services

need 10K twitter followers Max $7

hello we need 10K twitter followers. High quality and no drop please. Only ...

USASocialMedia Level 1

Twitterf

G+ Project For Spiderwave Max $10

Hello this project is for 1600 G to be delivered to my url of choice . the ...

USASocialMedia Level 1

Google Plus

Google Adsense Specialist Needed Max $60

Hello, I am looking to hire a google adsense expert for consultation and to...

USASocialMedia Level 1

Google Adsense

450K Twitter Follwers needed Max $195

Hello, We need 450 twitter followers total to be given over 2 accounts. One...

USASocialMedia Level 1

Twitter Follower

2000 Google plus ones needed worldwide and USA Max $50

Hello, We need 2000 google plus ones on our website. The g plus must be sta...

USASocialMedia Level 1

Goodle Googlepl Google

1 million Youtube Views Needed Stable long term prov... Max $200

Hello, We are looking for a stable long term provider who can give us high ...

USASocialMedia Level 1

Youtbe

120 google plus spread over 2 pages Max $5

I need 120 g plus spread over 2 pages but please send extras or replace dro...

USASocialMedia Level 1

google plus

Buyer Reviews

Seller Reviews

Recommendations

Statuses

About

Northcoast Web Services / USA Social Media We are pioneers in the social media advertising industry dating back to the days of Myspace,and have amassed one of the largest and most comprehensive networks in the world! We currently provide Twitter followers, Facebook Likes, Linkedin Connections, web traffic, Google Plus1 Votes, and much more, to our over 150+ resellers. Our extensive list of clients include companies such as u social, ineedhits.com, majon international, buyfanstoday, twitter1K, several Advertising Agencies from all over the world, and many intermediate sized clients as well. Our company boasts the highest quality fans and followers available in the indistry today! All of our services feature users with real and active accounts,created on unique ips from all over the world. We also, feature virtually 24/7 dedicated reseller support for effiecient order processing, and fielding client inquiries. We always, remain transparent to your clients, and will only deal with you. We look forward to serving your client needs! We are very excited to begin offering our services to seoclerk members and making new contacts and clients. We will be offering the highest quality services and we will be offering some amazing special pricing only to seo clerk members; We look forward to serving all of your SEO and Social media needs:)

Details

Response Time	1 day
Total Ratings	134
Last Seen	3020 days ago

More Info

Responses	0
Discussions	0
Verified User	No
Country	US
RSS	RSS feed

Followers (49)

SEOClerks

USASocialMedia has no services

need 10K twitter followers Max $7

G+ Project For Spiderwave Max $10

Google Adsense Specialist Needed Max $60

450K Twitter Follwers needed Max $195

2000 Google plus ones needed worldwide and USA Max $50

1 million Youtube Views Needed Stable long term prov... Max $200

120 google plus spread over 2 pages Max $5

Buyer Reviews

Recommendations

Statuses

Featured Seller

Invalid SQL

Expensive SQL

Suspicious SQL

Match	Count	SQL	Script
SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400	1	SELECT 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 seoclerks.members WHERE username='USASocialMedia' AND status='1'	1	SELECT * FROM seoclerks.members WHERE username='USASocialMedia' AND status='1'	/opt/clerks-staging/docroot/user.php 54 () ()
SELECT * FROM seoclerks.members WHERE USERID=?	1	SELECT profile_data FROM seoclerks.members WHERE USERID=?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1861 GetUserData() GetUserTypes()
SELECT * FROM seoclerks.orders WHERE seller_USERID = ?	1	SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE seller_USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()
SELECT * FROM seoclerks.orders WHERE affiliateUserId = ?	1	SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE affiliateUserId = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()
SELECT * FROM seoclerks.orders WHERE USERID = ?	1	SELECT SUM(price*quantity) as total FROM seoclerks.orders WHERE USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()
SELECT * FROM codeclerks.orders WHERE seller_USERID = ?	1	SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE seller_USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()
SELECT * FROM codeclerks.orders WHERE affiliateUserId = ?	1	SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE affiliateUserId = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()
SELECT * FROM codeclerks.orders WHERE USERID = ?	1	SELECT SUM(price*quantity) as total FROM codeclerks.orders WHERE USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()
SELECT * FROM listingdock.orders WHERE seller_USERID = ?	1	SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE seller_USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()
SELECT * FROM listingdock.orders WHERE affiliateUserId = ?	1	SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE affiliateUserId = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()
SELECT * FROM listingdock.orders WHERE USERID = ?	1	SELECT SUM(price*quantity) as total FROM listingdock.orders WHERE USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()
SELECT * FROM pixelclerks.orders WHERE seller_USERID = ?	1	SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE seller_USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()
SELECT * FROM pixelclerks.orders WHERE affiliateUserId = ?	1	SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE affiliateUserId = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()
SELECT * FROM pixelclerks.orders WHERE USERID = ?	1	SELECT SUM(price*quantity) as total FROM pixelclerks.orders WHERE USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()
SELECT * FROM wordclerks.orders WHERE seller_USERID = ?	1	SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE seller_USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1560 GetUserTypes() ()
SELECT * FROM wordclerks.orders WHERE affiliateUserId = ?	1	SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE affiliateUserId = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1566 GetUserTypes() ()
SELECT * FROM wordclerks.orders WHERE USERID = ?	1	SELECT SUM(price*quantity) as total FROM wordclerks.orders WHERE USERID = ?	/opt/clerks-staging/docroot/include/functions/includes/member.php 1572 GetUserTypes() ()
UPDATE seoclerks.members SET profile_data='{\"userTypeUpdated\":1772563856,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='73668'	1	UPDATE seoclerks.members SET profile_data='{\"userTypeUpdated\":1772563856,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='73668'	/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()
UPDATE codeclerks.members SET profile_data='{\"userTypeUpdated\":1772563856,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='73668'	1	UPDATE codeclerks.members SET profile_data='{\"userTypeUpdated\":1772563856,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='73668'	/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()
UPDATE listingdock.members SET profile_data='{\"userTypeUpdated\":1772563856,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='73668'	1	UPDATE listingdock.members SET profile_data='{\"userTypeUpdated\":1772563856,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='73668'	/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()
UPDATE pixelclerks.members SET profile_data='{\"userTypeUpdated\":1772563856,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='73668'	1	UPDATE pixelclerks.members SET profile_data='{\"userTypeUpdated\":1772563856,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='73668'	/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()
UPDATE wordclerks.members SET profile_data='{\"userTypeUpdated\":1772563856,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='73668'	1	UPDATE wordclerks.members SET profile_data='{\"userTypeUpdated\":1772563856,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='73668'	/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()
SELECT * FROM seoclerks.members WHERE USERID='73668'	1	SELECT lastlogin FROM seoclerks.members WHERE USERID='73668'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetUserLastLoginDays()
SELECT * FROM posts WHERE USERID=73668	1	SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=73668	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal()
SELECT * FROM follow F, members M WHERE F.FOLLOWING=73668 AND F.USERID = M.USERID ORDER BY F.time_added DESC LIMIT 4	1	SELECT F.USERID, M.profilepicture, M.username, M.userlevel, M.status FROM follow F, members M WHERE F.FOLLOWING=73668 AND F.USERID = M.USERID ORDER BY F.time_added DESC LIMIT 4	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUniUserFollower()
SELECT * FROM follow F, members M WHERE F.USERID=73668 AND F.FOLLOWING = M.USERID ORDER BY F.time_added DESC LIMIT 4	1	SELECT F.FOLLOWING AS USERID, M.profilepicture, M.username, M.userlevel, M.status FROM follow F, members M WHERE F.USERID=73668 AND F.FOLLOWING = M.USERID ORDER BY F.time_added DESC LIMIT 4	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUniUserFollower()
SELECT * FROM follow WHERE FOLLOWING=73668	1	SELECT COUNT(FID) AS total FROM follow WHERE FOLLOWING=73668	/opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() ()
SELECT * FROM follow WHERE USERID=73668	1	SELECT COUNT(FID) AS total FROM follow WHERE USERID=73668	/opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() ()
SELECT * FROM posts A, seoclerks.members C WHERE A.active = '1' AND A.USERID = C.USERID AND A.USERID = ? AND A.type != 99	1	SELECT count(A.PID) AS total FROM posts A, seoclerks.members C WHERE A.active = '1' AND A.USERID = C.USERID AND A.USERID = ? AND A.type != 99	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM posts A, seoclerks.members C WHERE A.active = 1 AND A.type != 99 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, C.profilepicture FROM posts A, seoclerks.members C WHERE A.active = 1 AND A.type != 99 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM wanttobuy A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ?	1	SELECT count(A.wantid) AS total FROM wanttobuy A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ?	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM wanttobuy A, seoclerks.members C, categories_wanttobuy D WHERE A.active = 1 AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, D.seo FROM wanttobuy A, seoclerks.members C, categories_wanttobuy D WHERE A.active = 1 AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM wantbids WHERE active=1 AND wantid='24154'	1	SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='24154'	/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
SELECT * FROM categories_wanttotrade WHERE seo='Social-Networks'	1	SELECT name FROM categories_wanttotrade WHERE seo='Social-Networks'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo()
SELECT * FROM wantbids WHERE active=1 AND wantid='10044'	1	SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='10044'	/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
SELECT * FROM wantbids WHERE active=1 AND wantid='8719'	1	SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='8719'	/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
SELECT * FROM categories_wanttotrade WHERE seo='SEO-Reports'	1	SELECT name FROM categories_wanttotrade WHERE seo='SEO-Reports'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo()
SELECT * FROM wantbids WHERE active=1 AND wantid='8443'	1	SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='8443'	/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
SELECT * FROM wantbids WHERE active=1 AND wantid='7937'	1	SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='7937'	/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
SELECT * FROM wantbids WHERE active=1 AND wantid='7908'	1	SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='7908'	/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
SELECT * FROM categories_wanttotrade WHERE seo='youtube'	1	SELECT name FROM categories_wanttotrade WHERE seo='youtube'	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetTradeCatNameFromSeo()
SELECT * FROM wantbids WHERE active=1 AND wantid='7384'	1	SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='7384'	/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()
SELECT * FROM wanttotrade A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY A.tradeid DESC	1	SELECT count(A.tradeid) AS total FROM wanttotrade A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY A.tradeid DESC	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM wanttotrade A, seoclerks.members C, categories_wanttotrade D WHERE A.active = '1' AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, D.seo FROM wanttotrade A, seoclerks.members C, categories_wanttotrade D WHERE A.active = '1' AND A.USERID = C.USERID AND D.CATID = A.category AND A.USERID = ? ORDER BY lastgigedit DESC LIMIT 0, 40	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM codeclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='73668' ORDER BY A.lastgigedit DESC LIMIT 10	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM codeclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='73668' ORDER BY A.lastgigedit DESC LIMIT 10	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM listingdock.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='73668' ORDER BY A.lastgigedit DESC LIMIT 10	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM listingdock.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='73668' ORDER BY A.lastgigedit DESC LIMIT 10	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM pixelclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='73668' ORDER BY A.lastgigedit DESC LIMIT 10	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM pixelclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='73668' ORDER BY A.lastgigedit DESC LIMIT 10	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM wordclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='73668' ORDER BY A.lastgigedit DESC LIMIT 10	1	SELECT A.*, C.userlevel, C.username, C.ip, C.lip, A.lastgigedit FROM wordclerks.posts A, seoclerks.members C WHERE A.active='1' AND A.type!=99 AND A.USERID=C.USERID AND A.USERID='73668' ORDER BY A.lastgigedit DESC LIMIT 10	/opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() ()
SELECT * FROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 1	1	SELECT time FROM inbox2 WHERE MSGFROM = ? AND action = 'delivery' ORDER BY time DESC LIMIT 1	/opt/clerks-staging/docroot/include/functions/main.php 570 getLastDelivery() ()
SELECT * FROM seoclerks.ratings WHERE USERID='73668' AND PID != 0	1	SELECT good, bad FROM seoclerks.ratings WHERE USERID='73668' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM codeclerks.ratings WHERE USERID='73668' AND PID != 0	1	SELECT good, bad FROM codeclerks.ratings WHERE USERID='73668' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM listingdock.ratings WHERE USERID='73668' AND PID != 0	1	SELECT good, bad FROM listingdock.ratings WHERE USERID='73668' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM pixelclerks.ratings WHERE USERID='73668' AND PID != 0	1	SELECT good, bad FROM pixelclerks.ratings WHERE USERID='73668' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
SELECT * FROM wordclerks.ratings WHERE USERID='73668' AND PID != 0	1	SELECT good, bad FROM wordclerks.ratings WHERE USERID='73668' AND PID != 0	/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()
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()