Piano Sojo | Venta de Pianos Costa Rica

Filtros

2 resultados - mostrando 1 - 2

Ordenar

Steinway & Sons Popular

0 7

Fabricado en Estados Unidos, New York Con sistema PianoDisc

Yamaha

0 1

$8500 incluye transporte y la afinación en el área metropolitana.

2 resultados - mostrando 1 - 2

S2Framework Debug Console

Database Queries (43)

SHOW TABLES LIKE 'e1xlz_jreviews_config'

SELECT value FROM e1xlz_jreviews_config WHERE id IN ('community','debug_overrides_disable')

SHOW TABLES LIKE 'e1xlz_jreviews_addons'

SELECT name FROM e1xlz_jreviews_addons WHERE state = 1 ORDER BY ordering

SET SQL_BIG_SELECTS=1

SHOW TABLES LIKE '%_jreviews_config'

SELECT value FROM e1xlz_jreviews_config WHERE id = 'cms_secret'

SELECT name FROM e1xlz_jreviews_addons WHERE state = 1 ORDER BY ordering

SELECT ListingType.id AS `ListingType.listing_type_id`, ListingType.title AS `ListingType.title`, ListingType.groupid AS `ListingType.group_id`, ListingType.state AS `ListingType.state`, ListingType.search AS `ListingType.search`, ListingType.config AS `ListingType.config` FROM e1xlz_jreviews_criteria AS ListingType

SELECT CriteriaRating.criteria_id AS `CriteriaRating.criteria_id`, CriteriaRating.title AS `CriteriaRating.title`, CriteriaRating.required AS `CriteriaRating.required`, CriteriaRating.weight AS `CriteriaRating.weight`, CriteriaRating.description AS `CriteriaRating.description`, CriteriaRating.listing_type_id AS `CriteriaRating.listing_type_id`, CriteriaRating.ordering AS `CriteriaRating.ordering`, ListingType.state AS `CriteriaRating.listing_type_state` FROM e1xlz_jreviews_criteria_ratings AS CriteriaRating LEFT JOIN e1xlz_jreviews_criteria AS ListingType ON ListingType.id = CriteriaRating.listing_type_id WHERE 1 = 1 AND ( CriteriaRating.listing_type_id IN (1) ) ORDER BY CriteriaRating.ordering

SELECT * FROM e1xlz_jreviews_config AS `Config`

INSERT INTO e1xlz_jreviews_config ( id, value ) VALUES ('cms_secret','FiuJaP7SPVx66op5') ON DUPLICATE KEY UPDATE value = VALUES(value)

INSERT INTO e1xlz_jreviews_config ( id, value ) VALUES ('last_cache_clean','1734865955') ON DUPLICATE KEY UPDATE value = VALUES(value)

DELETE FROM e1xlz_jreviews_registration WHERE session_time < 1734862355

INSERT INTO e1xlz_jreviews_config ( id, value ) VALUES ('ranks_rebuild_last','1734865955') ON DUPLICATE KEY UPDATE value = VALUES(value)

SELECT Review.id FROM e1xlz_jreviews_comments as Review WHERE Review.mode = "com_content" AND Review.pid NOT IN ( SELECT id from e1xlz_content )

DELETE FROM e1xlz_jreviews_reviewer_ranks WHERE user_id = 0 OR user_id NOT IN ( SELECT userid FROM e1xlz_jreviews_comments WHERE published = 1 ) OR user_id NOT IN ( SELECT id FROM e1xlz_users WHERE block = 0 )

INSERT INTO e1xlz_jreviews_reviewer_ranks (user_id, reviews, votes_percent_helpful, votes_total) ( SELECT userid AS user_id, COUNT(*) AS reviews, (IF(SUM(vote_total)>0,SUM(vote_helpful)/SUM(vote_total),0)) AS votes_percent_helpful, SUM(vote_total) AS votes_total FROM e1xlz_jreviews_comments AS Review RIGHT JOIN e1xlz_users AS User ON User.id = Review.userid AND User.block = 0 WHERE userid > 0 AND published = 1 GROUP BY userid ORDER BY NULL ) ON DUPLICATE KEY UPDATE reviews = VALUES(reviews), votes_percent_helpful = VALUES(votes_percent_helpful), votes_total = VALUES(votes_total);

INSERT INTO e1xlz_jreviews_reviewer_ranks (user_id, `rank`) ( SELECT user_id, @curRank := @curRank + 1 AS `rank` FROM e1xlz_jreviews_reviewer_ranks, (SELECT @curRank := 0) r ORDER BY reviews DESC, votes_percent_helpful DESC ) ON DUPLICATE KEY UPDATE `rank` = VALUES(`rank`);

INSERT INTO e1xlz_jreviews_config ( id, value ) VALUES ('media_likes_rebuild_last','1734865955') ON DUPLICATE KEY UPDATE value = VALUES(value)

INSERT INTO e1xlz_jreviews_media (media_id, likes_up, likes_total) (SELECT media_id AS media_id, SUM(IF(vote = 1, 1, 0)) AS likes_up, COUNT(*) AS likes_total FROM e1xlz_jreviews_media_likes GROUP BY media_id ORDER BY NULL ) ON DUPLICATE KEY UPDATE likes_up = VALUES(likes_up), likes_total = VALUES(likes_total);

SELECT @max_likes := MAX(likes_total) FROM e1xlz_jreviews_media;

INSERT INTO e1xlz_jreviews_media (media_id, likes_rank) (SELECT media_id AS media_id, (SUM(IF(vote = 1, 1,0))/COUNT(*)) * (COUNT(*)/@max_likes) * 16000000 AS likes_rank FROM e1xlz_jreviews_media_likes GROUP BY media_id ORDER BY NULL ) ON DUPLICATE KEY UPDATE likes_rank = VALUES(likes_rank);

SELECT path FROM e1xlz_categories WHERE id IN ('10')

SELECT ParentCategory.id AS `Category.cat_id`, ParentCategory.lft AS `Category.lft`, ParentCategory.title AS `Category.title`, IF(JreviewsCategory.page_title <> '',JreviewsCategory.page_title,ParentCategory.title) AS `Category.title_seo`, JreviewsCategory.title_override AS `Category.title_override`, ParentCategory.alias AS `Category.slug`, ParentCategory.description AS `Category.description`, ParentCategory.level AS `Category.level`, ParentCategory.published AS `Category.published`, ParentCategory.access AS `Category.access`, ParentCategory.params AS `Category.params`, ParentCategory.parent_id AS `Category.parent_id`, ParentCategory.metadesc AS `Category.metadesc`, ParentCategory.metakey AS `Category.metakey`, IF(ParentCategory.metadesc <> '' AND JreviewsCategory.desc_override =1,ParentCategory.metadesc,ParentCategory.description) AS `Category.description`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, JreviewsCategory.dirid AS `Directory.dir_id`, Directory.slug AS `Directory.slug`, Directory.title AS `Directory.title`, Directory.description AS `Directory.description` FROM e1xlz_categories AS ParentCategory INNER JOIN e1xlz_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = ParentCategory.id AND JreviewsCategory.`option` = 'com_content' LEFT JOIN e1xlz_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id WHERE ParentCategory.path IN ( 'frontpage-blog') ORDER BY ParentCategory.lft

SELECT level, path FROM e1xlz_categories WHERE id = 10

SELECT Category.path FROM e1xlz_categories AS Category WHERE Category.extension = "com_content" AND Category.access NOT IN ( 1)

SELECT Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.path AS `Category.path`, IF(CategoryListingCount.listing_count > 0,CategoryListingCount.listing_count,0) AS `Category.listing_count`, Category.alias AS `Category.slug`, Category.description AS `Category.description`, Category.level AS `Category.level`, Category.params AS `Category.params`, Category.parent_id AS `Category.parent_id`, Category.metadesc AS `Category.metadesc`, Category.metakey AS `Category.metakey`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, JreviewsCategory.tmpl AS `Category.tmpl`, JreviewsCategory.tmpl_suffix AS `Category.tmpl_suffix`, Directory.id AS `Directory.dir_id`, Directory.slug AS `Directory.slug`, Directory.title AS `Directory.title`, Directory.description AS `Directory.description` FROM e1xlz_categories AS Category LEFT JOIN ( SELECT ParentCategory.id, COUNT(Listing.id) as listing_count FROM e1xlz_categories AS Category, e1xlz_categories AS ParentCategory, e1xlz_content AS Listing WHERE Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND Category.id IN (SELECT id FROM e1xlz_jreviews_categories WHERE `option` = "com_content") AND Category.id = Listing.catid AND Category.extension = "com_content" AND Category.level > 0 AND (Category.path = "frontpage-blog" OR Category.path LIKE "frontpage-blog/%") AND Listing.state = 1 AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP) GROUP BY ParentCategory.id ) AS CategoryListingCount ON CategoryListingCount.id = Category.id INNER JOIN e1xlz_jreviews_categories AS JreviewsCategory ON Category.id = JreviewsCategory.id AND JreviewsCategory.option = "com_content" LEFT JOIN e1xlz_jreviews_directories AS Directory ON JreviewsCategory.dirid = Directory.id WHERE 1 = 1 AND ( Category.published = 1 AND Category.extension = "com_content" AND (Category.path = "frontpage-blog" OR Category.path LIKE "frontpage-blog/%") AND Category.level <= 2 ) ORDER BY Category.lft # Removed directory from order by because it makes the query SLOW # Instead we run a much faster query below to re-order the output array

SELECT count(DISTINCT groupid) FROM e1xlz_jreviews_criteria WHERE groupid != ''

SELECT groupid FROM e1xlz_jreviews_groups WHERE groupid IN (1) AND type = 'content'

SELECT Field.fieldid, Field.title AS text, Field.name AS value, Field.access_view AS access FROM e1xlz_jreviews_fields AS Field WHERE Field.location = 'content' AND Field.listsort = 1 AND Field.groupid IN (1)

SELECT Category.id FROM e1xlz_categories AS Category, e1xlz_categories AS ParentCategory WHERE Category.published >= 0 AND Category.extension = "com_content" AND Category.access IN ( 1) AND Category.lft BETWEEN ParentCategory.lft AND ParentCategory.rgt AND ParentCategory.id = 10

SELECT id FROM e1xlz_jreviews_categories WHERE `option` = "com_content"

SELECT Listing.id AS `Listing.listing_id`, Listing.alias AS `Listing.slug`, Listing.title AS `Listing.title`, Listing.introtext AS `Listing.summary`, Listing.fulltext AS `Listing.description`, Listing.images AS `Listing.images`, Listing.hits AS `Listing.hits`, Listing.catid AS `Listing.cat_id`, Listing.created_by AS `Listing.user_id`, Listing.created_by_alias AS `Listing.author_alias`, Listing.created AS `Listing.created`, Listing.modified AS `Listing.modified`, Listing.access AS `Listing.access`, Listing.state AS `Listing.state`, Listing.publish_up AS `Listing.publish_up`, Listing.publish_down AS `Listing.publish_down`, Listing.metakey AS `Listing.metakey`, Listing.metadesc AS `Listing.metadesc`, 'com_content' AS `Listing.extension`, Field.featured AS `Listing.featured`, JreviewsCategory.criteriaid AS `ListingType.listing_type_id`, Category.id AS `Category.cat_id`, Category.title AS `Category.title`, Category.alias AS `Category.slug`, Category.access AS `Category.access`, Category.params AS `Category.params`, Directory.id AS `Directory.dir_id`, Directory.title AS `Directory.title`, Directory.slug AS `Directory.slug`, User.id AS `User.user_id`, User.name AS `User.name`, User.username AS `User.username`, User.email AS `User.email`, User.block AS `User.block`, Claim.approved AS `Claim.approved`, Totals.user_rating AS `Review.user_rating`, Totals.user_rating_count AS `Review.user_rating_count`, Totals.user_criteria_rating AS `Review.user_criteria_rating`, Totals.user_criteria_rating_count AS `Review.user_criteria_rating_count`, Totals.user_comment_count AS `Review.user_review_count`, Totals.editor_rating AS `Review.editor_rating`, Totals.editor_rating_count AS `Review.editor_rating_count`, Totals.editor_criteria_rating AS `Review.editor_criteria_rating`, Totals.editor_criteria_rating_count AS `Review.editor_criteria_rating_count`, Totals.editor_comment_count AS `Review.editor_review_count`, Totals.media_count AS `Listing.media_count`, Totals.video_count AS `Listing.video_count`, Totals.photo_count AS `Listing.photo_count`, Totals.audio_count AS `Listing.audio_count`, Totals.attachment_count AS `Listing.attachment_count`, (Totals.media_count - Totals.media_count_user) AS `Listing.media_count_owner`, (Totals.video_count - Totals.video_count_user) AS `Listing.video_count_owner`, (Totals.photo_count - Totals.photo_count_user) AS `Listing.photo_count_owner`, (Totals.audio_count - Totals.audio_count_user) AS `Listing.audio_count_owner`, (Totals.attachment_count - Totals.attachment_count_user) AS `Listing.attachment_count_owner`, Totals.media_count_user AS `Listing.media_count_user`, Totals.video_count_user AS `Listing.video_count_user`, Totals.photo_count_user AS `Listing.photo_count_user`, Totals.audio_count_user AS `Listing.audio_count_user`, Totals.attachment_count_user AS `Listing.attachment_count_user` FROM e1xlz_jreviews_content AS Field USE KEY (featured) LEFT JOIN e1xlz_content AS Listing ON Field.contentid = Listing.id LEFT JOIN e1xlz_jreviews_listing_totals AS Totals ON Totals.listing_id = Listing.id AND Totals.extension = 'com_content' LEFT JOIN e1xlz_jreviews_categories AS JreviewsCategory ON JreviewsCategory.id = Listing.catid AND JreviewsCategory.`option` = 'com_content' LEFT JOIN e1xlz_categories AS Category ON Category.id = Listing.catid AND Category.extension = 'com_content' LEFT JOIN e1xlz_jreviews_directories AS Directory ON Directory.id = JreviewsCategory.dirid LEFT JOIN e1xlz_users AS User ON User.id = Listing.created_by LEFT JOIN e1xlz_jreviews_claims AS Claim ON Claim.listing_id = Listing.id AND Claim.user_id = Listing.created_by AND Claim.approved = 1 WHERE 1 = 1 AND ( Listing.catid IN (10) AND Listing.state = 1 AND Listing.access IN ( 1) AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP) ) ORDER BY Field.featured DESC, Field.contentid DESC LIMIT 10

SELECT path FROM e1xlz_categories WHERE id = 10

SELECT id AS cat_id, lft FROM e1xlz_categories WHERE path IN ( 'frontpage-blog')

SELECT Field.fieldid AS `Field.field_id`, Field.groupid AS `Field.group_id`, Field.name AS `Field.name`, Field.title AS `Field.title`, Field.showtitle AS `Field.showTitle`, Field.description AS `Field.description`, Field.required AS `Field.required`, Field.type AS `Field.type`, Field.location AS `Field.location`, Field.options AS `Field.params`, Field.contentview AS `Field.contentView`, Field.listview AS `Field.listView`, Field.compareview AS `Field.compareView`, Field.listsort AS `Field.listSort`, Field.search AS `Field.search`, Field.access AS `Field.access`, Field.access_view AS `Field.accessView`, Field.published As `Field.published`, Field.ordering AS `Field.ordering`, `Group`.groupid AS `Group.group_id`, `Group`.title AS `Group.title`, `Group`.name AS `Group.name`, `Group`.showtitle AS `Group.showTitle`, `Group`.ordering AS `Group.ordering`, `Group`.control_field AS `Group.control_field`, `Group`.control_value AS `Group.control_value` FROM e1xlz_jreviews_fields AS Field LEFT JOIN e1xlz_jreviews_groups AS `Group` ON `Group`.groupid = Field.groupid WHERE Field.published = 1 AND Field.location = 'content' AND Field.groupid IN ( 1)

SELECT Listing.contentid AS element_id,jr_marca,jr_numerodeserie,jr_ano,jr_precio FROM e1xlz_jreviews_content AS Listing WHERE Listing.contentid IN (67,66)

SELECT content_id AS listing_id, count(*) AS favored FROM e1xlz_jreviews_favorites AS Favorite WHERE Favorite.content_id IN (67,66) GROUP BY listing_id

SELECT media.media_id, media.media_type, media.media_function, media.likes_rank, media.likes_up, media.likes_total, media.created, media.main_media, media.listing_id, media.review_id, media.user_id, media.filename, media.file_extension, media.rel_path, media.title, media.description, media.media_info, media.metadata, media.embed, media.published, media.approved, media.access, media.views, media.filesize, media.extension FROM e1xlz_jreviews_media AS media WHERE listing_id IN (67,66) AND published = 1 AND approved = 1 AND access IN (1) AND main_media = 1

SELECT COUNT(*) FROM e1xlz_jreviews_content AS Field LEFT JOIN e1xlz_content AS Listing ON Field.contentid = Listing.id WHERE 1 = 1 AND ( Listing.catid IN (10) AND Listing.state = 1 AND Listing.access IN ( 1) AND ( Listing.publish_up IS NULL OR Listing.publish_up <= UTC_TIMESTAMP ) AND (Listing.publish_down IS NULL OR Listing.publish_down = 0 OR Listing.publish_down > UTC_TIMESTAMP) )

SELECT Directory.id AS `Directory.dir_id`, Directory.slug AS `Directory.slug`, Directory.slug AS `Directory.name`, Directory.title AS `Directory.title`, Directory.description AS `Directory.description`, Directory.tmpl_suffix AS `Directory.tmpl_suffix` FROM e1xlz_jreviews_directories AS Directory WHERE 1 = 1 AND ( Directory.id = 1 )

Bienvenido a la tienda Piano Sojo, en esta sección encontrará Pianos que se encuentran en venta en Costa Rica

Acceso

S2Framework Debug Console

Database Queries (43)