SELECT
optimizedSub1.*,
(SELECT
c.categoryName
FROM
categories c
WHERE
c.categoryId = optimizedSub1.categoryId) AS categoryName,
(SELECT
uc.countryName
FROM
usersaccounts u
JOIN
countries uc
ON u.userCountryId = uc.countryId
WHERE
optimizedSub1.userId = u.userId) AS countryName
FROM
(
SELECT
e.id AS 'id',
e.userId AS 'userId',
e.description AS 'description',
e.partNo AS 'partNo',
e.dateTime AS 'dateTime',
e.altMakeId AS 'altMakeId',
e.complete AS 'complete',
e.cancel AS 'cancel',
e.status AS 'status',
e.notifyBuyer AS 'notifyBuyer',
e.categoryId AS 'categoryId',
mo.modelName AS 'modelName',
mo.modelImage AS 'modelImage',
mo.modelId AS 'modelId',
mo.makeId AS 'makeId',
ma.makeName AS 'makeName',
ma.makeImage AS 'makeImage',
ma.makeUserDefined AS 'makeUserDefined',
ma.makeShortUrl AS 'makeShortUrl'
FROM
enquiries e
JOIN
models mo
ON e.modelId = mo.modelId
JOIN
makes ma
ON mo.makeId = ma.makeId
WHERE
1 = 1
AND e.id = ?
ORDER BY e.id DESC
LIMIT 100000
) AS optimizedSub1
SQLPARAMETERS
array
1
330437
Cat D350E 1601756 - New & Used Parts | Heavy Equipment & Plant Spare Part Requests