WordPress-ის მონაცემთა ბაზის შეცდომა: [Not unique table/alias: 'tb']
SELECT SQL_CALC_FOUND_ROWS wp_posts.*, min(CAST(tb2.min_price as DECIMAL)) as st_price
FROM wp_posts JOIN wp_icl_translations wpml_translations
ON wp_posts.ID = wpml_translations.element_id
AND wpml_translations.element_type = CONCAT('post_', wp_posts.post_type) INNER JOIN wp_st_hotel as tb2 ON wp_posts.ID = tb2.post_id INNER JOIN wp_st_tours as tb ON wp_posts.ID = tb.post_id INNER JOIN wp_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wp_st_tours as tb_st_tours ON wp_posts.ID = tb_st_tours.post_id INNER JOIN wp_st_activity as tb ON wp_posts.ID = tb.post_id INNER JOIN wp_postmeta as tb_postmeta ON tb.post_id = tb_postmeta.post_id AND tb_postmeta.meta_key = 'discount_type' INNER JOIN wp_st_activity as tb_st_activity ON wp_posts.ID = tb_st_activity.post_id
WHERE 1=1 AND ((wp_posts.post_type = 'st_activity' AND (wp_posts.post_status = 'publish'))) AND ( ( ( wpml_translations.language_code = 'ka' OR (
wpml_translations.language_code = 'en'
AND wp_posts.post_type IN ( 'e-landing-page','elementor_library' )
AND ( (
( SELECT COUNT(element_id)
FROM wp_icl_translations
WHERE trid = wpml_translations.trid
AND language_code = 'ka'
) = 0
) OR (
( SELECT COUNT(element_id)
FROM wp_icl_translations t2
JOIN wp_posts p ON p.id = t2.element_id
WHERE t2.trid = wpml_translations.trid
AND t2.language_code = 'ka'
AND (
p.post_status = 'publish' OR
p.post_type='attachment' AND p.post_status = 'inherit'
)
) = 0 ) )
) ) AND wp_posts.post_type IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','product','product_variation','shop_order','shop_order_refund','shop_coupon','shop_order_placehold','st_hotel','hotel_room','st_activity','st_tours','wpcf7_contact_form','mc4wp-form','location','st_order','st_coupon_code' ) ) OR wp_posts.post_type NOT IN ('post','page','attachment','wp_block','wp_template','wp_template_part','wp_navigation','e-landing-page','elementor_library','product','product_variation','shop_order','shop_order_refund','shop_coupon','shop_order_placehold','st_hotel','hotel_room','st_activity','st_tours','wpcf7_contact_form','mc4wp-form','location','st_order','st_coupon_code' ) ) AND wp_posts.ID IN (SELECT post_id FROM wp_st_location_relationships WHERE 1=1 AND location_from IN ('15926') AND post_type IN ('st_hotel')) AND CAST(tb2.hotel_booking_period AS UNSIGNED) <= 0 AND wp_posts.ID IN (SELECT post_id FROM wp_st_location_relationships WHERE 1=1 AND location_from IN ('17171') AND post_type IN ('st_tours')) AND
CASE
WHEN ISNULL(tb.max_people) THEN 1=1
WHEN tb.max_people = '' THEN 1=1
WHEN tb.max_people = '0' THEN 1=1
ELSE tb.max_people >= 1 END
AND wp_posts.ID IN (SELECT post_id FROM wp_st_location_relationships WHERE 1=1 AND location_from IN ('17171') AND post_type IN ('st_activity'))
GROUP BY wp_posts.ID
ORDER BY tb_st_activity.is_featured desc
LIMIT 0, 8
ქართული
English