These jumbo-sized pastels use the same vibrant pigments that Richeson Pastels are known for. Because these 2.75" x .75" pastels are rain-durable, they are perfect for murals and other outdoor surfaces! They blend beautifully and will not crumble upon application. With 60 amazing colors to choose from, say goodbye to the old washed out, washed up sidewalk chalk and hello to Street Stix Pavement Pastels!
1054 - Unknown column 'p.products_hazardousdesc' in 'order clause'
select p.products_image, pd.products_name, p.products_freight, p.products_hazardous, p.products_id, p.manufacturers_id, p.products_color_number, p.products_msrp, p.products_price, p.products_tax_class_id, p.products_freight, p.products_dropship, p.products_hazardous, 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 from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '101308' order by p.products_hazardousdesc, pd.products_name limit 0, 30