WordPress database error: [Table 'wp_ppl_ir_test.pplir_memdata_base' doesn't exist]SELECT
DISTINCT (MemNo),
pplir_memdata_base.id AS user_id,
TRIM(concat(IFNULL(Title, ''),' ',FirstName,' ',LastName)) AS FullName,
EMAIL as Email,
CONCAT(IFNULL(CONCAT(Address1,'<br>'), ''),IFNULL(CONCAT(Address2,'<br>'), ''),IFNULL(CONCAT(City,'<br>'), ''),IFNULL(CONCAT(Postcode,'<br>'), ''),IFNULL(CONCAT(Country,'<br>'), '')) AS Address,
IFNULL(AircraftType,'N/A') AS AircraftType,
IFNULL(Phone,'N/A') AS Phone,
IFNULL(Mobile,'N/A') AS Mobile,
IFNULL(home_base,'N/A') AS HomeBaseICAO,
pplir_privacy_choices.user_choices
FROM pplir_memdata_base
LEFT JOIN pplir_privacy_choices ON pplir_privacy_choices.user_id = pplir_memdata_base.id
WHERE ExpiryDate > NOW() AND Status = 'complete'
ORDER BY LastName
| Order | Name | Home Base | Phone | Mobile | Address | Licence Details | Aircraft Type |
|---|