$(this).parent().siblings('ul').children('li')$(this).siblings('ul').children('li')
SELECT `p1`.`entity_id`
FROM `products` AS `p1`
JOIN `products` AS `p2` USING(`entity_id`)
WHERE `p1`.`value_id` = '19'
AND `p2`.`value_id` = '12'SELECT `t1`.`usrid`, `t2`.`data`, `t2`.`postid`
FROM (
SELECT `usrid`, COUNT(*) AS `cnt`
FROM `posts`
WHERE `data` BETWEEN :start AND :end
GROUP BY `usrid`
ORDER BY `cnt` DESC
LIMIT 10
) AS `t1`
JOIN `posts` AS `t2` USING(`usrid`)
WHERE `t2`.`data` BETWEEN :start AND :end
ORDER BY `t1`.`cnt`, `t1`.`usrid`, `t2`.`data`SELECT `ul`.`user_id`, `ul`.`name`, `ul`.`uid`, `ul`.`gender`
FROM `users_list` AS `ul`
JOIN `users_groups` AS `ug` ON `ul`.`user_id` = `ug`.`user_id`
JOIN `groups_list` AS `gl` ON `gl`.`group_id` = `ug`.`user_id`
WHERE `gl`.`uid` = :gid;A p element's end tag may be omitted if the p element is immediately followed by an address, article, aside, blockquote, div, dl, fieldset, footer, form, h1, h2, h3, h4, h5, h6, header, hgroup, hr, main, nav, ol, p, pre, section, table, or ul, element, or if there is no more content in the parent element and the parent element is not an a element.
<body>
<div id="z">
<p>TEST1 </p>
<p>TEST2 </p>
<p>TEST3 </p>
</p>
</p>
</div>
</body>div > p {
color: red;
}
div > p > * {
color: black;
}UPDATE `user1` AS `t1`
JOIN `user2` AS `t2` ON `t2`.`id` = `t1`.`id`
SET `t1`.`name1` = `t2`.`name2`;SELECT *
FROM `table`
ORDER BY IF(NOW() BETWEEN `dt_start` AND `dt_end`, 0,
IF (NOW() < `dt_start`, 1, 2)),
ABS(DATEDIFF(NOW(), `dt_start`)),
`dt_start`, `dt_end`