Shop by Category  
Musical Instruments
Special Features
Styles

 

Showing Products 1 to 10 of over 1000 products

« Hide Refinements

You refined by: Music (undo) undo all
Price Estimate
Merchant
A message from our sponsor

Sort by: relevance - name - product rating - best price - (reverse order)

The Price of Fame 1960-1965


Bear Family - 2 offers from $197.43
This Product has an average rating of 4.50 stars from 2 people who have rated it.
The complete Warner Bros. Recordings (1960 - 1965) ú 29 previously unissued performances. The hardcover book contains many rare and previously unpublished pictures. The set contains their complete German and Italian recordings. A Bear Family release. 2006....

filed under: Music  
email - block - save result

Around the World to Poor Valley


Bear Family - 2 offers from $187.97
This Product has an average rating of 0.00 stars from 0 people who have rated it.
...

filed under: Music  
email - block - save result

Moby Grape '84


San Francisco Sound - 2 offers from $176.60
This Product has an average rating of 2.50 stars from 3 people who have rated it.
Two Albums on One CD, 1984 Reunion Album featuring Fourteen Cuts Including Hard Road to Follow and Silver Wheels....

filed under: Music  
email - block - save result

The Ertegun's New York: New York Cabaret Music


Atlantic / Wea - 2 offers from $173.41
This Product has an average rating of 0.00 stars from 0 people who have rated it.
...

filed under: Music  
email - block - save result

R U Still Down? (Remember Me)


Jive - 2 offers from $172.58
This Product has an average rating of 4.50 stars from 101 people who have rated it.
26 cuts of "gangsta rap" that only increase in doom when you realize the guy talking it didn't live to laugh about it. Perhaps he now knows the answer to his question, "I Wonder If Heaven Got a Ghetto," which shows up here twice. Shakur, like most hard rappers, liked to sound tou...

filed under: Music  
email - block - save result

H.P. Lovecraft's from Beyond


La-La Land Records - 1 offer from $152.65
This Product has an average rating of 5.00 stars from 1 people who have rated it.
Presenting composer Richard Band's (RE-ANIMATOR, STARGATE SG-1) award-winning, atmospheric score to Stuart Gordon's horror/sci-fi classic H.P. Lovecraft's FROM BEYOND. This expanded and fully remastered score is now available for the first time on CD and contains previously unreleased material!...

filed under: Music  
email - block - save result

Vincenzo Bellini: La Sonnambula


Nuova Era - 2 offers from $150.00
This Product has an average rating of 0.00 stars from 0 people who have rated it.
...

filed under: Music  
email - block - save result

Queens of Jazz


EMI - 2 offers from $125.99
This Product has an average rating of 0.00 stars from 0 people who have rated it.
...

filed under: Music  
email - block - save result

Sheffield/Coustic Set-Up and Test Disc


Sheffield Lab - 2 offers from $124.95
This Product has an average rating of 5.00 stars from 3 people who have rated it.
...

filed under: Music  
email - block - save result

The Presidents of the United States of America


P.U.S.a. Inc. - 2 offers from $120.04
This Product has an average rating of 5.00 stars from 9 people who have rated it.
The Presidents Of The United States Of America’s 1995 debut went double platinum in the U.S., rocketed all the way to #6 on Billboard’s Top 200, produced three Top 40 hits & a #1 single on Billboard’s Modern Rock Chart, and garnered two Grammy nominations and a gaggle of critical praise. You eit...

filed under: Music  
email - block - save result

 


Debugging Information
ColdFusion Server Developer 8,0,1,195520
Template /index.cfm
Time Stamp 08-Sep-10 03:26 AM
Locale English (US)
User Agent CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
Remote IP 192.168.1.4
Host Name 192.168.1.4


Execution Time

Total Time Avg Time Count Template
7919 ms 7919 ms 1 /var/www/html/pricepatch_linux/index.cfm
7918 ms 7918 ms 1 /var/www/html/pricepatch_linux/template1_inner.cfm
7897 ms 7897 ms 1 /var/www/html/pricepatch_linux/newsearch.cfm
15 ms 15 ms 1 /var/www/html/pricepatch_linux/newprodlist.cfm
9 ms 1 ms 10 /var/www/html/pricepatch_linux/newsubcat.cfm
1 ms 1 ms 1 /var/www/html/pricepatch_linux/newapplication.cfm
1 ms 1 ms 1 /var/www/html/pricepatch_linux/newcatbrowse.cfm
0 ms 0 ms 1 /var/www/html/pricepatch_linux/newadsense.cfm
0 ms 0 ms 1 /var/www/html/pricepatch_linux/newcleanquerystring.cfm
0 ms 0 ms 1 /var/www/html/pricepatch_linux/newfooter.cfm
0 ms 0 ms 1 /var/www/html/pricepatch_linux/newpagination.cfm
0 ms 0 ms 10 /var/www/html/pricepatch_linux/newprodnotes.cfm
0 ms 0 ms 1 /var/www/html/pricepatch_linux/newrefineresults.cfm
0 ms 0 ms 1 /var/www/html/pricepatch_linux/newtellafriend.cfm
1 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
7920 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


SQL Queries

prodsearch (Datasource=pricepatch2, Time=5320ms, Records=10) in /var/www/html/pricepatch_linux/newsearch.cfm @ 03:26:23.023
select 'm=01s&mname=Music' as requestid, l.prodid,p.aliasid,p.prodname,p.proddesc,p.thumburl, p.mediumurl, m.manname, m.manid, p.rank as prank, p.rankreviews as prankreviews,
1 as score,p.oldid,
count(l.listid) as listcount,
min(l.price) as lowestprice

from prodmaster_ext p
 
inner join listmaster l on p.prodid=l.prodid
inner join manmaster m on p.manid=m.manid

	inner join 
	(select distinct pm.prodid from prodmenu pm
	 
	where menuid LIKE '01s%' 
	
	limit 10000) pm on p.prodid=pm.prodid
	

where 
l.active = 1 and p.prodname <> '' and l.price > 0

group by l.prodid,p.prodname,p.proddesc,m.manname,score,p.oldid
order by score desc,lowestprice desc, p.prodname 
limit 0,10
countall (Datasource=pricepatch2, Time=669ms, Records=1) in /var/www/html/pricepatch_linux/newsearch.cfm @ 03:26:24.024
select 'm=01s&mname=Music' as requestid, 
count(distinct l.prodid) as thecount
 from listmaster l

	inner join 
	(select distinct pm.prodid from prodmenu pm
	 
	where menuid LIKE '01s%' 
	
	limit 10000) pm on l.prodid=pm.prodid
	
where 
l.active=1


limit 1100
filterman (Datasource=pricepatch2, Time=118ms, Records=100) in /var/www/html/pricepatch_linux/newsearch.cfm @ 03:26:24.024
select 'm=01s&mname=Music' as requestid, m.manid,m.manname,
count(p.prodid) as prodcount from prodmaster p


inner join listmaster l on p.prodid=l.prodid

inner join manmaster m on p.manid=m.manid

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01s%' 
	
limit 1000) pm on p.prodid=pm.prodid

where 
l.active = 1 and p.prodname <> ''

group by m.manname
order by prodcount desc
limit 100
filterprice (Datasource=pricepatch2, Time=1446ms, Records=1) in /var/www/html/pricepatch_linux/newsearch.cfm @ 03:26:25.025
select 'm=01s&mname=Music' as requestid, max(price) as maxprice,min(price) as minprice, avg(price) as avgprice, std(price) as stdprice
from prodmaster p

inner join listmaster l on p.prodid=l.prodid

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01s%' 
	limit 10000) pm on p.prodid=pm.prodid

where 
l.active = 1 and p.prodname <> ''


limit 5000
filterprice (Datasource=pricepatch2, Time=255ms, Records=4) in /var/www/html/pricepatch_linux/newsearch.cfm @ 03:26:26.026
select 'm=01s&mname=Music' as requestid, 
count(distinct l.prodid) as count,
 0.01 as lower, 10.0150505 as upper
from listmaster l

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01s%' 
	
limit 1000) pm on l.prodid=pm.prodid

where 
l.active = 1


and l.price between 0.01 and 10.0150505
having count(l.prodid) > 0
union
select 'm=01s&mname=Music' as requestid, 
count(distinct l.prodid),
10.0250505 as lower, 20.020101 as upper
from listmaster l

inner join 
(select distinct pm.prodid from prodmenu pm 
 
where menuid LIKE '01s%' 
	
limit 1000) pm on l.prodid=pm.prodid

where 
l.active = 1 


and l.price between 10.0250505 and 20.020101
having count(l.prodid) > 0
union
select 'm=01s&mname=Music' as requestid, 
count(distinct l.prodid),
 20.030101 as lower, 184.7600505 as upper
from listmaster l

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01s%' 
	
limit 1000) pm on l.prodid=pm.prodid

where 
l.active = 1 


and l.price between 20.030101 and 184.7600505
having count(l.prodid) > 0
union
select 'm=01s&mname=Music' as requestid, 
count(distinct l.prodid),
 184.7700505 as lower, 349.50 as upper
from listmaster l

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01s%' 
	
limit 1000) pm on l.prodid=pm.prodid

where 
l.active = 1


and l.price between 184.7700505 and 349.50
having count(l.prodid) > 0
limit 5000
filtermerch (Datasource=pricepatch2, Time=72ms, Records=6) in /var/www/html/pricepatch_linux/newsearch.cfm @ 03:26:26.026
select 'm=01s&mname=Music' as requestid, m.merchid, m.merchname,
count(distinct l.prodid) as prodcount 
from listmaster l

inner join merchmaster m on l.merchid=m.merchid

inner join 
(select distinct pm.prodid from prodmenu pm 

where menuid LIKE '01s%' 
	
limit 1000) pm on l.prodid=pm.prodid

where 
l.active = 1


group by m.merchname
order by prodcount desc
limit 100
getparent (Datasource=pricepatch2, Time=1ms, Records=1) in /var/www/html/pricepatch_linux/newsearch.cfm @ 03:26:26.026
select 'm=01s&mname=Music' as requestid, lstparent from menumaster 
where menuid='01s'
filtermenu (Datasource=pricepatch2, Time=4ms, Records=0) in /var/www/html/pricepatch_linux/newsearch.cfm @ 03:26:26.026
select 'm=01s&mname=Music' as requestid, mm.menuid,mm.name 
, menus.prodcount 
from (
		select 
			substring(pm.menuid,1,5)
			
		as menuid 
		
		,count(distinct l.prodid) as prodcount 
		
		from listmaster l
		
		inner join 
		(select pm.prodid,pm.menuid from prodmenu pm 
		
		where menuid LIKE '01s%' 
	limit 1000) pm on l.prodid=pm.prodid
		inner join menumaster mm on pm.menuid=mm.menuid
		
		where 
		l.active = 1
		
		and pm.menuid<>'01s'
		and mm.menuid like '01s%'
		
		
			group by 
			
			substring(pm.menuid,1,5)
			
			
) menus
inner join menumaster mm on menus.menuid = mm.menuid			
	

order by prodcount desc

limit 20
getParent (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newcatbrowse.cfm @ 03:26:26.026
SELECT *		
FROM menumaster
WHERE MenuID = '01s'
and active=1
getBreadCrumbs (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newcatbrowse.cfm @ 03:26:26.026
SELECT *		
FROM menumaster
WHERE menuid in ('0','01')
and active = 1
order by menuid 
getTopics (Datasource=pricepatch2, Time=0ms, Records=3, Cached Query) in /var/www/html/pricepatch_linux/newcatbrowse.cfm @ 03:26:26.026
SELECT *
FROM menumaster 
WHERE lstParent = '0,01,01s'
and active=1
ORDER BY MenuID
getmenuid (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid
from prodmenu
WHERE prodid='473065'
AND (menuid like '01s%' or menuid='01s')
limit 1
getParent2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT lstparent		
from menumaster 
WHERE menuid='01s'
limit 1
getBreadCrumbs2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01')
OR menuid='01s')
AND menuid <> '01'
order by menuid 
getmenuid (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid
from prodmenu
WHERE prodid='687185'
AND (menuid like '01s%' or menuid='01s')
limit 1
getParent2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT lstparent		
from menumaster 
WHERE menuid='01s'
limit 1
getBreadCrumbs2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01')
OR menuid='01s')
AND menuid <> '01'
order by menuid 
getmenuid (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid
from prodmenu
WHERE prodid='481975'
AND (menuid like '01s%' or menuid='01s')
limit 1
getParent2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT lstparent		
from menumaster 
WHERE menuid='01s'
limit 1
getBreadCrumbs2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01')
OR menuid='01s')
AND menuid <> '01'
order by menuid 
getmenuid (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid
from prodmenu
WHERE prodid='819316'
AND (menuid like '01s%' or menuid='01s')
limit 1
getParent2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT lstparent		
from menumaster 
WHERE menuid='01s'
limit 1
getBreadCrumbs2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01')
OR menuid='01s')
AND menuid <> '01'
order by menuid 
getmenuid (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid
from prodmenu
WHERE prodid='838961'
AND (menuid like '01s%' or menuid='01s')
limit 1
getParent2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT lstparent		
from menumaster 
WHERE menuid='01s'
limit 1
getBreadCrumbs2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01')
OR menuid='01s')
AND menuid <> '01'
order by menuid 
getmenuid (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid
from prodmenu
WHERE prodid='724491'
AND (menuid like '01s%' or menuid='01s')
limit 1
getParent2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT lstparent		
from menumaster 
WHERE menuid='01s'
limit 1
getBreadCrumbs2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01')
OR menuid='01s')
AND menuid <> '01'
order by menuid 
getmenuid (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid
from prodmenu
WHERE prodid='830531'
AND (menuid like '01s%' or menuid='01s')
limit 1
getParent2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT lstparent		
from menumaster 
WHERE menuid='01s'
limit 1
getBreadCrumbs2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01')
OR menuid='01s')
AND menuid <> '01'
order by menuid 
getmenuid (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid
from prodmenu
WHERE prodid='773976'
AND (menuid like '01s%' or menuid='01s')
limit 1
getParent2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT lstparent		
from menumaster 
WHERE menuid='01s'
limit 1
getBreadCrumbs2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01')
OR menuid='01s')
AND menuid <> '01'
order by menuid 
getmenuid (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid
from prodmenu
WHERE prodid='856381'
AND (menuid like '01s%' or menuid='01s')
limit 1
getParent2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT lstparent		
from menumaster 
WHERE menuid='01s'
limit 1
getBreadCrumbs2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01')
OR menuid='01s')
AND menuid <> '01'
order by menuid 
getmenuid (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid
from prodmenu
WHERE prodid='820176'
AND (menuid like '01s%' or menuid='01s')
limit 1
getParent2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT lstparent		
from menumaster 
WHERE menuid='01s'
limit 1
getBreadCrumbs2 (Datasource=pricepatch2, Time=0ms, Records=1, Cached Query) in /var/www/html/pricepatch_linux/newsubcat.cfm @ 03:26:26.026
SELECT menuid, name
FROM menumaster 
WHERE (menuid in ('0','01')
OR menuid='01s')
AND menuid <> '01'
order by menuid 


Scope Variables

Application Variables:
applicationname=pricepatch
CGI Variables:
AUTH_PASSWORD=
AUTH_TYPE=
AUTH_USER=
CERT_COOKIE=
CERT_FLAGS=
CERT_ISSUER=
CERT_KEYSIZE=
CERT_SECRETKEYSIZE=
CERT_SERIALNUMBER=
CERT_SERVER_ISSUER=
CERT_SERVER_SUBJECT=
CERT_SUBJECT=
CF_TEMPLATE_PATH=/var/www/html/pricepatch_linux/index.cfm
CONTENT_LENGTH=
CONTENT_TYPE=
CONTEXT_PATH=
GATEWAY_INTERFACE=CGI/1.1
HTTPS=
HTTPS_KEYSIZE=
HTTPS_SECRETKEYSIZE=
HTTPS_SERVER_ISSUER=
HTTPS_SERVER_SUBJECT=
HTTP_ACCEPT=text/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
HTTP_ACCEPT_ENCODING=gzip
HTTP_ACCEPT_LANGUAGE=en-us,en;q=0.5
HTTP_CONNECTION=keep-alive
HTTP_COOKIE=CFID=2284933; CFTOKEN=35288966
HTTP_HOST=www.pricepatch.com
HTTP_REFERER=
HTTP_USER_AGENT=CCBot/1.0 (+http://www.commoncrawl.org/bot.html)
PATH_INFO=
PATH_TRANSLATED=/var/www/html/pricepatch_linux/index.cfm
QUERY_STRING=m=01s&mname=Music
REMOTE_ADDR=192.168.1.4
REMOTE_HOST=192.168.1.4
REMOTE_USER=
REQUEST_METHOD=GET
SCRIPT_NAME=/index.cfm
SERVER_NAME=www.pricepatch.com
SERVER_PORT=80
SERVER_PORT_SECURE=0
SERVER_PROTOCOL=HTTP/1.0
SERVER_SOFTWARE=Apache/2.2.6 (Fedora)
WEB_SERVER_API=
Cookie Variables:
CFID=2284933
CFTOKEN=35288966
Server Variables:
COLDFUSION=Struct (8)
OS=Struct (5)
Session Variables:
cfid=2284933
cftoken=35288966
sessionid=PRICEPATCH_2284933_35288966
urltoken=CFID=2284933&CFTOKEN=35288966
URL Parameters:
M=01s
MNAME=Music
Debug Rendering Time: 13 ms