SELECT
id
FROM
kategorier
WHERE

status
='skjult' AND site_id='21'

SELECT
*
FROM
kategorier
WHERE
id='990'

SELECT
SUM( bh.antall ) AS antall
FROM
butikk_handlekurv AS bh, artikler AS bv, kategorier AS k
WHERE
bh.session_id='a5f45b1591fbf4f3730d4e66c61f3fa3' AND bh.vare_id=bv.id AND bv.kategori_id=k.id AND k.site_id=21
GROUP BY
bv.id

SELECT
kategorier.id, kategorier.navn
FROM
kategorier JOIN artikler ON artikler.kategori_id=kategorier.id
WHERE
foreldre_id=702 AND type=26
GROUP BY
kategorier.id
ORDER BY
kategorier.nr

SELECT
g.*
FROM
grupper AS g JOIN aktive_grupper AS ag ON ag.gruppe_id=g.id JOIN artikler AS a ON ag.artikkel_id=a.id JOIN kategorier AS k ON k.id=a.kategori_id
WHERE
g.type=215 AND a.kategori_id='990'
GROUP BY
g.id
ORDER BY
g.navn

SELECT
antall, type, site_id
FROM
kategorier
WHERE
id='990'

SELECT
*, a.nr AS sortnr, a.id AS aid, SUBSTR(a.tittel, 1, CHAR_LENGTH(a.tittel) - 2) AS gruppetittel, (
SELECT
g.navn
FROM
grupper AS g JOIN aktive_grupper AS ag ON g.id=ag.gruppe_id
WHERE
ag.artikkel_id=a.id AND g.type=215
LIMIT
0,1) AS serie, (
SELECT
g.id
FROM
grupper AS g JOIN aktive_grupper AS ag ON g.id=ag.gruppe_id
WHERE
ag.artikkel_id=a.id AND g.type=215
LIMIT
0,1) AS serieid, (
SELECT
g.navn
FROM
grupper AS g JOIN aktive_grupper AS ag ON g.id=ag.gruppe_id
WHERE
ag.artikkel_id=a.id AND g.type=213
LIMIT
0,1) AS type, (
SELECT
g.id
FROM
grupper AS g JOIN aktive_grupper AS ag ON g.id=ag.gruppe_id
WHERE
ag.artikkel_id=a.id AND g.type=213
LIMIT
0,1) AS typeid, (
SELECT
GROUP_CONCAT(g.navn SEPARATOR ', ')
FROM
grupper AS g JOIN aktive_grupper AS ag ON g.id=ag.gruppe_id
WHERE
ag.artikkel_id=a.id AND g.type=216) AS produsenter, (
SELECT
valueNumber
FROM
artikler_innhold
WHERE
feltId=28 AND artId=a.id) AS pris2, (
SELECT
valueNumber
FROM
artikler_innhold
WHERE
feltId=34 AND artId=a.id) AS kampanjepris2, (
SELECT
valueNumber
FROM
artikler_innhold
WHERE
feltId=31 AND artId=a.id) AS pris, (
SELECT
valueNumber
FROM
artikler_innhold
WHERE
feltId=38 AND artId=a.id) AS kampanjepris a.id AS no
FROM
artikler AS a JOIN kategorier AS k ON a.kategori_id = k.id
WHERE
(k.id='990' OR k.foreldre_id='990') AND a.til_dato > NOW() AND a.fra_dato < NOW() AND a.
status
= 'aktiv' AND a.id NOT LIKE '' AND (k.type = 26 OR k.type = 27)
GROUP BY
a.id
ORDER BY
a.nr
LIMIT
0,999

$_POST

array (
)

$_GET

array (
)

$_SESSION

array (
'LAST_ACTIVITY' => 1747277212,
)

$_COOKIE

array (
)

$_FILES

array (
)

$_SERVER

array (
'PATH' => '/usr/local/bin:/usr/bin:/bin',
'TEMP' => '/tmp',
'TMP' => '/tmp',
'TMPDIR' => '/tmp',
'PWD' => '/',
'HTTP_ACCEPT' => 'text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8',
'HTTP_ACCEPT_ENCODING' => 'br,gzip',
'HTTP_ACCEPT_LANGUAGE' => 'en-US,en;q=0.5',
'CONTENT_LENGTH' => '0',
'HTTP_HOST' => 'cymbaler.no',
'HTTP_USER_AGENT' => 'CCBot/2.0 (https://commoncrawl.org/faq/)',
'HTTP_X_HTTPS' => '1',
'REDIRECT_UNIQUE_ID' => 'aCVVnAFBvSRYjIQNXYvgXQABEQE',
'REDIRECT_SCRIPT_URL' => '/varemerker',
'REDIRECT_SCRIPT_URI' => 'https://cymbaler.no/varemerker',
'REDIRECT_HTTPS' => 'on',
'REDIRECT_SSL_TLS_SNI' => 'cymbaler.no',
'REDIRECT_HTTP2' => 'on',
'REDIRECT_H2PUSH' => 'on',
'REDIRECT_H2_PUSH' => 'on',
'REDIRECT_H2_PUSHED' => '',
'REDIRECT_H2_PUSHED_ON' => '',
'REDIRECT_H2_STREAM_ID' => '3',
'REDIRECT_H2_STREAM_TAG' => '522612-4-3',
'REDIRECT_STATUS' => '200',
'UNIQUE_ID' => 'aCVVnAFBvSRYjIQNXYvgXQABEQE',
'SCRIPT_URL' => '/varemerker',
'SCRIPT_URI' => 'https://cymbaler.no/varemerker',
'HTTPS' => 'on',
'SSL_TLS_SNI' => 'cymbaler.no',
'HTTP2' => 'on',
'H2PUSH' => 'on',
'H2_PUSH' => 'on',
'H2_PUSHED' => '',
'H2_PUSHED_ON' => '',
'H2_STREAM_ID' => '3',
'H2_STREAM_TAG' => '522612-4-3',
'SERVER_SIGNATURE' => '',
'SERVER_SOFTWARE' => 'Apache',
'SERVER_NAME' => 'cymbaler.no',
'SERVER_ADDR' => '167.235.84.107',
'SERVER_PORT' => '443',
'REMOTE_ADDR' => '18.97.9.174',
'DOCUMENT_ROOT' => '/home/kanting/public_html/cymbaler.no',
'REQUEST_SCHEME' => 'https',
'CONTEXT_PREFIX' => '',
'CONTEXT_DOCUMENT_ROOT' => '/home/kanting/public_html/cymbaler.no',
'SERVER_ADMIN' => 'webmaster@cymbaler.no.kanting.no',
'SCRIPT_FILENAME' => '/home/kanting/public_html/cymbaler.no/index.php',
'REMOTE_PORT' => '39332',
'REDIRECT_URL' => '/varemerker',
'SERVER_PROTOCOL' => 'HTTP/2.0',
'REQUEST_METHOD' => 'GET',
'QUERY_STRING' => '',
'REQUEST_URI' => '/varemerker',
'SCRIPT_NAME' => '/index.php',
'PHP_SELF' => '/index.php',
'REQUEST_TIME_FLOAT' => 1747277212.3748390674591064453125,
'REQUEST_TIME' => 1747277212,
'argv' => 
array (
),
'argc' => 0,
)