Welcome to Read Naturally

connect

SELECT `rn_DLanguage`.* FROM `rn_DLanguage` WHERE (`enabled` = "y") ORDER BY `def` ASC, `sorter` ASC

SELECT MAX(id) AS `maxId`, COUNT(*) AS `count` FROM `rn_Log` AS `Log`

SELECT `rn_DPageOption`.`name`, `rn_DPageOption`.`value` FROM `rn_DPageOption` ORDER BY `sorter` ASC

SELECT `rn_DPageOption`.`name`, `rn_DPageOption`.`title`, `rn_DPageOption`.`show`, `rn_DPageOption`.`value` FROM `rn_DPageOption` ORDER BY `sorter` ASC

SELECT `Page`.*, IFNULL(`c`.`title`, `cDef`.`title`) AS title, IFNULL( `c`.`menuTitle`, `cDef`.`menuTitle` ) AS menuTitle, IFNULL(`c`.`header`, `cDef`.`header`) AS header, IF( `dp`.`id` IS NOT NULL AND `dp`.`added` <> `dp`.`changed`, 'y', 'n' ) AS `hasDraft` FROM `rn_Page` AS `Page` INNER JOIN `rn_PageContent` AS `cDef` ON `cDef`.`idPage` = `Page`.`id` AND `cDef`.`language` = 'eng' LEFT JOIN `rn_PageContent` AS `c` ON `c`.`idPage` = `Page`.`id` AND `c`.`language` = 'eng' LEFT JOIN `rn_DraftPage` AS `dp` ON `dp`.`id` = `Page`.`id` WHERE (`Page`.`alias` IS NOT NULL) ORDER BY `Page`.`idParent` ASC, `Page`.`sorter` ASC

SELECT `rn_PageOption`.* FROM `rn_PageOption`

SELECT `PageItemConfig`.* FROM `rn_PageItemConfig` AS `PageItemConfig`

SELECT `PageItem`.* FROM `rn_PageItem` AS `PageItem` ORDER BY `PageItem`.`idPage` ASC, `PageItem`.`sorter` ASC

SELECT `rn_Page`.* FROM `rn_Page` WHERE ( ( (`rn_Page`.`id` = 1) ) )

SELECT `rn_PageContent`.* FROM `rn_PageContent` WHERE (idPage = '1') AND (language = 'eng')

SELECT `i`.*, `g`.`title` AS `groupTitle`, `g`.`name` AS `groupName` FROM `rn_PageItem` AS `i` INNER JOIN `rn_DPageItemGroup` AS `g` ON g.id = i.idGroup WHERE (`i`.idPage = 1) ORDER BY `g`.`sorter` ASC, `i`.`sorter` ASC

SELECT `PageItemConfig`.`idItem`, `PageItemConfig`.`name`, `PageItemConfig`.`value` FROM `rn_PageItemConfig` AS `PageItemConfig` WHERE ( `PageItemConfig`.`idItem` IN (12305, 12304) ) ORDER BY `PageItemConfig`.`id` ASC

SELECT `Product`.*, IF ( `Product`.`image` IS NULL, ( SELECT `ProductImage`.`image` FROM `rn_ProductImage` AS `ProductImage` WHERE ( `ProductImage`.`productId` = `Product`.`id` ) AND (`ProductImage`.`enabled` = "y") AND ( `ProductImage`.`itemType` = 'image' ) ORDER BY `ProductImage`.`sorter` ASC LIMIT 1 ), `Product`.`image` ) AS `image`, `ProductCategory`.`title` AS `categoryTitle`, `ProductCategory`.`typeId` AS `categoryType` FROM `rn_Product` AS `Product` INNER JOIN `rn_ProductCategory` AS `ProductCategory` ON `Product`.`categoryId` = `ProductCategory`.`id` WHERE (`Product`.`enabled` = "y") AND ( `ProductCategory`.`typeId` = 'customizedCoaching' ) ORDER BY `sorter` ASC

SELECT `ps`.`productId`, `s`.`title`, `s`.`image` FROM `rn_ProductSkill` AS `ps` INNER JOIN `rn_Skill` AS `s` ON `s`.`id` = `ps`.`skillId` WHERE ( `ps`.`productId` IN(175, 176, 31) ) AND (`ps`.`skillType` = 'primary') ORDER BY `s`.`sorter` ASC

SELECT `ps`.`productId`, `s`.`title`, `s`.`image` FROM `rn_ProductSkill` AS `ps` INNER JOIN `rn_Skill` AS `s` ON `s`.`id` = `ps`.`skillId` WHERE ( `ps`.`productId` IN(175, 176, 31) ) AND (`ps`.`skillType` = 'secondary') ORDER BY `s`.`sorter` ASC

SELECT `WideSlide`.* FROM `rn_WideSlide` AS `WideSlide` WHERE (`WideSlide`.`enabled` = "y") ORDER BY `sorter` ASC

SELECT `h`.*, `c`.* FROM `rn_HtmlBlock` AS `h` LEFT JOIN `rn_HtmlBlockContent` AS `c` ON `c`.`idBlock` = `h`.`id` AND `c`.`language` = 'eng' WHERE (`h`.`id` = 10319)

SELECT `SideBlock`.* FROM `rn_SideBlock` AS `SideBlock` INNER JOIN `rn_SideBlock2Page` AS `SideBlock2Page` ON ( `SideBlock2Page`.`idSideBlock` = `SideBlock`.`id` ) AND (`SideBlock2Page`.`idPage` = '1') AND ( `SideBlock2Page`.`auto` = IF( `SideBlock`.`pageType` = 'all', 'y', 'n' ) ) INNER JOIN `rn_Page` AS `Page` ON `Page`.`id` = `SideBlock2Page`.`idPage` AND `Page`.`showSideBlock` = 'y' WHERE (`SideBlock`.`show` = 'y') ORDER BY `SideBlock2Page`.`sorter` ASC

SELECT `Challenge`.* FROM `rn_Challenge` AS `Challenge` WHERE (`enabled` = "y") ORDER BY `sorter` ASC LIMIT 20

SELECT COUNT(1) AS `zend_paginator_row_count` FROM `rn_Challenge` AS `Challenge` WHERE (`enabled` = "y") LIMIT 20

SELECT `Settings`.`name`, `Settings`.`value`, `Settings`.`fieldType`, `Settings`.`options` FROM `rn_Settings` AS `Settings` INNER JOIN `rn_SettingsCategory` AS `sc` ON `sc`.`id` = `Settings`.`idCategory` ORDER BY `Settings`.`sorter` ASC

SELECT `Settings`.`name`, `Settings`.`changed`, `Settings`.`fieldType`, `Settings`.`options` FROM `rn_Settings` AS `Settings` INNER JOIN `rn_SettingsCategory` AS `sc` ON `sc`.`id` = `Settings`.`idCategory` ORDER BY `Settings`.`sorter` ASC

SELECT `ProductReview`.*, `Product`.`alias` AS `productAlias`, `Product`.`title` AS `productTitle` FROM `rn_ProductReview` AS `ProductReview` INNER JOIN `rn_Product` AS `Product` ON `ProductReview`.`productId` = `Product`.`id` WHERE ( `ProductReview`.`statusId` = 'approved' ) AND (`ProductReview`.`featured` = "y") AND ( `ProductReview`.`parentId` IS NULL ) AND (`Product`.`enabled` = "y") ORDER BY `added` DESC LIMIT 10

SELECT `Product`.* FROM `rn_Product` AS `Product` WHERE (`Product`.`id` = 170)

SELECT `ps`.`skillId` FROM `rn_ProductSkill` AS `ps` WHERE (`ps`.`productId` = 170) AND (`ps`.`skillType` = 'primary')

SELECT `ps`.`skillId` FROM `rn_ProductSkill` AS `ps` WHERE (`ps`.`productId` = 170) AND (`ps`.`skillType` = 'secondary')

SELECT `pc`.* FROM `rn_ProductContent` AS `pc` LEFT JOIN `rn_ProductPricingGroup` AS `ppg` ON `pc`.`groupId` = `ppg`.`id` WHERE (`pc`.`productId` = 170) AND (`pc`.`enabled` = "y") ORDER BY `pc`.`sorter` ASC, `ppg`.`sorter` ASC

SELECT `pp`.* FROM `rn_ProductPricing` AS `pp` LEFT JOIN `rn_ProductPricingGroup` AS `ppg` ON `pp`.`groupId` = `ppg`.`id` WHERE (`pp`.`productId` = 170) ORDER BY `ppg`.`sorter` ASC, `pp`.`sorter` ASC

SELECT `p`.`id`, `p`.`categoryId`, `p`.`title` FROM `rn_Product` AS `p` INNER JOIN `rn_ProductRelated` AS `pr` ON `p`.`id` = `pr`.`productId` WHERE (`pr`.`relatedId` = 170) AND (`pr`.`required` = 'y')

SELECT `p`.`id`, `p`.`categoryId`, `p`.`title` FROM `rn_Product` AS `p` INNER JOIN `rn_ProductRelated` AS `pr` ON `p`.`id` = `pr`.`productId` WHERE (`pr`.`relatedId` = 170) AND (`pr`.`required` = 'n')

SELECT `ProductImage`.*, `ht`.`itemType` AS `howToType`, `ht`.`youtubeUrl` AS `howToYoutubeUrl`, `ht`.`youtubeId` AS `howToYoutubeId`, `ht`.`videoThumbnail` AS `howToVideoThumbnail`, `ht`.`video` AS `howToVideo`, `ht`.`videoResolutionX` AS `howToVideoResolutionX`, `ht`.`videoResolutionY` AS `howToVideoResolutionY` FROM `rn_ProductImage` AS `ProductImage` LEFT JOIN `rn_Kb2Article` AS `ht` ON `ht`.`id` = `ProductImage`.`howtoVideoId` WHERE (`productId` = 170) AND (`ProductImage`.`enabled` = 'y') ORDER BY `sorter` ASC

SELECT `Post`.*, ( SELECT COUNT(id) FROM `rn_PostComment` AS `PostComment` WHERE ( `PostComment`.`idPost` = `Post`.`id` ) AND ( `PostComment`.`status` = "approved" ) ) AS `countComments`, `PostCategory`.`title` AS `categoryTitle`, `PostCategory`.`alias` AS `categoryAlias`, `PostCategory`.`enabled` AS `categoryEnabled` FROM `rn_Post` AS `Post` INNER JOIN `rn_PostCategory` AS `PostCategory` ON `PostCategory`.`id` = `Post`.`categoryId` WHERE (`Post`.`featured` = 'y') AND (`Post`.`enabled` = "y") AND (`PostCategory`.`enabled` = "y") AND ( `Post`.`date` <= '2024-09-16 00:40:54' ) ORDER BY `date` DESC LIMIT 3

SELECT `Post2Tag`.`idPost`, `Post2Tag`.`idTag`, `PostTag`.`value` FROM `rn_Post2Tag` AS `Post2Tag` INNER JOIN `rn_PostTag` AS `PostTag` ON `Post2Tag`.`idTag` = `PostTag`.`id` WHERE ( `idPost` IN (561, 563, 609) ) ORDER BY `PostTag`.`usageCount` DESC, `PostTag`.`value` ASC

SELECT `SocialLink`.* FROM `rn_SocialLink` AS `SocialLink` WHERE (`SocialLink`.`enabled` = "y") ORDER BY `sorter` ASC

SELECT `rn_DContactReason`.`id`, `rn_DContactReason`.`title` FROM `rn_DContactReason` ORDER BY `sorter` ASC

SELECT `h`.*, `c`.* FROM `rn_HtmlBlock` AS `h` LEFT JOIN `rn_HtmlBlockContent` AS `c` ON `c`.`idBlock` = `h`.`id` AND `c`.`language` = 'eng' WHERE (`h`.`id` = 4554)

INSERT INTO `rn_Cart` (`added`, `changed`) VALUES (?, ?)

SELECT SUM(`quantity`) FROM `rn_Cart` AS `Cart` INNER JOIN `rn_CartItem` AS `CartItem` ON `CartItem`.`cartId` = `Cart`.`id` LEFT JOIN `rn_CartItemPromo` AS `CartItemPromo` ON `CartItemPromo`.`cartId` = `Cart`.`id` AND `CartItem`.`itemId` = `CartItemPromo`.`productId` LEFT JOIN `rn_Product` AS `p` ON `p`.`id` = `CartItem`.`itemId` AND `CartItem`.`itemType` = 'ECommerce_Product_' LEFT JOIN `rn_ProductCategory` AS `pc` ON `p`.`categoryId` = `pc`.`id` LEFT JOIN `rn_ProductCategoryType` AS `pct` ON `pc`.`typeId` = `pct`.`id` AND `pct`.`changeQuantity` = "y" LEFT JOIN `rn_Seminar` AS `s` ON `s`.`id` = `CartItem`.`itemId` AND `CartItem`.`itemType` = 'Seminar\\' WHERE (`Cart`.id = 43493156)

SELECT `Strip`.* FROM `rn_Strip` AS `Strip` INNER JOIN `rn_Strip2Page` AS `Strip2Page` ON ( `Strip2Page`.`stripId` = `Strip`.`id` ) AND (`Strip2Page`.`pageId` = '1') INNER JOIN `rn_Page` AS `Page` ON `Page`.`id` = `Strip2Page`.`pageId` WHERE (`Strip`.`enabled` = 'y') ORDER BY `Strip2Page`.`sorter` ASC

SELECT DISTINCT `Product`.`id`, `Product`.`alias`, `Product`.`title`, `Product`.`categoryId` FROM `rn_Product` AS `Product` INNER JOIN `rn_ProductCategory` AS `ProductCategory` ON `Product`.`categoryId` = `ProductCategory`.`id` WHERE (`Product`.`enabled` = "y") AND ( `ProductCategory`.`typeId` = 'program' ) AND (`showInFooter` = "y") AND ( `Product`.`categoryId` IN (1, 2) ) ORDER BY `Product`.`sorter` ASC