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