ошибки по теме после отлаживания 
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
П омогите решить хотябы одну из них для примера.