... or two. Have to be kidding me!
Search term: 90 all naturals
The query:
Select Top 1000 * From
DVD
Where ( Stock = '90 all naturals'
OR (
Subtitle like '%90 all naturals%'
OR REPLACE(Subtitle, '''', '') like '%90 all
naturals%'
or Subtitle like '%90 all naturals!%'
OR REPLACE(Subtitle, '''', '') like '%90 all
naturals!%' or Subtitle like '%90_all_naturals%'
OR REPLACE(Subtitle, '''', '') like
'%90_all_naturals%' or Subtitle like '%90_all_naturals%'
OR REPLACE(Subtitle, '''', '') like
'%90_all_naturals%' or Subtitle like '%90 all naturals!%' or Subtitle like
'%90 all%'
)
OR Title like '%90 all naturals%'
OR REPLACE(Title, '''', '') like '%90 all naturals%'
or Title like '%90 all naturals!%'
OR REPLACE(Title, '''', '') like '%90 all
naturals!%' or Title like '%90_all_naturals%'
OR REPLACE(Title, '''', '') like '%90_all_naturals%'
or Title like '%90_all_naturals%'
OR REPLACE(Title, '''', '') like '%90_all_naturals%'
or Title like '%90 all naturals!%' or Title like '%90 all%'
or Title like '%90: all naturals %'
or Title like '%90? all naturals %'
or Title like '%90! all naturals %'
or Title like '%90 all: naturals %'
or Title like '%90 all? naturals %'
or Title like '%90 all! naturals %'
or Title like '%90 all naturals: %'
or Title like '%90 all naturals? %'
or Title like '%90 all naturals! %'
OR Title like '%90%'
OR Title like '%90 all%'
OR Title like '%90 all naturals!%'
)
AND url like '%.%'
order by Rating DESC, Title
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Want to reach the ColdFusion community with something they want? Let them know
on the House of Fusion mailing lists
Archive:
http://www.houseoffusion.com/groups/cf-community/message.cfm/messageid:298826
Subscription: http://www.houseoffusion.com/groups/cf-community/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.5
