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