Members

Query Log:

pdo:

SELECT
	users.id,
	users.approved,
	users.archived,
	UNIX_TIMESTAMP(date_joined) AS date_joined,
	month_dues_owed,
	UNIX_TIMESTAMP(date_dues_paid) AS date_dues_paid,
	email,
	first_name,
	middle_name,
	last_name,
	name_suffix,
	birth_month,
	birth_day,
	spouse_first_name,
	company_name,
	corporation,
	business_phone,
	business_phone_extension,
	residence_phone,
	cell_phone,
	fax,
	website,
	business_address_street,
	business_address_suffix,
	business_address_direction,
	business_address_suite,
	business_city,
	business_state,
	business_zip,
	residence_address_street,
	residence_address_suffix,
	residence_address_direction,
	residence_address_apartment,
	residence_city,
	residence_state,
	residence_zip,
	mail_to_residence,
	property_owner,
	engaged_in_business,
	sponsor,
	keywords,
	is_past_president,
	is_past_chairman,
	deceased,

	roles.id AS roles_id,
	roles.hidden AS roles_hidden,
	roles.developer AS roles_developer,
	roles.role AS roles_role,

	business_types.id AS business_types_id,
	business_types.name AS business_types_name,

	member_types_id,

	pictures.id AS pictures_id
FROM
	users
LEFT JOIN
	roles ON users.roles_id=roles.id
LEFT JOIN
	business_types ON users.business_types_id=business_types.id
LEFT JOIN
	pictures ON users.pictures_id=pictures.id
WHERE
	roles.hidden=FALSE AND UPPER(users.last_name) LIKE "C%"
ORDER BY
	users.last_name , users.first_name

pdo:


            SELECT
                GROUP_CONCAT(DISTINCT SUBSTRING(TRIM(last_name),1,1) SEPARATOR '') AS last_name_search_letters
            FROM users
            WHERE last_name != ''

pdo:

SELECT
	business_types.id,
	name
FROM
	business_types
	
ORDER BY
	business_types.name