user warning: 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 ') GROUP BY n.nid ASC ORDER BY score DESC' at line 1 query: CREATE TEMPORARY TABLE temp_faceted_search_results_6 (nid int unsigned NOT NULL, PRIMARY KEY (nid)) Engine=HEAP SELECT n.nid AS nid, 5 * POW(2, (GREATEST(MAX(n.created), MAX(n.changed), MAX(c.last_comment_timestamp)) - 1335649655) * 6.43e-8) AS score FROM node AS n LEFT JOIN node_comment_statistics AS c ON n.nid = c.nid WHERE ((n.status = 1) AND (n.type IN ('corsage'))) AND n.nid IN () GROUP BY n.nid ASC ORDER BY score DESC in /home/crabappl/public_html/sites/all/modules/faceted_search/faceted_search.inc on line 1185.
user warning: Table 'crabappl_drupal.temp_faceted_search_results_6' doesn't exist query: SELECT COUNT(*) FROM temp_faceted_search_results_6 in /home/crabappl/public_html/sites/all/modules/faceted_search/faceted_search.inc on line 1186.

Corsages

White Rose Corsage A beautiful white rose corsage with some traditional white baby's breath, a satin bow, and satin ribboning of the stems. Price: $25 Photo Credit: Crab Apple Floral Design Seasonal Availability: Year round	Purple Lisianthus Corsage A purple lisianthus pin-on corsage Price: $20	White Lisianthus & Green Hypericum This simple and elegant corsage combines the beauty of white lisianthus buds and green hypericum berries on a background of locally, hand-picked salal leaves. Price: $25
White Rose & Pink Lisianthus Corsage Elegant and garden like, this corsage combines a simple white rose with the softness of pink lisianthus and fuscia waxflower as an accent. Price: $25 Photo Credit: Crab Apple Floral Design Seasonal Availability: Year round	Lily of the Valley & Spray Mums This corsage is made of the wonderfully fragrant lily of the valley and a few pink spray chrysanthemums. For greenery, we've used some Italian ruscus here to add colour and texture. Lily of the valley has a short seasonality usually between April and May depending on the weather. Price: $25 Photo Credit: Crab Apple Floral Design Seasonal Availability: Spring	Mango Calla Lilies The ever elegant mango coloured mini calla lilies highlight this corsage's beauty and simplicity. To add some fullness and greenery, we've used a few sprigs of Italian ruscus here along with a small satin bow. Price: $25 Photo Credit: Crab Apple Floral Design Seasonal Availability: Year round
Orchids & Freesia This multi-textured corsage uses a white and pink mini-cymbidium orchid with a fuscia throat, a white dendrobium orchid, and white, fragrant freesia. To dress it, we've also used some Italian ruscus and a small, satin bow. Price: $25 Photo Credit: Crab Apple Floral Design Seasonal Availability: Year round	Pink & Yellow Ranunculus The high petal count of these beautiful ranunculus flowers makes this corsage full and lush. We've added some variegated pittosporum as a greenery backing, a sprig of pink waxflower, as well as a small satin ribbon bow. Price: $25 Photo Credit: Crab Apple Floral Design Seasonal Availability: Summer	White & Purple Dendrobium Orchids These beautiful and sturdy little dendrobium orchids come in a wide variety of colours. Here we've dressed the corsage with some Italian ruscus sprigs for greenery and added a small, satin ribbon bow. Price: $25 Photo Credit: Crab Apple Floral Design Seasonal Availability: Year round
Red Roses The traditional red rose corsage is still a strong favourite. Of course, roses come in almost every colour under the sun. Here we've added a few sprigs of Italian ruscus for greenery and a small, satin ribbon bow to fill out the corsage. Price: $25 Photo Credit: Crab Apple Floral Design Seasonal Availability: Year round	White Rose & Purple Orchids This corsage is comprised of an elegant white rose and the more exotic looking purple dendrobium orchids. This corsage offers nice contrasting colours and is long-lasting. To fill it out, we've added sprigs of Italia ruscus for greenery and a small, satin ribbon bow. Price: $25 Photo Credit: Crab Apple Floral Design Seasonal Availability: Year round	White Rose & Freesia An alternative to the more often seen pin-on corsage, this wrist corsage incorporate the elegance of the white rose with the delicacy of the fragrant white freesia. We've also filled this corsage out with sprigs of Italian ruscus and a small, satin ribbon bow. Price: $30 Photo Credit: Crab Apple Floral Design Seasonal Availability: Year round