| 1 |
SELECT
SQL_CALC_FOUND_ROWS
`Configuration`.`id`,
`s_byusers` AS `Configuration__created_by_user`,
`s_public` AS `Configuration__public`,
`s_done` AS `Configuration__state`,
`s_jmeno` AS `Configuration__name`,
`s_email` AS `Configuration__email`,
`cislo_objednavky`,
`konecna_cena_vat` AS `Configuration__price_vat`,
FLOOR(konecna_cena_vat / 1.21) AS `Configuration__price_no_vat`,
`dph` AS `Configuration__vat`,
`marze_novat` AS `Configuration__margin_no_vat`,
`modified`,
`secret`,
(
SELECT
GROUP_CONCAT(`PcComponent`.`nazev` ORDER BY `priorita` SEPARATOR ", ")
FROM `komponenty` AS `PcComponent`
JOIN `sestava_komponenta` AS `SestavaKomponentum` ON (
`SestavaKomponentum`.`idecko` = `PcComponent`.`id`
)
JOIN `kategorie` ON (
`kategorie`.`id` = `PcComponent`.`kategorie`
)
WHERE
`SestavaKomponentum`.`master` = `Configuration`.`id`
AND `k_deleted` = "0"
AND `PcComponent`.`kategorie` IN (15,18,19,20)
) AS `Configuration__components`,
`ConfigurationCategory`.`wk_id` AS `ConfigurationCategory__id`,
`ConfigurationCategory`.`wk_title` AS `ConfigurationCategory__title`,
`ConfigurationCategory`.`label`
FROM `sestava` AS `Configuration`
LEFT JOIN `webkat` AS `ConfigurationCategory` ON (
`Configuration`.`configuration_category_id` = `ConfigurationCategory`.`wk_id`
)
WHERE `Configuration`.`s_public` = 1 AND `Configuration`.`s_done` = 1
ORDER BY `Configuration`.`id` DESC LIMIT 4100,20 | | 20 | 20 | 29 |
| 4 | SELECT `Composer`.`ws_order`, (ws_id) AS `Composer__id`, (ws_name) AS `Composer__title`, `Composer`.`ws_kat` FROM `xcompute2`.`webses` AS `Composer` WHERE `public` = '1' AND `Composer`.`ws_kat` IN (7, 22, 6, 15, 24, 23, 5, 25) ORDER BY `ws_order` ASC | | 21 | 21 | 1 |
