ON a.TESTID=b.TESTID INNER JOIN TESTITEM_DETAIL AS c ON AND a.TESTCLASSID = c.TESTCLASSID INNER JOIN TESTITEM_GROUP AS d ON c.TSTITMSETSECID = d.TSTITMID AND c.TESTCLASSID = d.TESTCLASSID WHERE a.TESTDATE BETWEEN AND ‘2008-01-01’ ‘2008-12-31’ AND a.TESTCLASSID = ‘7’ AND a.TESTTYPE=’NT’ AND a.TESTRESULT IN (‘F’,’PRS’) AND b.RFRTYPE IN(‘F’,’P’) GROUP BY d.ITEMNAME ; Basic Expansion of RfR Hierarchy for Class 5 Vehicles SELECT ,a.RFRDESC ,b.ITEMNAME AS LEVEL1 ,c.ITEMNAME AS LEVEL2 ,d.ITEMNAME AS LEVEL3 ,e.ITEMNAME AS LEVEL4 ,f.ITEMNAME AS LEVEL5 FROM TESTITEM_DETAIL AS a INNER JOIN TESTITEM_GROUP AS b ON a.TSTITMID = b.TSTITMID AND a.TESTCLASSID = b.TESTCLASSID LEFT JOIN TESTITEM_GROUP AS c ON b.PARENTID = c.TSTITEMID AND b.TESTCLASSID = c.TESTCLASSID LEFT JOIN TESTITEM_GROUP AS d ON c.PARENTID = d.TSTITEMID AND c.TESTCLASSID = d.TESTCLASSID LEFT JOIN TESTITEM_GROUP AS e ON d.PARENTID = e.TSTITEMID AND d.TESTCLASSID = e.TESTCLASSID LEFT JOIN TESTITEM_GROUP AS f ON e.PARENTID = f.TSTITMID AND e.TESTCLASSID = f.TESTCLASSID WHERE a.TESTCLASSID = ‘5’ ; Appendix A Further Reading – MOT information for public use MOT Testing Manuals and Guides Internal DVSA MOT Scheme Operations Manual
ON a.TESTID=b.TESTID INNER JOIN TESTITEM_DETAIL AS c ON AND a.TESTCLASSID = c.TESTCLASSID INNER JOIN TESTITEM_GROUP AS d ON c.TSTITMSETSECID = d.TSTITMID AND c.TESTCLASSID = d.TESTCLASSID WHERE a.TESTDATE BETWEEN ‘2008-01-01’ AND ‘2008-12-31’ AND a.TESTCLASSID = ‘7’ AND a.TESTTYPE=’NT’ AND a.TESTRESULT IN (‘F’,’PRS’) AND b.RFRTYPE IN(‘F’,’P’) GROUP BY d.ITEMNAME ; Basic Expansion of RfR Hierarchy for Class 5 Vehicles SELECT ,a.RFRDESC ,b.ITEMNAME AS LEVEL1 ,c.ITEMNAME AS LEVEL2 ,d.ITEMNAME AS LEVEL3 ,e.ITEMNAME AS LEVEL4 ,f.ITEMNAME AS LEVEL5 FROM TESTITEM_DETAIL AS a INNER JOIN TESTITEM_GROUP AS b ON a.TSTITMID = b.TSTITMID AND a.TESTCLASSID = b.TESTCLASSID LEFT JOIN TESTITEM_GROUP AS c ON b.PARENTID = c.TSTITEMID AND b.TESTCLASSID = c.TESTCLASSID LEFT JOIN TESTITEM_GROUP AS d ON c.PARENTID = d.TSTITEMID AND c.TESTCLASSID = d.TESTCLASSID LEFT JOIN TESTITEM_GROUP AS e ON d.PARENTID = e.TSTITEMID AND d.TESTCLASSID = e.TESTCLASSID LEFT JOIN TESTITEM_GROUP AS f ON e.PARENTID = f.TSTITMID AND e.TESTCLASSID = f.TESTCLASSID WHERE a.TESTCLASSID = ‘5’ ; Appendix A – Further Reading MOT information for public use MOT Testing Manuals and Guides Internal DVSA MOT Scheme Operations Manual
MOT_user_guide_v4.docx