I am individual aimed to provide quality and unique services. I m very proficient and have valuable experience in Data Entry, MS Excel, MS Word, PDF to Excel, PDF to word, Web Research,,email marketing,scrape email list and other various business related works.
Data-entryPdf-to-wordMs-excelMs-wordMs-officePdf-to-exce| Match | Count | SQL | Script |
| SELECT * FROM query_cache WHERE query= ? LIMIT 1 | 1 | SELECT `value`, `last_checked`
FROM query_cache
WHERE query= ?
LIMIT 1
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() queryCache() |
| SELECT * FROM members WHERE show_freelancer = 1 AND status = 1 AND total_recommendations > 0 AND (skills LIKE '%Pdf-to-word%') ORDER BY total_recommendations desc LIMIT 0,40 | 1 | SELECT *
FROM members
WHERE show_freelancer = 1
AND status = 1
AND total_recommendations > 0 AND (skills LIKE '%Pdf-to-word%')
ORDER BY total_recommendations desc
LIMIT 0,40 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM posts WHERE USERID=62354 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=62354 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal() |
| 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() |
Explain: SELECT good, bad FROM seoclerks.ratings WHERE USERID='40083' AND PID != 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SIMPLE | ratings | ref | USERID,PID | USERID | 4 | const | 165318 | Using where |
