[find-user]



 /* SQL-1 Start */
$sql = "
SELECT
c2.customer_id,
TRIM(c2.first_name) AS first_name,
TRIM(c2.last_name) AS last_name,
c2.cookie_stamp AS uuid,
c2.created_at AS created_at
FROM wpl6_easy_system_key AS s
JOIN wpl6_easy_customers AS c1
ON CONVERT(TRIM(s.key1) USING utf8mb4) COLLATE utf8mb4_unicode_ci
= CONVERT(TRIM(c1.cookie_stamp) USING utf8mb4) COLLATE utf8mb4_unicode_ci
AND CONVERT(TRIM(s.subject) USING utf8mb4) COLLATE utf8mb4_unicode_ci
IN ('uuid_customer_map','customer-uuid')
LEFT JOIN wpl6_easy_customers AS c2
ON c2.customer_id = CAST(TRIM(s.key2) AS UNSIGNED)
ORDER BY c1.customer_id ASC
LIMIT 1
";
/* SQL-1 end */