Get Them While They're Hot!
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(663, 539, 530, 513, 541, 629, 505, 582, 581, 571, 572, 664, 405, 573, 512, 520, 519, 661, 532, 467, 655, 531, 502, 516, 524, 536, 542, 543, 544, 545, 630, 576, 579, 584, 583, 587, 614, 600, 601, 603, 604, 605, 606, 607, 608, 609, 610, 613, 615, 624, 625, 626, 660, 656, 640, 645, 647, 648, 649, 650, 651, 652, 653, 658) 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]