Error filtering template: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'at_sale.value' in 'where clause', query was: SELECT COUNT(DISTINCT e.entity_id) FROM `catalog_product_flat_2` AS `e` INNER JOIN `catalog_category_product_index_store2` AS `cat_index` ON cat_index.product_id=e.entity_id AND cat_index.store_id=2 AND cat_index.visibility IN(2, 4) AND cat_index.category_id=123 INNER JOIN `catalog_product_index_price` AS `price_index` ON price_index.entity_id = e.entity_id AND price_index.website_id = '1' AND price_index.customer_group_id = 0 INNER JOIN `cataloginventory_stock_status` AS `stock_status_index` ON e.entity_id = stock_status_index.product_id WHERE (e.entity_id IN('3532', '1812', '3593', '3756', '3114', '4291', '909', '666', '4400', '4163', '1283', '3757', '3621', '4500', '1138', '3632', '1803', '3998', '1201', '2495', '3990', '2823', '220', '3779', '3094', '3074', '3764', '310', '3144', '3603', '3093', '3042', '556', '2680', '3061', '2579', '1154', '1891', '2483', '1761', '1261', '3113', '3422', '3457', '3580', '175', '4164', '828', '3436', '406', '2567', '4416', '1125', '4457', '1897', '4142', '3038', '3608', '3403', '3019', '4240', '2515', '73', '4504', '501', '2690', '4263', '1226', '3527', '1068', '3445', '3561', '3636', '1126', '3553', '3556', '4315', '4159', '2830', '2568', '4278', '2682', '3522', '3644', '3443', '2561', '4323', '3616', '1102', '4138', '3528', '3894', '581', '3427', '3560', '3020', '240', '4512', '2486', '1860', '3138', '1852', '3537', '1132', '2693', '2586', '3808', '2467', '3448', '1307', '446', '3021', '3032', '2560', '884', '959', '3594', '4302', '4560', '1333', '300', '4272', '970', '1135', '4268', '4058', '3022', '3050', '3008', '3888', '3557', '1228', '1727', '3428', '1775', '3026', '3988', '3083', '3531', '3597', '4288', '3137', '3623', '3449', '3440', '3162', '1327', '1017', '1723', '3450', '3769', '2546', '626', '4398', '3433', '1318', '2557', '4134', '2519', '3639', '3807', '2555', '1350', '1030', '3033', '3130', '576', '1700', '3549', '3568', '4137', '4004', '1316', '3075', '3800', '4293', '270', '3967', '853', '1776', '783', '3143', '1861', '3524', '3801', '706', '3426', '3941', '3055', '1145', '1691', '18', '2565', '145', '2687', '2516', '1152', '3169', '3587', '3563', '3529', '1176', '2685', '3052', '2822', '1623', '3082', '3590', '1134', '451', '335', '879', '3100', '3591', '1755', '2538', '4226', '3768', '4489', '4233', '3754', '3058', '1000', '2588', '1084', '904', '4231', '3799', '155', '3999', '2468', '803', '1889', '1872', '3129', '4298', '1177', '3446', '2472', '3439', '3544', '185', '985', '3419', '4141', '370', '3148', '4498', '1162', '4430', '731', '4269', '3620', '1432', '3564', '1067', '1726', '4318', '2670', '762', '1704', '1224', '1194', '3525', '3600', '1257', '4260', '3604', '1158', '3627', '461', '1831', '4372', '1880', '2481', '3780', '1014', '3039', '3634', '4251', '4076', '1124', '3097', '125', '3453', '3581', '4175', '345', '2558', '1123', '2826', '2530', '591', '3629', '3053', '3134', '1853', '1814', '3136', '3521', '3084', '3423', '4528', '3547', '486', '1349', '1264', '63', '3420', '3601', '3896', '4026', '4074', '3625', '4266', '1320', '521', '380', '4370', '1073', '813', '3891', '611', '2534', '686', '586', '1608', '4229', '43', '3432', '3520', '3599', '3633', '255', '2571', '4367', '4032', '1255', '200', '3092', '4470', '3824', '1253', '899', '3166', '3458', '3087', '1762', '3085', '1183', '3761', '3932', '1012', '3533', '4345', '3049', '516', '33', '3047', '280', '3078', '3554', '3526', '2551', '4283', '3056', '4451', '4284', '140', '150', '3555', '3809', '3031', '3904', '4140', '1695', '3041', '3051', '3540', '3991', '3459', '3102', '466', '491', '3767', '973', '4301', '3885', '3595', '3017', '848', '2827', '3111', '1140', '2545', '3447', '2384', '53', '793', '3865', '4281', '2518', '4232', '972', '3589', '863', '3534', '355', '3614', '631', '350', '3127', '726', '601', '3615', '4160', '3574', '3909', '3582', '3826', '788', '2385', '4089', '1133', '79', '135', '4054', '596', '1557', '1256', '4424', '3624', '3908', '160', '2580', '1622', '4478', '2487', '3118', '2382', '3939', '476', '3167', '4346', '3610', '4294', '2537', '3845', '245', '1258', '1137', '3076', '3575', '2576', '3145', '205', '1243', '3571', '295', '3541', '4267', '671', '2587', '3048', '1155', '3551', '3576', '4280', '1873', '99', '1108', '3565', '1722', '2564', '2544', '2575', '1431', '4561', '1809', '4287', '1351', '3115', '1813', '1805', '3611', '696', '3813', '68', '4296', '4279', '3778', '1369', '1101', '3107', '616', '3618', '1023', '4022', '4295', '84', '4289', '3168', '4491', '621', '4223', '4023', '4143', '431', '4338', '3766', '2482', '4069', '3157', '3598', '4520', '1289', '3131', '3441', '751', '3062', '3622', '386', '4337', '858', '3140', '260', '3607', '4376', '3029', '1260', '979', '3424', '3043', '1758', '3566', '3128', '1290', '3945', '3030', '995', '3065', '4135', '3117', '1189', '330', '8', '2508', '1233', '3421', '3519', '676', '506', '2566', '3015', '3037', '89', '3164', '1696', '2379', '3096', '2591', '561', '3631', '4456', '1890', '3060', '3402', '315', '4165', '3400', '3542', '230', '4409', '1193', '4249', '3523', '13', '833', '1719', '3820', '3081', '3889', '1438', '4035', '691', '496', '954', '3119', '3158', '2569', '1262', '2669', '170', '4073', '3112', '1859', '119', '3512', '1006', '949', '3781', '919', '4271', '4224', '1022', '4068', '1808', '2520', '2683', '2824', '4461', '195', '3013', '3028', '3153', '3628', '721', '2376', '28', '1227', '711', '3810', '1884', '3451', '4273', '426', '798', '2506', '1759', '3089', '4259', '4401', '2585', '1335', '1321', '4227', '3900', '1754', '3125', '2987', '4225', '3152', '716', '874', '3630', '3976', '3584', '436', '736', '3514', '4173', '3147', '2671', '210', '3073', '365', '3510', '651', '1877', '1703', '3585', '3539', '4402', '3538', '3412', '3626', '3923', '2594', '929', '1326', '4462', '3133', '3110', '3893', '2829', '3018', '2570', '1774', '4049', '3825', '2485', '4230', '4277', '3057', '2645', '4440', '3637', '971', '3516', '3146', '2581', '421', '340', '2377', '4343', '1892', '4393', '3095', '3088', '4543', '3099', '48', '396', '4340', '3063', '4261', '1323', '566', '4460', '3641', '4292', '4300', '3507', '4439', '3989', '511', '701', '3770', '571', '130', '2471', '2686', '3543', '3640', '646', '3592', '3588', '225', '4139', '3535', '3132', '58', '3606', '4252', '3161', '641', '3452', '3159', '481', '3023', '3434', '4443', '3442', '4482', '1692', '944', '3511', '2378', '1037', '3609', '2552', '2578', '3141', '4228', '3572', '3456', '1898', '4067', '3406', '3455', '3995', '4264', '4027', '3504', '3635', '1088', '3163', '3066', '3935', '94', '275', '3974', '3430', '3024', '1690', '3404', '3570', '3009', '3401', '3782', '1146', '1072', '3104', '4562', '3515', '4172', '4329', '3562', '1836', '3596', '526', '1331', '1038', '4265', '3890', '114', '3602', '3121', '531', '2509', '3642', '1712', '2517', '4297', '3429', '2536', '2593', '681', '3405', '2562', '3064', '3550', '3165', '1807', '4436', '4399', '3098', '4275', '2550', '2583', '2574', '3971', '4276', '250', '3643', '3638', '4256', '4364', '536', '4495', '3007', '1715', '3170', '3586', '3567', '3536', '741', '3605', '3124', '3506', '1778', '109', '1254', '746', '1760', '305', '4540', '889', '823', '3503', '4253', '4344', '1733', '1815', '4446', '4341', '190', '4270', '4403', '1858', '3171', '3103', '4003', '3077', '411', '3508', '3578', '3892', '1284', '3150', '3619', '606', '3142', '1103', '1306', '4145', '320', '2825', '914', '1263', '974', '3613', '3530', '3139', '1620', '1065', '1136', '3431', '3518', '3059', '894', '1699', '2563', '3913', '964', '1066', '4556', '1777', '2684', '4447', '3545', '3548', '934', '3014', '4502', '4254', '3509', '3928', '2381', '285', '1265', '23', '3617', '325', '3435', '4553', '2694', '1195', '3579', '1071', '215', '4282', '265', '3151', '3071', '416', '2577', '3160', '4025', '3135', '3558', '456', '990', '3760', '939', '3895', '3086', '3149', '1259', '104', '180', '3079', '3816', '4136', '3569', '2582', '2592', '441', '1883', '1874', '3783', '3552', '1896', '1200', '3010', '3573', '3513', '2484', '4062', '656', '3040', '3409', '3517', '4036', '838', '4024', '4290', '235', '551', '4285', '2380', '165', '3425', '3612', '773', '3577', '1716', '1192', '3583', '546', '869', '541', '1693', '756', '2572', '2928', '1782', '636', '3753', '2554', '778', '843', '3505', '3407', '2553', '3559', '38', '1830', '2383', '391', '1164', '767', '2497', '924', '3054', '290', '1151', '3975', '2584', '3444', '1736', '471', '1732', '4274', '3755', '3546', '375', '2677', '1729', '4262', '661', '3819', '4286', '4304', '4328', '360', '2828', '4536', '1728', '401', '1888')) AND (((at_sale.value = 1) OR (IF(at_special_from_date.value_id > 0, at_special_from_date.value, at_special_from_date_default.value) <= '2023-05-30 23:59:59') AND (((((IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) >= '2023-05-30 00:00:00') OR (IF(at_special_to_date.value_id > 0, at_special_to_date.value, at_special_to_date_default.value) IS null)))))))
Recently Viewed
No recently views items
Clear All
Copyright © 2013-present Tommy's Supply.