Our Products

Browse our large assortment of European products!

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

Page 1 of 66

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