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