ошибки по теме после отлаживания
1 SELECT id as value, title FROM jos_autobb_vendors WHERE category='601' ORDER BY title
2 SELECT id as value, title FROM jos_autobb_models WHERE vendor='0' ORDER BY title
3 SELECT count(a.id) FROM jos_autobb_messages AS a
WHERE a.expirationDate>=NOW() AND a.published='1' AND exists (select 1 from jos_autobb_photos p1 where a.id=p1.msgid)
4 SELECT a.*, v.title as vendortitle, m.title as modeltitle, v.itemid as vendor_itemid,
m.itemid as model_itemid, cur.title as currency_title, (SELECT min(p.id) FROM jos_autobb_photos AS p WHERE a.id=p.msgid) AS photoid
FROM jos_autobb_messages AS a
LEFT JOIN jos_autobb_vendors as v ON a.vendor=v.id
LEFT JOIN jos_autobb_models as m ON a.model=m.id
LEFT JOIN jos_autobb_currency as cur ON cur.id=a.currency
WHERE a.expirationDate>=NOW() AND a.published='1' AND exists (select 1 from jos_autobb_photos p1 where a.id=p1.msgid)
LIMIT 7,1
5 SELECT a.*, v.itemid as vendor_itemid, v.title as vendortitle, m.itemid as model_itemid, m.title as modeltitle, p.id as photoid, cur.sign as currency_title, ct.title as city_title, LOWER(s.title) as state_title, s.ordering as state_id FROM jos_autobb_messages AS a
LEFT JOIN jos_autobb_vendors as v ON a.vendor=v.id
LEFT JOIN jos_autobb_models as m ON a.model=m.id
LEFT JOIN jos_autobb_photos as p ON a.id=p.msgid
LEFT JOIN jos_autobb_cities as ct ON a.city=ct.id
LEFT JOIN jos_autobb_states as s ON a.state=s.id
LEFT JOIN jos_autobb_currency as cur ON cur.id=a.currency
WHERE a.expirationDate>=NOW() AND a.published='1' AND a.front='1' AND p.id IS NOT NULL
GROUP BY a.id
ORDER BY a.sticked DESC, a.ordering, a.createDate DESC
LIMIT 0, 5
6 SELECT a.city, c.title, count(a.id) as msg_count
FROM jos_autobb_messages a
LEFT JOIN jos_autobb_cities as c ON c.id=a.city
WHERE a.expirationDate>=NOW() AND a.published='1'
GROUP BY a.city
ORDER BY 3 desc
7 SELECT v.*, count(a.id) as msg_count FROM jos_autobb_vendors AS v
LEFT JOIN jos_autobb_messages as a ON a.vendor=v.id
WHERE a.expirationDate>=NOW() AND a.published='1' AND (a.id IS NOT NULL or v.itemid>0)
GROUP BY v.id
ORDER BY v.title
П омогите решить хотябы одну из них для примера.
13.05.2025, 23:26:17