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