SEOClerks

List of Hip Hop/ Rap music lovers to promote!

List of Hip Hop/ Rap music lovers to promote!

Looking to promote myself to music lovers who want to look for new HIP HOP music and vote for me in this contest. http://t.co/kENsQYfJU1


Requirements

I am looking for a list of hip hop music lovers who will be linked to my page either through twitter, facebook, email. MUST be real active followers, friends on the internet. No bots, no fakes!! I will find out if you are.


Skills Required

promoting marketing forum blogger email blase

Bids

i can help you by promoting your link and will have at least 5 - 10 retweets from real active. i will also share it on my other social network
all done by me not a bot
thank you !

  • Media
    qt76 Level 1
  • order now!

    hi,

    i am interested in this job, i will promote your music through out soundcloud, myspace, itunes.
    it will comes up with all active and real people. before bid my service, pm me for further discussion.

    regards & thanks,
    sohel

    this is your opportunitie for one of the most effective options for self promotion and one of the best way to get your music heard. it's a very simple thing. all you have to do is get your music out to the djs. i will give you a list of 2,000+ djs. most of theme are hiphop djs. i can't guarantee this djs will all follow you back but many will. i

    Bid On Listing Created 13 years ago in Link Development

    Other jobs by eddyblazejr

    Order Now
    Process Time: 0.32417988777161

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

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

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

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

    SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 2987 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%promoting marketing forum blogger email blase%' ) LIMIT 41SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 2987 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%promoting marketing forum blogger email blase%' ) LIMIT 4

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    /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.0909021SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 2987 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%promoting marketing forum blogger email blase%' ) LIMIT 40.0909020.090902