Products of serie - Комплект с Яспис / Set 26 B.A. in category SILVER NECKLACES & PENDANTS

SELECT *
FROM `languages`
WHERE `abbr` = 'gallery' ?>

SELECT `name`
FROM `active_pages`
WHERE `enabled` = 1 ?>

SELECT `translations`.`name` as `lname`, `active_pages`.`name` as `pname`
FROM `active_pages`
LEFT JOIN `translations` ON `translations`.`for_id` = `active_pages`.`id`
WHERE `active_pages`.`name` IN('how-to-order', 'payment', 'delivery', 'terms-and-conditions', 'about-us', 'contacts')
AND `translations`.`abbr` = 'en'
AND `translations`.`type` = 'page' ?>

SELECT value FROM valueStore WHERE thekey = 'template' ?>

SELECT `translations`.`name`
FROM `shop_categories`
INNER JOIN `translations` ON `translations`.`for_id` = `shop_categories`.`id`
WHERE `shop_categories`.`id` = '255'
AND `translations`.`abbr` = 'en'
AND `translations`.`type` = 'shop_categorie' ?>

SELECT shop_categories.*, translations.name FROM shop_categories INNER JOIN translations ON translations.for_id = shop_categories.id WHERE translations.abbr = "en" AND sub_for = "255" AND translations.type = "shop_categorie" ORDER BY id DESC ?>

SELECT DISTINCT `translations`.`name`, `shop_categories`.`id`
FROM `translations`
INNER JOIN `shop_categories` ON `shop_categories`.`id` = `translations`.`for_id`
INNER JOIN `products` ON `products`.`shop_categorie` = `shop_categories`.`id`
WHERE `translations`.`abbr` = 'en'
AND `translations`.`type` = 'shop_categorie'
AND `products`.`serie_id` = '238'
AND `products`.`deleted` = 0
ORDER BY `id` DESC ?>

SELECT COUNT(id) as num FROM shop_categories WHERE id = 255 ANd sub_for = 0 ?>

SELECT shop_categories.*, translations.name FROM shop_categories INNER JOIN translations ON translations.for_id = shop_categories.id WHERE translations.abbr = "en" AND sub_for = "255" AND translations.type = "shop_categorie" ORDER BY order_by ASC ?>

SELECT value FROM valueStore WHERE thekey = 'outOfStock' ?>

SELECT `products`.`id`, `products`.`image`, `products`.`quantity`, `translations`.`title`, `translations`.`price`, `translations`.`old_price`, `products`.`url`
FROM `products`
LEFT JOIN `translations` ON `translations`.`for_id` = `products`.`id`
WHERE `products`.`shop_categorie` IN(255)
AND `products`.`serie_id` = '238'
AND `translations`.`abbr` = 'en'
AND `translations`.`type` = 'product'
AND `visibility` = 1
AND `deleted` = 0
ORDER BY `time` DESC
 LIMIT 20 ?>

SELECT COUNT(id) as num FROM shop_categories WHERE id = 255 ANd sub_for = 0 ?>

SELECT shop_categories.*, translations.name FROM shop_categories INNER JOIN translations ON translations.for_id = shop_categories.id WHERE translations.abbr = "en" AND sub_for = "255" AND translations.type = "shop_categorie" ORDER BY order_by ASC ?>

SELECT value FROM valueStore WHERE thekey = 'outOfStock' ?>

SELECT COUNT(*) AS `numrows`
FROM `products`
LEFT JOIN `translations` ON `translations`.`for_id` = `products`.`id`
WHERE `translations`.`abbr` = 'en'
AND `translations`.`type` = 'product'
AND `products`.`shop_categorie` IN(255)
AND `products`.`serie_id` = '238'
AND `visibility` = 1
AND `deleted` = 0 ?>

SELECT `sub_for`
FROM `shop_categories`
WHERE `id` = '255' ?>

SELECT `sub_for`
FROM `shop_categories`
WHERE `id` = '17' ?>

SELECT `shop_categories`.*, `translations`.`name`
FROM `shop_categories`
INNER JOIN `translations` ON `translations`.`for_id` = `shop_categories`.`id`
WHERE `shop_categories`.`id` IN('17')
AND `translations`.`abbr` = 'en'
AND `translations`.`type` = 'shop_categorie'
ORDER BY `id` DESC ?>

SELECT `shop_categories`.`sub_for`, `shop_categories`.`id`, `translations`.`name`, IF(shop_categories.sub_for = 0, 1, 0) as master
FROM `translations`
INNER JOIN `shop_categories` ON `shop_categories`.`id` = `translations`.`for_id`
WHERE `abbr` = 'en'
AND `type` = 'shop_categorie'
ORDER BY `shop_categories`.`order_by` ASC ?>

SELECT `shop_categories`.`id`, `translations`.`name`
FROM `translations`
INNER JOIN `shop_categories` ON `shop_categories`.`id` = `translations`.`for_id`
WHERE `abbr` = 'en'
AND `shop_categories`.`sub_for` = 0
AND `type` = 'shop_categorie'
 LIMIT 10 ?>

SELECT value FROM valueStore WHERE thekey = 'sitelogo' ?>

SELECT value FROM valueStore WHERE thekey = 'navitext' ?>

SELECT value FROM valueStore WHERE thekey = 'footercopyright' ?>

SELECT value FROM valueStore WHERE thekey = 'contactspage' ?>

SELECT value FROM valueStore WHERE thekey = 'footerContactAddr' ?>

SELECT value FROM valueStore WHERE thekey = 'footerContactPhone' ?>

SELECT value FROM valueStore WHERE thekey = 'footerContactEmail' ?>

SELECT value FROM valueStore WHERE thekey = 'footerAboutUs' ?>

SELECT value FROM valueStore WHERE thekey = 'footerSocialFacebook' ?>

SELECT value FROM valueStore WHERE thekey = 'footerSocialTwitter' ?>

SELECT value FROM valueStore WHERE thekey = 'footerSocialGooglePlus' ?>

SELECT value FROM valueStore WHERE thekey = 'footerSocialPinterest' ?>

SELECT value FROM valueStore WHERE thekey = 'footerSocialYoutube' ?>

SELECT value FROM valueStore WHERE thekey = 'addJs' ?>

SELECT value FROM valueStore WHERE thekey = 'publicQuantity' ?>

SELECT value FROM valueStore WHERE thekey = 'moreInfoBtn' ?>

SELECT * FROM languages ?>

SELECT `link`, `theme`, `message`, `button_text`, `learn_more`
FROM `cookie_law`
INNER JOIN `cookie_law_translations` ON `cookie_law_translations`.`for_id` = `cookie_law`.`id`
WHERE `cookie_law_translations`.`abbr` = 'en'
AND `cookie_law`.`visibility` = '1' ?>

Array
(
    [0] => blog
)

Array
(
)