SELECT `p`.`thread_id`
FROM `msg_participants` AS `p`
JOIN `msg_participants` AS `t` USING(`thread_id`)
WHERE `p`.`user_id` = ?
AND `t`.`user_id` = ?
SELECT `p`.`thread_id`
FROM (SELECT `thread_id` FROM `msg_participants` WHERE `user_id` = ?)
AS `p`
JOIN (SELECT `thread_id` FROM `msg_participants` WHERE `user_id` = ?)
AS `t` USING(`thread_id`)
SELECT `jp`.*, `ji`.`image`
FROM `jml_jquery_plugins` AS `jp`
LEFT JOIN `jml_jquery_images` as `ji`
ON `ji`.`pluginid` = `jp`.`id`
LEFT JOIN (SELECT MIN(`id`) AS `min`, `pluginid` FROM `jml_jquery_images` GROUP BY `pluginid`) AS `t`
ON `t`.`pluginid` = `jp`.`id`
WHERE `jp`.`del` != 1
AND `jp`.`lastupdate` > 0
AND (`t`.`min` = `ji`.`id` OR `ji`.`image` IS NULL)
ORDER `jp`.`name` ASC
LIMIT 20
<div id="container">
<div>...</div>
<div>...</div>
<div>...</div>
<div> <!-- у этого div'а фиксированная высота и overflow:hidden -->
<p class="image">...</p>
<p class="title">...</p>
<p class="options">...</p>
<div class="payment">...</div>
</div>
</div>
if (isset($_GET['field'], $_GET['order']) &&
in_array($_GET['field'], $allowedFieldsList) &&
($_GET['order'] == 'desc' || $_GET['order'] == 'asc'))
$_SESSION['sort'] = array('field' => $_GET['field'], 'order' => $_GET['order']);
if (isset($_GET['field'], $_GET['rel']) &&
in_array($_GET['field'], $allowedFieldsList) &&
in_array($_GET['rel'], $allowedRelationsList))
$_SESSION['filter'][$_GET['field']] = array('relation' => $_GET['rel'],
'value1' => $_GET['value1'],
'value2' => $_GET['value2']);