SELECT dr1_users.name, dr1_users.mail, dr1_profile_values.value,
dr1_users_roles.rid FROM dr1_users, dr1_profile_values, dr1_users_roles
WHERE dr1_users.uid = dr1_profile_values.uid and  dr1_profile_values.fid = 2
and dr1_users_roles.uid = dr1_users.uid and dr1_users_roles.rid = 3
Database drupal
Prefix dr1_
Table: role
rid     name
2       authenticated user
3       student
4       staff
profile_fields
fid     title
1       Class Roll No
2       Mobile
3       Date of Birth
4       Sex
5       Passout year
profile_values
fid     uid     value
(1-5)
users
uid     name    mail
SELECT dr1_users.name, dr1_users.mail, dr1_profile_values.value FROM
dr1_users, dr1_profile_values WHERE dr1_users.uid = dr1_profile_values.uid
and  dr1_profile_values.fid […]

Ldh Delhi Pilani  313 (6:46) +  167 (3:47) = 480 (10:33)
From:Ludhiana, PunjabTo:Pilani, Jhunjhunun, Rajasthan
Dist:334kms Time:6 hrs 52 mins.
1 Straight(0.6 km) going toward Partap Chowk
2  At Partap Chowk, take 2nd exit, go 0.4 km overall
3 2nd Left onto SH11 Hwy, go 24 km.Enter Ludhiana District at 4.3 km.
4Right onto SH11 Hwy, go 16 km.Enter Sangrur District.Enter […]

There is no excerpt because this is a protected post.

Welcome to portal of Hardeep Singh Rai, Structural Engineers, who uses and promote FOSS (Free and Opensource Software). So, you will find stuff related to Civil Engineering in general, Structural Engeering in particular, and his experience regarding use of FOSS (GNU/Linux based) software in Engineering, and general use.