Category:HeavyTruckParts.net/Manufacturers

From ISoft Wiki
< Category:HeavyTruckParts.net
Revision as of 13:46, 3 February 2011 by Duff (talk | contribs) (Created page with "These manufacturers were returned by the following query on 2011-02-02: <source lang="MySQL"> SELECT manufacturer FROM ( SELECT f_sentence_case(pmanufacturer, 4) AS manufacturer,...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigationJump to search

These manufacturers were returned by the following query on 2011-02-02:

SELECT manufacturer
FROM (
SELECT f_sentence_case(pmanufacturer, 4) AS manufacturer, COUNT(*) AS tehcount
FROM mnfcrmod
WHERE productcode = 0
GROUP BY pmanufacturer
HAVING tehcount > 10
ORDER BY pmanufacturer
) AS butts