| |||||
| SQL: | ||
|
SELECT SQL_CALC_FOUND_ROWS IF(enhanced_icon IS NOT NULL,'<img alt="Enhanced" src="http://mtf.goexposoftware.com/2011/FORMfields/uploads/listIcon-EX_ENHANCED_ICON-1300460181.png"/> ','') AS '', CONCAT('<a ',IF(highlight IS NOT NULL,'class="upgrade2" ',''),' href="exhibitor/viewExhibitorProfile.php?__id=',exhibitors.__id,'">',exhibitors.company_name,'</a>') AS 'Company Name', GROUP_CONCAT('<a href="floorPlan/viewFloorPlan.php?ei=',exhibitors.__id,'&zb=',exhibitor_booths.booth_number,'">',exhibitor_booths.booth_number,'','</a>' SEPARATOR '<br/>') AS 'Booth Number' ,CONCAT(' <table cellspacing="0" cellspacing="0" style="border-collapse:collapse;border-spacing:0px;"> <tr valign="top"> <td> <div class="geAddToPlannerButton" style="cursor:pointer;" onclick="window.location=\'http://mtf.goexposoftware.com/2011/goExpo/login.php?goTo=%2F2011%2FgoExpo%2Fexhibitor%2FlistExhibitorProfiles.php%3Fcategory%3DScooters%2520%2526%2520Accessories%2520-%2520Scooters%2520%2526%2520Accessories%26list__sort%3D3\'"> </div> </td> <td> <div class="geAddToPlannerLabel" style="cursor:pointer;" onclick="window.location=\'http://mtf.goexposoftware.com/2011/goExpo/login.php?goTo=%2F2011%2FgoExpo%2Fexhibitor%2FlistExhibitorProfiles.php%3Fcategory%3DScooters%2520%2526%2520Accessories%2520-%2520Scooters%2520%2526%2520Accessories%26list__sort%3D3\'"> Add to Planner </div> </td> </tr> </table> ') AS '' FROM ge_mtf_exhibitors AS exhibitors LEFT JOIN ge_mtf_exhibitor_booths AS exhibitor_booths ON exhibitor_booths.exhibitor_id=exhibitors.__id LEFT JOIN ge_mtf_booths AS booths ON booths.booth_number=exhibitor_booths.booth_number LEFT JOIN ge_mtf_floor_plan_booths AS floor_plan_booths ON floor_plan_booths.booth_number=exhibitor_booths.booth_number LEFT JOIN ge_mtf_floor_plan_areas AS floor_plan_areas ON floor_plan_areas.area_id=floor_plan_booths.area_id LEFT JOIN ge_mtf_users AS users ON users.user_id=exhibitors.contact_id LEFT JOIN ge_mtf_planners AS planners ON (planners.in_planner_user_id=exhibitors.contact_id AND planners.user_id='') WHERE users.status='Active' AND categories LIKE BINARY '%Scooters & Accessories - Scooters & Accessories%' GROUP BY exhibitors.__id ORDER BY `3` ASC | ||