SEOClerks


Willpower1234 has no services


sir i need unique visitors from all world not from China. my link is shortu...

traffic seo

Sir I have a site needs 500000 unique visitor to my site ,u can give me uni...

Traffic Seoexper Socialme

Sir2 i need unique banner impressions on home page and having visitor timer...

Install

I have debvelope an app it is abndroid app now i want to promote it for thi...

Marketer Socialme Seoexper

Buyer Reviews


Recommendations


Statuses


Order Now
Process Time: 0.04763388633728

Possible Duplicate queries found!
MatchCountSQLScript
SELECT * FROM seoclerks.members WHERE username='Willpower1234' AND status='1' 1SELECT * FROM seoclerks.members WHERE username='Willpower1234' AND status='1'

/opt/clerks-staging/docroot/user.php 54 () ()

SELECT * FROM seoclerks.orders WHERE seller_USERID = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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 = ?1SELECT 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='{\"advanced_editor\":1,\"userLevelUpdated\":1620401445,\"userTypeUpdated\":1772564848,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='601082'1UPDATE seoclerks.members SET profile_data='{\"advanced_editor\":1,\"userLevelUpdated\":1620401445,\"userTypeUpdated\":1772564848,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='601082'

/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

UPDATE codeclerks.members SET profile_data='{\"advanced_editor\":1,\"userLevelUpdated\":1620401445,\"userTypeUpdated\":1772564848,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='601082'1UPDATE codeclerks.members SET profile_data='{\"advanced_editor\":1,\"userLevelUpdated\":1620401445,\"userTypeUpdated\":1772564848,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='601082'

/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

UPDATE listingdock.members SET profile_data='{\"advanced_editor\":1,\"userLevelUpdated\":1620401445,\"userTypeUpdated\":1772564848,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='601082'1UPDATE listingdock.members SET profile_data='{\"advanced_editor\":1,\"userLevelUpdated\":1620401445,\"userTypeUpdated\":1772564848,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='601082'

/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

UPDATE pixelclerks.members SET profile_data='{\"advanced_editor\":1,\"userLevelUpdated\":1620401445,\"userTypeUpdated\":1772564848,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='601082'1UPDATE pixelclerks.members SET profile_data='{\"advanced_editor\":1,\"userLevelUpdated\":1620401445,\"userTypeUpdated\":1772564848,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='601082'

/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

UPDATE wordclerks.members SET profile_data='{\"advanced_editor\":1,\"userLevelUpdated\":1620401445,\"userTypeUpdated\":1772564848,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='601082'1UPDATE wordclerks.members SET profile_data='{\"advanced_editor\":1,\"userLevelUpdated\":1620401445,\"userTypeUpdated\":1772564848,\"userType\":{\"main\":\"buyer\",\"0\":\"buyer\"}}' WHERE USERID='601082'

/opt/clerks-staging/docroot/include/functions/main.php 12994 UpdateMembersAllSites() UpdateUserData()

SELECT * FROM seoclerks.members WHERE USERID='601082'1SELECT lastlogin FROM seoclerks.members WHERE USERID='601082'

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

SELECT * FROM posts WHERE USERID=6010821SELECT sum(positive_ratings) as thumbup, sum(negative_ratings) as thumbdown FROM posts WHERE USERID=601082

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

SELECT * FROM follow F, members M WHERE F.FOLLOWING=601082 AND F.USERID = M.USERID ORDER BY F.time_added DESC LIMIT 41SELECT F.USERID, M.profilepicture, M.username, M.userlevel, M.status FROM follow F, members M WHERE F.FOLLOWING=601082 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=601082 AND F.FOLLOWING = M.USERID ORDER BY F.time_added DESC LIMIT 41SELECT F.FOLLOWING AS USERID, M.profilepicture, M.username, M.userlevel, M.status FROM follow F, members M WHERE F.USERID=601082 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=6010821SELECT COUNT(FID) AS total FROM follow WHERE FOLLOWING=601082

/opt/clerks-staging/docroot/include/functions/main.php 22279 getUserTotalFollower() ()

SELECT * FROM follow WHERE USERID=6010821SELECT COUNT(FID) AS total FROM follow WHERE USERID=601082

/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 1SELECT 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 1SELECT 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 = ? 1SELECT 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, 401SELECT 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='74108'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='74108'

/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

SELECT * FROM categories_wanttotrade WHERE seo='Traffic'1SELECT name FROM categories_wanttotrade WHERE seo='Traffic'

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

SELECT * FROM wantbids WHERE active=1 AND wantid='62063'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62063'

/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

SELECT * FROM wantbids WHERE active=1 AND wantid='61927'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='61927'

/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

SELECT * FROM categories_wanttotrade WHERE seo='Banner-Ads'1SELECT name FROM categories_wanttotrade WHERE seo='Banner-Ads'

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

SELECT * FROM wantbids WHERE active=1 AND wantid='62026'1SELECT COUNT(bidid) AS total FROM wantbids WHERE active=1 AND wantid='62026'

/opt/clerks-staging/docroot/include/functions/main.php 18501 GetTotalBids() ChangeWTBPostData()

SELECT * FROM categories_wanttotrade WHERE seo='Social-Networks'1SELECT name FROM categories_wanttotrade WHERE seo='Social-Networks'

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

SELECT * FROM wanttotrade A, seoclerks.members C WHERE A.active = 1 AND A.USERID = C.USERID AND A.USERID = ? ORDER BY A.tradeid DESC1SELECT 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, 401SELECT 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='601082' ORDER BY A.lastgigedit DESC LIMIT 101SELECT 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='601082' 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='601082' ORDER BY A.lastgigedit DESC LIMIT 101SELECT 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='601082' 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='601082' ORDER BY A.lastgigedit DESC LIMIT 101SELECT 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='601082' 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='601082' ORDER BY A.lastgigedit DESC LIMIT 101SELECT 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='601082' 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 11SELECT 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='601082' AND PID != 01SELECT good, bad FROM seoclerks.ratings WHERE USERID='601082' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM codeclerks.ratings WHERE USERID='601082' AND PID != 01SELECT good, bad FROM codeclerks.ratings WHERE USERID='601082' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM listingdock.ratings WHERE USERID='601082' AND PID != 01SELECT good, bad FROM listingdock.ratings WHERE USERID='601082' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM pixelclerks.ratings WHERE USERID='601082' AND PID != 01SELECT good, bad FROM pixelclerks.ratings WHERE USERID='601082' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

SELECT * FROM wordclerks.ratings WHERE USERID='601082' AND PID != 01SELECT good, bad FROM wordclerks.ratings WHERE USERID='601082' AND PID != 0

/opt/clerks-staging/docroot/include/functions/includes/smarty.php 135 insert_get_percent() include()

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()

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.4751891SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (64) AND gtags like'%photoshop%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4751890.475189
0.4476681SELECT A.*, C.username, C.profilepicture, C.userlevel, C.ratingcount, C.rating, C.lastlogin, C.ip, C.lip, C.profile_data from posts A, seoclerks.members C WHERE A.active=1 AND A.USERID=C.USERID AND A.sold_out=0 AND category IN (87) AND gtags like'%News%' AND type !=99 AND A.feat=0 AND A.catfeatured_upgrade=0 order by A.lastgigedit desc limit 0, 400.4476680.447668
0.1924861SELECT 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 AND (A.tags LIKE '%An%' OR A.skills LIKE '%An%') ORDER BY A.lastgigedit desc LIMIT 0,400.1924860.192486
0.1864841SELECT 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 AND (A.tags LIKE '%BASIC%' OR A.skills LIKE '%BASIC%') ORDER BY A.lastgigedit desc LIMIT 0,400.1864840.186484
0.1851531SELECT 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 AND (A.tags LIKE '%Indesign%' OR A.skills LIKE '%Indesign%') ORDER BY A.lastgigedit desc LIMIT 0,400.1851530.185153
0.1806921SELECT 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 AND (A.tags LIKE '%An%' OR A.skills LIKE '%An%')0.1806920.180692
0.1520961SELECT 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 AND (A.tags LIKE '%BASIC%' OR A.skills LIKE '%BASIC%')0.1520960.152096
0.1487161SELECT 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 AND (A.tags LIKE '%warm%' OR A.skills LIKE '%warm%') ORDER BY A.lastgigedit desc LIMIT 0,400.1487160.148716
0.1192881SELECT 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 AND (A.tags LIKE '%COMPUTER%' OR A.skills LIKE '%COMPUTER%')0.1192880.119288
0.1080631SELECT 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 AND (A.tags LIKE '%warm%' OR A.skills LIKE '%warm%')0.1080630.108063