Try left joining your states table also. MySQL may be joining the
property_photos and the states table first, which would screw up your
left join. Haven't had my morning coffee yet so I can't say for sure.
Put EXPLAIN in front of your query to see what MySQL is doing.
SELECT
...
FROM
pr
I am running the following query:
SELECT
...stuff...
FROM
properties LEFT JOIN property_photos ON
property_photos.property_id=properties.id,
states
WHERE
states.code='fl' AND
properties.state_id=states.id
LIMIT 0, 10
(not sure if the JOIN is
