Difference between revisions of "Category:HeavyTruckParts.net/Manufacturers"
From ISoft Wiki
Jump to navigationJump to search
(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,...") |
|||
| Line 11: | Line 11: | ||
) AS butts | ) AS butts | ||
</source> | </source> | ||
[[Category:HeavyTruckParts.net]] | |||
Revision as of 13:47, 3 February 2011
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
Subcategories
This category has the following 35 subcategories, out of 35 total.
