- 01
- 02
- 03
- 04
- 05
- 06
- 07
- 08
- 09
- 10
- 11
- 12
- 13
- 14
- 15
- 16
- 17
- 18
- 19
- 20
- 21
- 22
- 23
- 24
- 25
- 26
- 27
- 28
- 29
- 30
- 31
- 32
- 33
- 34
- 35
- 36
- 37
- 38
- 39
- 40
- 41
- 42
- 43
- 44
- 45
- 46
- 47
- 48
- 49
- 50
- 51
- 52
- 53
- 54
- 55
- 56
- 57
- 58
- 59
- 60
- 61
- 62
- 63
SELECT A.Id AS AppraiserId,
(SELECT A2.FieldValueInt AS SubcontractorId
FROM sm_forms_FieldValues A2
WHERE
A2.InstanceId = (
SELECT FormInstanceId
FROM sm_genericdatabase_Instances
WHERE ModuleId=1736 AND Title='Appraisers'
)
AND
A2.FieldId = (
SELECT Id FROM sm_forms_Fields
WHERE InstanceId= A2.InstanceId
AND Title = 'Subcontractor'
)
AND
A2.ValueId=A.Id
) AS SubcontractorId,
(SELECT A3.FieldValueInt
FROM sm_forms_FieldValues A3
WHERE
InstanceId = (
SELECT FormInstanceId
FROM sm_genericdatabase_Instances
WHERE ModuleId=1736 AND Title='Appraisers'
)
AND
FieldId = (
SELECT Id FROM sm_forms_Fields
WHERE InstanceId= A3.InstanceId
AND Title = 'Heavy Equipment'
)
AND
A3.ValueId= A.Id
) AS HeavyEquipment,
(SELECT A3.FieldValueInt
FROM sm_forms_FieldValues A3
WHERE
InstanceId = (
SELECT FormInstanceId
FROM sm_genericdatabase_Instances
WHERE ModuleId=1736 AND Title='Appraisers'
)
AND
FieldId = (
SELECT Id FROM sm_forms_Fields
WHERE InstanceId= A3.InstanceId
AND Title = 'Name'
)
AND
A3.ValueId= A.Id
) AS Name
FROM sm_forms_Values A
where InstanceId = (
SELECT FormInstanceId
FROM sm_genericdatabase_Instances
WHERE ModuleId=1736 AND Title='Appraisers'
)
ORDER BY 2
выборка из большой базы... И нихрена не понятной.