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