SELECT restaurants.city AS restaurants_city, restaurants.name AS restaurants_name, restaurants.grade AS restaurants_grade, restaurants.address1 AS restaurants_address1, restaurants.address2 AS restaurants_address2, restaurants.zipcode AS restaurants_zipcode, restaurants.franchise_id AS restaurants_franchise_id, restaurants.url AS restaurants_url, restaurants.state AS restaurants_state, restaurants.in_store AS restaurants_in_store, restaurants.lng AS restaurants_lng, restaurants.lat AS restaurants_lat, inspections_6c83.restaurant_id AS inspections_6c83_restaur_f920, inspections_6c83.noncritical AS inspections_6c83_noncritical, inspections_6c83.date AS inspections_6c83_date, violations_dfb2.county AS violations_dfb2_county, violations_dfb2.correction AS violations_dfb2_correction, violations_dfb2.code AS violations_dfb2_code, violations_dfb2.id AS violations_dfb2_id, violations_dfb2.description AS violations_dfb2_description, inspection_viol_6bc0.inspection_id AS inspection_viol_6bc0_ins_7aae, inspection_viol_6bc0.severity AS inspection_viol_6bc0_severity, inspection_viol_6bc0.violation_id AS inspection_viol_6bc0_vio_2ec4, inspections_6c83.type AS inspections_6c83_type, inspections_6c83.id AS inspections_6c83_id, restaurants.id AS restaurants_id 
FROM (SELECT restaurants.id AS restaurant_id, max(inspections.date) AS date 
FROM restaurants, inspections 
WHERE inspections.restaurant_id = restaurants.id GROUP BY restaurants.id) AS maxdate, restaurants JOIN inspections ON restaurants.id = inspections.restaurant_id JOIN inspection_violations ON inspections.id = inspection_violations.inspection_id JOIN violations ON violations.id = inspection_violations.violation_id LEFT OUTER JOIN inspections AS inspections_6c83 ON restaurants.id = inspections_6c83.restaurant_id LEFT OUTER JOIN inspection_violations AS inspection_viol_6bc0 ON inspections_6c83.id = inspection_viol_6bc0.inspection_id LEFT OUTER JOIN violations AS violations_dfb2 ON violations_dfb2.id = inspection_viol_6bc0.violation_id 
WHERE inspections.date = maxdate.date AND restaurants.id = maxdate.restaurant_id AND violations.code = %(violations_code)s ORDER BY restaurants.id, inspections_6c83.date DESC, violations_dfb2.id