As evidenced by the name, Royal Doulton enjoys the distinction of a "Royal Warrant" -- a mark of distinction bestowed upon people or companies who have regularly supplied members of the Royal Family with goods or services. Royal Warrants, regarded as a mark of supreme excellence and quality, cannot be bought or sold.
King Edward awarded the first Royal Warrant to Royal Doulton in 1901. The Doulton Company then became The Royal Doulton Company. Presently, the Royal Doulton brand holds two Royal Warrants, the Royal Albert brand holds two Royal Warrants and the Minton brand holds one.
p.ss_productfield5,p.ss_productfield6,p.ss_productfield7,p.ss_productfield8,p.ss_productfield10,p.ss_productfield11,p.ss_productfield12,p.ss_productfield13,p.ss_productfield14,p.ss_productfield15,p.ss_productfield16,p.ss_productfield17,p.ss_productfield18,p.ss_productfield19,ss_productdescription,count(*) as c
from ss_products p LEFT JOIN ss_orders o
ON o.sku = p.ss_sku
where p.ss_productfield4 not like ''
and p.ss_productfield6 not like ''
and p.ss_productfield12 not like 'DSC'
and p.ss_productfield13 like 'RD' and DATE_SUB(CURDATE(),INTERVAL 30 DAY) <= o.date and p.ss_productfield3!='Y' group by p.ss_productfield4 order by c desc limit 24