| |||||
| SQL: | ||
|
SELECT SQL_CALC_FOUND_ROWS IF(enhanced_icon IS NOT NULL,'<img alt="Enhanced" src="http://n2a.goexposoftware.com/events/pp2011/FORMfields/uploads/listIcon-EX_ENHANCED_ICON-1298584799.jpg"/> ','') AS '', CONCAT('<a ',IF(highlight IS NOT NULL,'class="geHl geBold" ',''),' 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=',floor_plan_booths.booth_number,'">',floor_plan_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://n2a.goexposoftware.com/events/pp2011/goExpo/public/login.php?goTo=%2Fevents%2Fpp2011%2FgoExpo%2Fexhibitor%2FlistExhibitorProfiles.php%3Fcategory%3DInkjet%2520Canvas%26list__sort%3D3\'"> </div> </td> <td> <div class="geAddToPlannerLabel" style="cursor:pointer;" onclick="window.location=\'http://n2a.goexposoftware.com/events/pp2011/goExpo/public/login.php?goTo=%2Fevents%2Fpp2011%2FgoExpo%2Fexhibitor%2FlistExhibitorProfiles.php%3Fcategory%3DInkjet%2520Canvas%26list__sort%3D3\'"> Add to Show Organizer </div> </td> </tr> </table> ') AS '' FROM ge_dev_exhibitors AS exhibitors LEFT JOIN ge_dev_booth_assignments AS booth_assignments ON booth_assignments.exhibitor_id=exhibitors.__id LEFT JOIN ge_dev_floor_plan_booths AS floor_plan_booths ON floor_plan_booths.fp_booth_id=booth_assignments.fp_booth_id LEFT JOIN ge_dev_floor_plan_areas AS floor_plan_areas ON floor_plan_areas.area_id=floor_plan_booths.area_id LEFT JOIN ge_dev_users AS users ON users.user_id=exhibitors.contact_id LEFT JOIN ge_dev_planners AS planners ON (planners.in_planner_user_id=exhibitors.contact_id AND planners.user_id='') LEFT JOIN ge_dev_exhibitor_matcher_profiles AS exhibitor_matcher_profiles ON exhibitor_matcher_profiles.contact_id=exhibitors.contact_id WHERE users.status='Active' AND categories LIKE BINARY '%Inkjet Canvas%' GROUP BY exhibitors.__id ORDER BY `3` ASC | ||