Links

SELECT `value` FROM `fw_var` AS `V`
INNER JOIN `fw_settings` AS `S` ON (`S`.`var_id` = `V`.id AND `V`.`key` =
"timeZone")

SELECT `L`.`id`, `V`.`value` AS `timezone` FROM `fw_country` AS `C`
LEFT JOIN `fw_var` AS `V` ON (`V`.`id` = `C`.`var_timezone_id`)
LEFT JOIN `fw_language` AS `L` ON (`L`.`id` = `C`.`language_id`)
WHERE `L`.`code` = 'nl_NL'

SELECT `P`.`id`, `PC`.`title`, `PC`.`meta_tags` , `PC`.`meta_description`
FROM `cms_page` AS `P`
INNER JOIN `cms_page_country` AS `PC` ON (`P`.`id` = `PC`.`page_id` AND
`PC`.`deleted` = "n")
INNER JOIN `fw_country` AS `C` ON (`C`.`id` = `PC`.`country_id` AND
`C`.`deleted` = "n")
WHERE LOWER(`P`.`name`) = 'links'
AND `C`.`language_id` = 1
AND `P`.`deleted` = "n"
AND `P`.`parent_page_id`= 0
ORDER BY P.id DESC

SELECT `PC`.`id`, `PCC`.`title`, `PCC`.`text`, `PCC`.`meta_tags`,
`PCC`.`meta_description`, 
`PC`.`default_img`, `PCC`.`page_content_id`
FROM `cms_page_content_country` AS `PCC`
INNER JOIN `cms_page_content` AS `PC` ON (PC.id = PCC.page_content_id AND
PC.deleted="n")
INNER JOIN `fw_country` AS `C`ON (C.id = PCC.country_id AND C.deleted="n")
WHERE `PC`.`page_id` = 54
AND `C`.`language_id` = 1
AND PCC.deleted="n"
AND (`PC`.`display_from` IS NULL OR `PC`.`display_from` < NOW())
AND (`PC`.`display_until` IS NULL OR `PC`.`display_until` > NOW())
ORDER BY `PCC`.`id` DESC

SELECT `id`, `image`
FROM `cms_page_content_image`
WHERE `page_content_id` = 83
AND `deleted` = "n" ORDER BY `image` DESC

SELECT `id`,`type`, `name`, `img`, `url`
FROM `cm_item` 
WHERE `deleted` = "n"
AND `type` = "Cattery"
ORDER BY RAND()

SELECT `id`,`type`, `name`, `img`, `url`
FROM `cm_item` 
WHERE `deleted` = "n"
AND `type` = "Anders"
ORDER BY RAND()

SELECT `id`,`type`, `name`, `img`, `url`
FROM `cm_item` 
WHERE `deleted` = "n"
AND `type` = "Cattery"
ORDER BY RAND()

SELECT `id`,`type`, `name`, `img`, `url`
FROM `cm_item` 
WHERE `deleted` = "n"
AND `type` = "Anders"
ORDER BY RAND()

SELECT `id`,`name`, `foto1`
FROM `cm_portfolio` 
WHERE deleted = "n"
AND `foto1` != ""
ORDER BY `id` DESC

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 18
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 18
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 10
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 10
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 9
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 9
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 8
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 8
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 6
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 6
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 5
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 5
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 4
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 4
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 1
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 1
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `id`, `name`, `foto1`
FROM `cm_portfolio` 
WHERE deleted = "n" 
ORDER BY `id` DESC
LIMIT 6

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 52
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 52
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 51
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 51
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 50
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 50
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 49
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 49
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 48
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 48
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 47
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT `I`.`id`, `I`.`image` FROM `cm_image` AS `I`
INNER JOIN `cm_product_image` AS `PI` ON (`PI`.`image_id` = `I`.`id` AND
`PI`.`deleted`="n")
INNER JOIN `cm_portfolio` AS `DPI` ON (`DPI`.`default_product_image_id` =
`I`.`id`)
WHERE `PI`.`product_id` = 47
AND `I`.`deleted` = "n"
LIMIT 0,1

SELECT UNIX_TIMESTAMP(`last_login`) AS `time` FROM `fw_user` WHERE `id` = 18