sanfora
Level 1
Write the reason you're deleting this FAQ
How can I create local listing to website or business without spend alot of money? I don't want to use software either.
Are you sure you want to delete this post?
| Match | Count | SQL | Script |
| 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='17663' | 1 | SELECT 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='17663' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='60292' | 1 | SELECT * FROM seoclerks.members WHERE USERID='60292' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='36' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='36' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM categories_faq WHERE CATID='30' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='30' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=60292 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=60292 | /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=17663 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faq as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=17663
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='17663' AND a.userid=b.USERID and b.status='1' AND a.status=1 ORDER BY a.combined_votes DESC, a.date_answered asc | 1 | SELECT 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='17663' 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=96425 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=96425
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=96418 LIMIT 5 | 1 | SELECT m.username FROM
ratings_faqanswers as r,
seoclerks.members as m
WHERE r.USERID=m.USERID
AND r.upvote=1
AND r.PID=96418
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='17663' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='17663' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='17663' AND status='1' AND (question like '%How create local listing website%' OR question like '%create%' OR question like '%local%' OR question like '%listing%' OR question like '%website%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='17663' AND status='1'
AND (question like '%How create local listing website%' OR question like '%create%' OR question like '%local%' OR question like '%listing%' OR question like '%website%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='1323' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1323' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='9' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='632' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='632' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='337' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='337' 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 1 | 1 | SELECT 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 members_ledger WHERE script='/opt/clerks-staging/docroot/viewfaq.php' AND querystring LIKE '%id=17663%' AND added>=UNIX_TIMESTAMP(NOW())-1200 GROUP BY USERID | 1 | SELECT USERID, username FROM members_ledger
WHERE script='/opt/clerks-staging/docroot/viewfaq.php'
AND querystring LIKE '%id=17663%'
AND added>=UNIX_TIMESTAMP(NOW())-1200
GROUP BY USERID
| /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| 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() |
| SELECT * FROM seoclerks.members WHERE USERID='19821.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='19821.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='306632.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='306632.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| select * from categories_faq order by name asc | 1 | select * from categories_faq order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetFaqCategories() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
| Avg Time | Count | SQL | Max | Min |
TommyCarey
I know you don't want to spend any money, or use software, but that's two of the fastest ways of doing this. You can pay someone a few dollars and they will submit your information to dozens or hundreds of citation sites.
If you want to do it manually, here's a list of citation type websites.
Citation Sites:
Some of these may be dead, outdated or changed their settings for people to put their information into. I've had this list for a while, hopefully it does you some good
- Razzy You can do a search for citation websites and that should give you a pretty big list of where you can add your business information. I know you don't want to spend any money, or use software, but that's two of the fastest ways of doing this. You can pay someone a few dollars and they will submit your information to dozens or hundreds of citation sites. If you want to do it manually, here's a list of citation type websites. [size=200][u][b]Citation Sites:[/b][/u][/size] [list=1][*]google places[/*][*]local yahoo[/*][*]mapquest[/*][*]yelp![/*][*]merchantcircle[/*][*]citysquares[/*][*]hotfrog[/*][*]tuugo[/*][*]judysbook[/*][*]myhuckleberry[/*][*]insiderpages[/*][*]trivok[/*][*]bing[/*][*]cityfos[/*][*]kudzu[/*][*]mysheriff[/*][*]mogopages[/*][*]manta[/*][*]guidespot[/*][*]spicypage[/*][*]superpages[/*][*]yellowpages[/*][*]bizwiki[/*][*]mylocalbizsearch[/*][*]ezlocal[/*][*]localprice[/*][*]jayde[/*][*]number[/*][*]citysearch[/*][*]yellowbot[/*][*]yellowee[/*][*]brownbook[/*][*]revark[/*][*]idirectory[/*][*]igolook[/*][*]showsmart[/*][*]showmelocal[/*][*]magicyellow[/*][*]thinklocal[/*][*]matchPoint[/*][*]bridgat[/*][*]rateitall[/*][*]localbotw[/*][*]expressbusinessdirectory[/*][*]cylex[/*][*]qurkl[/*][*]bbyp[/*][*]checkmyreviews[/*][*]ebusinesspages[/*][*]adoos[/*][*]backpage[/*][*]mylocalservices[/*][*]yellowusapages[/*][*]jigsaw[/*][*]epage[/*][*]local.ezilon[/*][*]mastermoz[/*][*]mycitybusiness[/*][*]searchsight[/*][*]yipple[/*][*]shopinusa[/*][*]spotabusiness[/*][*]the localweb[/*][*]wowcity[/*][*]thefreebusinessdirectory[/*][*]cyclopages[/*][*]fixr[/*][*]genieknows[/*][*]yellowpagecity[/*][*]zipperpages[/*][*]local[/*][*]yellowbrowser[/*][*]smartguy[/*][*]idirectory[/*][*]thumbtack[/*][*]localizedbiz[/*][*]pennysaverusa[/*][*]uscity[/*][*]adpost[/*][*]uscounties[/*][*]walldirectory[/*][*]wdonline[/*][*]bizvots[/*][*]spoke[/*][*]bdpages[/*][*]localdatabase[/*][*]telists[/*][*]bestdealon[/*][*]tagzania[/*][*]carollinabusiness[/*][*]fyple[/*][*]callupcontact[/*][*]dexknows[/*][*]freeadlists[/*][*]usnetads[/*][*]secure.sell[/*][*]usfreeads[/*][*]andysdirectory[/*][*]aaspaas[/*][*]yellowhours[/*][*]lookuppage[/*][*]biznet[/*][*]directorycentral[/*][*]nexport[/*][*]2FindLocal[/*][*]ABlocal[/*][*]AllPages[/*][*]AskLocalPages[/*][*]B2BYellowPages[/*][*]BBB[/*][*]BigwigBiz[/*][*]Birectory[/*][*]corporationwiki[/*][*]localsearchlight[/*][*]find-us-here[/*][*]BusinessPatrol[/*][*]CBSYellowPages[/*][*]ChamberofCommerce[/*][*]Cherrp[/*][*]City-Data[/*][*]CitySlick[/*][*]CliqSearch[/*][*]CMAC.ws[/*][*]Company[/*][*]ConnectorLocal[/*][*]CornerstonesWorld[/*][*]Craigslist[/*][*]DigaBusiness[/*][*]Directory-Net[/*][*]DiscoverOurTown[/*][*]DreamLocal[/*][*]EAscend[/*][*]eLocalFinder[/*][*]ExportFocus[/*][*]FindItNow[/*][*]FindTheBest[/*][*]Find-Your-Biz[/*][*]fyple[/*][*]Geodelic[/*][*]GetFave[/*][*]GetFreeListing[/*][*]GigPark[/*][*]Go2[/*][*]GoMyLocal[/*][*]HelloMetro[/*][*]HWhere[/*][*]IBegin[/*][*]ImmersiFind[/*][*]Infignos[/*][*]ecarnegietech[/*][*]JustClickLocal[/*][*]2FindLocal[/*][/list] Some of these may be dead, outdated or changed their settings for people to put their information into. I've had this list for a while, hopefully it does you some good :) - Razzy
Are you sure you want to delete this post?