SELECT * FROM news2cat WHERE IdNews = '15'
select properties of object
Všechny články Zajímavosti
Dotaz cislo:1
SELECT Name, Value FROM _config
Dotaz cislo:2
SELECT *
FROM _language
WHERE Id=1
select properties of object language
Dotaz cislo:3
SELECT *
FROM template_page2lang WHERE Domain = 'dev.ai-shop.cz'
select properties of object template_page
Dotaz cislo:4
SELECT *
FROM redirects
WHERE URLOld='clanky'
select id of inserted redirects from db
Dotaz cislo:5
SELECT *
FROM virtual_directory2lang
WHERE Name LIKE 'clanky'
select properties of object virtual_directory2lang
Dotaz cislo:6
SELECT *
FROM virtual_directory
WHERE Id=7363
select properties of object virtual_directory
Dotaz cislo:7
SELECT *
FROM virtual_directory2lang WHERE IdDirectory = 7363
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:8
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7363'
select properties of object virtual_directpry_set
Dotaz cislo:9
SELECT *
FROM _language
WHERE Id=1
select properties of object language
Dotaz cislo:10
SELECT *
FROM virtual_directory
WHERE Id=7363
select properties of object virtual_directory
Dotaz cislo:11
SELECT * FROM virtual_directory2lang
WHERE IdDirectory=7363 AND
IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:12
SELECT s.*
FROM virtual_directory_set s
WHERE s.IdDirectory = '7363'
select properties of object virtual_directpry_set
Dotaz cislo:13
SELECT *
FROM exchange
WHERE Id='37';
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsExchange.php on line 186 in method Cexchange::loadById
Dotaz cislo:14
SELECT Id, CONCAT(Name,' ',Surname) as Login,LogPassword,LogPasswordType, LogHash
FROM security_user SU
WHERE
((LogName='!Annonym') AND
Flags&1) OR
(LogHash ='' AND
Loghash IS NOT NULL AND
Loghash <>'' AND
LogHashExpire > NOW()
)
login user
Dotaz cislo:15
SELECT su.*, c.IdCostType as CostTypeId,
c.Rabat as CompanyDiscount, sct.Discount as CostTypeDiscount, c.Flags & 128=128 as CompanyIndividualPrice,
sct.ViewPriceWithVat,
a.IdState
FROM security_user su
LEFT JOIN company2user c2u ON c2u.IdUser = su.Id /*AND
c2u.IdType = 1*/
LEFT JOIN company c ON c.Id=c2u.IdCompany
LEFT JOIN address a ON a.Id=c.IdPayementAddress
LEFT JOIN shop_cost_type sct ON sct.Id=c.IdCostType
WHERE su.Id=2
ORDER BY c2u.IdType
LIMIT 0, 1
select properties of object security_user
Dotaz cislo:16
SELECT *
FROM security_user2group
WHERE IdUser=2
select groups of security_user
Dotaz cislo:17
call getRightsForUser(2, 52)
load rights
Dotaz cislo:18
SELECT *
FROM company2user WHERE (1=1) AND IdUser = '2'
select properties of object company2user
Dotaz cislo:19
SELECT *
FROM company
WHERE Id=1
select properties of object company
Dotaz cislo:20
SELECT *
FROM company2user WHERE (1=1) AND IdCompany = '1'
select properties of object company2user
Dotaz cislo:21
SELECT su.*, c.IdCostType as CostTypeId,
c.Rabat as CompanyDiscount, sct.Discount as CostTypeDiscount, c.Flags & 128=128 as CompanyIndividualPrice,
sct.ViewPriceWithVat,
a.IdState
FROM security_user su
LEFT JOIN company2user c2u ON c2u.IdUser = su.Id /*AND
c2u.IdType = 1*/
LEFT JOIN company c ON c.Id=c2u.IdCompany
LEFT JOIN address a ON a.Id=c.IdPayementAddress
LEFT JOIN shop_cost_type sct ON sct.Id=c.IdCostType
WHERE su.Id=2
ORDER BY c2u.IdType
LIMIT 0, 1
select properties of object security_user
Dotaz cislo:22
SELECT *
FROM security_user2group
WHERE IdUser=2
select groups of security_user
Dotaz cislo:23
SELECT *
FROM template_page
select properties of object template_page
Dotaz cislo:24
SELECT *
FROM template_page
WHERE Id=29
select properties of object template_page
Dotaz cislo:25
SELECT *
FROM template_page2lang
WHERE IdPage=29 AND IdLanguage=1
select properties of object template_page
AIVision, s.r.o.
Veverkova 731/19
170 00 Praha 7
IČO: 27131955
DIČ: CZ27131955
+420 233 370 498
+420 608 224 380