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='285e1ddd9fa30d1d9e1592fde1d63083' 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='285e1ddd9fa30d1d9e1592fde1d63083' 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 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
|
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' => 1702183563, ) |
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' => '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, ) |