Т.е. если пользователь не указал фильтр, то и в запросе такое условие AND должно отсутствовать.
Во-первых, ты спрашивал про SQL, а не про РНР. У тебя даже тега такого в вопросе нет.
Во-вторых, зачем вообще добавлять условие в запрос, если оно не нужно?
В-третьих, у тебя тут sql инъекции кругом.
$query = "SELECT clientname, positive, producttype, price, likes, datetime, description, pros, cons FROM reviews.normal ";
$query .= "WHERE (" . (($reqtype == "any") ? "0=0" : ("positive=" . $reqtype)) . ") ";
$query .= "AND (" . (($producttype == "any") ? "0=0" : ("producttype=\"" . $producttype . "\"")) . ") ";
$query .= "ORDER BY " . $sorttype . ";";Feb 10 11:32:32 * systemd[1]: opendkim.service: Can't open PID file /run/opendkim/opendkim.pid (yet?) after start: No such file or directoryFeb 8 10:59:31 * postfix/postfix-script[29703]: warning: symlink leaves directory: /etc/postfix/./makedefs.outFeb 7 15:11:06 * postfix/anvil[15174]: statistics: max connection count 1 for (smtp:141.98.**.***) at Feb 7 15:04:53
Feb 7 15:11:06 * postfix/anvil[15174]: statistics: max cache size 1 at Feb 7 15:04:53
Feb 7 15:11:51 * postfix/pickup[15203]: 0371A411D4: uid=33 from=<www-data>
Feb 7 15:11:51 * postfix/cleanup[15286]: warning: connect to Milter service inet:localhost:8891: Connection refused
Feb 7 15:11:51 * postfix/cleanup[15286]: 0371A411D4: message-id=<20210207151151.0371A411D4@*.ru>
Feb 7 15:11:51 * postfix/qmgr[14406]: 0371A411D4: from=<www-data@*.ru>, size=759, nrcpt=1 (queue active)
Feb 7 15:11:51 * postfix/pickup[15203]: 0AA8041640: uid=33 from=<www-data>
Feb 7 15:11:51 * postfix/cleanup[15286]: warning: connect to Milter service inet:localhost:8891: Connection refused
Feb 7 15:11:51 * postfix/cleanup[15286]: 0AA8041640: message-id=<20210207151151.0AA8041640@*.ru>
Feb 7 15:11:51 * postfix/qmgr[14406]: 0AA8041640: from=<www-data@*.ru>, size=759, nrcpt=1 (queue active)
Feb 7 15:11:51 * postfix/smtp[15292]: 0AA8041640: to=<maks.smagin.999@mail.ru>, relay=mxs.mail.ru[94.100.***.***]:25, delay=0.66, delays=0.01/0.01/0.04/0.6, dsn=2.0.0, sta$
Feb 7 15:11:51 * postfix/qmgr[14406]: 0AA8041640: removed
Feb 7 15:11:53 * postfix/smtp[15291]: 0371A411D4: to=<maks.smagin.999@mail.ru>, relay=mxs.mail.ru[94.100.***.***]:25, delay=2.4, delays=0.03/0.02/0.04/2.3, dsn=2.0.0, stat$
Feb 7 15:11:53 *postfix/qmgr[14406]: 0371A411D4: removedFeb 7 15:11:51 * postfix/cleanup[15286]: warning: connect to Milter service inet:localhost:8891: Connection refused
Feb 7 15:11:51 * postfix/cleanup[15286]: warning: connect to Milter service inet:localhost:8891: Connection refused