1054 - Unknown column 'qpr.quote_products_status' in 'on clause'
select count(distinct p.products_id) as total from promo_office.pc_products p
left join promo_office.pc_products_description pd on ( pd.products_id = p.products_id )
left join promo_office.pc_products_to_categories p2c on ( p2c.products_id = p.products_id )
inner join pcworkplace.pc_products_price_review qpr on ( qpr.products_id = p.products_id and qpr.price_status =1 and qpr.new_porducts_status = '1' and qpr.quote_products_status = '1' )
left outer join reseller_products rp on ( rp.products_id = p.products_id )
left outer join reseller_products_to_categories rp2c on ( rp2c.products_id = p.products_id and rp2c.categories_id = p2c.categories_id)
where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and ( rp.reseller_status = '1' or rp.reseller_status is null) and ( rp2c.status = '1' or rp2c.status is null)