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='285e1ddd9fa30d1d9e1592fde1d63083' 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
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=216
LIMIT
0,1 ) AS produsent, (
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' => 1702183563,
)

$_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' => '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_FORWARDED_FOR' => '34.228.52.21',
'HTTP_X_REAL_IP' => '34.228.52.21',
'HTTP_X_REMOTE_IP' => '172.70.175.153',
'HTTP_CDN_LOOP' => 'cloudflare',
'HTTP_CF_IPCOUNTRY' => 'US',
'HTTP_CF_RAY' => '8332d785bd7582ed-IAD',
'HTTP_X_FORWARDED_PROTO' => 'https',
'HTTP_CF_VISITOR' => '{"scheme":"https"}',
'HTTP_CF_CONNECTING_IP' => '34.228.52.21',
'HTTP_X_HTTPS' => '1',
'REDIRECT_UNIQUE_ID' => 'ZXVCixJDiQLFJTj50N-t5AAAAUQ',
'REDIRECT_SCRIPT_URL' => '/varemerker',
'REDIRECT_SCRIPT_URI' => 'https://cymbaler.no/varemerker',
'REDIRECT_HTTPS' => 'on',
'REDIRECT_STATUS' => '200',
'UNIQUE_ID' => 'ZXVCixJDiQLFJTj50N-t5AAAAUQ',
'SCRIPT_URL' => '/varemerker',
'SCRIPT_URI' => 'https://cymbaler.no/varemerker',
'HTTPS' => 'on',
'SERVER_SIGNATURE' => '',
'SERVER_SOFTWARE' => 'Apache',
'SERVER_NAME' => 'cymbaler.no',
'SERVER_ADDR' => '167.235.84.107',
'SERVER_PORT' => '443',
'REMOTE_ADDR' => '172.70.175.153',
'DOCUMENT_ROOT' => '/home/kanting/public_html/cymbaler.no',
'REQUEST_SCHEME' => 'https',
'CONTEXT_PREFIX' => '',
'CONTEXT_DOCUMENT_ROOT' => '/home/kanting/public_html/cymbaler.no',
'SERVER_ADMIN' => '[email protected]',
'SCRIPT_FILENAME' => '/home/kanting/public_html/cymbaler.no/index.php',
'REMOTE_PORT' => '49022',
'REDIRECT_URL' => '/varemerker',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'REQUEST_METHOD' => 'GET',
'QUERY_STRING' => '',
'REQUEST_URI' => '/varemerker',
'SCRIPT_NAME' => '/index.php',
'PHP_SELF' => '/index.php',
'REQUEST_TIME_FLOAT' => 1702183563.3708798885345458984375,
'REQUEST_TIME' => 1702183563,
'argv' => 
array (
),
'argc' => 0,
)