Difference between revisions of "Category:HeavyTruckParts.net/Manufacturers"

From ISoft Wiki
Jump to navigationJump to search
(Replaced content with "Category:HeavyTruckParts.net")
 
Line 1: Line 1:
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, COUNT(*) AS tehcount
FROM mnfcrmod
WHERE productcode = 0
GROUP BY pmanufacturer
HAVING tehcount > 10
ORDER BY pmanufacturer
) AS butts
</source>
[[Category:HeavyTruckParts.net]]
[[Category:HeavyTruckParts.net]]

Latest revision as of 14:35, 3 February 2011