colour
scheme
Browse
Vinyl
CDs
Original Vinyl
New Arrivals

Back In Stock
Features
Keith Mansfield

John Barry

KPM

Guru

Releases Of The Day

Genres
2Tone. Ska. Reggae.

African. Brasilian. Latin. World

Boogie. Disco. Electro

Broken Beat / New Jazz

Deepstep. D&B. Breaks

Electronica. Leftfield

Folk. Pop. Rock. Psyche.

Funk. Soul. Rhythm & Blues

Hip Hop. Beats

House. Techno

Japanese Imports

Jazz

Library. S/Trax. D/Tempo.

Rarities 12s

Rarities 7s

Re-Edits

RECORD STORE DAY

Reissue 45s

Other Products
ACESSORIES: T/TABLES, MATS, BAGS

ALI AUGUR PRINTS

BLUES AND SOUL

BOOKS

DVDS

EDDIE OTCHERE PRINTS

JULES MANN SCREEN PRINTS

MAGS: VARIOUS

PRINTS

RECORD CLEANER

STRAIGHT NO CHASER. WAX POETICS

TEES

VINTAGE SUNGLASSES

Shopping
My Account

View Basket

Checkout

Advanced Search
Security Notice
Connect
If Music Radio Show

If Music on MySpace

Events Photos

If Music Twitter

Where We Are

Contact Us
Rss Feeds
New Arrivals Rss Feed

Podcast Rss Feed

Search Results

Your search results for: Oscar Brown, Jr.




1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1

select distinct p.products_image, p.products_artist, pd.products_name, m.manufacturers_name, p.products_date_added, f.format_name, p.products_id, m.manufacturers_id, p.products_id, p.format_id, p.producttype_id, f.format_id, f.format_name, p.products_artist, pd.products_description, p.products_status, pd.products_name, p.products_price, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price) as final_price , pt.track_one_url from products p left join manufacturers m using(manufacturers_id) left join format f on p.format_id=f.format_id left join specials s on p.products_id = s.products_id left join products_tracklisting pt on p.products_id = pt.products_id, products_description pd, categories c, products_to_categories p2c where p.products_id = pd.products_id and pd.language_id = '1' and p.products_id = p2c.products_id and p2c.categories_id = c.categories_id and ((pd.products_name like '%oscar%' or p.products_catno like '%oscar%' or p.products_artist like '%oscar%' or m.manufacturers_name like '%oscar%' or pt.track_one_title like '%oscar%' or pt.track_two_title like '%oscar%' or pt.track_three_title like '%oscar%' or pt.track_four_title like '%oscar%' or pt.track_five_title like '%oscar%' or pt.track_six_title like '%oscar%' or pt.track_seven_title like '%oscar%' or pt.track_eight_title like '%oscar%' or pt.track_nine_title like '%oscar%' or pt.track_ten_title like '%oscar%' or pt.track_eleven_title like '%oscar%' or pt.track_twelve_title like '%oscar%' or pt.track_thirteen_title like '%oscar%' or pt.track_fourteen_title like '%oscar%' or pt.track_fifteen_title like '%oscar%' or pt.track_sixteen_title like '%oscar%' or pt.track_seventeen_title like '%oscar%' or pt.track_eighteen_title like '%oscar%' or pt.track_nineteen_title like '%oscar%' or pt.track_twenty_title like '%oscar%' or pt.track_one_artist like '%oscar%' or pt.track_two_artist like '%oscar%' or pt.track_three_artist like '%oscar%' or pt.track_four_artist like '%oscar%' or pt.track_five_artist like '%oscar%' or pt.track_six_artist like '%oscar%' or pt.track_seven_artist like '%oscar%' or pt.track_eight_artist like '%oscar%' or pt.track_nine_artist like '%oscar%' or pt.track_ten_artist like '%oscar%' or pt.track_eleven_artist like '%oscar%' or pt.track_twelve_artist like '%oscar%' or pt.track_thirteen_artist like '%oscar%' or pt.track_fourteen_artist like '%oscar%' or pt.track_fifteen_artist like '%oscar%' or pt.track_sixteen_artist like '%oscar%' or pt.track_seventeen_artist like '%oscar%' or pt.track_eighteen_artist like '%oscar%' or pt.track_nineteen_artist like '%oscar%' or pt.track_twenty_artist like '%oscar%') and (pd.products_name like '%brown,%' or p.products_catno like '%brown,%' or p.products_artist like '%brown,%' or m.manufacturers_name like '%brown,%' or pt.track_one_title like '%brown,%' or pt.track_two_title like '%brown,%' or pt.track_three_title like '%brown,%' or pt.track_four_title like '%brown,%' or pt.track_five_title like '%brown,%' or pt.track_six_title like '%brown,%' or pt.track_seven_title like '%brown,%' or pt.track_eight_title like '%brown,%' or pt.track_nine_title like '%brown,%' or pt.track_ten_title like '%brown,%' or pt.track_eleven_title like '%brown,%' or pt.track_twelve_title like '%brown,%' or pt.track_thirteen_title like '%brown,%' or pt.track_fourteen_title like '%brown,%' or pt.track_fifteen_title like '%brown,%' or pt.track_sixteen_title like '%brown,%' or pt.track_seventeen_title like '%brown,%' or pt.track_eighteen_title like '%brown,%' or pt.track_nineteen_title like '%brown,%' or pt.track_twenty_title like '%brown,%' or pt.track_one_artist like '%brown,%' or pt.track_two_artist like '%brown,%' or pt.track_three_artist like '%brown,%' or pt.track_four_artist like '%brown,%' or pt.track_five_artist like '%brown,%' or pt.track_six_artist like '%brown,%' or pt.track_seven_artist like '%brown,%' or pt.track_eight_artist like '%brown,%' or pt.track_nine_artist like '%brown,%' or pt.track_ten_artist like '%brown,%' or pt.track_eleven_artist like '%brown,%' or pt.track_twelve_artist like '%brown,%' or pt.track_thirteen_artist like '%brown,%' or pt.track_fourteen_artist like '%brown,%' or pt.track_fifteen_artist like '%brown,%' or pt.track_sixteen_artist like '%brown,%' or pt.track_seventeen_artist like '%brown,%' or pt.track_eighteen_artist like '%brown,%' or pt.track_nineteen_artist like '%brown,%' or pt.track_twenty_artist like '%brown,%') and (pd.products_name like '%jr.%' or p.products_catno like '%jr.%' or p.products_artist like '%jr.%' or m.manufacturers_name like '%jr.%' or pt.track_one_title like '%jr.%' or pt.track_two_title like '%jr.%' or pt.track_three_title like '%jr.%' or pt.track_four_title like '%jr.%' or pt.track_five_title like '%jr.%' or pt.track_six_title like '%jr.%' or pt.track_seven_title like '%jr.%' or pt.track_eight_title like '%jr.%' or pt.track_nine_title like '%jr.%' or pt.track_ten_title like '%jr.%' or pt.track_eleven_title like '%jr.%' or pt.track_twelve_title like '%jr.%' or pt.track_thirteen_title like '%jr.%' or pt.track_fourteen_title like '%jr.%' or pt.track_fifteen_title like '%jr.%' or pt.track_sixteen_title like '%jr.%' or pt.track_seventeen_title like '%jr.%' or pt.track_eighteen_title like '%jr.%' or pt.track_nineteen_title like '%jr.%' or pt.track_twenty_title like '%jr.%' or pt.track_one_artist like '%jr.%' or pt.track_two_artist like '%jr.%' or pt.track_three_artist like '%jr.%' or pt.track_four_artist like '%jr.%' or pt.track_five_artist like '%jr.%' or pt.track_six_artist like '%jr.%' or pt.track_seven_artist like '%jr.%' or pt.track_eight_artist like '%jr.%' or pt.track_nine_artist like '%jr.%' or pt.track_ten_artist like '%jr.%' or pt.track_eleven_artist like '%jr.%' or pt.track_twelve_artist like '%jr.%' or pt.track_thirteen_artist like '%jr.%' or pt.track_fourteen_artist like '%jr.%' or pt.track_fifteen_artist like '%jr.%' or pt.track_sixteen_artist like '%jr.%' or pt.track_seventeen_artist like '%jr.%' or pt.track_eighteen_artist like '%jr.%' or pt.track_nineteen_artist like '%jr.%' or pt.track_twenty_artist like '%jr.%') ) order by

[TEP STOP]