SEOClerks

Clear
Sign In Join

WARRIORFORUM Doesn't Welcome SEOClerks!

  • hitmeasap Level X5
    • 15

    Write the reason you're deleting this FAQ

    WARRIORFORUM Doesn't Welcome SEOClerks!

    Hello everyone,
    I thought I'd share something quite "fun" with you today. It's no surprise that I'm a HUGE FAN of SEOClerks. I always speak well about SEOClerks in any topic I can find. Especially the ones where people are talking about "Fiverr being the best marketplace" etc. Those are the most common ones actually. It's easy to just state the truth in those cases. SEOClerks is more affordable, have outstanding support and well.. SEOClerks beats Fiverr in any way. Except the Traffic part.

    Fiverr has more traffic, but it's not a huge surprise. It's older and it's the largest "playground" around. Anything is accepted and people are buying crazy things. Which you can't on SEOClerks in the same way.

    That said, I don't include links to SEOClerks. I simply say things like "SEOClerks is more affordable" and whatever comes to mind. Without a link!

    Here's what Warriorforum thinks of me for doing that:

    WARRIORFORUM Doesn

    Like stated in the above image:
    "All your SEOClerk posts are being deleted. No more SEOClerk spam." ... But it's still 100% okay to mention Fiverr all day long? That's hard to understand..

    My conclusion is, that Feelancer, which recently bought Warriorforum are doing everything they can to prevent posts about their competitiors.


    Another "fun" thing about this..
    I'm a "War Room Member". I bought MEMBERSHIP FOR LIFE on WF several months back & they're treating me like dirt. No warnings, no nothing. Simply a one week ban.


    Regards,
    hitmeasap

    # General & Misc
    Share post:

    Comments

    Please login or sign up to leave a comment

    Join
    Topseoservice

    Topseoservice

    That is quite unfortunate as WF is restricting talk about SEOClerks which is definitely better than Fiverr. Although I also promote my services through WF signature, and haven't faced any issue till date.
    12 years ago

    Are you sure you want to delete this post?

    NaturalWriter

    NaturalWriter



    Like stated in the above image:
    "All your SEOClerk posts are being deleted. No more SEOClerk spam." ... But it's still 100% okay to mention Fiverr all day long? That's hard to understand..

    Regards,
    hitmeasap


    That is unfortunate! SEOClerks frowns upon promoting other places too. I believe in freedom to express yourself, without spamming, of course.

    The big difference in the above quoted statement is something of HUGE significance.
    Their company is the same as Fiverr. They do not have an affiliate program. I think they're jealous because they're not jumping on the affiliate pattywagon. Whereas we ROCK as affiliates and have MANY of them, which means, the more affiliates there are, the spammier it gets... You know how it goes. Facebook and other social media sites are crunching down on affiliates because of this reason WARRIORFORUM Doesn
    12 years ago

    Are you sure you want to delete this post?

    hitmeasap

    hitmeasap

    That is unfortunate! SEOClerks frowns upon promoting other places too. I believe in freedom to express yourself, without spamming, of course.

    The big difference in the above quoted statement is something of HUGE significance.
    Their company is the same as Fiverr. They do not have an affiliate program. I think they're jealous because they're not jumping on the affiliate pattywagon. Whereas we ROCK as affiliates and have MANY of them, which means, the more affiliates there are, the spammier it gets... You know how it goes. Facebook and other social media sites are crunching down on affiliates because of this reason WARRIORFORUM Doesn



    The main thing I wonder about.. Is "No more SEOClerk spam".
    What do they call spam? 2-3 posts each week that mentions SEOClerk?

    I wouldn't mind being banned if I was trashing threads with "SEOCLERKS IS THE BEST!!!" 10 times per hour.. But I did a few posts each week.. Without links.. 1 week ban isn't much to argue about, however, I didn't even get a warning, no message, nothing. I just got suspended with an incorrect statement. At least in my opinion.

    I didn't notice this myself either. It was a co-worker of mine who told me about this. His account got suspended too, with the same statement as mine. On top of this, you're still allowed to talk about Fiverr.
    12 years ago

    Are you sure you want to delete this post?

    vinothmech

    vinothmech

    Hello everyone,
    I thought I'd share something quite "fun" with you today. It's no surprise that I'm a HUGE FAN of SEOClerks. I always speak well about SEOClerks in any topic I can find. Especially the ones where people are talking about "Fiverr being the best marketplace" etc. Those are the most common ones actually. It's easy to just state the truth in those cases. SEOClerks is more affordable, have outstanding support and well.. SEOClerks beats Fiverr in any way. Except the Traffic part.

    Fiverr has more traffic, but it's not a huge surprise. It's older and it's the largest "playground" around. Anything is accepted and people are buying crazy things. Which you can't on SEOClerks in the same way.

    That said, I don't include links to SEOClerks. I simply say things like "SEOClerks is more affordable" and whatever comes to mind. Without a link!

    Here's what Warriorforum thinks of me for doing that:

    WARRIORFORUM Doesn

    Like stated in the above image:
    "All your SEOClerk posts are being deleted. No more SEOClerk spam." ... But it's still 100% okay to mention Fiverr all day long? That's hard to understand..

    My conclusion is, that Feelancer, which recently bought Warriorforum are doing everything they can to prevent posts about their competitiors.


    Another "fun" thing about this..
    I'm a "War Room Member". I bought MEMBERSHIP FOR LIFE on WF several months back & they're treating me like dirt. No warnings, no nothing. Simply a one week ban.


    Regards,
    hitmeasap


    Hi,
    I too got banned for posting link about Seoclerks. These guys consider our link as spam but allowing Fiverr link. Typically hard to understand their concept. SEO and SMM service in our site is the best compared to fiverr.

    I also heared that Fiverr banned users for offering Social Media services. Then why Warriorforum keeping Fiverr as their pet.
    12 years ago

    Are you sure you want to delete this post?

    sunil0021

    sunil0021

    Well they are jelious of seoclerks WARRIORFORUM Doesn and

    One word for warriorforum: go to hell. We don't need you to grow our website.

    - Sunil Bishnoi
    12 years ago

    Are you sure you want to delete this post?

    vinothmech

    vinothmech

    Well said @sunil0021 . We don't need themself for growing.
    12 years ago

    Are you sure you want to delete this post?

    Beverly

    Beverly

    I wonder how they would treat signature link to an SEOClerks affiliate store or freelancer blog (which links to that person's own SEOClerks gigs).

    That is unfortunate! SEOClerks frowns upon promoting other places too. I believe in freedom to express yourself, without spamming, of course.


    Please feel free to visit Jordan's FreelanceForum where we discuss all freelance gig type sites.
    http://freelanceforums.org/
    12 years ago

    Are you sure you want to delete this post?

    Jade

    Jade

    Least its only a week.

    I got banned from DP for 3 months the other day for replying to an old thread.

    Absolutely and completely and totally RIDICULOUS!


    Not really so ridiculous. Most forums have rules against bumping very old threads, especially if the purpose is self promotional or advertising for another site. Even responding to an old thread can get you a warning or banned. Start a new thread if the topic really interests you.
    12 years ago

    Are you sure you want to delete this post?

    America

    America

    What amazes me is how SEOClerks has such name recognition. You don't even have to post a link for people to know where it is online. And, actually with browsers being so intuitive, you would only need to enter SEOClerks into the browser bar to find this site. That could be one reason they are so scared about anyone mentioning this site as they know it is an ad, even without the link. Still it's a good sign with the name recognition being so high.
    12 years ago

    Are you sure you want to delete this post?

    angie828

    angie828

    What a shame! SEOClerks is so much better than fiverr ever will be.
    12 years ago

    Are you sure you want to delete this post?

    Beverly

    Beverly

    What a shame! SEOClerks is so much better than fiverr ever will be.


    I've heard horror stories of where Fiverr sellers were banned over silly little things or had their money refunded to the buyer for no good reason, even after the job was done. So basically, Fiverr is protecting the buyer and treating the seller who is providing the services as an expendable resource.
    12 years ago

    Are you sure you want to delete this post?

    LizAnne

    LizAnne

    Does anyone know why this other forum you mentioned would be so protective of Fiverr? Are they being paid for this affiliation or maybe that site is owned by the main company which owns the other forum?
    12 years ago

    Are you sure you want to delete this post?

    hitmeasap

    hitmeasap

    Does anyone know why this other forum you mentioned would be so protective of Fiverr? Are they being paid for this affiliation or maybe that site is owned by the main company which owns the other forum?


    I believe it's because Freelancer bought warriorforum. Can't find any other reason.
    12 years ago

    Are you sure you want to delete this post?

    Griffin

    Griffin

    What a shame! SEOClerks is so much better than fiverr ever will be.


    And, you can price what you want on SEOClerks. That's not true of Fiverr. You are stuck with just pricing at $5.00 even if your service is worth $100.
    12 years ago

    Are you sure you want to delete this post?

    Order Now
    Process Time: 1.0953359603882

    Possible Duplicate queries found!
    MatchCountSQLScript
    SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-864001SELECT 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 `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='17280'1SELECT q.*, c.seo as CatSEO, c.name as CatName, c.parentid FROM `questions` as q JOIN categories_faq as c ON q.catid=c.CATID WHERE (q.status=1 OR (q.status=2 AND userid='') ) AND q.quesid='17280'

    		/opt/clerks-staging/docroot/viewfaq.php 496 () ()

    SELECT * FROM seoclerks.members WHERE USERID='6160'1SELECT * FROM seoclerks.members WHERE USERID='6160'

    		/opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() ()

    SELECT * FROM seoclerks.members WHERE USERID=61601SELECT googleplus_profile FROM seoclerks.members WHERE USERID=6160

    		/opt/clerks-staging/docroot/include/functions/main.php 16914 GetGooglePlusProfileFromId() ()

    SELECT * FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=17280 LIMIT 51SELECT m.username FROM ratings_faq as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=17280 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='17280' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc1SELECT a.answer, a.USERID, a.upvotes, a.downvotes, a.ansid, a.parentid, a.combined_votes, a.date_answered, b.username, b.userlevel, b.profilepicture FROM answers a, seoclerks.members b WHERE a.quesid='17280' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc

    		/opt/clerks-staging/docroot/viewfaq.php 1245 () ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93473 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93473 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93474 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93474 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93475 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93475 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93476 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93476 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93478 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93478 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93479 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93479 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93480 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93480 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93481 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93481 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93482 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93482 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93483 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93483 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93484 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93484 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93485 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93485 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93486 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93486 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    SELECT * FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93487 LIMIT 51SELECT m.username FROM ratings_faqanswers as r, seoclerks.members as m WHERE r.USERID=m.USERID AND r.upvote=1 AND r.PID=93487 LIMIT 5

    		/opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() ()

    UPDATE questions SET total_views = total_views + 1 WHERE quesid='17280'1UPDATE questions SET total_views = total_views + 1 WHERE quesid='17280'

    		/opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() ()

    SELECT * FROM questions WHERE quesid!='17280' AND status='1' AND (question like '%WARRIORFORUM SEOClerks!%' OR question like '%WARRIORFORUM%' OR question like '%SEOClerks!%') -- ORDER BY RAND() LIMIT 151SELECT quesid, question, seo, userid FROM questions WHERE quesid!='17280' AND status='1' AND (question like '%WARRIORFORUM SEOClerks!%' OR question like '%WARRIORFORUM%' OR question like '%SEOClerks!%') -- ORDER BY RAND() LIMIT 15

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

    SELECT * FROM seoclerks.members WHERE USERID='155011' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='155011' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='147' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='147' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='19824' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='19824' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='168430' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='168430' limit 1

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

    SELECT * FROM seoclerks.members WHERE USERID='414694' limit 11SELECT profilepicture FROM seoclerks.members WHERE USERID='414694' limit 1

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

    SELECT * FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=17280%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID 1SELECT USERID, username FROM members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=17280%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    select * from categories_faq order by name asc1select * from categories_faq order by name asc

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

    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.2892941SELECT A.*, B.seo, B.name as categoryname, C.username, C.userlevel, C.lastlogin, C.ip, C.profilepicture FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID ORDER BY A.bdays desc LIMIT 0,400.2892940.289294
    0.1818701SELECT COUNT(A.wantid) AS total FROM wanttobuy as A, categories_wanttobuy B, seoclerks.members C WHERE A.active = 1 AND A.category = B.CATID AND A.USERID = C.USERID 0.1818700.181870
    0.1034071SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Typescript%') ORDER BY total_recommendations desc LIMIT 0,400.1034070.103407