SELECT DISTINCT `id`, `business_id`, `status`, `country_id`, `state_id`, `state_slug`, `city_id`, `city_slug`, `name`, `description`, `slug`, `address`, `zip_code`, `phone`, `fax`, `url`, `categories`, `aliases`, `tags`, `data`, `coords`, `is_verified`, `date_added`, `date_changed`, `photo_image`, `photo_label`, `photo_id`, `ratings_votes`, `ratings_score` FROM (SELECT (businesses_businessmeta__categories.category_id) AS `category_id`, (AsText(coords)) AS `coords`, `businesses_businessmeta`.`id`, `businesses_businessmeta`.`business_id`, `businesses_businessmeta`.`status`, `businesses_businessmeta`.`country_id`, `businesses_businessmeta`.`state_id`, `businesses_businessmeta`.`state_slug`, `businesses_businessmeta`.`city_id`, `businesses_businessmeta`.`city_slug`, `businesses_businessmeta`.`name`, `businesses_businessmeta`.`description`, `businesses_businessmeta`.`slug`, `businesses_businessmeta`.`address`, `businesses_businessmeta`.`zip_code`, `businesses_businessmeta`.`phone`, `businesses_businessmeta`.`fax`, `businesses_businessmeta`.`url`, `businesses_businessmeta`.`categories`, `businesses_businessmeta`.`aliases`, `businesses_businessmeta`.`tags`, `businesses_businessmeta`.`data`, AsText(`businesses_businessmeta`.`coords`), `businesses_businessmeta`.`is_verified`, `businesses_businessmeta`.`date_added`, `businesses_businessmeta`.`date_changed`, `businesses_businessmeta`.`photo_image`, `businesses_businessmeta`.`photo_label`, `businesses_businessmeta`.`photo_id`, `businesses_businessmeta`.`ratings_votes`, `businesses_businessmeta`.`ratings_score` FROM `businesses_businessmeta` , `businesses_businessmeta__categories` WHERE businesses_businessmeta__categories.business_id = businesses_businessmeta.id) as t WHERE t.category_id IN (1321, 7304, 9189, 4736, 4737, 1322, 8554, 1323, 1324, 9459, 1325, 1326, 4738, 1327, 1328, 1329, 1330, 1331, 1332, 1333, 1334, 8031, 8387) LIMIT 0, 10000