Find your Yamaha experience

Basic level
15 days
  • Madrid
Basic level
15 days
  • Madrid
Intermediate level
days
  • Madrid
Intermediate level
days
  • Madrid
Intermediate level
5 days
  • Madrid
  • xcsxcvxvx
  • (0) more destinations.
{
    "where": "{\\\"category\\\":[\\\"29\\\"]}"
}
COUNT: {
    "page": 1,
    "limit": 10,
    "totals": 5
}
[
    {
        "ID": "6175",
        "post_author": "1",
        "post_date": "2019-08-05 11:48:21",
        "post_date_gmt": "2019-08-05 11:48:21",
        "post_content": "Experience description 1",
        "post_title": "test carlos 7",
        "post_excerpt": "Experience description 1",
        "post_status": "publish",
        "comment_status": "closed",
        "ping_status": "closed",
        "post_password": "",
        "post_name": "test-carlos-7",
        "to_ping": "",
        "pinged": "",
        "post_modified": "2019-11-06 11:10:56",
        "post_modified_gmt": "2019-11-06 11:10:56",
        "post_content_filtered": "",
        "post_parent": "0",
        "guid": "https:\/\/test.destination-yamaha-motor.eu\/experience\/test-carlos-7\/",
        "menu_order": "0",
        "post_type": "experience",
        "post_mime_type": "",
        "comment_count": "0",
        "id": "164",
        "experience_id": "6175",
        "type": "off-road",
        "difficulty": "basic",
        "distance": "10",
        "duration": "15",
        "countries": "es,fr",
        "bike_rental": "yes",
        "bike_transport": "no",
        "price": "100.00",
        "average_rating": "0.00",
        "yamaha_items": "5945,6259",
        "continents": "EU",
        "country": "ES",
        "destinations": "Madrid",
        "object_id": null,
        "categories": null,
        "tags": null
    },
    {
        "ID": "6176",
        "post_author": "1",
        "post_date": "2019-08-05 11:48:21",
        "post_date_gmt": "2019-08-05 11:48:21",
        "post_content": "",
        "post_title": "test carlos 7 [gr]",
        "post_excerpt": "",
        "post_status": "publish",
        "comment_status": "closed",
        "ping_status": "closed",
        "post_password": "",
        "post_name": "test-carlos-7-gr",
        "to_ping": "",
        "pinged": "",
        "post_modified": "2019-08-05 11:48:21",
        "post_modified_gmt": "2019-08-05 11:48:21",
        "post_content_filtered": "",
        "post_parent": "0",
        "guid": "https:\/\/test.destination-yamaha-motor.eu\/experience\/test-carlos-7-gr\/",
        "menu_order": "0",
        "post_type": "experience",
        "post_mime_type": "",
        "comment_count": "0",
        "id": "165",
        "experience_id": "6176",
        "type": "road",
        "difficulty": "intermediate",
        "distance": null,
        "duration": null,
        "countries": "",
        "bike_rental": "yes",
        "bike_transport": "",
        "price": "100.00",
        "average_rating": "0.00",
        "yamaha_items": null,
        "continents": "EU",
        "country": "ES",
        "destinations": "Madrid",
        "object_id": null,
        "categories": null,
        "tags": null
    },
    {
        "ID": "6177",
        "post_author": "1",
        "post_date": "2019-08-05 11:48:21",
        "post_date_gmt": "2019-08-05 11:48:21",
        "post_content": "",
        "post_title": "test carlos 7 [es]",
        "post_excerpt": "",
        "post_status": "publish",
        "comment_status": "closed",
        "ping_status": "closed",
        "post_password": "",
        "post_name": "test-carlos-7-es",
        "to_ping": "",
        "pinged": "",
        "post_modified": "2019-08-05 11:48:21",
        "post_modified_gmt": "2019-08-05 11:48:21",
        "post_content_filtered": "",
        "post_parent": "0",
        "guid": "https:\/\/test.destination-yamaha-motor.eu\/experience\/test-carlos-7-es\/",
        "menu_order": "0",
        "post_type": "experience",
        "post_mime_type": "",
        "comment_count": "0",
        "id": "166",
        "experience_id": "6177",
        "type": "road",
        "difficulty": "intermediate",
        "distance": null,
        "duration": null,
        "countries": "",
        "bike_rental": "yes",
        "bike_transport": "",
        "price": "100.00",
        "average_rating": "0.00",
        "yamaha_items": null,
        "continents": "EU",
        "country": "ES",
        "destinations": "Madrid",
        "object_id": null,
        "categories": null,
        "tags": null
    },
    {
        "ID": "6200",
        "post_author": "1",
        "post_date": "2019-10-28 13:15:03",
        "post_date_gmt": "2019-10-28 13:15:03",
        "post_content": "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.",
        "post_title": "Demo",
        "post_excerpt": "Lorem ipsum dolor sit amet, consectetur adipiscing elit, sed do eiusmod tempor incididunt ut labore et dolore magna aliqua. Ut enim ad minim veniam, quis nostrud exercitation ullamco laboris nisi ut aliquip ex ea commodo consequat. Duis aute irure dolor in reprehenderit in voluptate velit esse cillum dolore eu fugiat nulla pariatur.",
        "post_status": "publish",
        "comment_status": "closed",
        "ping_status": "closed",
        "post_password": "",
        "post_name": "demo",
        "to_ping": "",
        "pinged": "",
        "post_modified": "2019-11-15 15:25:29",
        "post_modified_gmt": "2019-11-15 15:25:29",
        "post_content_filtered": "",
        "post_parent": "0",
        "guid": "https:\/\/test.destination-yamaha-motor.eu\/?post_type=experience&p=6200",
        "menu_order": "0",
        "post_type": "experience",
        "post_mime_type": "",
        "comment_count": "0",
        "id": "170",
        "experience_id": "6200",
        "type": "snow",
        "difficulty": "intermediate",
        "distance": "78",
        "duration": "5",
        "countries": "AL,AO",
        "bike_rental": "yes",
        "bike_transport": "yes",
        "price": "124.00",
        "average_rating": "0.00",
        "yamaha_items": "6259,6260",
        "continents": "EU,NA,EU",
        "country": "ES,BL,AX",
        "destinations": "Madrid,xcsxcvxvx,dasdasdasdasd",
        "object_id": "6200",
        "categories": null,
        "tags": "AMBASSADORS,Argentina,activities"
    },
    {
        "ID": "6237",
        "post_author": "1",
        "post_date": "2019-11-03 10:56:42",
        "post_date_gmt": "0000-00-00 00:00:00",
        "post_content": "adasdasadasda",
        "post_title": "Test 4",
        "post_excerpt": "adasdasadasda",
        "post_status": "publish",
        "comment_status": "closed",
        "ping_status": "closed",
        "post_password": "",
        "post_name": "test-4",
        "to_ping": "",
        "pinged": "",
        "post_modified": "2019-11-03 10:56:42",
        "post_modified_gmt": "2019-11-03 10:56:42",
        "post_content_filtered": "",
        "post_parent": "0",
        "guid": "https:\/\/test.destination-yamaha-motor.eu\/?post_type=experience&p=6237",
        "menu_order": "0",
        "post_type": "experience",
        "post_mime_type": "",
        "comment_count": "0",
        "id": "175",
        "experience_id": null,
        "type": "off-road",
        "difficulty": "intermediate",
        "distance": "5",
        "duration": "5",
        "countries": "AD",
        "bike_rental": "no",
        "bike_transport": "no",
        "price": "12.00",
        "average_rating": "0.00",
        "yamaha_items": "5945",
        "continents": null,
        "country": null,
        "destinations": null,
        "object_id": "6237",
        "categories": null,
        "tags": "Asia,asien"
    }
]
SELECT * FROM wp_posts u LEFT JOIN wp_dym_experience_filters dymf ON u.ID = dymf.experience_id LEFT JOIN (SELECT loc.experience_id, GROUP_CONCAT(loc.continent) AS continents FROM wp_dym_experience_locations loc GROUP BY loc.experience_id) dymcont ON u.ID = dymcont.experience_id LEFT JOIN (SELECT loc.experience_id, GROUP_CONCAT(loc.country) AS country FROM wp_dym_experience_locations loc GROUP BY loc.experience_id) dymcoun ON u.ID = dymcoun.experience_id LEFT JOIN (SELECT loc.experience_id, GROUP_CONCAT(loc.destination) AS destinations FROM wp_dym_experience_locations loc GROUP BY loc.experience_id) dymdes ON u.ID = dymdes.experience_id LEFT JOIN (SELECT ttr.object_id, group_concat(tg.name) as categories FROM wp_terms tg LEFT JOIN wp_term_taxonomy tt on tg.term_id = tt.term_id LEFT JOIN wp_term_relationships ttr ON ttr.term_taxonomy_id = tt.term_taxonomy_id WHERE taxonomy = 'experience_cat' GROUP BY ttr.object_id) dymcats ON u.ID = dymcats.object_id LEFT JOIN (SELECT ttr.object_id, group_concat(tg.name) as tags FROM wp_terms tg LEFT JOIN wp_term_taxonomy tt on tg.term_id = tt.term_id LEFT JOIN wp_term_relationships ttr ON ttr.term_taxonomy_id = tt.term_taxonomy_id WHERE taxonomy = 'experience_tag' GROUP BY ttr.object_id) dymtags ON u.ID = dymtags.object_id WHERE post_type = 'experience' AND post_status = 'publish' ORDER BY average_rating DESC LIMIT 10 
Close Menu