A PHP Error was encountered

Severity: Notice

Message: Undefined index: id

Filename: models/dealers.php

Line Number: 18

A PHP Error was encountered

Severity: Notice

Message: Undefined index: id

Filename: controllers/site.php

Line Number: 1249

Database Error

A Database Error Occurred

Error Number: 1064

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY video_id DESC, has_picture DESC ,make_name ASC, model_name ASC' at line 1

SELECT a.*, d.branch_name, d.phone, d.dealer_image_url, d.address, d.city, d.state, d.zip, d.email, d.other_locs, d.website_url FROM themotor_autolisting.autos a JOIN themotor_autolisting.dealers d ON a.dealer_id = d.id WHERE dealer_id= ORDER BY video_id DESC, has_picture DESC ,make_name ASC, model_name ASC