Get Them While They're Hot! Get Them While They're Hot!
 
1054 - Unknown column 'p.products_group_access' in 'where clause'

select count(distinct p.products_id) as total from products p left join products_groups pg on p.products_id = pg.products_id and pg.customers_group_id like '%G%', products_description pd, specials s where p.products_status = '1' and s.products_id = p.products_id and pd.products_id = p.products_id and pd.language_id = '1' and s.status = '1' and p.products_group_access like '%G%'

[TEP STOP]