Exception: Error: Unknown column 'pp.property_id' in 'where clause'
Error No: 1054
select distinct p.*, (select price from pd__product_specials ps where ps.product_id = p.id and ((ps.start_date is null or UNIX_TIMESTAMP(ps.start_date) < UNIX_TIMESTAMP('2025-05-09 14:10:43')) and (ps.end_date is null or UNIX_TIMESTAMP(ps.end_date) > UNIX_TIMESTAMP('2025-05-09 14:10:43'))) order by ps.priority asc, ps.price asc limit 1) as special, (select ROUND(avg(rating), 1) from pd__product_reviews r1 left join pd__products p1 on (r1.product_id = p1.id) where (`p1`.`id` = p.id or `p1`.`master_id` = p.id) and `r1`.`status` = 1) as rating, (select count(*) from pd__product_reviews r2 left join pd__products p2 on (r2.product_id = p2.id) where (`p2`.`id` = p.id or `p2`.`master_id` = p.id) and `r2`.`status` = 1) as reviews from pd__products p where (FIND_IN_SET ('31', p.categories)) and (pp.property_id = '2462') and (p.master_id is null or p.master_id = 0) and (`p`.`is_coin_exchange` <> 1) and (`p`.`is_included` = 0 and `p`.`is_show` = 1) and (`p`.`status` = 1 and `p`.`deleted_at` is null) group by p.id order by p.created_at desc, p.id desc in /www/wwwroot/onlstreet.com/web/system/library/db/mysqli.php on line 43