เมื่อผมวางยาตัวเอง

// login
$login= (int)$_SESSION['login']['id'];
// query
$sql = "SELECT L.`id`,L.`module_id`,L.`period`,L.`point`,L.`like`,L.`published`,G.`id` AS `cat_id`,G.`topic`,G.`c2`,U.`id` AS `member_id`,U.`point` AS `u_point`";
$sql .= ",COALESCE((SELECT `id` FROM `".DB_LOTTO_CUSTOMER."` WHERE `member_id`='$login' AND `lotto_id`=L.`id` LIMIT 1),0) AS `customer`";
$sql .= " FROM `".DB_LOTTO."` AS L";
$sql .= " INNER JOIN `".DB_MODULES."` AS M ON M.`id`=L.`module_id` AND M.`owner`='lottoresult'";
$sql .= " INNER JOIN `".DB_CATEGORY."` AS G ON G.`category_id`=L.`category_id` AND G.`module_id`=L.`module_id`";
$sql .= " INNER JOIN `".DB_USER."` AS U ON U.`id`='$login'";
$sql .= " WHERE L.`id`='$match[2]' LIMIT 1";
$lotto = $db->customQuery($sql);