(SELECT DISTINCT queryTable6.pinnum, queryTable6.pinndxnum, queryTable6.value, queryTable6.collectionnum, queryTable6.parent, IF (queryTable7.nvalue>5, 0, 1), IF (queryTable7.nvalue>5, queryTable7.pinnum, -1), IF (queryTable7.nvalue>5, queryTable7.pinndxnum, -1), IF (queryTable7.nvalue>5, queryTable7.value, -1) FROM pinndx_1 queryTable6, pinndx_1 queryTable6_1, pinndx_1 queryTable7_1, pinndx_1 queryTable7_2, pinndx_1 queryTable7 WHERE ( (queryTable6.tagpath=62 AND queryTable6.collectionnum=1 AND queryTable6.tagtype="E" AND ( (queryTable7.tagtype="E" AND queryTable6.parent=queryTable6_1.pinndxnum AND queryTable7.parent=queryTable7_1.pinndxnum AND queryTable7_1.parent=queryTable7_2.pinndxnum AND queryTable7.tagpath=102 AND queryTable7.collectionnum=1 AND queryTable6_1.parent=queryTable7_2.parent))) ) AND queryTable6.pinnum=queryTable6_1.pinnum AND queryTable6_1.pinnum=queryTable7_1.pinnum AND queryTable7_1.pinnum=queryTable7_2.pinnum AND queryTable7_2.pinnum=queryTable7.pinnum AND ( queryTable6.collectionnum=1 ) AND ( queryTable6_1.collectionnum=1 ) AND ( queryTable7_1.collectionnum=1 ) AND ( queryTable7_2.collectionnum=1 ) AND ( queryTable7.collectionnum=1 ) AND queryTable6.collectionnum=queryTable6_1.collectionnum AND queryTable6_1.collectionnum=queryTable7_1.collectionnum AND queryTable7_1.collectionnum=queryTable7_2.collectionnum AND queryTable7_2.collectionnum=queryTable7.collectionnum ORDER BY queryTable6.pinnum, queryTable6.pinndxnum) UNION (SELECT DISTINCT queryTable9.pinnum, queryTable9.pinndxnum, queryTable9.value, queryTable9.collectionnum, queryTable9.parent, IF (queryTable10.nvalue>5, 0, 1), IF (queryTable10.nvalue>5, queryTable10.pinnum, -1), IF (queryTable10.nvalue>5, queryTable10.pinndxnum, -1), IF (queryTable10.nvalue>5, queryTable10.value, -1) FROM pinndx_1 queryTable9, pinndx_1 queryTable10 WHERE ( (queryTable9.tagpath=62 AND queryTable9.collectionnum=1 AND queryTable9.tagtype="E" AND ( (queryTable10.tagtype="E" AND queryTable10.tagpath=62 AND queryTable10.collectionnum=1 AND queryTable9.pinndxnum=queryTable10.pinndxnum))) ) AND queryTable9.pinnum=queryTable10.pinnum AND ( queryTable9.collectionnum=1 ) AND ( queryTable10.collectionnum=1 ) AND queryTable9.collectionnum=queryTable10.collectionnum ORDER BY queryTable9.pinnum, queryTable9.pinndxnum)