Our Products

Browse our large assortment of European products!

Our Products
$4.99
the Old Mill Coffee Wafers
$4.69
Verstegen Spice Mix for Gyros
$12.99
Kitchen Tools Cheese Slicer (Black)
$7.99
Verstegen Spice Mix for Curry Chicken
$22.99
Purol Ointment
$3.99
Gwoon Cup A Soup Chicken
$4.69
Verstegen Spice Mix for Ground Beef
$3.69
D.F. English Peppermints
$5.99
Fruit-tella Strawberry 4 Pack
$27.99
Venco Griotten Licorice
$25.99
Venco Salmiak Rounds
$26.99
Venco Double-Salted Licorice
$5.49
Coroos Marrowfat Peas
$25.99
Venco Licorice Cats
$4.89
Verstegen Salt-Free Spice Mix for Ground Beef
$5.99
Pickwick English Loose Tea
$4.69
Verstegen Spice Mix for Pork
$6.69
Calve Mustard
$7.69
Hak Kale
$4.69
Verstegen Spice Mix for Fish

Page 1 of 67

Debug Message - Perch Runway 3.1.5
[17] SELECT p.pagePath, pr.routePattern, pr.routeRegExp, p.pageTemplate, pr.routeOrder, s.settingValue AS siteOffline FROM perch3_pages p LEFT JOIN perch3_page_routes pr ON p.pageID=pr.pageID LEFT JOIN perch3_settings s ON s.settingID='siteOffline' UNION SELECT NULL AS pagePath, pr2.routePattern, pr2.routeRegExp, pr2.templatePath AS pageTemplate, pr2.routeOrder, NULL AS siteOffline FROM perch3_page_routes pr2 WHERE templateID!=0 ORDER BY routeOrder ASC, pagePath ASC
Matched page: /products, so not using routes.
Using master page: /templates/pages/products.php
[1] SELECT * FROM perch3_pages WHERE pagePath='/products' LIMIT 1
[44] SELECT DISTINCT settingID, settingValue FROM perch3_settings WHERE userID=0
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
INSERT INTO perch3_shop_cart(memberID,locationID,currencyID,cartPricing,cartProperties) VALUES(NULL,'1',26,'standard','[]')
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1994169
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1994169
[nil] SELECT * FROM perch3_shop_sales WHERE saleFrom<='2026-01-18 13:16:00' AND saleTo>'2026-01-18 13:16:00' AND saleActive=1 AND saleDeleted IS NULL ORDER BY saleOrder ASC
Using template: /templates/pages/attributes/seo.html
------------------------------ Calculating cart ------------------------------
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1994169
[1] SELECT * FROM perch3_shop_cart WHERE cartID=1994169
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT locationID FROM perch3_shop_tax_locations WHERE locationIsHome=1 LIMIT 1
[1] SELECT * FROM perch3_shop_tax_locations WHERE locationID=1 AND locationDeleted IS NULL LIMIT 1
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=26 LIMIT 1
[1] SELECT COUNT(productID) AS product_count, SUM(itemQty) AS item_count FROM perch3_shop_cart_items WHERE cartID=1994169
Tax mode: exc
[nil] SELECT * FROM perch3_shop_cart_items WHERE cartID=1994169 ORDER BY itemID ASC
[2] SELECT regionKey, regionHTML FROM perch3_content_regions WHERE regionPage='/products' OR regionPage='*' ORDER BY regionPage DESC
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='type' LIMIT 1
[14] SELECT main.* FROM perch3_categories main WHERE 1=1 AND setID=2 ORDER BY catTreePosition ASC
[14] Using template: /templates/categories/type.html
[1] SELECT setID FROM perch3_category_sets WHERE setSlug='type' LIMIT 1
[nil] SELECT main.* FROM perch3_categories main WHERE 1=1 AND (catSlug='') AND setID=2 ORDER BY catTreePosition ASC
Using template: /templates/categories/type_heading.html
[4631] SELECT DISTINCT idx.itemID FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' AND ((idx.indexKey='_category' AND idx.indexValue LIKE 'type/%' OR idx.indexKey='_category' AND idx.indexValue='type/'))
[20] SELECT SQL_CALC_FOUND_ROWS DISTINCT tbl.* FROM ( SELECT idx.itemID, main.*, idx2.indexValue as sortval FROM perch3_shop_index idx JOIN perch3_shop_products main ON idx.itemID=main.productID AND idx.itemKey='productID' JOIN perch3_shop_index idx2 ON idx.itemID=idx2.itemID AND idx.itemKey='productID' AND idx2.indexKey='brand' AND idx.itemID IN ('51', '52', '54', '59', '64', '65', '67', '68', '69', '71', '72', '224', '519', '629', '630', '699', '747', '748', '749', '835', '1139', '1142', '1160', '1205', '1215', '1333', '1366', '1404', '1405', '1497', '1533', '1540', '1501', '1562', '1563', '1567', '1536', '1618', '1688', '1761', '1772', '1795', '1873', '1904', '2253', '2267', '2144', '70', '1935', '2190', '2191', '1564', '1578', '2237', '1741', '2051', '1804', '1498', '1113', '1166', '1595', '2312', '2313', '2793', '2238', '3090', '1934', '1632', '3114', '1423', '3389', '2614', '1768', '3104', '3468', '3646', '2873', '2872', '2135', '2516', '1945', '3449', '2591', '885', '2982', '53', '3726', '3727', '3749', '3750', '3796', '960', '3503', '3506', '1788', '3875', '3497', '3508', '1963', '3893', '3895', '56', '22', '2617', '2615', '57', '3504', '1640', '2814', '3666', '3664', '3665', '2815', '1092', '3113', '2618', '3510', '3513', '2641', '1966', '4052', '3062', '3894', '3511', '1862', '2515', '3103', '226', '937', '58', '4051', '3512', '3507', '2616', '2739', '3643', '3390', '1944', '1529', '3450', '1666', '3115', '3428', '3473', '55', '2792', '1218', '63', '2367', '2621', '1787', '2176', '66', '4231', '4227', '4228', '4229', '4230', '4258', '4260', '4309', '4308', '4310', '75', '4409', '4410', '4411', '4413', '3635', '726', '3933', '4148', '2012', '2620', '4095', '3093', '3609', '1500', '395', '1091', '1738', '4427', '4456', '4457', '4458', '4277', '4542', '4543', '4311', '4426', '4050', '4564', '2619', '4600', '4601', '4398', '4399', '1699', '2464', '3679', '2816', '3997', '2623', '3830', '4263', '4541', '4066', '4279', '4280', '4278', '4660', '4662', '4663', '1672', '1836', '225', '4544', '1340', '1096', '2094', '4592', '1916', '1789', '4661', '118', '4664', '570', '631', '632', '633', '634', '635', '636', '649', '656', '658', '659', '660', '662', '768', '780', '789', '815', '827', '905', '912', '1047', '1048', '1089', '1132', '1226', '1228', '1256', '1259', '1352', '1363', '1704', '1821', '1898', '1974', '1978', '1980', '2095', '2181', '2268', '1112', '1083', '1066', '1332', '1284', '1979', '1046', '1255', '1799', '826', '1950', '637', '2543', '1561', '2553', '2568', '2757', '2758', '2901', '2935', '2554', '2969', '3019', '2069', '2544', '3155', '3156', '3159', '3160', '3162', '3163', '3165', '3167', '3168', '3169', '582', '1984', '3161', '1985', '1983', '3164', '3363', '3364', '3365', '3377', '828', '2565', '2566', '2569', '2564', '3380', '3400', '3401', '3402', '3538', '3593', '2837', '2839', '2706', '2970', '3537', '3016', '578', '580', '579', '3153', '3535', '759', '661', '2049', '3534', '3580', '3581', '3915', '3582', '3595', '3584', '3583', '657', '3152', '3924', '4038', '4040', '3171', '3765', '1071', '798', '3166', '2390', '3579', '2794', '3157', '3925', '4283', '4284', '4285', '3745', '2579', '3158', '2971', '4488', '4489', '4490', '4491', '4118', '3170', '581', '3536', '4344', '4232', '475', '4638', '4639', '4640', '1361', '1220', '4282', '2705', '3154', '476', '648', '1130', '227', '2', '5', '6', '9', '10', '11', '12', '13', '14', '15', '18', '19', '20', '39', '43', '46', '47', '222', '331', '332', '333', '334', '418', '419', '420', '421', '422', '423', '424', '425', '426', '427', '428', '429', '430', '431', '433', '435', '507', '510', '623', '676', '678', '703', '704', '719', '755', '756', '757', '760', '796', '807', '819', '825', '836', '839', '899', '925', '976', '984', '1008', '1009', '1076', '1105', '1115', '1123', '1203', '1212', '1223', '1224', '1248', '1282', '1285', '1298', '1299', '1575', '1577', '1581', '1583', '1658', '1659', '1856', '1911', '1969', '2032', '2084', '2136', '2180', '2182', '1912', '1913', '1914', '1915', '2222', '1834', '221', '16', '2091', '1311', '417', '674', '434', '2010', '1939', '1655', '627', '904', '1714', '1246', '1580', '1214', '1656', '626', '1777', '1940', '2285', '2286', '2287', '2322', '2323', '2324', '2325', '2338', '2362', '2477', '2517', '2634', '2865', '2888', '2604', '795', '3003', '3005', '3026', '898', '2828', '2761', '624', '2097', '3085', '2124', '571', '2455', '2456', '2868', '3017', '2046', '1383', '3020', '2309', '3613', '3069', '2109', '2198', '675', '3086', '1554', '2431', '1953', '2428', '3078', '3079', '3077', '2070', '2227', '3084', '628', '2426', '2915', '313', '2578', '2855', '3720', '432', '3455', '3730', '2310', '1034', '720', '3835', '3848', '3857', '3542', '3867', '2630', '2704', '2703', '1103', '1572', '2542', '2825', '2215', '2311', '2551', '3954', '2442', '865', '775', '903', '2438', '1375', '21', '3874', '3983', '3651', '3992', '3905', '1712', '2538', '4015', '4042', '4043', '4046', '4047', '2163', '3081', '4041', '4016', '1167', '1189', '2229', '3384', '3383', '677', '3080', '2849', '2895', '3985', '4128', '2894', '2424', '2425', '2423', '3616', '3620', '3619', '1942', '776', '3990', '4045', '1941', '2893', '4286', '4288', '4290', '3779', '3623', '3612', '3624', '4339', '4340', '4388', '4390', '1251', '3661', '4401', '4402', '4403', '4404', '4405', '4407', '4408', '4412', '4414', '4126', '3873', '4137', '4136', '4138', '3607', '4135', '3027', '3984', '3076', '3082', '2432', '4418', '4129', '2358', '2363', '3755', '2361', '2357', '1711', '1710', '2441', '1713', '1718', '2439', '1026', '2443', '900', '696', '777', '866', '902', '2437', '1717', '1025', '3610', '3614', '3615', '3617', '3621', '3622', '3625', '4139', '4437', '4400', '4462', '4482', '4485', '4486', '4393', '4545', '4459', '3605', '1538', '3904', '2436', '697', '40', '4566', '4567', '4487', '2827', '1657', '3606', '4631', '4464', '4287', '4133', '3837', '3346', '1544', '1545', '4443', '509', '220', '1543', '4644', '4645', '4116', '3386', '4466', '3659', '3391', '4385', '1715', '7', '4389', '2409', '3050', '2434', '901', '2433', '1716', '1709', '4435', '4406', '3061', '625', '3719', '3780', '4643', '4668', '4671', '4562', '3906', '3790', '312', '3070', '1542', '4386', '4546', '4391', '4281', '4117', '4460', '1943', '3814', '4461', '4392', '3907', '8', '17', '1445', '508', '4134', '4387', '2356', '2354', '2364', '2440', '2435', '38', '2946', '4446', '3611', '3618', '4', '3382', '3362', '4127', '4483', '4484', '157', '158', '159', '160', '161', '162', '163', '165', '166', '168', '169', '170', '171', '172', '173', '174', '175', '176', '177', '178', '180', '181', '182', '183', '184', '185', '186', '187', '188', '189', '190', '191', '192', '193', '194', '195', '196', '197', '198', '199', '200', '201', '203', '205', '206', '208', '209', '210', '211', '212', '213', '214', '215', '218', '270', '271', '272', '273', '277', '278', '279', '282', '283', '285', '290', '293', '294', '295', '296', '299', '300', '301', '302', '355', '356', '357', '358', '359', '363', '365', '366', '374', '375', '380', '381', '382', '383', '389', '542', '544', '550', '553', '554', '555', '561', '565', '566', '650', '652', '653', '654', '701', '702', '713', '714', '715', '745', '746', '765', '809', '810', '811', '813', '814', '816', '850', '860', '861', '862', '867', '870', '871', '872', '873', '876', '877', '882', '884', '887', '888', '895', '896', '915', '916', '917', '918', '920', '921', '927', '929', '933', '935', '951', '954', '964', '965', '966', '967', '977', '978', '995', '1000', '1001', '1002', '1010', '1017', '1018', '1019', '1024', '1031', '1032', '1035', '1036', '1043', '1050', '1052', '1053', '1056', '1063', '1075', '1081', '1088', '1104', '1108', '1126', '1148', '1157', '1162', '1164', '1171', '1172', '1178', '1181', '1198', '1204', '1217', '1233', '1244', '1263', '1269', '1273', '1277', '1278', '1289', '1296', '1303', '1309', '1319', '1328', '1336', '1342', '1377', '1378', '1380', '1397', '1401', '1420', '1421', '1426', '1431', '1432', '1436', '1437', '1439', '1443', '1444', '1453', '1506', '1508', '1516', '1517', '1535', '1539', '1560', '1585', '1601', '1602', '1603', '1609', '1619', '1622', '1624', '1625', '1626', '1630', '1650', '1652', '1653', '1654', '1665', '1674', '1687', '1694', '1695', '1703', '1720', '1721', '1728', '1731', '1739', '1747', '1762', '1763', '1771', '1778', '1779', '1781', '1784', '1786', '1791', '1805', '1806', '1808', '1809', '1814', '1815', '1816', '1825', '1827', '1832', '1837', '1847', '1848', '1854', '1869', '1871', '1872', '1879', '1880', '1890', '1758', '1897', '1766', '1919', '1928', '1930', '1932', '1956', '1961', '1970', '1975', '1996', '2008', '2019', '2021', '2054', '2066', '2078', '2092', '2093', '2096', '2105', '2106', '2127', '1870', '1881', '2149', '2150', '2152', '2153', '1883', '2162', '2166', '2179', '2192', '2193', '2203', '2207', '2208', '2211', '2223', '2228', '2235', '2236', '2261', '2262', '2263', '1933', '274', '275', '276', '851', '2009', '2024', '2025', '2026', '2210', '1304', '1305', '1586', '698', '1510', '1287', '651', '364', '286', '288', '1600', '2113', '2168', '852', '1270', '291', '1952', '1947', '1410', '1574', '281', '2040', '1127', '1192', '1041', '2036', '2116', '886', '2041', '1878', '1398', '1782', '1660', '2056', '1867', '1525', '1690', '1759', '360', '1334', '2205', '1520', '1519', '1399', '1438', '164', '1811', '2146', '1783', '2520', '2526', '2532', '2550', '2589', '2592', '2593', '2594', '2605', '2610', '2613', '1664', '2633', '2655', '2693', '2696', '2714', '2719', '2742', '284', '2103', '1033', '1059', '2820', '2844', '2860', '2861', '2862', '2525', '2905', '2926', '2053', '2022', '2940', '2950', '2951', '2962', '2778', '1826', '1109', '3014', '2823', '2507', '1382', '2185', '3033', '3034', '3035', '3051', '3054', '3055', '2786', '3097', '3098', '3099', '3100', '3101', '2011', '2014', '2809', '1767', '812', '1006', '3148', '3149', '1973', '1646', '2822', '3032', '3030', '3322', '3324', '3326', '3328', '3336', '1885', '3053', '2892', '2148', '2882', '2023', '2947', '2879', '2881', '3025', '3374', '2776', '3333', '2523', '3314', '3319', '3325', '3323', '3313', '3321', '2925', '3320', '2519', '3310', '3312', '3306', '2521', '2924', '2522', '2518', '3327', '3057', '2701', '3396', '3431', '3432', '3433', '3434', '3435', '3430', '3457', '3464', '3465', '3466', '3467', '2777', '3486', '3337', '2979', '919', '928', '3526', '3516', '3522', '3528', '3517', '3531', '3540', '3585', '3586', '3588', '3590', '3591', '3589', '3592', '3594', '2978', '2692', '2064', '2939', '3150', '846', '3316', '3335', '3309', '2057', '1813', '1968', '3543', '167', '3147', '2673', '2779', '3311', '2856', '1639', '944', '2759', '560', '3570', '3683', '3684', '2691', '2694', '2697', '3052', '3056', '3695', '2202', '2209', '179', '2204', '1981', '354', '2948', '2878', '3376', '2949', '3373', '3375', '2952', '1668', '2875', '2874', '3453', '3739', '3308', '934', '3334', '2527', '3307', '3317', '1900', '1954', '2102', '3315', '2524', '3329', '3760', '3761', '3762', '2672', '3771', '3772', '3602', '3398', '3397', '744', '2213', '3331', '1833', '2780', '3728', '2555', '1792', '2112', '2740', '3840', '973', '3846', '1252', '1812', '1993', '1797', '1798', '1796', '2980', '2981', '3699', '3700', '3701', '3704', '3703', '3756', '717', '3571', '3880', '1675', '3650', '3896', '2858', '3649', '3694', '2644', '2711', '3898', '3917', '3918', '3648', '3657', '2067', '2079', '2789', '1828', '3832', '3833', '3036', '3860', '2819', '3861', '2821', '2700', '2698', '3778', '2577', '1568', '2708', '2857', '2160', '4004', '4005', '4006', '3921', '4029', '3711', '3708', '4036', '2808', '3712', '3706', '3713', '3702', '3031', '3707', '3710', '3715', '3714', '3709', '3705', '3698', '3757', '2158', '3881', '156', '3685', '1829', '3693', '2240', '4064', '2653', '3741', '3395', '564', '3770', '2189', '4073', '4074', '4076', '4077', '4078', '4079', '4080', '4075', '4081', '4082', '4085', '4084', '4083', '4086', '4087', '4088', '4089', '4090', '4091', '4092', '4093', '3641', '3935', '2187', '3766', '543', '1995', '2715', '2654', '2652', '3879', '2710', '4099', '4100', '4101', '4102', '4103', '4104', '4105', '4106', '4107', '4108', '4109', '4110', '1219', '2646', '3094', '3916', '3087', '1729', '3994', '3688', '3668', '3596', '2073', '2531', '3361', '4144', '3919', '2101', '3360', '3000', '2880', '3532', '367', '3088', '207', '3767', '1584', '3427', '3853', '2810', '3689', '3089', '1440', '2943', '2781', '3769', '2720', '4191', '3851', '3996', '4188', '4193', '4268', '4272', '4273', '4274', '4275', '4276', '2233', '4314', '4349', '4353', '4354', '4355', '4356', '4357', '4358', '4368', '4369', '4370', '4371', '4372', '4374', '219', '1249', '2859', '3426', '3425', '3735', '3673', '3597', '3718', '552', '2642', '2645', '1901', '3332', '1770', '2561', '3636', '3920', '3533', '547', '3738', '1016', '3539', '3441', '1147', '1356', '216', '3934', '2954', '2033', '2031', '202', '2718', '1861', '4436', '4477', '3733', '548', '3732', '2773', '289', '2775', '716', '549', '2774', '546', '292', '545', '287', '2695', '297', '2476', '4492', '4493', '4494', '4495', '4498', '4499', '4500', '4501', '4502', '4503', '3721', '4350', '1846', '987', '3541', '2804', '2803', '1327', '869', '1326', '2807', '2802', '2805', '2806', '2885', '1736', '4557', '4558', '4559', '1094', '3736', '3734', '3731', '4065', '4269', '4352', '3821', '4376', '2772', '2712', '1064', '2713', '1955', '1068', '4425', '2034', '2145', '4194', '3836', '4569', '4570', '4571', '4573', '4577', '4067', '3723', '4442', '2089', '4351', '4574', '3663', '3768', '563', '3936', '4594', '4595', '4575', '4378', '4609', '4612', '1395', '4615', '1231', '2595', '1065', '2020', '3724', '3740', '2716', '2151', '4373', '4627', '4632', '4377', '4419', '4348', '217', '4614', '2749', '4367', '3922', '4365', '1114', '4189', '2699', '2717', '3722', '4347', '4496', '4504', '3815', '1909', '3102', '204', '1886', '4361', '4360', '4359', '4362', '4363', '2559', '3716', '2709', '4271', '4270', '1889', '1051', '4620', '4120', '1896', '2080', '2165', '2115', '4657', '4658', '3662', '3717', '3995', '4121', '2188', '4572', '4618', '4628', '1371', '4313', '1288', '2748', '4497', '1276', '1335', '2562', '4366', '4670', '2960', '3359', '4576', '4379', '4634', '4633', '4635', '4450', '3388', '353', '2999', '3151', '3422', '1316', '298', '3817', '3816', '3759', '1838', '2254', '4062', '3687', '3993', '4641', '1673', '2677', '3358', '3847', '2843', '3672', '3671', '1565', '1216', '1061', '2961', '1994', '3305', '2118', '1917', '2083', '2959', '2799', '551', '1095', '2743', '2643', '4364', '4190', '1062', '280', '4380', '3330', '3318', '2998', '2866', '4375', '3', '24', '25', '26', '27', '28', '31', '32', '37', '394', '398', '399', '400', '408', '410', '413', '414', '415', '416', '511', '567', '646', '671', '672', '722', '786', '788', '993', '1042', '1070', '1177', '1183', '1185', '1186', '1209', '1254', '1274', '1275', '1293', '1300', '1310', '1320', '1372', '1373', '1411', '1447', '1499', '1648', '1800', '1801', '1802', '2264', '2266', '1629', '2154', '2156', '2155', '1015', '1099', '1321', '1931', '1780', '1929', '1927', '1893', '330', '1850', '1923', '2273', '2449', '2570', '2573', '2581', '2582', '2669', '3039', '3073', '3075', '3366', '2891', '3555', '3638', '2584', '2586', '2038', '3403', '3399', '3553', '2574', '2111', '2668', '2664', '23', '1208', '3040', '3042', '2877', '3041', '2530', '2853', '2122', '3744', '3764', '2045', '3791', '2536', '2575', '2576', '3822', '3074', '994', '3823', '3824', '2197', '2572', '3825', '3826', '3827', '3828', '1100', '1504', '3831', '3843', '3844', '3845', '2195', '3849', '3552', '401', '3888', '1090', '854', '3554', '2196', '1434', '3564', '2670', '3842', '2942', '3628', '3626', '2852', '3627', '568', '2044', '3794', '3892', '3980', '2890', '397', '396', '1851', '2887', '1184', '1247', '33', '1541', '404', '3795', '2535', '3793', '3792', '2039', '2927', '4056', '34', '2911', '2446', '411', '4057', '4055', '1029', '2585', '409', '1318', '2667', '3998', '36', '2662', '2448', '3878', '4184', '4185', '4186', '4187', '2368', '673', '2587', '1182', '1769', '412', '2889', '407', '2583', '2590', '4181', '4182', '4183', '4244', '4242', '4233', '4235', '4237', '2447', '4241', '4250', '4240', '4239', '4234', '4238', '4245', '4236', '4247', '4243', '4261', '4177', '3639', '4180', '4381', '3640', '3015', '3858', '3982', '3981', '856', '3850', '1014', '403', '402', '569', '2214', '1649', '1341', '2164', '2663', '3629', '3725', '4430', '4249', '4478', '4480', '4248', '4505', '4518', '4520', '4521', '4522', '4523', '4524', '4526', '853', '855', '2922', '4251', '4252', '4256', '3551', '405', '4253', '4254', '406', '35', '4604', '4605', '4582', '4179', '4506', '4384', '4255', '4246', '2666', '723', '1241', '1077', '721', '30', '4467', '4622', '1337', '4525', '4507', '2369', '4479', '4481', '3072', '3841', '3018', '3071', '4519', '952', '1199', '787', '906', '512', '4560', '513', '1351', '1240', '1374', '29', '4383', '4382', '1', '315', '316', '317', '321', '324', '325', '362', '368', '369', '372', '373', '376', '377', '378', '379', '384', '385', '388', '390', '391', '392', '393', '506', '558', '562', '667', '669', '670', '791', '793', '822', '857', '863', '864', '878', '892', '950', '957', '998', '999', '1057', '1080', '1118', '1140', '1268', '1286', '1330', '1359', '1353', '1394', '1417', '1418', '1425', '1441', '1449', '1464', '1468', '1502', '1503', '1512', '1623', '1693', '1696', '1706', '1735', '1793', '1726', '1874', '1875', '1958', '1967', '1977', '2042', '2061', '2159', '2232', '1920', '1921', '1055', '1245', '2071', '1669', '1450', '2138', '2075', '2076', '1620', '1965', '386', '2062', '2099', '1253', '2098', '792', '668', '1159', '2137', '2100', '2052', '2401', '1997', '2329', '2384', '2385', '2427', '2487', '2501', '2528', '2588', '2784', '2785', '2851', '2955', '2956', '2958', '2035', '3037', '1810', '370', '2771', '2077', '3342', '3343', '2472', '2453', '1946', '371', '3429', '3437', '3438', '3439', '3440', '3442', '3443', '3445', '3446', '3463', '3469', '3470', '3471', '3472', '2624', '3481', '3482', '3483', '3484', '3485', '2241', '3560', '3436', '3652', '2452', '2876', '2687', '3013', '2486', '2328', '2649', '2650', '3496', '2953', '3561', '2114', '3798', '3799', '3501', '3494', '3562', '3871', '3876', '2791', '3887', '1283', '3642', '3927', '3928', '328', '2945', '3872', '3868', '3870', '3869', '1446', '3820', '559', '327', '3385', '3012', '4012', '4013', '4014', '2306', '2307', '2304', '2382', '3696', '4037', '2489', '3387', '4048', '4049', '1137', '3509', '1143', '1633', '992', '2305', '2303', '3923', '3929', '4069', '4070', '4071', '4072', '4044', '326', '319', '1082', '2936', '3500', '3011', '2327', '4011', '2990', '4132', '3882', '3852', '3883', '320', '3083', '4010', '2469', '2470', '4028', '2529', '4007', '4025', '991', '4206', '4205', '4221', '4124', '2508', '4335', '4336', '3729', '2383', '4131', '2558', '2471', '3884', '557', '2787', '4424', '4429', '4432', '2707', '4465', '4470', '4471', '4472', '4475', '4423', '4026', '1677', '3890', '4565', '4098', '4431', '4473', '4593', '3379', '3819', '3378', '387', '4130', '4625', '838', '4568', '4223', '4222', '3758', '4636', '4637', '2386', '4606', '4027', '2824', '323', '4141', '4008', '4009', '4650', '4651', '4652', '4653', '4654', '4655', '4656', '4659', '4428', '2488', '4476', '3747', '318', '4624', '1507', '1678', '4433', '4579', '4646', '3926', '4613', '1005', '1719', '4607', '4610', '1676', '3781', '3834', '2651', '3447', '2870', '314', '322', '2813', '2788', '3559', '4474', '305', '307', '308', '309', '310', '311', '556', '945', '1069', '1078', '1084', '1239', '1528', '1634', '1689', '1986', '1988', '1989', '1823', '2086', '2104', '2123', '2178', '2246', '1990', '2239', '1987', '1200', '718', '1524', '2043', '1551', '1161', '2766', '2611', '2688', '2944', '2690', '3029', '2928', '1155', '3371', '3372', '3495', '3498', '3549', '3544', '3546', '3550', '3565', '3566', '3567', '1611', '2125', '2639', '1612', '2206', '2119', '2537', '3692', '2194', '3421', '3492', '3499', '3545', '1613', '3784', '3505', '2629', '1238', '3578', '3774', '3773', '3775', '3493', '2689', '1552', '3502', '3777', '4096', '4097', '3369', '3897', '3776', '2640', '2765', '3829', '4259', '3370', '3367', '3368', '4535', '3746', '3608', '303', '705', '706', '707', '1628', '4580', '2028', '2224', '1550', '4581', '304', '306', '139', '140', '141', '142', '143', '144', '145', '146', '147', '148', '149', '150', '151', '152', '153', '154', '155', '708', '709', '710', '712', '750', '751', '752', '753', '754', '808', '823', '824', '844', '879', '938', '939', '940', '986', '1213', '1271', '1306', '1307', '1308', '1406', '1407', '1408', '1589', '1824', '2065', '2087', '2175', '2199', '1272', '2201', '1705', '1894', '2063', '2466', '2398', '2399', '2400', '2406', '2408', '1992', '2342', '2371', '2372', '2376', '2378', '2379', '2380', '3117', '3123', '3125', '3126', '3127', '3131', '3132', '3133', '3134', '3142', '3143', '3146', '3138', '3137', '3136', '2349', '2346', '3130', '2340', '2392', '3144', '2974', '2975', '3523', '3120', '2478', '2393', '3004', '2395', '2394', '2396', '3140', '3129', '2348', '2343', '2347', '1027', '2317', '2314', '2377', '2370', '2375', '2374', '2373', '2001', '3145', '2484', '2467', '2483', '1895', '3345', '3008', '3049', '837', '2976', '2345', '2344', '908', '2797', '3742', '1060', '3118', '2200', '2341', '3122', '2060', '3121', '3128', '2407', '3135', '3119', '2326', '2397', '3139', '4226', '4224', '4212', '4214', '4211', '4213', '4216', '4215', '4329', '4330', '4331', '4334', '3141', '711', '3752', '3753', '3751', '2339', '2389', '4030', '2391', '2468', '2059', '4527', '4528', '4529', '4531', '4532', '4533', '4534', '4210', '4209', '4033', '4530', '2977', '3124', '3116', '4327', '4332', '4328', '4333', '4626', '4032', '4225', '2405', '3818', '4031', '875', '881', '941', '942', '943', '974', '980', '981', '1004', '1120', '1121', '1151', '1279', '1280', '1384', '1385', '1389', '1390', '1392', '1515', '1523', '1548', '1557', '1606', '1614', '1615', '1645', '1647', '1681', '1745', '1746', '1749', '1752', '1998', '2058', '268', '269', '663', '664', '665', '666', '764', '2029', '2147', '1266', '1381', '1044', '1391', '1685', '1386', '1588', '1587', '1003', '2000', '1547', '1682', '1683', '874', '2212', '1225', '968', '1743', '848', '1644', '1631', '1740', '2242', '1751', '1750', '1753', '1534', '953', '2845', '2864', '3009', '3010', '3028', '1910', '3181', '3183', '3184', '3185', '3186', '3189', '3199', '3201', '3204', '3205', '3206', '3210', '3212', '3213', '3214', '3215', '3218', '3220', '3221', '3228', '3230', '3231', '3240', '3241', '3242', '1261', '265', '3456', '3563', '1744', '2184', '1999', '1849', '3236', '1424', '1387', '1365', '2088', '1556', '3229', '3233', '3224', '3208', '3198', '1388', '1079', '3239', '3190', '1680', '1122', '3182', '1165', '1281', '3697', '3244', '3192', '3235', '1607', '3237', '1264', '3344', '3232', '3216', '3211', '3188', '2243', '1202', '3785', '3786', '3797', '3800', '3801', '3783', '3803', '890', '3838', '975', '3203', '1742', '3787', '1876', '1045', '3243', '3250', '1748', '3802', '1922', '4034', '3200', '1549', '3179', '3219', '3891', '3207', '3839', '4068', '3217', '4167', '4168', '4169', '4170', '4171', '4172', '4173', '4174', '4175', '4176', '2186', '3238', '1106', '3914', '2217', '3223', '3225', '3226', '3227', '3222', '3459', '3187', '3193', '3196', '3194', '3197', '3195', '3191', '3937', '1265', '1608', '4561', '4578', '4599', '3234', '3667', '3202', '3180', '3209', '4517', '1037', '1400', '4591', '266', '858', '859', '1158', '1903', '254', '255', '256', '257', '259', '261', '262', '263', '267', '534', '535', '536', '537', '538', '539', '540', '541', '260', '264', '258', '1566', '1514', '3068', '3247', '3249', '3257', '3261', '3267', '3268', '3269', '3270', '3271', '3272', '3273', '3274', '3275', '3276', '3277', '3278', '3279', '3280', '3282', '3283', '3284', '3285', '3286', '3287', '3288', '3289', '3290', '3291', '3292', '3293', '3294', '3295', '3297', '3298', '3299', '3300', '3301', '3302', '3251', '3064', '3404', '3405', '3407', '3408', '3409', '3410', '3411', '3412', '3413', '3414', '3415', '3416', '3417', '3418', '3419', '3420', '3458', '3645', '847', '3296', '3357', '3265', '1884', '3349', '3348', '3263', '3782', '3066', '3854', '3855', '3253', '3252', '3260', '3406', '3462', '3262', '3962', '3964', '3965', '3970', '3971', '3972', '3973', '3974', '3975', '3976', '3977', '3968', '3969', '3967', '4094', '3248', '3979', '3978', '3963', '4125', '3264', '4150', '4151', '4152', '4153', '4154', '4156', '4157', '4158', '4159', '4160', '4162', '4165', '4149', '4161', '4164', '4163', '4147', '4146', '4292', '4315', '4142', '4143', '3254', '3067', '3065', '3258', '3256', '3255', '3259', '3246', '3989', '3281', '3347', '4145', '3266', '2817', '2609', '4155', '3354', '3245', '4602', '4603', '4621', '3353', '3356', '3350', '3352', '3355', '3351', '3603', '4166', '50', '76', '77', '79', '80', '81', '82', '83', '84', '85', '87', '88', '89', '92', '93', '101', '105', '106', '112', '115', '117', '121', '123', '125', '126', '127', '128', '132', '135', '228', '237', '241', '242', '329', '335', '337', '338', '341', '342', '361', '436', '437', '438', '439', '441', '442', '452', '453', '454', '455', '456', '457', '464', '465', '466', '467', '468', '470', '472', '473', '474', '477', '478', '479', '480', '481', '482', '520', '521', '523', '524', '525', '526', '527', '573', '576', '638', '641', '642', '645', '681', '700', '724', '727', '728', '729', '730', '732', '762', '766', '773', '799', '800', '801', '802', '803', '804', '831', '832', '842', '845', '849', '909', '946', '948', '959', '961', '982', '989', '990', '1022', '1039', '1049', '1074', '1085', '1093', '1111', '1125', '1129', '1134', '1153', '1163', '1190', '1211', '1221', '1222', '1229', '1230', '1234', '1257', '1040', '1292', '1313', '1338', '1343', '1346', '1349', '1350', '1344', '1345', '1355', '1412', '1413', '1414', '1427', '1433', '1442', '1459', '1491', '1492', '1493', '1495', '1513', '1521', '1530', '1531', '1532', '1555', '1569', '1592', '1594', '1596', '1597', '1599', '1604', '1642', '1651', '1662', '1667', '1671', '1723', '1757', '1760', '1764', '1822', '1840', '1841', '1853', '1855', '1860', '1863', '1864', '1908', '1938', '1951', '2002', '2003', '2004', '2005', '2110', '2134', '2141', '2244', '2245', '2256', '2258', '2260', '2265', '817', '1482', '1480', '1481', '1479', '1591', '1154', '1339', '2143', '2142', '1428', '931', '805', '119', '244', '86', '238', '243', '78', '1170', '111', '962', '239', '235', '2117', '1243', '440', '134', '1262', '2131', '843', '2230', '1354', '2231', '1496', '1452', '1727', '682', '138', '529', '731', '897', '1790', '443', '349', '352', '1765', '1902', '574', '2388', '2293', '2294', '2381', '2500', '2502', '2503', '2504', '2505', '2512', '2598', '2678', '2686', '2702', '2732', '2736', '2737', '2752', '113', '351', '2968', '1807', '2733', '2292', '2295', '3043', '3058', '1868', '1839', '1007', '963', '2735', '2130', '2133', '2967', '2534', '2983', '2957', '1290', '3392', '3461', '2533', '2965', '3478', '2387', '2973', '2513', '3518', '2284', '2933', '3656', '2282', '2278', '2283', '2547', '2279', '1936', '1102', '2132', '2288', '2289', '2734', '3393', '2850', '114', '2721', '2884', '2563', '1892', '2140', '3681', '3682', '2599', '1865', '2932', '2931', '2930', '2929', '2934', '1073', '1733', '2319', '2964', '2684', '2683', '1643', '1416', '680', '2280', '2281', '2745', '2290', '725', '1471', '1461', '2218', '4017', '4018', '4020', '4021', '4022', '4023', '4024', '3991', '818', '4039', '2966', '4122', '2941', '3096', '1679', '3601', '3527', '3460', '1329', '2731', '2682', '4140', '1291', '2886', '3480', '2986', '94', '530', '2007', '4019', '2421', '2420', '2417', '2509', '2414', '100', '103', '3548', '2834', '2854', '575', '447', '1312', '446', '449', '448', '4192', '4195', '4198', '4207', '4208', '4265', '3024', '3095', '4297', '4299', '2277', '2418', '4341', '4342', '97', '4346', '2331', '2608', '2511', '2963', '1866', '4123', '1460', '1494', '1470', '1451', '1734', '922', '129', '820', '124', '133', '2081', '130', '1258', '2419', '2416', '2413', '2829', '1527', '95', '806', '99', '96', '1509', '1028', '1692', '98', '102', '528', '108', '116', '936', '735', '868', '2723', '4455', '2835', '4196', '4515', '2415', '2318', '2987', '4469', '4199', '4197', '4417', '4201', '4202', '4200', '2730', '2747', '4587', '4589', '4590', '120', '2830', '107', '2016', '4468', '1937', '2412', '4512', '2320', '2762', '4298', '4294', '1925', '3479', '955', '346', '4585', '2330', '4588', '350', '2746', '2744', '4586', '2321', '2984', '2169', '1294', '4296', '2139', '2738', '733', '4293', '2017', '4345', '2560', '131', '4291', '90', '734', '4343', '2422', '1598', '3303', '3424', '2728', '3304', '4295', '4516', '2988', '3454', '1138', '2680', '122', '110', '109', '104', '2157', '2430', '2490', '2506', '2818', '2597', '2606', '1621', '234', '236', '469', '1957', '949', '1891', '1488', '1486', '1473', '1593', '1964', '1133', '1842', '647', '2909', '2921', '2219', '2833', '2831', '3044', '3091', '932', '3176', '983', '758', '763', '1124', '2908', '2910', '3338', '2299', '2301', '2920', '2918', '2902', '3174', '1107', '1128', '2770', '3568', '3569', '3630', '3631', '1013', '1422', '2840', '3451', '3452', '2832', '2919', '2177', '2499', '2607', '1522', '2750', '1415', '2173', '2172', '2174', '471', '1907', '2300', '2302', '3529', '463', '1976', '1722', '1852', '1409', '2491', '2907', '2906', '2917', '1483', '1467', '2497', '1487', '1485', '761', '2549', '2912', '348', '1610', '1484', '1462', '3913', '3911', '3910', '3930', '3932', '3653', '3953', '3956', '3957', '3958', '3959', '3960', '3524', '3931', '3604', '3669', '830', '2496', '4000', '4002', '4003', '1803', '2863', '2074', '3859', '4035', '4053', '4054', '4001', '1331', '2366', '461', '3178', '230', '3862', '3863', '2234', '1267', '3999', '841', '3748', '231', '3172', '2751', '1237', '1905', '979', '2914', '3177', '1131', '910', '2812', '240', '3632', '1210', '2493', '1098', '451', '450', '4262', '4267', '4266', '4289', '2724', '3173', '4302', '4301', '4303', '4304', '4305', '4306', '4307', '3912', '3633', '4312', '347', '2359', '4337', '4394', '4395', '4396', '3634', '136', '137', '3988', '1175', '1117', '2498', '1235', '3961', '232', '2916', '1472', '1297', '4422', '4416', '522', '4536', '4537', '4538', '4539', '4540', '4547', '4548', '4549', '4550', '4551', '4553', '2546', '1086', '2270', '1367', '1888', '4617', '1831', '4629', '4630', '1176', '4449', '1887', '1546', '3175', '2628', '4447', '2297', '60', '3525', '2783', '1948', '2269', '2271', '1730', '4552', '2725', '462', '2221', '3877', '4563', '4555', '1193', '3885', '4441', '1918', '1959', '4648', '4647', '460', '4257', '3856', '4673', '4438', '2722', '2548', '229', '4300', '797', '2782', '4554', '4445', '2298', '458', '459', '233', '1207', '2769', '3987', '41', '42', '44', '48', '61', '73', '74', '223', '245', '339', '340', '343', '344', '345', '514', '515', '516', '517', '679', '774', '794', '833', '834', '840', '883', '889', '907', '923', '926', '956', '1012', '1030', '1116', '1152', '1156', '1169', '1174', '1179', '1180', '1302', '1616', '1617', '1661', '1700', '1701', '1702', '1707', '1708', '1755', '1785', '1819', '1835', '1926', '2006', '2018', '2037', '2085', '2250', '2251', '2252', '2050', '336', '1857', '1858', '1859', '1364', '1576', '1314', '924', '2090', '1315', '2226', '2121', '518', '2107', '1991', '2404', '2402', '2403', '2108', '49', '2350', '2510', '2638', '2657', '2659', '2661', '2727', '2729', '2869', '2871', '2883', '2903', '2904', '2923', '893', '2841', '1301', '2842', '969', '2541', '1430', '1590', '1579', '1553', '2216', '2867', '1429', '1360', '3488', '3489', '3491', '2685', '3515', '2351', '2352', '2838', '2756', '1817', '2360', '2596', '2603', '2660', '2656', '2658', '3340', '3341', '3339', '1419', '2225', '3903', '3899', '3938', '3939', '3941', '3942', '3943', '3944', '3945', '3946', '3947', '3948', '3949', '3950', '3951', '3952', '3955', '2411', '1518', '3547', '4058', '4059', '4060', '4061', '2992', '1732', '2636', '2635', '4115', '2332', '2333', '2276', '3476', '3902', '2410', '2275', '2601', '1362', '2625', '4114', '3474', '2334', '1537', '3658', '3490', '3901', '2355', '45', '2161', '4421', '1818', '4509', '572', '2753', '1820', '1737', '4420', '4608', '3394', '2755', '4513', '2335', '1754', '2991', '4611', '4326', '3940', '4514', '4649', '4511', '4508', '4642', '2637', '3487', '3475', '4203', '4204', '3900', '2336', '2337', '4063', '4667', '4669', '4112', '4325', '4444', '4113', '4324', '2600', '4111', '3423', '2274', '4510', '4584', '1393', '1570', '4623', '3477', '4434', '2602', '3521', '4583', '4119', '2754', '62', '91', '246', '247', '248', '249', '250', '251', '252', '253', '444', '445', '483', '484', '485', '487', '488', '491', '493', '499', '501', '502', '505', '531', '532', '533', '577', '583', '584', '586', '587', '588', '589', '590', '591', '592', '593', '594', '595', '596', '597', '598', '600', '601', '603', '605', '606', '607', '608', '609', '610', '611', '612', '613', '615', '616', '617', '618', '619', '620', '621', '622', '639', '640', '643', '644', '655', '684', '686', '692', '695', '737', '739', '740', '742', '743', '767', '769', '770', '771', '772', '779', '781', '783', '784', '790', '829', '880', '891', '894', '911', '930', '947', '958', '971', '972', '996', '1011', '1021', '1038', '1054', '1072', '1097', '1110', '1119', '1135', '1136', '1145', '1146', '1168', '1188', '1194', '1195', '1196', '1201', '1227', '1232', '1236', '1260', '1295', '1317', '1323', '1324', '1348', '1357', '1358', '1347', '1368', '1369', '1370', '1376', '1379', '1396', '1402', '1403', '1435', '1448', '1454', '1466', '1475', '1476', '1526', '1573', '1582', '1627', '1636', '1637', '1641', '1663', '1684', '1697', '1724', '1725', '1773', '1794', '1830', '1877', '1906', '1960', '1962', '2013', '2120', '2183', '2248', '2255', '2259', '1698', '2220', '1242', '2082', '1924', '1949', '2030', '2068', '1756', '736', '486', '1187', '1982', '585', '497', '1325', '1845', '2048', '1144', '1691', '2481', '2482', '602', '2272', '2316', '2451', '2457', '2475', '2580', '1972', '2899', '2913', '2972', '2989', '2996', '3047', '3060', '2480', '1020', '1635', '2055', '1465', '3110', '3111', '3112', '1458', '3381', '3046', '2445', '2353', '2848', '3519', '3530', '3574', '3600', '3558', '3556', '3572', '3573', '3577', '3587', '3655', '1844', '1322', '985', '2296', '1478', '3007', '3675', '3676', '738', '2760', '2795', '3660', '2796', '2994', '3680', '494', '2291', '2836', '2429', '490', '1191', '1670', '489', '914', '1058', '1490', '2128', '1489', '1474', '3045', '2495', '2129', '2846', '2463', '504', '2458', '2465', '492', '2900', '2473', '2474', '2993', '2897', '3805', '2557', '3023', '3575', '3557', '2997', '1882', '1250', '3789', '2937', '690', '3021', '1559', '3865', '3866', '2898', '2556', '1023', '3806', '3808', '3864', '3576', '2826', '3678', '3048', '2444', '1149', '3107', '2015', '3106', '3677', '1571', '2170', '3691', '685', '1558', '2492', '2938', '687', '2763', '604', '1141', '1101', '2494', '1206', '3812', '1477', '1463', '3448', '3886', '4264', '997', '782', '3908', '4317', '2648', '4321', '4322', '4323', '4338', '4397', '1173', '3804', '2768', '2249', '2072', '3022', '1899', '3006', '3754', '2995', '970', '2365', '3690', '3637', '503', '500', '3813', '1774', '3059', '1469', '1843', '1457', '1455', '3909', '1456', '3001', '2896', '2462', '689', '614', '1197', '498', '1638', '2047', '4439', '4440', '4318', '4453', '4454', '4463', '3811', '3810', '2485', '3002', '495', '1605', '688', '1775', '496', '778', '3674', '4556', '2647', '3514', '2126', '2454', '691', '785', '4597', '4596', '4598', '4616', '4619', '2171', '3889', '2767', '741', '1067', '4452', '3644', '3763', '1776', '3809', '4316', '2450', '913', '2675', '1971', '2257', '3108', '4415', '3109', '3654', '3686', '2167', '3737', '988', '4665', '4666', '4448', '2764', '3788', '2247', '1686', '3598', '3670', '3743', '3520', '4674', '3986', '4319', '2027', '4672', '821', '4320', '3599', '3647', '1150', '1087', '694', '1511', '3807', '2459', '2460', '683', '1505', '693', '2461', '599') WHERE 1=1 AND idx.itemID=idx2.itemID AND idx.itemKey=idx2.itemKey GROUP BY idx.itemID, idx2.indexValue, productID ) as tbl WHERE (productDeleted IS NULL AND productStatus=1 AND parentID IS NULL) GROUP BY itemID, sortval ORDER BY sortval DESC LIMIT 0, 20
[1] SELECT FOUND_ROWS() AS `count`
[20] Using template: /templates/shop/products/list.html
[1] SELECT * FROM perch3_shop_currencies WHERE currencyID=26 LIMIT 1
Request time: 0.0502
Process time: 0.0459
Memory: 2.1042