Sussex Bird Safari - Pagham Harbour (17/02/17) - Additional Date Friday, 17th February 2017 9:30 AM - 4:30 PM

We will be exploring around the Visitor Centre and looking over the Ferry Pool before heading off to Church Norton. Large numbers of geese, ducks and waders visit here every winter and that in turn can attract raptors such as peregrine and merlin.

No previous knowledge or skills required, just enthusiasm!

Meet at Pagham Harbour Visitor Centre, Selsey Rd, Chichester PO20 7NE.

Booking essential.

Download course details sheet


Notice: Undefined offset: 0 in /var/www/html/admin/templates/pages/events/event.php on line 47

7 tickets left

Description Price Qty
Test Event £10.00
Seven Sisters Nature Tots - Wednedays (1 March - 29 March 2017) £45.00
Woods Mill Wild Woodies Spring Holiday Club (19/04/17) £30.00
A Beginners Guide to Raptors (21/04/17) - Additional Date £42.00
Woods Mill Nature Tots - Saturdays (22 April, 27 May, 24 June and 22 July 2017) £45.00
The Life and Times of the Badger (23/04/17) £58.00
Sussex Half Day Bird Safari - Cuckmere Haven and Seaford Head (24/04/17) £21.00
An Evening with Badgers (24/04/17) £30.00
An Evening with Badgers (26/04/17) £30.00
Ecology and Management of Woodlands (28/04/17) £42.00
An Evening with Badgers (03/05/17) £30.00
An Introduction to Micro-moths (06/05/17) £42.00
Stanmer Park Nature Tots - Wednesday (1 March - 5 April 2017) £54.00
Rye Harbour Wildlife Watch - Saturdays (06/05/17) £26.00
Dawn Chorus (07/05/17) £21.00
The Life and Times of the Badger (07/05/17) £58.00
An Evening with Badgers (8/05/17) £30.00
Sussex Half Day Bird Safari - Pett Levels (10/05/17) £21.00
An Evening with Nightingales (11/05/17) £21.00
An Introduction to Warblers (12/05/17) £42.00
Botanical Illustration (12, 13 and 14/05/2017) £200.00
The Life and Times of the Badger (14/05/17) £58.00
An Evening with Badgers (15/05/17) £30.00
Tilgate Park Nature Tots - Thursdays (2 March - 30 March 2017) £45.00
Sussex Half Day Bird Safari - Hastings Country Park (16/05/17) £21.00
An Introduction to Warblers (17/05/17) £42.00
How to Help Bees and other Pollinators (19/05/17) £42.00
An Evening with Bats (19/05/17) £21.00
Introduction to the Wild Flowers of Sussex (20/05/17) £42.00
Wild Beasts and Birds in Willow (20/05/17) £70.00
The Life and Times of the Badger (21/05/17) £58.00
Wildlife and the Planning Process (23/05/17) £21.00
Ecology of the Hazel Dormouse (26/05/17) £42.00
Brilliant Birds (30/05/17) £3.00
Horsham Nature Tots - Mondays (6 March - 10 April 2017) £54.00
Rockpool Ramble (01/06/17) £3.00
Undersea Explorers 2 - Brighton (02/06/17) £14.00
Wildflower Meadows : Creation, Management and Enjoyment (07/06/17) £42.00
Beginners Birds - Summer Breeders (10/06/17) £12.00
Wild Ways (10/06/17) £42.00
An Evening with Nightjars (15/06/17) £21.00
An Introduction to Moths and Moth Trapping (23/06/17) £21.00
An Introduction to Dragonflies and Damselflies (24/06/17) £42.00
Woods Mill Nature Tots - Tuesdays (7 March - 4 April 2017) £54.00
Sussex Half Day Bird Safari - Ambersham Common (27/06/17) £21.00
Identification of Grasses, Sedges and Rushes (30/06/17 & 01/07/17) £196.00
Wildlife of Chalk Downland (30/06/17) £42.00
Natural Navigation - Reading Nature's Signposts (07/07/17) £35.00
An Evening with Glow Worms (07/07/17) £21.00
Summer Butterflies of Sussex (08/07/17) £21.00
Identification and Natural History of Bumblebees (08/07/17) £42.00
Introduction to the Wild Flowers of Sussex (15/07/17) £42.00
Beginning Nature Photography (22 & 23/07/17) £126.00
Wild Beach - Pett Level (28/07/17) £5.00
Sussex Half Day Bird Safari -Stedham and Iping Common (08/03/17) £21.00
Woods Mill Wild Woodies Summer Holiday Club (01/08/17) £30.00
Seven Sisters Wild Beach Holiday Club (01/08/17) £21.00
Stanmer Park Wild Woodies Summer Holiday Club (02/08/17) £21.00
Undersea Explorers 1 - Brighton (02/08/17) £14.00
Undersea Explorers 2 - Brighton (02/08/17) £14.00
Minibeasts (02/08/17) £3.00
Rockpool Ramble (03/08/17) £3.50
Woods Mill Wild Woodies Summer Holiday Club (08/08/17) £30.00
My Wildlife Adventure (08/08/17) £7.00
Rye Bay Nature Tots - Fridays (10 March - 31 March 2017) £26.00
Castle Water Safari (08/08/17)
25 tickets left
£5.00
Seven Sisters Wild Woodies Summer Holiday Club (10/08/17) £21.00
Mud, Mud, Glorious Mud (11/08/17) £3.00
Rockpool Ramble - Pett Level (14/08/17) £3.00
Woods Mill Wild Woodies Summer Holiday Club (15/08/17) £30.00
Shrimping (15/8/17) £3.00
Seven Sisters Wild Woodies Summer Holiday Club (15/08/17) £21.00
Stanmer Park Wild Woodies Summer Holiday Club (16/08/17) £21.00
Invertebrates of a Heathland (18/08/17) £70.00
Woods Mill Nature Tots - Saturdays (11 March, 8 April, 13 May, 10 June and 8 July 2017) £45.00
Navigation for Juniors (25/08/17) £30.00
Woods Mill Wild Woodies Summer Holiday Club (22/08/17) £30.00
Wild Play in the Woods (22/08/17) £7.00
Seven Sisters Wild Woodies Summer Holiday Club (23/08/17) £21.00
Stanmer Park Wild Woodies Summer Holiday Club (23/08/17) £21.00
Mud, Mud, Glorious Mud (25/08/17) £3.00
Introduction to Waders on Autumn Migration (01/09/17) £42.00
Rye Harbour Wildlife Watch - Saturdays (02/09/17) £26.00
Sussex Bird Safari - Rye Harbour Nature Reserve (08/09/17) £42.00
Learn to Navigate (09/09/17) £42.00
Stanmer Park Nature Tots - Saturdays (11/03/17) £45.00
Beginning Nature Photography - (16 & 17/09/17) £126.00
Ecology of the Hazel Dormouse (22/09/17) £42.00
Wyrd Ways (23/09/17) £42.00
The Owls of Sussex (24/09/17) £42.00
The Owls of Sussex (27/09/17) £42.00
Harvest Mouse Ecology and Survey (29/09/17) £42.00
The Owls of Sussex (01/10/17) £42.00
The Owls of Sussex (04/10/17) £42.00
Make a Minibeast Home (24/10/17) £3.00
Seven Sisters Wild Woodies Autumn Holiday Club (25/10/17) £21.00
Woods Mill Wildlife Watch - Saturdays (11 March, 8 April, 13 May, 10 June and 8 July 2017) £0.00
Undersea Explorers 1 - Brighton (26/10/17)
16 tickets left
£14.00
Undersea Explorers 2 - Brighton (26/10/17) £14.00
Sussex Bird Safari - Medmerry, Selsey (27/10/17) £42.00
Halloween Horrors! (27/10/17) £8.00
An Introduction to Fungi (02/11/17) £42.00
Improving Your Nature Photography (04 & 05/11/17) £126.00
Beginners Birds - Winter Waders (25/11/17) £12.00
Winter Wonder (02/12/17) £7.00
Stanmer Park Wildlife Watch - Saturdays (11/03/17) £45.00
Adopt a badger pack
162 tickets left
£15.00
A Feast of West Sussex
12 tickets left
£9.99
A Sussex Guide to Sussex Wildlife
9 tickets left
£8.99
Adopt a grey seal £15.00
adopt a turtle dove
155 tickets left
£15.00
Sussex Half Day Bird Safari - Stedham & Iping (15/03/17) - Additional Date £21.00
Birds: A Portrait in Pictures and Words £12.99
Frog hat £12.95
Mark Greco Greeting Card Set £11.00
Pledge a sheep
50 tickets left
£20.00
Pledge towards essential livestock medicines £25.00
Pledge towards marine survey equipment £30.00
Pledge towards restoration of hedgerows £10.00
Sandpiper mug with case £8.50
Snow by Sam Usher £11.99
Tea towel duo common tern / sandpiper £14.00
Wild Garden Weekends £16.99
Wild Swimming £16.99
Wildflower Seedball tin - bee friendly mix £4.99
Wildflower Seedball tin - Butterfly friendly mix £4.99
Wildflower Seedball tin - Edible Herb Mix £4.99
Wildflower Seedball tin - Salad Mix £4.99
Wildflower Seedball tin - Urban Meadow Mix £4.99
Woodland Craft £25.00
Sussex Half Day Bird Safari - Broadwater Warren (17/03/17) £21.00
Woods Mill Wildlife Watch - Saturdays (18 March, 15 April, 20 May, 17 June and 15 July 2017) £45.00
An Introduction to Hoverflies (25 & 26/03/17) £84.00
Sussex Half Day Bird Safari - West Dean Woods (29/03/17) - Additional Date £21.00
Book
9 tickets left
£10.00
Woodland and Willow Basket Making (01/04/17) £84.00
Rye Harbour Wildlife Watch Taster Day - (01/04/17) £6.50
Rockpool Ramble - Pett Level, near Hastings (03/04/17) £3.00
Woods Mill Nature Tots - Wednesdays (1 March - 5 April 2017) £54.00
Minibeast Hunt (05/04/17) £3.00
An Introduction to the Small Mammals of Sussex (07/04/17) £42.00
A Beginners Guide to Raptors (07/04/17) £42.00
Beginning Nature Photography (8 & 9/04/17) £126.00
Seven Sisters Wild Woodies Spring Holiday Club (11/4/17) £21.00
Woods Mill Wild Woodies Spring Holiday Club (12/04/17) £30.00
Stanmer Park Wild Woodies Spring Holiday Club (13/04/17) £21.00
Undersea Explorers 1 - Brighton (13/04/17) £14.00
Undersea Explorers 2 - Brighton (13/04/17) £14.00
Make a Minibeast Home (13/04/17) £3.00

Notice: Undefined offset: 0 in /var/www/html/admin/templates/pages/events/event.php on line 47

7 tickets left

Description Price Qty
Test Event £10.00
Seven Sisters Nature Tots - Wednedays (1 March - 29 March 2017) £45.00
Woods Mill Wild Woodies Spring Holiday Club (19/04/17) £30.00
A Beginners Guide to Raptors (21/04/17) - Additional Date £42.00
Woods Mill Nature Tots - Saturdays (22 April, 27 May, 24 June and 22 July 2017) £45.00
The Life and Times of the Badger (23/04/17) £58.00
Sussex Half Day Bird Safari - Cuckmere Haven and Seaford Head (24/04/17) £21.00
An Evening with Badgers (24/04/17) £30.00
An Evening with Badgers (26/04/17) £30.00
Ecology and Management of Woodlands (28/04/17) £42.00
An Evening with Badgers (03/05/17) £30.00
An Introduction to Micro-moths (06/05/17) £42.00
Stanmer Park Nature Tots - Wednesday (1 March - 5 April 2017) £54.00
Rye Harbour Wildlife Watch - Saturdays (06/05/17) £26.00
Dawn Chorus (07/05/17) £21.00
The Life and Times of the Badger (07/05/17) £58.00
An Evening with Badgers (8/05/17) £30.00
Sussex Half Day Bird Safari - Pett Levels (10/05/17) £21.00
An Evening with Nightingales (11/05/17) £21.00
An Introduction to Warblers (12/05/17) £42.00
Botanical Illustration (12, 13 and 14/05/2017) £200.00
The Life and Times of the Badger (14/05/17) £58.00
An Evening with Badgers (15/05/17) £30.00
Tilgate Park Nature Tots - Thursdays (2 March - 30 March 2017) £45.00
Sussex Half Day Bird Safari - Hastings Country Park (16/05/17) £21.00
An Introduction to Warblers (17/05/17) £42.00
How to Help Bees and other Pollinators (19/05/17) £42.00
An Evening with Bats (19/05/17) £21.00
Introduction to the Wild Flowers of Sussex (20/05/17) £42.00
Wild Beasts and Birds in Willow (20/05/17) £70.00
The Life and Times of the Badger (21/05/17) £58.00
Wildlife and the Planning Process (23/05/17) £21.00
Ecology of the Hazel Dormouse (26/05/17) £42.00
Brilliant Birds (30/05/17) £3.00
Horsham Nature Tots - Mondays (6 March - 10 April 2017) £54.00
Rockpool Ramble (01/06/17) £3.00
Undersea Explorers 2 - Brighton (02/06/17) £14.00
Wildflower Meadows : Creation, Management and Enjoyment (07/06/17) £42.00
Beginners Birds - Summer Breeders (10/06/17) £12.00
Wild Ways (10/06/17) £42.00
An Evening with Nightjars (15/06/17) £21.00
An Introduction to Moths and Moth Trapping (23/06/17) £21.00
An Introduction to Dragonflies and Damselflies (24/06/17) £42.00
Woods Mill Nature Tots - Tuesdays (7 March - 4 April 2017) £54.00
Sussex Half Day Bird Safari - Ambersham Common (27/06/17) £21.00
Identification of Grasses, Sedges and Rushes (30/06/17 & 01/07/17) £196.00
Wildlife of Chalk Downland (30/06/17) £42.00
Natural Navigation - Reading Nature's Signposts (07/07/17) £35.00
An Evening with Glow Worms (07/07/17) £21.00
Summer Butterflies of Sussex (08/07/17) £21.00
Identification and Natural History of Bumblebees (08/07/17) £42.00
Introduction to the Wild Flowers of Sussex (15/07/17) £42.00
Beginning Nature Photography (22 & 23/07/17) £126.00
Wild Beach - Pett Level (28/07/17) £5.00
Sussex Half Day Bird Safari -Stedham and Iping Common (08/03/17) £21.00
Woods Mill Wild Woodies Summer Holiday Club (01/08/17) £30.00
Seven Sisters Wild Beach Holiday Club (01/08/17) £21.00
Stanmer Park Wild Woodies Summer Holiday Club (02/08/17) £21.00
Undersea Explorers 1 - Brighton (02/08/17) £14.00
Undersea Explorers 2 - Brighton (02/08/17) £14.00
Minibeasts (02/08/17) £3.00
Rockpool Ramble (03/08/17) £3.50
Woods Mill Wild Woodies Summer Holiday Club (08/08/17) £30.00
My Wildlife Adventure (08/08/17) £7.00
Rye Bay Nature Tots - Fridays (10 March - 31 March 2017) £26.00
Castle Water Safari (08/08/17)
25 tickets left
£5.00
Seven Sisters Wild Woodies Summer Holiday Club (10/08/17) £21.00
Mud, Mud, Glorious Mud (11/08/17) £3.00
Rockpool Ramble - Pett Level (14/08/17) £3.00
Woods Mill Wild Woodies Summer Holiday Club (15/08/17) £30.00
Shrimping (15/8/17) £3.00
Seven Sisters Wild Woodies Summer Holiday Club (15/08/17) £21.00
Stanmer Park Wild Woodies Summer Holiday Club (16/08/17) £21.00
Invertebrates of a Heathland (18/08/17) £70.00
Woods Mill Nature Tots - Saturdays (11 March, 8 April, 13 May, 10 June and 8 July 2017) £45.00
Navigation for Juniors (25/08/17) £30.00
Woods Mill Wild Woodies Summer Holiday Club (22/08/17) £30.00
Wild Play in the Woods (22/08/17) £7.00
Seven Sisters Wild Woodies Summer Holiday Club (23/08/17) £21.00
Stanmer Park Wild Woodies Summer Holiday Club (23/08/17) £21.00
Mud, Mud, Glorious Mud (25/08/17) £3.00
Introduction to Waders on Autumn Migration (01/09/17) £42.00
Rye Harbour Wildlife Watch - Saturdays (02/09/17) £26.00
Sussex Bird Safari - Rye Harbour Nature Reserve (08/09/17) £42.00
Learn to Navigate (09/09/17) £42.00
Stanmer Park Nature Tots - Saturdays (11/03/17) £45.00
Beginning Nature Photography - (16 & 17/09/17) £126.00
Ecology of the Hazel Dormouse (22/09/17) £42.00
Wyrd Ways (23/09/17) £42.00
The Owls of Sussex (24/09/17) £42.00
The Owls of Sussex (27/09/17) £42.00
Harvest Mouse Ecology and Survey (29/09/17) £42.00
The Owls of Sussex (01/10/17) £42.00
The Owls of Sussex (04/10/17) £42.00
Make a Minibeast Home (24/10/17) £3.00
Seven Sisters Wild Woodies Autumn Holiday Club (25/10/17) £21.00
Woods Mill Wildlife Watch - Saturdays (11 March, 8 April, 13 May, 10 June and 8 July 2017) £0.00
Undersea Explorers 1 - Brighton (26/10/17)
16 tickets left
£14.00
Undersea Explorers 2 - Brighton (26/10/17) £14.00
Sussex Bird Safari - Medmerry, Selsey (27/10/17) £42.00
Halloween Horrors! (27/10/17) £8.00
An Introduction to Fungi (02/11/17) £42.00
Improving Your Nature Photography (04 & 05/11/17) £126.00
Beginners Birds - Winter Waders (25/11/17) £12.00
Winter Wonder (02/12/17) £7.00
Stanmer Park Wildlife Watch - Saturdays (11/03/17) £45.00
Adopt a badger pack
162 tickets left
£15.00
A Feast of West Sussex
12 tickets left
£9.99
A Sussex Guide to Sussex Wildlife
9 tickets left
£8.99
Adopt a grey seal £15.00
adopt a turtle dove
155 tickets left
£15.00
Sussex Half Day Bird Safari - Stedham & Iping (15/03/17) - Additional Date £21.00
Birds: A Portrait in Pictures and Words £12.99
Frog hat £12.95
Mark Greco Greeting Card Set £11.00
Pledge a sheep
50 tickets left
£20.00
Pledge towards essential livestock medicines £25.00
Pledge towards marine survey equipment £30.00
Pledge towards restoration of hedgerows £10.00
Sandpiper mug with case £8.50
Snow by Sam Usher £11.99
Tea towel duo common tern / sandpiper £14.00
Wild Garden Weekends £16.99
Wild Swimming £16.99
Wildflower Seedball tin - bee friendly mix £4.99
Wildflower Seedball tin - Butterfly friendly mix £4.99
Wildflower Seedball tin - Edible Herb Mix £4.99
Wildflower Seedball tin - Salad Mix £4.99
Wildflower Seedball tin - Urban Meadow Mix £4.99
Woodland Craft £25.00
Sussex Half Day Bird Safari - Broadwater Warren (17/03/17) £21.00
Woods Mill Wildlife Watch - Saturdays (18 March, 15 April, 20 May, 17 June and 15 July 2017) £45.00
An Introduction to Hoverflies (25 & 26/03/17) £84.00
Sussex Half Day Bird Safari - West Dean Woods (29/03/17) - Additional Date £21.00
Book
9 tickets left
£10.00
Woodland and Willow Basket Making (01/04/17) £84.00
Rye Harbour Wildlife Watch Taster Day - (01/04/17) £6.50
Rockpool Ramble - Pett Level, near Hastings (03/04/17) £3.00
Woods Mill Nature Tots - Wednesdays (1 March - 5 April 2017) £54.00
Minibeast Hunt (05/04/17) £3.00
An Introduction to the Small Mammals of Sussex (07/04/17) £42.00
A Beginners Guide to Raptors (07/04/17) £42.00
Beginning Nature Photography (8 & 9/04/17) £126.00
Seven Sisters Wild Woodies Spring Holiday Club (11/4/17) £21.00
Woods Mill Wild Woodies Spring Holiday Club (12/04/17) £30.00
Stanmer Park Wild Woodies Spring Holiday Club (13/04/17) £21.00
Undersea Explorers 1 - Brighton (13/04/17) £14.00
Undersea Explorers 2 - Brighton (13/04/17) £14.00
Make a Minibeast Home (13/04/17) £3.00
Debug Message
[527] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate FROM swt_pages p LEFT JOIN swt_page_routes pr ON p.pageID=pr.pageID ORDER BY pr.routeOrder ASC, p.pagePath ASC
Matched route: whats-on/[slug:s]
Using master page: /templates/pages/events/event.php
Page arguments:
Array
(
    [0] => /whats-on/2017-02-17-sussex-bird-safari-pagham-harbour-170217-additional-date
    [s] => 2017-02-17-sussex-bird-safari-pagham-harbour-170217-additional-date
    [1] => 2017-02-17-sussex-bird-safari-pagham-harbour-170217-additional-date
)
[1] SELECT * FROM swt_pages WHERE pagePath='/whats-on/event' LIMIT 1
[60] SELECT DISTINCT settingID, settingValue FROM swt_settings WHERE userID=0
[1] SELECT locationID FROM swt_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
INSERT INTO swt_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',47,'standard','[]')
[1] SELECT * FROM swt_shop_cart WHERE cartID=87792
[1] SELECT * FROM swt_shop_cart WHERE cartID=87792
[1] SELECT DISTINCT e.* FROM swt_events e WHERE eventSlug='2017-02-17-sussex-bird-safari-pagham-harbour-170217-additional-date'
[3] SELECT c.* FROM swt_events_categories c, swt_events_to_categories e2c WHERE c.categoryID=e2c.categoryID AND e2c.eventID='828'
Using template: /templates/pages/attributes/seo.html
Using template: /templates/search/search-form.html
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM swt_shop_cart WHERE cartID=87792
[1] SELECT * FROM swt_shop_cart WHERE cartID=87792
[1] SELECT * FROM swt_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM swt_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM swt_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM swt_shop_currencies WHERE currencyID=47 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM swt_shop_cart_items WHERE cartID=87792
Tax mode: inc
[nil] SELECT * FROM swt_shop_cart_items WHERE cartID=87792 ORDER BY itemID ASC
[7] SELECT * FROM swt_pages WHERE pageNew=0 AND pageHidden=0 AND pageDepth >=0 AND pageDepth<=1 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM swt_pages WHERE pagePath='/whats-on/event' LIMIT 1
[2] SELECT pageID FROM swt_pages WHERE pageTreePosition IN ('000-008-001', '000-008', '000') ORDER BY pageTreePosition DESC
[7] Using template: /templates/navigation/item.html
[385] SELECT * FROM swt_pages WHERE pageNew=0 AND pageHidden=0 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM swt_pages WHERE pagePath='/whats-on/event' LIMIT 1
[2] SELECT pageID FROM swt_pages WHERE pageTreePosition IN ('000-008-001', '000-008', '000') ORDER BY pageTreePosition DESC
Using template: /templates/navigation/meganav.html
[9] Using template: /templates/navigation/meganav__item.html
[6] Using template: /templates/navigation/meganav__item.html
[27] Using template: /templates/navigation/meganav__item.html
[12] Using template: /templates/navigation/meganav__item.html
[1] Using template: /templates/navigation/meganav__item.html
[7] Using template: /templates/navigation/meganav__item.html
[1] SELECT pageTreePosition FROM swt_pages WHERE pagePath='/whats-on/event' OR pageSortPath='/whats-on/event' LIMIT 1
[1] SELECT * FROM swt_pages WHERE pageHidden=0 AND pageNew=0 AND pageTreePosition IN ('000-008-001', '000-008', '000') ORDER BY pageTreePosition
[1] Using template: /templates/navigation/breadcrumbs.html
[1] SELECT DISTINCT e.* FROM swt_events e WHERE eventSlug='2017-02-17-sussex-bird-safari-pagham-harbour-170217-additional-date'
[1] Using template: /templates/events/listing/event-detail.html
[3] SELECT c.* FROM swt_events_categories c, swt_events_to_categories e2c WHERE c.categoryID=e2c.categoryID AND e2c.eventID='828'
[nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM swt_shop_index idx JOIN swt_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN swt_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' WHERE 1=1 AND ((idx.indexKey='productID' AND idx.indexValue=1.4043652890129E+18)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10
Using template: /templates/shop/products/list.html
[149] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM swt_shop_index idx JOIN swt_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN swt_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[149] Using template: /templates/shop//products/variant_list.html
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=1 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='1' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM swt_shop_currencies WHERE currencyID=47 LIMIT 1
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=10 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=10 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='10' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=101 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=101 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='101' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=105 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=105 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='105' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=108 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=108 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='108' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=111 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=111 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='111' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=114 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=114 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='114' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=117 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=117 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='117' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=120 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=120 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='120' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=123 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=123 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='123' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=126 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=126 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='126' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=129 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=129 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='129' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=13 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=13 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='13' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=132 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=132 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='132' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=135 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=135 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='135' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=138 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=138 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='138' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=141 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=141 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='141' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=144 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=144 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='144' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=147 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=147 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='147' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=150 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=150 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='150' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=153 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=153 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='153' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=156 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=156 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='156' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=159 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=159 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='159' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=16 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=16 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='16' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=162 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=162 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='162' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=165 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=165 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='165' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=168 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=168 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='168' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=171 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=171 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='171' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=174 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=174 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='174' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=177 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=177 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='177' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=180 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=180 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='180' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=183 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=183 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='183' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=186 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=186 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='186' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=189 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=189 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='189' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=19 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='19' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=195 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=195 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='195' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=201 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=201 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='201' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=204 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=204 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='204' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=208 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=208 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='208' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=211 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=211 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='211' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=214 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=214 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='214' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=217 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=217 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='217' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=22 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=22 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='22' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=220 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=220 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='220' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=223 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=223 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='223' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=226 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=226 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='226' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=229 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=229 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='229' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=232 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=232 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='232' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=235 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=235 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='235' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=238 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=238 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='238' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=241 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=241 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='241' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=244 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=244 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='244' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=247 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=247 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='247' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=25 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=25 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='25' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=250 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=250 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='250' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=253 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=253 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='253' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=256 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=256 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='256' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=259 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=259 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='259' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=262 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=262 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='262' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=265 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=265 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='265' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=268 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=268 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='268' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=273 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=273 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='273' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=276 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=276 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='276' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=28 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=28 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='28' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=281 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=281 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='281' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=284 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=284 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='284' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=287 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=287 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='287' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=290 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=290 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='290' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=293 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=293 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='293' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=296 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=296 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='296' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=299 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=299 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='299' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=302 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=302 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='302' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=307 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=307 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='307' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=31 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=31 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='31' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=310 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=310 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='310' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=313 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=313 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='313' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=316 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=316 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='316' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=321 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=321 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='321' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=324 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=324 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='324' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=327 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=327 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='327' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=330 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=330 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='330' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=333 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=333 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='333' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=336 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=336 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='336' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=339 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=339 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='339' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=34 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=34 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='34' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=342 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=342 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='342' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=345 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=345 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='345' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=348 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=348 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='348' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=351 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=351 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='351' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=354 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=354 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='354' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=357 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=357 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='357' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=360 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=360 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='360' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=363 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=363 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='363' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=366 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=366 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='366' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=369 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=369 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='369' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=37 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=37 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='37' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=372 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=372 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='372' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=375 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=375 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='375' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=378 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=378 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='378' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=381 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=381 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='381' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=386 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=386 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='386' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=389 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=389 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='389' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=392 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=392 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='392' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=394 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=394 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='394' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=40 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=40 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='40' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=43 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=43 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='43' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=46 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=46 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='46' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=49 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=49 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='49' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=55 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=55 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='55' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=58 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=58 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='58' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=61 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=61 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='61' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=64 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=64 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='64' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=67 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=67 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='67' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=7 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=7 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='7' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=70 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=70 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='70' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=73 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=73 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='73' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=76 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=76 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='76' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=79 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=79 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='79' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=82 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=82 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='82' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=85 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=85 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='85' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=88 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=88 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='88' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=91 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=91 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='91' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=94 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=94 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='94' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=98 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=98 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='98' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[nil] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM swt_shop_index idx JOIN swt_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN swt_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='title' WHERE 1=1 AND ((idx.indexKey='productID' AND idx.indexValue=1.4043655945008E+18)) AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC LIMIT 0, 10
Using template: /templates/shop/products/list.html
[149] SELECT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM swt_shop_index idx JOIN swt_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN swt_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='_id' WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval ASC
[149] Using template: /templates/shop//products/variant_list.html
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=1 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=1 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='1' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=10 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=10 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='10' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=101 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=101 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='101' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=105 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=105 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='105' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=108 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=108 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='108' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=111 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=111 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='111' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=114 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=114 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='114' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=117 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=117 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='117' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=120 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=120 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='120' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=123 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=123 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='123' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=126 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=126 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='126' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=129 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=129 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='129' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=13 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=13 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='13' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=132 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=132 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='132' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=135 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=135 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='135' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=138 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=138 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='138' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=141 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=141 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='141' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=144 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=144 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='144' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=147 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=147 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='147' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=150 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=150 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='150' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=153 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=153 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='153' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=156 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=156 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='156' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=159 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=159 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='159' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=16 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=16 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='16' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=162 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=162 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='162' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=165 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=165 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='165' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=168 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=168 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='168' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=171 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=171 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='171' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=174 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=174 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='174' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=177 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=177 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='177' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=180 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=180 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='180' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=183 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=183 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='183' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=186 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=186 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='186' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=189 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=189 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='189' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=19 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=19 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='19' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=195 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=195 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='195' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=201 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=201 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='201' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=204 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=204 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='204' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=208 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=208 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='208' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=211 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=211 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='211' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=214 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=214 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='214' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=217 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=217 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='217' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=22 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=22 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='22' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=220 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=220 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='220' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=223 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=223 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='223' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=226 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=226 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='226' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=229 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=229 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='229' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=232 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=232 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='232' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=235 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=235 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='235' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=238 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=238 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='238' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=241 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=241 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='241' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=244 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=244 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='244' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=247 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=247 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='247' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=25 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=25 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='25' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=250 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=250 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='250' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=253 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=253 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='253' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=256 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=256 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='256' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=259 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=259 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='259' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=262 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=262 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='262' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=265 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=265 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='265' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=268 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=268 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='268' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=273 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=273 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='273' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=276 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=276 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='276' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=28 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=28 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='28' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=281 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=281 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='281' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=284 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=284 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='284' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=287 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=287 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='287' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=290 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=290 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='290' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=293 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=293 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='293' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=296 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=296 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='296' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=299 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=299 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='299' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=302 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=302 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='302' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=307 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=307 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='307' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=31 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=31 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='31' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=310 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=310 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='310' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=313 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=313 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='313' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=316 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=316 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='316' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=321 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=321 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='321' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=324 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=324 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='324' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=327 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=327 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='327' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=330 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=330 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='330' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=333 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=333 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='333' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=336 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=336 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='336' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=339 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=339 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='339' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=34 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=34 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='34' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=342 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=342 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='342' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=345 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=345 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='345' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=348 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=348 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='348' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=351 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=351 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='351' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=354 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=354 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='354' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=357 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=357 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='357' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=360 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=360 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='360' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=363 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=363 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='363' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=366 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=366 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='366' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=369 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=369 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='369' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=37 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=37 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='37' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=372 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=372 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='372' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=375 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=375 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='375' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=378 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=378 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='378' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=381 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=381 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='381' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=386 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=386 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='386' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=389 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=389 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='389' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=392 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=392 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[1] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='392' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[4] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=394 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=394 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[4] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='394' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=40 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=40 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='40' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=43 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=43 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='43' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=46 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=46 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='46' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=49 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=49 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='49' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=55 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=55 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='55' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=58 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=58 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='58' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=61 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=61 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='61' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=64 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=64 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='64' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=67 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=67 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='67' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=7 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=7 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='7' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=70 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=70 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='70' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=73 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=73 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='73' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=76 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=76 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='76' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=79 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=79 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='79' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=82 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=82 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='82' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=85 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=85 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='85' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=88 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=88 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='88' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=91 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=91 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='91' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=94 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=94 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[4] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=1 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='94' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='1' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[2] SELECT productID, productVariantDesc, stock_level FROM swt_shop_products WHERE parentID=98 AND productDeleted IS NULL ORDER BY productOrder ASC
[1] SELECT o.* FROM swt_shop_options o, swt_shop_product_options po WHERE o.optionID=po.optionID AND po.productID=98 AND o.optionDeleted IS NULL ORDER BY optionPrecendence ASC
[2] SELECT valueID AS id, valueTitle AS title, valueSKUCode AS skucode FROM swt_shop_option_values WHERE optionID=2 AND valueDeleted IS NULL ORDER BY valueOrder ASC
[2] SELECT pov.prodoptID, pov.optionID, pov.valueID, o.optionTitle, ov.* FROM swt_shop_product_option_values pov, swt_shop_options o, swt_shop_option_values ov WHERE pov.productID='98' AND pov.optionID=o.optionID AND pov.valueID=ov.valueID AND o.optionDeleted IS NULL AND ov.valueDeleted IS NULL AND o.optionID='2' ORDER BY o.optionPrecendence ASC, ov.valueOrder ASC
[1] SELECT * FROM swt_blog_posts WHERE postStatus='Published' AND postDateTime<='2017-02-22 15:15:00' AND postSlug='2017-02-17-sussex-bird-safari-pagham-harbour-170217-additional-date'
Using cart from cache.
Template file not found: /var/www/html/admin/addons/apps/perch_shop/templates/shop/cart/cart-summary.html
Using template: /templates/pages/attributes/default.html
Using sub-template: /templates/pages/attributes/seo.html
[3] SELECT * FROM swt_twitter_tweets WHERE tweetType='mine' AND tweetAccount='sussexwildlife' AND tweetIsReply=0 ORDER BY tweetDate DESC LIMIT 3
[3] Using template: /templates/twitter/tweet.html
[1] SELECT collectionID, collectionTemplate FROM swt_collections WHERE collectionKey='Asks'
[1] SELECT * FROM ( SELECT idx.itemID, ci.collectionID, ci.itemJSON, idx2.indexValue as sortval FROM swt_collection_index idx JOIN swt_collection_items ci ON idx.itemID=ci.itemID AND idx.itemRev=ci.itemRev AND idx.collectionID=ci.collectionID JOIN swt_collection_revisions cr ON idx.itemID=cr.itemID AND idx.itemRev=cr.itemRev AND idx.collectionID=ci.collectionID JOIN swt_collection_index idx2 ON idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev AND idx2.indexKey='_ID' WHERE (idx.collectionID=9) AND idx.itemID=idx2.itemID AND idx.itemRev=idx2.itemRev ) as tbl GROUP BY itemID, itemJSON, sortval ORDER BY RAND() LIMIT 0, 1
[1] Using template: /templates/content/ask_(tall).html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages WHERE pagePath='/discover' OR pageSortPath='/discover' LIMIT 1
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages WHERE pageTreePosition='000-003' LIMIT 1
[7] SELECT * FROM swt_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-003%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM swt_pages WHERE pagePath='/whats-on/event' LIMIT 1
[2] SELECT pageID FROM swt_pages WHERE pageTreePosition IN ('000-008-001', '000-008', '000') ORDER BY pageTreePosition DESC
[6] Using template: /templates/navigation/footer-nav.html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages WHERE pagePath='/visit' OR pageSortPath='/visit' LIMIT 1
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages WHERE pageTreePosition='000-004' LIMIT 1
[28] SELECT * FROM swt_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-004%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM swt_pages WHERE pagePath='/whats-on/event' LIMIT 1
[2] SELECT pageID FROM swt_pages WHERE pageTreePosition IN ('000-008-001', '000-008', '000') ORDER BY pageTreePosition DESC
[27] Using template: /templates/navigation/footer-nav.html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages WHERE pagePath='/what-we-do' OR pageSortPath='/what-we-do' LIMIT 1
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages WHERE pageTreePosition='000-002' LIMIT 1
[10] SELECT * FROM swt_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-002%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM swt_pages WHERE pagePath='/whats-on/event' LIMIT 1
[2] SELECT pageID FROM swt_pages WHERE pageTreePosition IN ('000-008-001', '000-008', '000') ORDER BY pageTreePosition DESC
[9] Using template: /templates/navigation/footer-nav.html
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages WHERE pagePath='/get-involved' OR pageSortPath='/get-involved' LIMIT 1
[1] SELECT pageID, pageParentID, pageDepth, pageTreePosition FROM swt_pages WHERE pageTreePosition='000-005' LIMIT 1
[13] SELECT * FROM swt_pages WHERE pageNew=0 AND pageHidden=0 AND pageTreePosition LIKE '000-005%' AND pageDepth >=1 AND pageDepth<=2 ORDER BY pageTreePosition ASC
[1] SELECT pageTreePosition FROM swt_pages WHERE pagePath='/whats-on/event' LIMIT 1
[2] SELECT pageID FROM swt_pages WHERE pageTreePosition IN ('000-008-001', '000-008', '000') ORDER BY pageTreePosition DESC
[12] Using template: /templates/navigation/footer-nav.html
Request time: 8.2646
Process time: 8.2629
Memory: 3.3587
Array
(
    [type] => 8
    [message] => Undefined offset: 0
    [file] => /var/www/html/admin/templates/pages/events/event.php
    [line] => 47
)