Vratite se na ti-bih.org
(default) 2 queries took 14 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1SELECT DISTINCT `Company`.`id`, `Company`.`name` FROM `tibihdb_arhiva`.`agreements` AS `Agreement` INNER JOIN `tibihdb_arhiva`.`companies` AS `Company` ON (`Agreement`.`purchase_id` = `Company`.`id`) WHERE ((`Agreement`.`display` = 1) AND (LEFT(`Company`.`name`, 1) = 'A')) ORDER BY `Company`.`name` ASC999
2SELECT DISTINCT LEFT(Company.name, 1) as firstLetter FROM `tibihdb_arhiva`.`agreements` AS `Agreement` INNER JOIN `tibihdb_arhiva`.`companies` AS `Company` ON (`Agreement`.`purchase_id` = `Company`.`id`) WHERE `Agreement`.`display` = 1 AND NOT (LEFT(`Company`.`name`, 1) IN ('1', '2', '3', '4', '5', '6', '7', '8', '9', '0')) ORDER BY `Company`.`name` ASC19195