SELECT e.* FROM `#__groupjive_plugin_events` AS e JOIN `#__groupjive_plugin_events_attendance` AS a on a.`user_id` = '[user_id]' AND a.`event` = e.`id` JOIN `#__groupjive_groups` AS b ON  b.`id` = e.`group` AND ( b.`category` = '13'  OR b.`id` = '56' ) ORDER BY e.`params`ASC

$marketevents  = $action->string( $user,'[var1_params_event]');

		if ($marketevents > 0) {		
			$db = JFactory::getDbo();
			$query = $db->getQuery();
			$query="SELECT id FROM `yq0g1_groupjive_plugin_events_attendance` WHERE `user_id` = ".$user_id."  AND `event` = ".$marketevents;
			$db->setQuery($query);
			$eventat = $db->loadResult();
			if ($eventat) {
				$query = "SELECT * FROM `yq0g1_groupjive_plugin_events` WHERE `id` =". $marketevents;
				$db->setQuery($query);
				$event=$db->loadObject();
				print_r($event);
				$displayevent = $event->event;
				//Choose the right category if it's for individuals or pros.
				$cat = null;
				$cats = json_decode($event->params);
				$cat = $cats->drophscat;
//				print_r($cat);
				if ($cat == '10') $value = "Professionnels";
				if ($cat == '20') $value = "Particuliers";
				if ($cat == '30') $value = "Tout public";
				if ($cat == '50') $value = "Campagnes souhaitées";
				//set multiplier to default or check fo display
				$groups = JAccess::getGroupsByUser($event->user_id);
				if (in_array(18, $groups) && $event->group != 56){
				$mfl = $cbUser->replaceUserVars ('[cb:userdata field="cb_marketing_multiplier" user="' . $event->user_id . '" /]');
				} else $mfl = 2;
				
			}	
		}      
		<div class="row">
			<div class="col col-sm-11 col-md-10 col-lg-8 mx-auto mt-0 mb-5">
				<div class="mx-1">
<?php								
										//run the content through the onContentPrepare Joomla event,
										$params = new JRegistry();
										$params->loadString("");
										$content = new StdClass;
										$content->text = $event->event;
										JFactory::getApplication()->triggerEvent('onContentPrepare', array("", &$content, &$params, 0));
										echo $content->text;
										//echo $event->text;										 
?>					
				</div>	
			</div>	
		</div>