SELECT
pd.pid
FROM
promisers_data pd
INNER JOIN promisers_data pd2 ON pd.pid = pd2.pid
WHERE 1
AND (pd.key='family' AND pd.value LIKE '%Иванов%')
AND (pd2.key='name' AND pd2.value LIKE '%Иван%')
<a class="opener" href="javascript:;">open</a>
<div class="block">
...
</div>
<a class="opener" href="javascript:;">open</a>
<div class="block">
...
</div>
<a class="opener" href="javascript:;">open</a>
<div class="block">
...
</div>
<a class="opener" href="javascript:;">open</a>
<div class="block">
...
</div>
var $blocks = $('.block'); // все блоки имеют класс block и перед ним элемент .opener для раскрытия.
$('.opener').on('click', function(e) {
e.preventDefault();
var $nextBlock = $(this).next('.block');
$blocks.not($nextBlock).hide();
$nextBlock.show();
});
$.get('/eh').then((data) => {
let json = JSON.parse(data);
// do something with json
window.sessionStorage.somekey = JSON.stringify(json);
});
var m = window.location.href.match(/([^#]+)#$/);
if ( m !== null ) {
window.location.replace(m[1]);
}