D
Deleted member 156
Guest
Hallo zusammen,
Weiss vielleicht jemand, warum beim folgenden SQL-Statement die Column "userprice" nicht gefunden wird obwohl ich sie in der ersten Zeile als berechnetes SQL-Feld reingenommen habe?
CODE
Error
SQL query:
SELECT slots.slot_price / currency.currency_value *1 AS userprice, vendor. * , cat. * , usr. * , usr_contact. * , region. * , currency. *
FROM slots
LEFT JOIN vendor ON vendor.vendor_id = slots.vendor_id
LEFT JOIN cat ON cat.cat_id = slots.cat_id
LEFT JOIN usr ON usr.usr_id = slots.usr_id
LEFT JOIN usr_contact ON usr.contact_id = usr_contact.usr_contact_id
LEFT JOIN region ON usr_contact.region = region.id_region
LEFT JOIN currency ON currency_id = slot_price_currency
WHERE (
(
userprice >100
)
AND (
userprice <500
)
)
AND usr.status = 'activated'
ORDER BY slots.slot_id DESC
LIMIT 0 , 30
MySQL said:
#1054 - Unknown column 'userprice' in 'where clause'
Weiss vielleicht jemand, warum beim folgenden SQL-Statement die Column "userprice" nicht gefunden wird obwohl ich sie in der ersten Zeile als berechnetes SQL-Feld reingenommen habe?
CODE
Error
SQL query:
SELECT slots.slot_price / currency.currency_value *1 AS userprice, vendor. * , cat. * , usr. * , usr_contact. * , region. * , currency. *
FROM slots
LEFT JOIN vendor ON vendor.vendor_id = slots.vendor_id
LEFT JOIN cat ON cat.cat_id = slots.cat_id
LEFT JOIN usr ON usr.usr_id = slots.usr_id
LEFT JOIN usr_contact ON usr.contact_id = usr_contact.usr_contact_id
LEFT JOIN region ON usr_contact.region = region.id_region
LEFT JOIN currency ON currency_id = slot_price_currency
WHERE (
(
userprice >100
)
AND (
userprice <500
)
)
AND usr.status = 'activated'
ORDER BY slots.slot_id DESC
LIMIT 0 , 30
MySQL said:
#1054 - Unknown column 'userprice' in 'where clause'