Showing 4–4 of 31 results
Sorted By
View
Fog Lamp Assembly 15728
6C0-941-699
CC. With comfort bumper. 2007-11. Eos. Left. Tiguan. 2013-2017, with r-line.
from 7 $ to 255 $
select * from "makes" where "alias" = 'volkswagen' limit 1
select * from "models" where "alias" = 'tiguan' limit 1
select * from "nested_categories" where "alias" = 'fog-lamps' limit 1
select * from "cars" where "model_id" = 19
select count(*) as aggregate from "parts" where exists (select * from "cars" inner join "car_part" on "cars"."id" = "car_part"."car_id" where "parts"."id" = "car_part"."part_id" and "cars"."id" in (167, 176, 179, 201, 211, 223, 226, 232, 243, 254, 262, 274, 286, 288, 292, 295, 334, 381, 383, 386, 389, 392, 402, 411, 454, 457, 463, 473, 475, 476, 479, 500, 504, 516, 551, 580, 583, 594, 603, 613, 657, 704, 713, 720, 740, 746, 767, 779, 800, 814, 868, 870, 897, 900, 902, 906, 907, 918, 921, 959, 960, 973, 1014, 1048, 1069, 1091)) and exists (select * from "nested_categories" inner join "part_sub_category" on "nested_categories"."id" = "part_sub_category"."nested_category_id" where "parts"."id" = "part_sub_category"."part_id" and "nested_categories"."id" = 199)
select * from "parts" where exists (select * from "cars" inner join "car_part" on "cars"."id" = "car_part"."car_id" where "parts"."id" = "car_part"."part_id" and "cars"."id" in (167, 176, 179, 201, 211, 223, 226, 232, 243, 254, 262, 274, 286, 288, 292, 295, 334, 381, 383, 386, 389, 392, 402, 411, 454, 457, 463, 473, 475, 476, 479, 500, 504, 516, 551, 580, 583, 594, 603, 613, 657, 704, 713, 720, 740, 746, 767, 779, 800, 814, 868, 870, 897, 900, 902, 906, 907, 918, 921, 959, 960, 973, 1014, 1048, 1069, 1091)) and exists (select * from "nested_categories" inner join "part_sub_category" on "nested_categories"."id" = "part_sub_category"."nested_category_id" where "parts"."id" = "part_sub_category"."part_id" and "nested_categories"."id" = 199) order by "max_price" asc limit 10 offset 30
select * from "part_photos" where "part_photos"."part_id" in (15728)
200
0 of 0 array:2 [▼ "page" => "4" "temp" => "list" ]
[]
0 of 0 array:23 [▼ "cookie" => array:1 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InkwZTQ5MUQ0OU8xMUNXMnNYak1pUWc9PSIsInZhbHVlIjoiTjNUS0wzUlNZeHZSWG9XUTd1cjFZME53VGdYcEpoNFBlNDAxdnpSWlc1RnlOQ2QzMk9KM21tMytiUTlKY0tJOUJnYS9lUGxZd0xWZ2tsUVpBd2lJVWkzY0ljOXRNVHNMVjlXOE9oSldyeHQyVVFxU3I0UCs2YU41blkzZi9sMFIiLCJtYWMiOiI2ZTMyYTk1YWNiMzUwMWZiYzJiN2M2Mzc4ZDZmZTU2YjkwMzIwMzM1ZTVhNGJkZDJiMTQyMDNkNzA0OTYyN2Y0IiwidGFnIjoiIn0%3D; partsbat_session=eyJpdiI6IlJCSGtxTzlWc3FmaHF6c1hJczZ2S1E9PSIsInZhbHVlIjoidEo2TDExVXhaVGVyN01iQm5CdWIyUWFLQ1ptLzRuekpWdkNxLzNBQlpDYldiRVZ0dEZjU0hHZ3hMakcwMzZ6WjQyNExTekVXNjBHamh4RVQ0bzFQQjlVMXZOVVRWbmNmTFY2YVFsL0Zod0VET0RXbmZIS2NqUnN1aUdMK1gvR2IiLCJtYWMiOiI2ZDU4NDMwNDRmMGY4MDM3YjM2NDRlZDNlNjMxN2IyN2MzMTkyOTNlMGM1NzIxNjFmOGIyYTNlYTQ3NjVmNzhiIiwidGFnIjoiIn0%3D ◀XSRF-TOKEN=eyJpdiI6InkwZTQ5MUQ0OU8xMUNXMnNYak1pUWc9PSIsInZhbHVlIjoiTjNUS0wzUlNZeHZSWG9XUTd1cjFZME53VGdYcEpoNFBlNDAxdnpSWlc1RnlOQ2QzMk9KM21tMytiUTlKY0tJOUJnYS9lU ▶" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "cf-ipcountry" => array:1 [▶ 0 => "US" ] "cf-connecting-ip" => array:1 [▶ 0 => "18.226.94.15" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "cf-visitor" => array:1 [▶ 0 => "{"scheme":"https"}" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "priority" => array:1 [▶ 0 => "u=0, i" ] "x-forwarded-proto" => array:1 [▶ 0 => "https" ] "cdn-loop" => array:1 [▶ 0 => "cloudflare; loops=1" ] "accept-encoding" => array:1 [▶ 0 => "gzip, br" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "x-forwarded-for" => array:1 [▶ 0 => "18.226.94.15" ] "cf-ray" => array:1 [▶ 0 => "9400aca3b845f51e-ORD" ] "host" => array:1 [▶ 0 => "partsbat.com" ] ]
0 of 0 array:2 [▼ "XSRF-TOKEN" => "99PZhN8FYv3EQoGSeV0AthMTVMcX3qHTrfKDAxYd" "partsbat_session" => "SuYzxCPiuKYaNvot1APiJuNQcCNar358Y1Y73CCL" ]
0 of 0 array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Thu, 15 May 2025 06:45:46 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im5EQjJzRE1wcmtNTW5GaGp2anNjcGc9PSIsInZhbHVlIjoiR2tXc3ArajlUckYwVEl2aUVJcUFNb3VPaExZZEdtaDlBMThkWTdyOUc2QXB4ZVlrbWZ1M1FNQytjUkVJYXFBS2NtSGQ2WGp1V0JLdkJKbEs4WkVvMVVzTlBYek5pZDF3K3lDQy83cHdjaWp3RXh1bmRFWC9mQnZuZDZiUWV2MGMiLCJtYWMiOiI5NWUzNzNhZjYxY2E3MTkyMzdmNjI1NmFmNzE1ZTg4MjRkZGVkMjE2MWU1YjZkZTA4ZDNiYTZjNjc4ZTNjNWNiIiwidGFnIjoiIn0%3D; expires=Thu, 15 May 2025 08:45:46 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6Im5EQjJzRE1wcmtNTW5GaGp2anNjcGc9PSIsInZhbHVlIjoiR2tXc3ArajlUckYwVEl2aUVJcUFNb3VPaExZZEdtaDlBMThkWTdyOUc2QXB4ZVlrbWZ1M1FNQytjUkVJYXFBS2NtSGQ2W ▶" 1 => "partsbat_session=eyJpdiI6ImUzclVhdTkyRTFPMWxFbXE0YVZkeHc9PSIsInZhbHVlIjoiU25lZjhGNGNWY3F1TE9qRk8rcjNUSjBjM1A5NDVmNjBybXAyb3dQTkJSamxTcnJnbmhLVG92N3J2K0NWRUpWWXo2b0hGNS9RNWxaZEZCakYxdGpYN0hKeVMyTFFMSUtSdEluT2VIOW1xVTQ0ejBDbEYzL1NPRm9NelFiNmJ6TTAiLCJtYWMiOiJjNjgyMTZkMjg1ZmViZWQ5OTFlODEzYzkxNmQxMGFlODRjNzFhMDNjMmFjZTcwMWU1Y2E4Y2Y1YmVkMTMwZThmIiwidGFnIjoiIn0%3D; expires=Thu, 15 May 2025 08:45:46 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀partsbat_session=eyJpdiI6ImUzclVhdTkyRTFPMWxFbXE0YVZkeHc9PSIsInZhbHVlIjoiU25lZjhGNGNWY3F1TE9qRk8rcjNUSjBjM1A5NDVmNjBybXAyb3dQTkJSamxTcnJnbmhLVG92N3J2K0NWRUpWWXo ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Im5EQjJzRE1wcmtNTW5GaGp2anNjcGc9PSIsInZhbHVlIjoiR2tXc3ArajlUckYwVEl2aUVJcUFNb3VPaExZZEdtaDlBMThkWTdyOUc2QXB4ZVlrbWZ1M1FNQytjUkVJYXFBS2NtSGQ2WGp1V0JLdkJKbEs4WkVvMVVzTlBYek5pZDF3K3lDQy83cHdjaWp3RXh1bmRFWC9mQnZuZDZiUWV2MGMiLCJtYWMiOiI5NWUzNzNhZjYxY2E3MTkyMzdmNjI1NmFmNzE1ZTg4MjRkZGVkMjE2MWU1YjZkZTA4ZDNiYTZjNjc4ZTNjNWNiIiwidGFnIjoiIn0%3D; expires=Thu, 15-May-2025 08:45:46 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6Im5EQjJzRE1wcmtNTW5GaGp2anNjcGc9PSIsInZhbHVlIjoiR2tXc3ArajlUckYwVEl2aUVJcUFNb3VPaExZZEdtaDlBMThkWTdyOUc2QXB4ZVlrbWZ1M1FNQytjUkVJYXFBS2NtSGQ2W ▶" 1 => "partsbat_session=eyJpdiI6ImUzclVhdTkyRTFPMWxFbXE0YVZkeHc9PSIsInZhbHVlIjoiU25lZjhGNGNWY3F1TE9qRk8rcjNUSjBjM1A5NDVmNjBybXAyb3dQTkJSamxTcnJnbmhLVG92N3J2K0NWRUpWWXo2b0hGNS9RNWxaZEZCakYxdGpYN0hKeVMyTFFMSUtSdEluT2VIOW1xVTQ0ejBDbEYzL1NPRm9NelFiNmJ6TTAiLCJtYWMiOiJjNjgyMTZkMjg1ZmViZWQ5OTFlODEzYzkxNmQxMGFlODRjNzFhMDNjMmFjZTcwMWU1Y2E4Y2Y1YmVkMTMwZThmIiwidGFnIjoiIn0%3D; expires=Thu, 15-May-2025 08:45:46 GMT; path=/; httponly ◀partsbat_session=eyJpdiI6ImUzclVhdTkyRTFPMWxFbXE0YVZkeHc9PSIsInZhbHVlIjoiU25lZjhGNGNWY3F1TE9qRk8rcjNUSjBjM1A5NDVmNjBybXAyb3dQTkJSamxTcnJnbmhLVG92N3J2K0NWRUpWWXo ▶" ] ]
0 of 0 array:5 [▼ "_token" => "99PZhN8FYv3EQoGSeV0AthMTVMcX3qHTrfKDAxYd" "locale" => "en" "_previous" => array:1 [▶ "url" => "https://partsbat.com/car/volkswagen/tiguan/fog-lamps?page=4&temp=list" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] "PHPDEBUGBAR_STACK_DATA" => [] ]