Next SQL SELECT `ref`,`name`,`id`,`slug` FROM `products` WHERE `section` = '13' AND `producttype` = '1' AND `id` > '1170' AND `showonweb` = 'Yes' LIMIT 1
Next SQL SELECT `ref`,`name`,`id`,`slug` FROM `products` WHERE `section` = '13' AND `producttype` = '1' AND `id` < '1170' AND `showonweb` = 'Yes' ORDER BY `id` DESC LIMIT 1
To find the delivery costs for your order simply place the items in your basket. Our delivery costs for most items are based on each item's size and weight. Delivery and handling estimates that appear in the basket are calculated with our lowest cost delivery method.
Please Note we do NOT deliver Framed Prints - they are for Collection only.
Product Section: [Methodist College Rowing Club Mug (Male Rower)] | 13 |
Personilise Result: | Yes |
Section Personilise 3: [13 | Belfast School Mugs] | Yes |
Section Personilise 2: [5 | School Mugs] | Yes |
Section Personilise 1: [2 | Mugs] | No |
Stock #: | 10 |
Attribute set at Product: [Mugs China/Ceramic (Personalised)] | 2 |
Attribute set at Section 1: [] | |
Attribute set at Section 2: [] | |
Attribute set at Section 3: [] |
Shona was inspired to launch her own jewellery business. Working in collaboration with these highly skilled artisans she created a collection of elegant, affordable handmade jewellery silver in her own designs skilled artisans she created a collection of elegant, affordable handmade jewellery silver in her own.
SELECT `products`.`id` AS 'product' FROM `products` WHERE `orgnameid` = '135' AND `producttype` = '1' AND `id` not like '1170' AND `showonweb` = 'Yes' ORDER BY rand() limit 6
slugid for section: By Org ID (135) - section: (13)
© Shona Donaldson 2024 | Privacy