SELECT `z`.`id`,
`ra`.`count` AS `acount`, `ra`.`rate` AS `asum`,
`rc`.`count` AS `ccount`, `rc`.`rate` AS `csum`
FROM `zav` AS `z`
LEFT JOIN (
SELECT COUNT(*) AS `count`, sum(`rate`) AS `rate`
FROM `rating`
WHERE `type` = 'a'
GROUP BY `id`
) AS `ra` ON `ra`.`id` = `z`.`id`
LEFT JOIN (
SELECT COUNT(*) AS `count`, sum(`rate`) AS `rate`
FROM `rating`
WHERE `type` = 'c'
GROUP BY `id`
) AS `rc` ON `rc`.`id` = `z`.`id`
WHERE `z`.`city` = 'spb' AND `z`.`closedzav` = '0'var re = /(?:^|\s)(?:xs|sm|md|lg|xlg)-(bottom|top|left|right)(?:$|\s)/;
$('[data-toggle="popover"]').each(function() {
var classList = $(this).attr('class');
var ok = re.exec(classList);
if (ok !== null) {
$(this).popover({
trigger: "hover",
container: "body",
placement: ok[1],
html: !0,
viewport: {
selector: "body",
padding: 2
},
template: '<div class="popover"><div class="arrow"></div><h3 class="popover-title"></h3><div class="popover-content"></div></div>'
});
}
});$stmt = mysqli_prepare($connect, "INSERT INTO *** (fio,email,age,anw1,anw2,frequency) VALUES (?, ?, ?, ?, ?, ?)");
mysqli_stmt_bind_param($stmt, "ssssss", $fio, $email, $age, $anw1, $anw2, $frequency);
mysqli_stmt_execute($stmt);
mysqli_stmt_close($stmt);