001
SELECT
id
FROM
kategorier
WHERE

status
='skjult' AND site_id='21'
id
718
719
723
952
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEkategorierALL570100.00Using where
filefunctionline
/home/kanting/public_html/pub5/php/function/Nettside.phpquery()156
/home/kanting/public_html/cymbaler.no/head.phpNettside()58
/home/kanting/public_html/cymbaler.no/index.phpinclude_once()2
002
SELECT
request
FROM
urler_cymbaler
WHERE
url='/varemerker'
request
a:2:{s:3:"sok";s:0:"";s:6:"kat_id";s:3:"990";}
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEurler_cymbalerALL118408100.00Using where
filefunctionline
/home/kanting/public_html/pub5/php/function/Nettside.phpquery()493
/home/kanting/public_html/pub5/php/function/Nettside.phpdecodeUrl()211
/home/kanting/public_html/cymbaler.no/head.phpNettside()58
/home/kanting/public_html/cymbaler.no/index.phpinclude_once()2
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'
idforeldre_idcanonical_idnavntypevisbeskrivelsekeywordstitlemetadescniva_oldnivaenhetstatusrolle_idopp_datoopp_navnendr_datoendr_navnantallnrsite_idgooglekatgoogleKatNavnprisfilKat
99000Varemerker210synlig02018-06-04 10:26:0812018-06-04 11:23:3015210
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEkategorierconstPRIMARYPRIMARY4const1100.00
filefunctionline
/home/kanting/public_html/pub5/php/function/Nettside.phpquery()453
/home/kanting/public_html/pub5/php/function/Nettside.phpgetDefaultArgs()222
/home/kanting/public_html/cymbaler.no/head.phpNettside()58
/home/kanting/public_html/cymbaler.no/index.phpinclude_once()2
004
DELETE

FROM
urler
WHERE
url='/' OR url='//'
filefunctionline
/home/kanting/public_html/pub5/php/display/Cymbaler.phpquery()17
/home/kanting/public_html/pub5/php/function/Nettside.phpsetSiteArgs()224
/home/kanting/public_html/cymbaler.no/head.phpNettside()58
/home/kanting/public_html/cymbaler.no/index.phpinclude_once()2
005
SELECT
SUM( bh.antall ) AS antall
FROM
butikk_handlekurv AS bh, artikler AS bv, kategorier AS k
WHERE
bh.session_id='6a7dc905b32e81b08e5279e858aa02a8' AND bh.vare_id=bv.id AND bv.kategori_id=k.id AND k.site_id=21
GROUP BY
bv.id
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEbhALL154149100.00Using where; Using temporary; Using filesort
1SIMPLEbveq_refPRIMARY,idPRIMARY4kanting_kanting.bh.vare_id1100.00Using where
1SIMPLEkeq_refPRIMARYPRIMARY4kanting_kanting.bv.kategori_id1100.00Using where
filefunctionline
/home/kanting/public_html/pub5/php/display/Cymbaler.phpquery()1391
/home/kanting/public_html/pub5/php/display/Cymbaler.phpantallHandlekurv()31
/home/kanting/public_html/pub5/php/function/Nettside.phpsetSiteArgs()224
/home/kanting/public_html/cymbaler.no/head.phpNettside()58
/home/kanting/public_html/cymbaler.no/index.phpinclude_once()2
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='6a7dc905b32e81b08e5279e858aa02a8' AND bh.vare_id=bv.id AND bv.kategori_id=k.id AND k.site_id=21
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEbhALL154149100.00Using where
1SIMPLEbveq_refPRIMARY,idPRIMARY4kanting_kanting.bh.vare_id1100.00Using where
1SIMPLEkeq_refPRIMARYPRIMARY4kanting_kanting.bv.kategori_id1100.00Using where
filefunctionline
/home/kanting/public_html/pub5/php/display/Cymbaler.phpquery()1430
/home/kanting/public_html/pub5/php/display/Cymbaler.phpvisHandlkurv()32
/home/kanting/public_html/pub5/php/function/Nettside.phpsetSiteArgs()224
/home/kanting/public_html/cymbaler.no/head.phpNettside()58
/home/kanting/public_html/cymbaler.no/index.phpinclude_once()2
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
idnavn
982Ride
989Crash/Ride
983Crash
984Hi-Hat
985Splash
986China
987Effekter og Stacks
988Pakker
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEartiklerALL6954100.00Using where; Using temporary; Using filesort
1SIMPLEkategoriereq_refPRIMARYPRIMARY4kanting_kanting.artikler.kategori_id1100.00Using where
filefunctionline
/home/kanting/public_html/pub5/php/display/Cymbaler.phpquery()351
/home/kanting/public_html/pub5/php/display/Cymbaler.phpsetCymbalfilter()37
/home/kanting/public_html/pub5/php/function/Nettside.phpsetSiteArgs()224
/home/kanting/public_html/cymbaler.no/head.phpNettside()58
/home/kanting/public_html/cymbaler.no/index.phpinclude_once()2
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
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEaALLPRIMARY,id6954100.00Using where; Using temporary; Using filesort
1SIMPLEkeq_refPRIMARYPRIMARY4kanting_kanting.a.kategori_id1100.00Using index
1SIMPLEagrefPRIMARYPRIMARY4kanting_kanting.a.id1100.00Using index
1SIMPLEgeq_refPRIMARYPRIMARY4kanting_kanting.ag.gruppe_id1100.00Using where
filefunctionline
/home/kanting/public_html/pub5/php/display/Cymbaler.phpquery()380
/home/kanting/public_html/pub5/php/display/Cymbaler.phpsetCymbalfilter()37
/home/kanting/public_html/pub5/php/function/Nettside.phpsetSiteArgs()224
/home/kanting/public_html/cymbaler.no/head.phpNettside()58
/home/kanting/public_html/cymbaler.no/index.phpinclude_once()2
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
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEaALLPRIMARY,id6954100.00Using where; Using temporary; Using filesort
1SIMPLEkeq_refPRIMARYPRIMARY4kanting_kanting.a.kategori_id1100.00Using index
1SIMPLEagrefPRIMARYPRIMARY4kanting_kanting.a.id1100.00Using index
1SIMPLEgeq_refPRIMARYPRIMARY4kanting_kanting.ag.gruppe_id1100.00Using where
filefunctionline
/home/kanting/public_html/pub5/php/display/Cymbaler.phpquery()403
/home/kanting/public_html/pub5/php/display/Cymbaler.phpsetCymbalfilter()37
/home/kanting/public_html/pub5/php/function/Nettside.phpsetSiteArgs()224
/home/kanting/public_html/cymbaler.no/head.phpNettside()58
/home/kanting/public_html/cymbaler.no/index.phpinclude_once()2
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'
idforeldre_idcanonical_idnavntypevisbeskrivelsekeywordstitlemetadescniva_oldnivaenhetstatusrolle_idopp_datoopp_navnendr_datoendr_navnantallnrsite_idgooglekatgoogleKatNavnprisfilKat
99000Varemerker210synlig02018-06-04 10:26:0812018-06-04 11:23:3015210
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEkategorierconstPRIMARYPRIMARY4const1100.00
filefunctionline
/home/kanting/public_html/pub5/php/function/Nettside.phpquery()226
/home/kanting/public_html/cymbaler.no/head.phpNettside()58
/home/kanting/public_html/cymbaler.no/index.phpinclude_once()2
011
SELECT
antall, type, site_id
FROM
kategorier
WHERE
id='990'
antalltypesite_id
2121
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEkategorierconstPRIMARYPRIMARY4const1100.00
filefunctionline
/home/kanting/public_html/pub5/php/display/Cymbaler.phpquery()526
/home/kanting/public_html/pub5/php/display/Cymbaler.phpshowCymbalList2()162
/home/kanting/public_html/cymbaler.no/index.phpproduktvelger()60
012
SELECT
sortering, multipleKat
FROM
kategori_typer
WHERE
id='21'
sorteringmultipleKat
idselect_typetabletypepossible_keyskeykey_lenrefrowsfilteredExtra
1SIMPLEkategori_typerconstPRIMARYPRIMARY4const1100.00
filefunctionline
/home/kanting/public_html/pub5/php/display/Cymbaler.phpquery()538
/home/kanting/public_html/pub5/php/display/Cymbaler.phpshowCymbalList2()162
/home/kanting/public_html/cymbaler.no/index.phpproduktvelger()60
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
filefunctionline
/home/kanting/public_html/pub5/php/display/Cymbaler.phpquery()678
/home/kanting/public_html/pub5/php/display/Cymbaler.phpshowCymbalList2()162
/home/kanting/public_html/cymbaler.no/index.phpproduktvelger()60
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' => 1708966138,
)
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' => '18.207.129.175',
'HTTP_X_REAL_IP' => '18.207.129.175',
'HTTP_X_REMOTE_IP' => '172.70.35.87',
'HTTP_CDN_LOOP' => 'cloudflare',
'HTTP_CF_IPCOUNTRY' => 'US',
'HTTP_CF_RAY' => '85b9adb978115ae7-IAD',
'HTTP_X_FORWARDED_PROTO' => 'https',
'HTTP_CF_VISITOR' => '{"scheme":"https"}',
'HTTP_CF_CONNECTING_IP' => '18.207.129.175',
'HTTP_X_HTTPS' => '1',
'REDIRECT_UNIQUE_ID' => 'ZdzA-pXFLtMEsLVAGzed0QAAAY0',
'REDIRECT_SCRIPT_URL' => '/varemerker',
'REDIRECT_SCRIPT_URI' => 'https://cymbaler.no/varemerker',
'REDIRECT_HTTPS' => 'on',
'REDIRECT_STATUS' => '200',
'UNIQUE_ID' => 'ZdzA-pXFLtMEsLVAGzed0QAAAY0',
'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.35.87',
'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' => '34996',
'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' => 1708966138.63202190399169921875,
'REQUEST_TIME' => 1708966138,
'argv' => 
array (
),
'argc' => 0,
)
12! / 1