Database Queries

SELECT * FROM languages WHERE visible=1 ORDER BY sort_order

SELECT MAX(updated_at) FROM languages

SELECT MAX(updated_at) FROM languages

SHOW FULL COLUMNS FROM `redirects`

SELECT `kcu`.`CONSTRAINT_NAME` AS `constraint_name`, `kcu`.`COLUMN_NAME` AS `column_name`, `kcu`.`REFERENCED_TABLE_NAME` AS `referenced_table_name`, `kcu`.`REFERENCED_COLUMN_NAME` AS `referenced_column_name` FROM `information_schema`.`REFERENTIAL_CONSTRAINTS` AS `rc` JOIN `information_schema`.`KEY_COLUMN_USAGE` AS `kcu` ON ( `kcu`.`CONSTRAINT_CATALOG` = `rc`.`CONSTRAINT_CATALOG` OR (`kcu`.`CONSTRAINT_CATALOG` IS NULL AND `rc`.`CONSTRAINT_CATALOG` IS NULL) ) AND `kcu`.`CONSTRAINT_SCHEMA` = `rc`.`CONSTRAINT_SCHEMA` AND `kcu`.`CONSTRAINT_NAME` = `rc`.`CONSTRAINT_NAME` WHERE `rc`.`CONSTRAINT_SCHEMA` = database() AND `kcu`.`TABLE_SCHEMA` = database() AND `rc`.`TABLE_NAME` = 'redirects' AND `kcu`.`TABLE_NAME` = 'redirects'

SELECT * FROM `redirects` WHERE `from`='/uk/'

SELECT EXISTS(SELECT * FROM `aliases` WHERE `alias`='/uk/')

SELECT `id` FROM `page` WHERE (`catalogue`=1) AND (`visible`=1)

SELECT `alias`, `controller`, `primaryKey` FROM `aliases` WHERE (`redirectID`=0) AND (`primaryKey`='3') AND (`model`='app\\modules\\page\\models\\Page')

SELECT `alias`, `controller`, `primaryKey`, `model` FROM `aliases` WHERE (`redirectID`=0) AND (`model` IN ('common\\models\\withdrawal\\MultiCategory', 'app\\modules\\shop\\models\\Showcase'))

SELECT `a`.`alias`, `a`.`controller`, `a`.`primaryKey`, `a`.`model` FROM `aliases` `a` LEFT JOIN `category` `c` ON a.primaryKey=c.id WHERE (`redirectID`=0) AND (`c`.`object`='app\\modules\\shop\\models\\Product') AND (`model`='app\\modules\\main\\models\\Category')

SELECT `retail`, `wholesale`, `dropshipping` FROM `social_visible_price` WHERE `alias`='uk/'