CLOSED
1054 - Unknown column 's.customers_group_id' in 'where clause'

select count(p.products_model) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id where p.products_id not in(539, 530, 513, 541, 305, 526, 582, 581, 571, 366, 572, 394, 405, 573, 512, 520, 519, 434, 441, 442, 532, 547, 467, 468, 469, 531, 502, 516, 517, 524, 534, 536, 542, 543, 544, 545, 546, 549, 550, 551, 576, 579, 584, 583, 585, 587, 618, 600, 601, 603, 604, 605, 606, 607, 608, 609, 610, 613, 615, 624, 625, 626) and p.products_status = '1' and p.products_id = pd.products_id and pd.language_id = '1' and s.status = '1' and s.customers_group_id = '0'

[TEP STOP]