Hi Pat SELECT `products`.`id` * 1 + 0 AS `id` , CAST(`products`.`name` AS CHAR) AS `name`, CAST(`products`.`id` AS CHAR) AS `id`, CAST(`products`.`description` AS CHAR) AS `description`, CAST(`products`.`age` AS CHAR) AS `age`, CAST(`products`.`productType` AS CHAR) AS `productType`, CAST(`brands`.`name` AS CHAR) AS `brandName`, CAST(GROUP_CONCAT(DISTINCT `stores`.`name` SEPARATOR ' ') AS CHAR) AS `storeName`, `products`.`id` AS `sphinx_internal_id`, 485965105 AS `class_crc`, '485965105' AS `subclass_crcs`, 0 AS `sphinx_deleted` FROM `products` LEFT OUTER JOIN `brands` ON `brands`.id = `products`.brand_id LEFT OUTER JOIN `inventorizations` ON (`products`.`id` = `inventorizations`.`product_id`) LEFT OUTER JOIN `stores` ON (`stores`.`id` = `inventorizations`.`store_id`) WHERE `products`.`id` >= $start AND `products`.`id` <= $end GROUP BY `products`.`id` ORDER BY NULL
thx -- You received this message because you are subscribed to the Google Groups "Thinking Sphinx" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/thinking-sphinx?hl=en.
