Comments for How to export SOBI2 Business Index information to Excel at http://joomla-r-us.com , comment 1 to 2 out of 2 comments http://joomla-r-us.com Fri, 10 Sep 2010 12:36:10 +0100 FeedCreator 1.7.3 http://joomla-r-us.com/home/48-sql-2-excel/125-how-to-export-sobi-business-index-information-to-excel#comment-363 @Wikus: You can easily filter the info for one or more categories. Just the filter in the WHERE clause. Example: SELECT a.itemid as `ID`, a.title as `Title`, GROUP_CONCAT(DISTINCT e.name ORDER BY e.name) AS `Categories`, GROUP_CONCAT(DISTINCT e.catid ORDER BY e.name) AS `Category IDs`, a.hits as `Hits`, a.visits as `Visits`, b.name as `Owner Name`, b.email as `Owner Email`, MAX(IF(c.fieldid=1,c.data_txt, NULL)) as `Street`, MAX(IF(c.fieldid=2,c.data_txt, NULL)) as `Postcode`, MAX(IF(c.fieldid=3,c.data_txt, NULL)) as `City`, MAX(IF(c.fieldid=4,c.data_txt, NULL)) as `County`, MAX(IF(c.fieldid=5,c.data_txt, NULL)) as `Federal State`, MAX(IF(c.fieldid=6,c.data_txt, NULL)) as `Country`, MAX(IF(c.fieldid=7,c.data_txt, NULL)) as `Email`, MAX(IF(c.fieldid=8,c.data_txt, NULL)) as `Website`, MAX(IF(c.fieldid=9,c.data_txt, NULL)) as `Contact Person`, MAX(IF(c.fieldid=10,c.data_txt, NULL)) as `Phone`, MAX(IF(c.fieldid=11,c.data_txt, NULL)) as `Fax`, MAX(IF(c.fieldid=12,c.data_txt, NULL)) as `Hotline`, MAX(IF(c.fieldid=13,c.data_txt, NULL)) as `Description` FROM jos_sobi2_item a LEFT JOIN jos_users b ON a.owner = b.id LEFT JOIN jos_sobi2_fields_data c on c.itemid=a.itemid LEFT JOIN jos_sobi2_cat_items_relations d on d.itemid=a.itemid LEFT JOIN jos_sobi2_categories e ON e.catid=d.catid WHERE d.itemid=a.itemid AND e.name='Cape Town' GROUP BY a.itemid ORDER BY ID DESC - Mats @ Joomla-R-Us Tue, 20 Jul 2010 16:35:09 +0100 http://joomla-r-us.com/home/48-sql-2-excel/125-how-to-export-sobi-business-index-information-to-excel#comment-362 Hi there, Thank you for this component. It might be exactly what I am looking for. I have one question though, is it possible to extract all the listings/data from a specific category in Sobi2? I have a category named "Cape Town" for example. Is it possible to only get the data belonging to that category? - Wikus Tue, 20 Jul 2010 01:12:51 +0100