SELECT SUM(itemsor) AS sor, itemcon.pname
FROM itemsor, itemcon
WHERE itemcon.id = itemsor.itemid AND (itemid < 23)
GROUP BY itemid,itemcon.pname
ORDER BY sor DESC
FROM itemsor, itemcon
WHERE itemcon.id = itemsor.itemid AND (itemid < 23)
GROUP BY itemid,itemcon.pname
ORDER BY sor DESC
FROM itemsor, itemcon
WHERE itemcon.id = itemsor.itemid AND (itemid < 23)
GROUP BY itemsor.itemid,itemcon.pname
ORDER BY sor DESC