Write the reason you're deleting this FAQ
My response to a User in the FAQ who had asked about putting a "Sold Out" Sign on their Gig (rather than simply making it disappear by Suspending it.
I have been thinking a lot lately about the Concept of being "Sold Out" of SOME things, SOME of the time - and how it may benefit not only your Sales, but your Business Practices in General.
Here's the Post:
Although, it wouldn't be a terrible idea to allow Buyers to still see your Gig. (especially as "Sold Out"). Or at least Mark our Gig "extras" as Sold Out.
I have learned through my years of Online Marketing that being Sold Out and allowing Buyers to see your Product or Service, actually creates more Demand for it.
People tend to want things they cannot have.
They also tend to want something more when they see that other people get to have it, but they don't.
Especially when it was other people getting it, that resulted in the very reason why they don't get to.
In business, people say it's good to be a "Yes" Man. That's what you would call a "Sellout".
But I think it makes for good, healthy business to "Just Say No" once in a while.
There's a difference between being a "Sellout", and being "Sold out".
To be a "Sellout" means you'll do anything for that Sale (even if it means the quality of your Service will suffer).
But being "Sold Out" makes you look Desirable & Honest.
I'm sick of all the "Double Offers", and the "but Wait! There's More!!", and all the "30% Off Sales", etc. etc.
To me, the only thing a "30% Off Sale" tells me, is that they were just ripping me off by 30% prior to the Sale. (makes me wonder about all their other Non-Sale Items).
It also makes their Product/Service seem "undesirable" and less attractive when it's being "Devalued" using very Old-Fashioned marketing strategies.
In all Advertising & Business, Visibility & Consistency are key.
I think that rather than "Suspend" a Gig (*poof* be gone), it would be much more effective for Sellers if they could keep their Gigs Visible (with a Sold Out sign?) so that Buyers could at least see what they're missing, anticipate their Order (or place Pre-Orders), and perhaps strike up a conversation with the Seller about it's availability. This would at least allow Sellers to Plant the Seeds of a Client/Seller relationship.
We all know that if Money were to grow on Trees, you'd still have to plant the seed.
Why do you think Pirates used to bury all that Treasure?
Are you sure you want to delete this post?
Oh, and Jordan!! Thanks!! You're awesome!! 
Are you sure you want to delete this post?
We all know that if Money were to grow on Trees, you'd still have to plant the seed.
Why do you think Pirates used to bury all that Treasure?
Are you sure you want to delete this post?
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='13061' | 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='13061' | /opt/clerks-staging/docroot/viewfaq.php 496 () () |
| SELECT * FROM seoclerks.members WHERE USERID='3764' | 1 | SELECT * FROM seoclerks.members WHERE USERID='3764' | /opt/clerks-staging/docroot/include/functions/includes/member.php 445 GetAllUserDetails() () |
| SELECT * FROM categories_faq WHERE CATID='42' | 1 | SELECT CATID, seo, name, metatitle, h2header, metakeywords, metadescription, metaheader, parentid, image_name FROM categories_faq WHERE CATID='42' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetCategorySeoFromType() |
| SELECT * FROM seoclerks.members WHERE USERID=3764 | 1 | SELECT googleplus_profile FROM seoclerks.members WHERE USERID=3764 | /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=13061 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=13061
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| SELECT * FROM answers a, seoclerks.members b WHERE a.quesid='13061' 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='13061' 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=64746 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=64746
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=64747 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=64747
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=64748 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=64748
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=64749 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=64749
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=64750 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=64750
LIMIT 5 | /opt/clerks-staging/docroot/include/functions/main.php 17159 GetVoters() () |
| UPDATE questions SET total_views = total_views + 1 WHERE quesid='13061' | 1 | UPDATE questions SET total_views = total_views + 1 WHERE quesid='13061' | /opt/clerks-staging/docroot/include/functions/main.php 1765 update_Faqviewcount() () |
| SELECT * FROM questions WHERE quesid!='13061' AND status='1' AND (question like '% "Sellout" "Sold Out"?%' OR question like '%"Sellout"%' OR question like '%"Sold%' OR question like '%Out"?%') -- ORDER BY RAND() LIMIT 15 | 1 | SELECT quesid, question, seo, userid
FROM questions
WHERE quesid!='13061' AND status='1'
AND (question like '% "Sellout" "Sold Out"?%' OR question like '%"Sellout"%' OR question like '%"Sold%' OR question like '%Out"?%')
-- ORDER BY RAND()
LIMIT 15 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() () |
| SELECT * FROM seoclerks.members WHERE USERID='78923' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='78923' limit 1 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_member_profilepicture() |
| SELECT * FROM seoclerks.members WHERE USERID='8619' limit 1 | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='8619' 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=13061%' 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=13061%'
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='9.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='9.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='1.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='1.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='3764.png' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='3764.png' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='12260.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='12260.jpg' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='147.jpg' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='147.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 |
| 0.171073 | 1 | SELECT 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.171073 | 0.171073 |
robertman11
Are you sure you want to delete this post?