select pc.pid, (select min(retailprice) from price_range where pid=p.pid) as retailprice from product p,prod_cat pc where p.pid=pc.pid and pc.catid like '155' group by pc.pid order by retailprice limit 0,18 At Show prods 72Status: 200 Ok
Content-type: text/html
Production Time:
business days As low as $1.24 each.
Page: 1
Note: * Prices are per unit, calculated at the cost specified per minimum quantity ordered, rounded to the nearest one-hundredth cent.
* Price includes a 1-color, 1-location imprint, unless otherwise noted.
We reserve the right at any time to correct any errors in pricing or descriptions. Product and service prices and specifications are subject to change without notice. Please review our Terms of Use for full disclosures on pricing policies.