001 |
SELECT
id FROM kategorier WHERE status ='skjult' AND site_id='21'
|
002 |
SELECT
request FROM urler_cymbaler WHERE url='/varemerker'
|
003 |
WARNING: The first few results returned by this query are the same as returned by 1 other queries!
SELECT
* FROM kategorier WHERE id='990'
|
004 |
DELETE
FROM urler WHERE url='/' OR url='//'
|
005 |
SELECT
SUM( bh.antall ) AS antall FROM butikk_handlekurv AS bh, artikler AS bv, kategorier AS k WHERE bh.session_id='372a4db5d489c062d7e74e458cd13704' AND bh.vare_id=bv.id AND bv.kategori_id=k.id AND k.site_id=21 GROUP BY bv.id
|
006 |
SELECT
bv.id, bv.tittel, bv.kategori_id, bh.antall, k.navn AS kategori, bh.alt1 FROM butikk_handlekurv AS bh, artikler AS bv, kategorier AS k WHERE bh.session_id='372a4db5d489c062d7e74e458cd13704' AND bh.vare_id=bv.id AND bv.kategori_id=k.id AND k.site_id=21
|
007 |
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
|
008 |
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=212 AND a.kategori_id='990' GROUP BY g.id ORDER BY g.navn
|
009 |
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
|
010 |
WARNING: The first few results returned by this query are the same as returned by 1 other queries!
SELECT
* FROM kategorier WHERE id='990'
|
011 |
SELECT
antall, type, site_id FROM kategorier WHERE id='990'
|
012 |
SELECT
sortering, multipleKat FROM kategori_typer WHERE id='21'
|
001 |
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'a.id AS no
FROM artikler AS a
JOIN kategorier AS k ON a.kategori_id = k.id
WH...' at line 7
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
|
001 |
No default charset and collections were set. Call set_charset() after connecting to the database.
|
002 |
The "memcache" extension is available on you server - consider using memcache for caching query results.
See the documentation for more information. |
001 |
$_POST
array ( ) |
001 |
$_GET
array ( ) |
001 |
$_SESSION
array ( 'LAST_ACTIVITY' => 1746767971, ) |
001 |
$_COOKIE
array ( ) |
001 |
$_FILES
array ( ) |
001 |
$_SERVER
array ( 'PATH' => '/usr/local/bin:/usr/bin:/bin', 'TEMP' => '/tmp', 'TMP' => '/tmp', 'TMPDIR' => '/tmp', 'PWD' => '/', 'HTTP_ACCEPT' => '*/*', 'HTTP_ACCEPT_ENCODING' => 'gzip, br, zstd, deflate', 'CONTENT_LENGTH' => '0', 'HTTP_HOST' => 'cymbaler.no', 'HTTP_USER_AGENT' => 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'HTTP_X_HTTPS' => '1', 'REDIRECT_UNIQUE_ID' => 'aB2QYwIMkqILXfv7RPIkiAAAEw8', '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' => 'off', 'REDIRECT_H2_PUSH' => 'off', 'REDIRECT_H2_PUSHED' => '', 'REDIRECT_H2_PUSHED_ON' => '', 'REDIRECT_H2_STREAM_ID' => '3', 'REDIRECT_H2_STREAM_TAG' => '2295429-13-3', 'REDIRECT_STATUS' => '200', 'UNIQUE_ID' => 'aB2QYwIMkqILXfv7RPIkiAAAEw8', 'SCRIPT_URL' => '/varemerker', 'SCRIPT_URI' => 'https://cymbaler.no/varemerker', 'HTTPS' => 'on', 'SSL_TLS_SNI' => 'cymbaler.no', 'HTTP2' => 'on', 'H2PUSH' => 'off', 'H2_PUSH' => 'off', 'H2_PUSHED' => '', 'H2_PUSHED_ON' => '', 'H2_STREAM_ID' => '3', 'H2_STREAM_TAG' => '2295429-13-3', 'SERVER_SIGNATURE' => '', 'SERVER_SOFTWARE' => 'Apache', 'SERVER_NAME' => 'cymbaler.no', 'SERVER_ADDR' => '167.235.84.107', 'SERVER_PORT' => '443', 'REMOTE_ADDR' => '3.17.173.228', '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' => '33156', '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' => 1746767971.4792330265045166015625, 'REQUEST_TIME' => 1746767971, 'argv' => array ( ), 'argc' => 0, ) |