
The Pioneer Tradie with Rhino-Rack Backbone System is perfect for transporting ladders, pipes and timber on your vehicle. Sporting a stylish aerodynamic design with built in side rails, it is a functional and fashionable addition to your vehicle.
Your Pioneer Tradie (1528mm x 1236mm) solution is made up of the following individual parts:
The Pioneer Tradie is built with tough-as-nails reinforced nylon and aluminium and has been tested in the harshest outdoor conditions. It's also non-corrosive so it won't rust or fade. It also features fully-welded side rails to make loading and unloading your gear easier. You can rest assured knowing that your equipment is safe on the road.
Tradespeople will also love the tray's compatibility with a large variety of Rhino-Rack accessories. A Rhino-Rack Rear Roller would make loading ladders and planks on to the tray a breeze. Our Shovel and High Lifting Jack Holder bracket, Rhino-Rack ladder and Pioneer Combination Bracket are also some of the many available accessories that will fit the Tradie Tray.
Even if you're not a tradie - the Pioneer Tradie still has great potential. Imagine being able to easily carry your fishing rods along with the rest of your weekend gear on the one tray. Or picking up supplies for your DIY home renovation and not worrying about how you'll get it back home.
Get your load from A to B hassle free with the Pioneer Tradie.
Note: The Pioneer Tradie is designed to suit specific vehicles and does not suit all legs. Legs are not included and need to be purchased separately.
Features:
Q1. What tools do I need to fit the Pioneer Tradie?
A1. The minimal tools that you need can be found in the documents section of this page.
Q2. Are the side rails detachable to make a Pioneer Platform?
A2. No the side rails are welded on for ultimate security. There is the option of getting a Pioneer Platform and purchasing a full rail kit that transforms the Pioneer Platform into a Pioneer Tray.
Q3. How much height does the Pioneer Tradie add above my roof racks or crossbars?
A3. The external height that this product raises your vehicle is only 135mm / 5.3in.
MITSUBISHI Triton Gen5 MQ/MR 4dr Ute Double Cab 04/15 On
NEXT
The Pioneer Tradie is built with tough-as-nails reinforced nylon and aluminium and has been tested in the harshest outdoor conditions. It's also non-corrosive so it won't rust or fade. It also features fully-welded side rails to make loading and unloading your gear easier. You can rest assured knowing that your equipment is safe on the road.
Tradespeople will also love the tray's compatibility with a large variety of Rhino-Rack accessories. A Rhino-Rack Rear Roller would make loading ladders and planks on to the tray a breeze. Our Shovel and High Lifting Jack Holder bracket, Rhino-Rack ladder and Pioneer Combination Bracket are also some of the many available accessories that will fit the Tradie Tray.
Even if you're not a tradie - the Pioneer Tradie still has great potential. Imagine being able to easily carry your fishing rods along with the rest of your weekend gear on the one tray. Or picking up supplies for your DIY home renovation and not worrying about how you'll get it back home.
Get your load from A to B hassle free with the Pioneer Tradie.
Note: The Pioneer Tradie is designed to suit specific vehicles and does not suit all legs. Legs are not included and need to be purchased separately.
Features:
Q1. What tools do I need to fit the Pioneer Tradie?
A1. The minimal tools that you need can be found in the documents section of this page.
Q2. Are the side rails detachable to make a Pioneer Platform?
A2. No the side rails are welded on for ultimate security. There is the option of getting a Pioneer Platform and purchasing a full rail kit that transforms the Pioneer Platform into a Pioneer Tray.
Q3. How much height does the Pioneer Tradie add above my roof racks or crossbars?
A3. The external height that this product raises your vehicle is only 135mm / 5.3in.
MITSUBISHI Triton Gen5 MQ/MR 4dr Ute Double Cab 04/15 On
NEXT
Your Pioneer Tradie (1528mm x 1236mm) solution can be equipped with these
1 x Application (99.46%) | 779.52ms |
1 x Booting (0.54%) | 4.21ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
69 |
|
70 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
69 |
|
70 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
69 |
|
70 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
69 |
|
70 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
69 |
|
70 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
63 |
|
64 |
|
65 |
|
66 |
|
67 |
|
68 |
|
69 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
29 |
|
30 |
|
31 |
|
32 |
|
33 |
|
34 |
|
35 |
|
36 |
|
37 |
|
38 |
|
39 |
|
40 |
|
41 |
|
42 |
|
43 |
|
44 |
|
45 |
|
46 |
|
47 |
|
48 |
|
49 |
|
50 |
|
51 |
|
52 |
|
53 |
|
54 |
|
55 |
|
56 |
|
57 |
|
58 |
|
59 |
|
60 |
|
61 |
|
62 |
|
select * from `PR_Categories` where `parentId` is null and `slug` = 'roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E' and `slug` = 'cross-bar-roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '13674F82-0F17-442D-AD28-13A8C7683425' and `slug` = 'pioneer-tradie' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `stockCode` like 'ja9160' and (title like 'pioneer%tradie%1528mm%x%1236mm%' or title_US_CA like 'pioneer%tradie%1528mm%x%1236mm%') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `embedCode` is not null and `embedCode` <> '' and `PR_Medias`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` asc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Links` where `vehicleId` is null and `PR_Links`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '2') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCompatibilities` where exists (select * from `PR_Products` where `PR_ProductCompatibilities`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_ProductCompatibilities`.`productId1` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_ProductCompatibilities`.`deleted_at` is null and (`PR_ProductCompatibilities`.`lngId` is null or `PR_ProductCompatibilities`.`lngId` = '2') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('B275CCF2-C7C8-4187-AC99-E989C208A79A') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('B275CCF2-C7C8-4187-AC99-E989C208A79A') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpareParts` where exists (select * from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_ProductSpareParts`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_WindFairings` where exists (select * from `PR_Products` where `PR_WindFairings`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_WindFairings`.`productId1` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `lngId` = 2 and `PR_WindFairings`.`deleted_at` is null order by `id` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_ProductSpecifications`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '1A76CA3F-315C-4EA6-8002-E3B352C23337', '2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '2F7D1296-9A11-420C-99DA-0CF2BB9A62DD', '33C27305-6859-4DF9-9CC5-FB5E0806602D', '50F360E9-8C0F-437E-A879-5685BEFF3827', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', 'CE49416F-033B-4F79-A495-86DFDF9F4655', 'F59236C8-DE3C-45A9-975D-0E0EE462E09E') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_ProductSpecificationProperties`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('F950CE65-0011-4E6A-903E-9749FD0280D1') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('F950CE65-0011-4E6A-903E-9749FD0280D1') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_CanopyProducts` where `CM_CanopyProducts`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `CM_CanopyProducts`.`deleted_at` is null and (`CM_CanopyProducts`.`lngId` is null or `CM_CanopyProducts`.`lngId` = '2') order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_BarTypeProductCompatibilities` inner join `PR_BarTypes` on `PR_BarTypeProductCompatibilities`.`barTypeId` = `PR_BarTypes`.`barTypeId` where `PR_BarTypeProductCompatibilities`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and PR_BarTypes.lngId=2 and `PR_BarTypeProductCompatibilities`.`deleted_at` is null order by `PR_BarTypes`.`order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_BarTypes` where `PR_BarTypes`.`barTypeId` in ('EC3A3563-3B1B-4055-ADB3-11B654EEC47F') and `PR_BarTypes`.`deleted_at` is null and (`PR_BarTypes`.`lngId` is null or `PR_BarTypes`.`lngId` = 2) order by `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `productId2`, `order`, `lngId` from `PR_RelatedProducts` where `productId1` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_RelatedProducts`.`deleted_at` is null and (`PR_RelatedProducts`.`lngId` is null or `PR_RelatedProducts`.`lngId` = '2') order by `order` asc, `id` desc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `productId2`, `order`, `lngId` from `PR_RelatedProducts` where `productId1` in ('F950CE65-0011-4E6A-903E-9749FD0280D1') and `PR_RelatedProducts`.`deleted_at` is null and (`PR_RelatedProducts`.`lngId` is null or `PR_RelatedProducts`.`lngId` = '2') order by `order` asc, `id` desc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `productId` in ('A40DC05E-FF48-433C-B8B3-DF55E44F8CC0', '20DB053F-F78E-4426-AE83-FC43DB6EE0B1', '8FBBC7E5-B0D3-460C-8C82-89E27BD69205', '8B21CC35-7BC7-402B-92F4-3C1291730C0C', '43E0EBE7-F78F-4574-B490-991325002FFA', 'C0E66D0D-A448-43D0-90D8-13315575B41F', 'B724B8D1-2ED0-440A-8CEE-3275B9167EDC', '50C3954D-ABB4-41DC-B2A1-003711F62947', '4DE959F4-EB24-4E2A-9B6F-C34E9E148160', '5E6F8D05-7C92-4939-9756-9AF99E99177D', 'AE2296FB-D50A-47D9-B9FF-EA02BA651AD4', '7C0CAE7D-6586-4ADE-A5C9-47FEB971168C', '4B1201F0-9878-488C-B1A3-C35A71F9D515', 'B15557EB-1FFE-44AB-B05E-A88DBBA9C553', '9A142E85-B946-4C16-8862-6B9B0F6C95BE', '56F76C29-CEAF-4662-947E-A6B8956C6527', '3996D16E-E405-4813-8D78-AF5AF135AD27', '665AC661-682C-4F91-8475-B5AAEC3868F1') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('3996D16E-E405-4813-8D78-AF5AF135AD27', '4B1201F0-9878-488C-B1A3-C35A71F9D515', '5E6F8D05-7C92-4939-9756-9AF99E99177D', '7C0CAE7D-6586-4ADE-A5C9-47FEB971168C', '8FBBC7E5-B0D3-460C-8C82-89E27BD69205', '9A142E85-B946-4C16-8862-6B9B0F6C95BE', 'B15557EB-1FFE-44AB-B05E-A88DBBA9C553', 'B724B8D1-2ED0-440A-8CEE-3275B9167EDC') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_ProductSpecificationProperties`.`productId` is not null and exists (select * from `PR_SpecificationProperties` where `PR_ProductSpecificationProperties`.`specificationPropertyId` = `PR_SpecificationProperties`.`specificationPropertyId` and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc) and `PR_ProductSpecificationProperties`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationProperties` where `PR_SpecificationProperties`.`specificationPropertyId` in ('0754223D-333A-4880-B62B-EED1492A023E', '1404128B-8306-4A41-926F-05ACF8F3B461', '3178C8C8-BCD1-49B2-8B42-5D6A9F870FE9', '3678388B-7153-434F-B245-0795D8AD6E60', '38A9EC0F-41EE-4B46-B03D-5F1B91922988', '3D70412C-100B-4FBD-9E2A-3195E8C38509', '40A339D4-C734-41BE-A9F5-7540C347B360', '6EC81350-90AD-44AC-93DD-C4259723C2F5', '7FF6FD81-194A-4575-8110-DA21E2657100', '852775DC-8804-4D09-BF04-1D892D6D9915', '9B57FACA-1967-4CFA-833C-6F9578CFD249', '9EB49FBD-D3D3-428E-9C59-B4E355A0022D', 'CCFCEE3B-1E54-4876-953D-ACD9C9CAA8C7', 'D78F6505-9766-4732-A858-73785505B425') and `PR_SpecificationProperties`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '1A76CA3F-315C-4EA6-8002-E3B352C23337', '2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '2F7D1296-9A11-420C-99DA-0CF2BB9A62DD', '33C27305-6859-4DF9-9CC5-FB5E0806602D', '50F360E9-8C0F-437E-A879-5685BEFF3827', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', 'CE49416F-033B-4F79-A495-86DFDF9F4655') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_SpecificationPropertyMasterData` where `PR_SpecificationPropertyMasterData`.`specificationPropertyMasterDataId` in ('13EE9F51-90CA-4128-9C57-2DB36ED18057', '83CF2ACC-FFB0-4A5F-8FC2-43124C363BA1', '8A7E5FD2-7EAC-4F48-8AF6-48DEF99037CA', '8B84CD36-FAD8-43DD-BEB2-A8DA2C86EDA8', 'A5264CCE-38E8-434F-9C62-DCD76BFA3695', 'CA611FC6-E1C9-4AAF-835E-B50DF33606B9', 'EC790BE0-A4B8-48CC-9F37-732AD3B86DBE', 'F43F3A0E-9C30-4771-B296-D427AA616738', 'FE48A148-4E1F-4762-8E87-446FC9A37E58') and `PR_SpecificationPropertyMasterData`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `id`, `specificationPropertyMasterDataId`, `key`, `name`, `value` from `PR_SpecificationPropertyMasterData_Features` where `PR_SpecificationPropertyMasterData_Features`.`specificationPropertyMasterDataId` in ('13EE9F51-90CA-4128-9C57-2DB36ED18057', '83CF2ACC-FFB0-4A5F-8FC2-43124C363BA1', '8A7E5FD2-7EAC-4F48-8AF6-48DEF99037CA', '8B84CD36-FAD8-43DD-BEB2-A8DA2C86EDA8', 'A5264CCE-38E8-434F-9C62-DCD76BFA3695', 'CA611FC6-E1C9-4AAF-835E-B50DF33606B9', 'EC790BE0-A4B8-48CC-9F37-732AD3B86DBE', 'F43F3A0E-9C30-4771-B296-D427AA616738', 'FE48A148-4E1F-4762-8E87-446FC9A37E58') and `PR_SpecificationPropertyMasterData_Features`.`deleted_at` is null and (`PR_SpecificationPropertyMasterData_Features`.`lngId` is null or `PR_SpecificationPropertyMasterData_Features`.`lngId` = 2) order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('0763DB5B-024D-4F37-901D-C483BA83712B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `specificationId` from `PR_CategorySpecifications` where `categoryId` in ('0763DB5B-024D-4F37-901D-C483BA83712B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isVisibleOnProduct` = 1 and `PR_CategorySpecifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `title` from `PR_Specifications` where `specificationId` in ('2F7D1296-9A11-420C-99DA-0CF2BB9A62DD', 'F59236C8-DE3C-45A9-975D-0E0EE462E09E', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '50F360E9-8C0F-437E-A879-5685BEFF3827', '2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', 'CE49416F-033B-4F79-A495-86DFDF9F4655', '1A76CA3F-315C-4EA6-8002-E3B352C23337', '33C27305-6859-4DF9-9CC5-FB5E0806602D', '2261BB38-5354-44FE-B45C-849D201849B0', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCustomSpecification` where `PR_ProductCustomSpecification`.`ProductId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_ProductCustomSpecification`.`ProductId` is not null and `PR_ProductCustomSpecification`.`deleted_at` is null order by `order` asc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('F950CE65-0011-4E6A-903E-9749FD0280D1') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Links` where `vehicleId` is null and `PR_Links`.`productId` in ('F950CE65-0011-4E6A-903E-9749FD0280D1') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '2') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_LinkNames` where `PR_LinkNames`.`linkNameId` in ('4A65457B-DF19-4771-99C7-D4BE4B313755') and `PR_LinkNames`.`deleted_at` is null and (`PR_LinkNames`.`lngId` is null or `PR_LinkNames`.`lngId` = 2) order by `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_ProductCategories`.`productId` is not null and `categoryId` in ('2B39426A-55C6-45D5-9418-5A79A0166DEA', '23C6863F-91C0-44EE-B8DB-949A42E96573', 'DBE8AFC5-A2D9-4715-BB32-79424DBECA14', 'F7380C9C-AF6D-4B3D-82C9-17E81216DCA2') and `PR_ProductCategories`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` = 'F950CE65-0011-4E6A-903E-9749FD0280D1' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpareParts` where `PR_ProductSpareParts`.`productId1` = 'F950CE65-0011-4E6A-903E-9749FD0280D1' and `PR_ProductSpareParts`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('0E8B6A70-B530-4B64-B849-7CD810FD8EDC', '101DA6E2-933C-4767-A273-AD02D34B276B', '178529AB-1EA3-4EDF-A491-FD999D51B5AE', '5CB16A43-18E2-4D21-9004-A1A726A54EC0', '5ED4BD51-EB3C-4953-B5FE-BFBDA60ECBBA', '7127BA6E-4C71-4E2A-931C-F25D50836AE6', '71E527AD-6535-4817-8EC9-6B920EABF053', 'C2F0FF0A-0767-468A-B7F1-F6FA03E21A43', 'EFC0301E-7BEF-48C4-AAC4-08A44B5E7CFA') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_CategoryProductImages` where `categoryId` in ('0763DB5B-024D-4F37-901D-C483BA83712B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `lngId` = 2 and `categoryId1` is not null and `categoryId2` is not null and `deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `parentId` from `PR_Categories` where `categoryId` in ('0763DB5B-024D-4F37-901D-C483BA83712B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `lngId` = 2 and `deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_CategoryProductImages` where `categoryId` in ('13674F82-0F17-442D-AD28-13A8C7683425', '5480AA8E-3C8D-4831-8005-8E1D56C668EA') and `lngId` = 2 and `categoryId1` is not null and (`categoryId2` = '' or `categoryId2` is null) and `deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `parentId` from `PR_Categories` where `categoryId` in ('13674F82-0F17-442D-AD28-13A8C7683425', '5480AA8E-3C8D-4831-8005-8E1D56C668EA') and `lngId` = 2 and `deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_CategoryProductImages` where `categoryId` in ('5C2DD4F5-056B-4961-B309-A37BA1BC5A4E', 'F1D7419B-13D1-4D95-8AF7-0D95AED30BF2') and `lngId` = 2 and (`categoryId1` = '' or `categoryId1` is null) and (`categoryId2` = '' or `categoryId2` is null) and `deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductBanners` where `PR_ProductBanners`.`productId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_ProductBanners`.`productId` is not null and `PR_ProductBanners`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ZwiflocRetrofit` where `PR_ZwiflocRetrofit`.`productId1` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_ZwiflocRetrofit`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ZwiflocRetrofit`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_ZwiflocRetrofit`.`deleted_at` is null and (`PR_ZwiflocRetrofit`.`lngId` is null or `PR_ZwiflocRetrofit`.`lngId` = 2) order by `id` asc, `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ZwiflocRetrofit` where `PR_ZwiflocRetrofit`.`productId1` = 'F950CE65-0011-4E6A-903E-9749FD0280D1' and `PR_ZwiflocRetrofit`.`productId1` is not null and exists (select * from `PR_Products` where `PR_ZwiflocRetrofit`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `lngId` = 2 and `PR_ZwiflocRetrofit`.`deleted_at` is null and (`PR_ZwiflocRetrofit`.`lngId` is null or `PR_ZwiflocRetrofit`.`lngId` = 2) order by `id` asc, `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `key`, `value` from `settings` where `key` = 'shipping_policy' and `settings`.`deleted_at` is null and (`settings`.`lngId` is null or `settings`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings` where `key` = 'enable_locally' and `settings`.`deleted_at` is null and (`settings`.`lngId` is null or `settings`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` is null and `slug` = 'roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '5C2DD4F5-056B-4961-B309-A37BA1BC5A4E' and `slug` = 'cross-bar-roof-racks' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `parentId` = '13674F82-0F17-442D-AD28-13A8C7683425' and `slug` = 'pioneer-tradie' and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `stockCode` like 'ja9160' and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `embedCode` is not null and `embedCode` <> '' and `PR_Medias`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` asc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Links` where `vehicleId` is null and `PR_Links`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '2') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCompatibilities` where exists (select * from `PR_Products` where `PR_ProductCompatibilities`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_ProductCompatibilities`.`productId1` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_ProductCompatibilities`.`deleted_at` is null and (`PR_ProductCompatibilities`.`lngId` is null or `PR_ProductCompatibilities`.`lngId` = '2') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('B275CCF2-C7C8-4187-AC99-E989C208A79A') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('B275CCF2-C7C8-4187-AC99-E989C208A79A') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpareParts` where exists (select * from `PR_Products` where `PR_ProductSpareParts`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_ProductSpareParts`.`productId1` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_ProductSpareParts`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_WindFairings` where exists (select * from `PR_Products` where `PR_WindFairings`.`productId2` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_WindFairings`.`productId1` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `lngId` = 2 and `PR_WindFairings`.`deleted_at` is null order by `id` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecifications` where `PR_ProductSpecifications`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_ProductSpecifications`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Specifications` where `PR_Specifications`.`specificationId` in ('14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '1A76CA3F-315C-4EA6-8002-E3B352C23337', '2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '2F7D1296-9A11-420C-99DA-0CF2BB9A62DD', '33C27305-6859-4DF9-9CC5-FB5E0806602D', '50F360E9-8C0F-437E-A879-5685BEFF3827', '6FEC7B95-51EA-498A-A900-8FD5DA6C89D2', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7', 'CE49416F-033B-4F79-A495-86DFDF9F4655', 'F59236C8-DE3C-45A9-975D-0E0EE462E09E') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductSpecificationProperties` where `PR_ProductSpecificationProperties`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_ProductSpecificationProperties`.`deleted_at` is null
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('F950CE65-0011-4E6A-903E-9749FD0280D1') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`productId` in ('F950CE65-0011-4E6A-903E-9749FD0280D1') and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `CM_CanopyProducts` where `CM_CanopyProducts`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and `CM_CanopyProducts`.`deleted_at` is null and (`CM_CanopyProducts`.`lngId` is null or `CM_CanopyProducts`.`lngId` = '2') order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_BarTypeProductCompatibilities` inner join `PR_BarTypes` on `PR_BarTypeProductCompatibilities`.`barTypeId` = `PR_BarTypes`.`barTypeId` where `PR_BarTypeProductCompatibilities`.`productId` in ('B854A978-39B4-4B94-A97C-F2201051B507') and PR_BarTypes.lngId=2 and `PR_BarTypeProductCompatibilities`.`deleted_at` is null order by `PR_BarTypes`.`order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_BarTypes` where `PR_BarTypes`.`barTypeId` in ('EC3A3563-3B1B-4055-ADB3-11B654EEC47F') and `PR_BarTypes`.`deleted_at` is null and (`PR_BarTypes`.`lngId` is null or `PR_BarTypes`.`lngId` = 2) order by `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('0763DB5B-024D-4F37-901D-C483BA83712B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `specificationId` from `PR_CategorySpecifications` where `categoryId` in ('0763DB5B-024D-4F37-901D-C483BA83712B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isVisibleOnProduct` = 1 and `PR_CategorySpecifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `title` from `PR_Specifications` where `specificationId` in ('2F7D1296-9A11-420C-99DA-0CF2BB9A62DD', 'F59236C8-DE3C-45A9-975D-0E0EE462E09E', '14F3FB81-8947-4E5E-BB23-2F17B1452EF2', '2A37E3E3-CB54-453A-9EE9-53B3406A76CB', '50F360E9-8C0F-437E-A879-5685BEFF3827', '2148B1D3-F535-4E7C-939D-7FD62DFA2FFB', 'CE49416F-033B-4F79-A495-86DFDF9F4655', '1A76CA3F-315C-4EA6-8002-E3B352C23337', '33C27305-6859-4DF9-9CC5-FB5E0806602D', '2261BB38-5354-44FE-B45C-849D201849B0', '7A90BAEF-94DE-4E35-9446-A53AE478B8C7') and `PR_Specifications`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCustomSpecification` where `PR_ProductCustomSpecification`.`ProductId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_ProductCustomSpecification`.`ProductId` is not null and `PR_ProductCustomSpecification`.`deleted_at` is null order by `order` asc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Products` where `PR_Products`.`productId` in ('F950CE65-0011-4E6A-903E-9749FD0280D1') and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Links` where `vehicleId` is null and `PR_Links`.`productId` in ('F950CE65-0011-4E6A-903E-9749FD0280D1') and `PR_Links`.`deleted_at` is null and (`PR_Links`.`lngId` is null or `PR_Links`.`lngId` = '2') order by `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_LinkNames` where `PR_LinkNames`.`linkNameId` in ('4A65457B-DF19-4771-99C7-D4BE4B313755') and `PR_LinkNames`.`deleted_at` is null and (`PR_LinkNames`.`lngId` is null or `PR_LinkNames`.`lngId` = 2) order by `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `productId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('0763DB5B-024D-4F37-901D-C483BA83712B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `PR_Medias`.`productId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_Medias`.`productId` is not null and `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `PR_Medias`.`productId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_Medias`.`productId` is not null and `embedCode` is not null and `embedCode` <> '' and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` asc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Medias` where `PR_Medias`.`productId` = 'F950CE65-0011-4E6A-903E-9749FD0280D1' and `PR_Medias`.`productId` is not null and `mediaUrl` is not null and `mediaUrl` <> '' and `contentType` = 1 and (`vehicleId` is null or exists (select * from `PR_Products` where `PR_Medias`.`productId` = `PR_Products`.`productId` and (select count(*) from `PR_VehicleProducts` where `PR_Products`.`productId` = `PR_VehicleProducts`.`productId` and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc) = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc)) and `PR_Medias`.`deleted_at` is null and (`PR_Medias`.`lngId` is null or `PR_Medias`.`lngId` = '2') and `isActive` = 1 order by `vehicleId` desc, `order` asc, `lngId` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_VehicleProducts` where `PR_VehicleProducts`.`productId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_VehicleProducts`.`productId` is not null and exists (select * from `VM_Vehicles` where `PR_VehicleProducts`.`vehicleId` = `VM_Vehicles`.`vehicleId` and exists (select * from `VM_Models` where `VM_Vehicles`.`modelId` = `VM_Models`.`modelId` and `VM_Models`.`deleted_at` is null and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Vehicles` where `VM_Vehicles`.`vehicleId` in ('60D60E9A-8285-4718-B337-9B51C3C0CA8F') and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_VehicleProducts` where `PR_VehicleProducts`.`productId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `PR_VehicleProducts`.`productId` is not null and exists (select * from `VM_Vehicles` where `PR_VehicleProducts`.`vehicleId` = `VM_Vehicles`.`vehicleId` and exists (select * from `VM_Models` where `VM_Vehicles`.`modelId` = `VM_Models`.`modelId` and `VM_Models`.`deleted_at` is null and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and `PR_VehicleProducts`.`deleted_at` is null and (`PR_VehicleProducts`.`lngId` is null or `PR_VehicleProducts`.`lngId` = '2') order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Vehicles` where `VM_Vehicles`.`vehicleId` in ('60D60E9A-8285-4718-B337-9B51C3C0CA8F') and `VM_Vehicles`.`deleted_at` is null and (`VM_Vehicles`.`lngId` is null or `VM_Vehicles`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Models` where `VM_Models`.`modelId` = '9ED5F1B6-899A-48DF-8679-F8D407AE8320' and exists (select * from `VM_Manufacturers` where `VM_Models`.`manufacturerId` = `VM_Manufacturers`.`manufacturerId` and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Manufacturers` where `VM_Manufacturers`.`manufacturerId` in ('48A5F29D-7E83-44B5-B093-4AE1AB8FE560') and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_BodyTypes` where `VM_BodyTypes`.`bodyTypeId` = 'B4C3C83A-7904-40F4-86DF-CFE5ECA7381F' and `VM_BodyTypes`.`deleted_at` is null and (`VM_BodyTypes`.`lngId` is null or `VM_BodyTypes`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Attributes` where `VM_Attributes`.`attributeId` = '1B6FF379-6EF5-442B-8E7A-AA5905D7F995' and `VM_Attributes`.`deleted_at` is null and (`VM_Attributes`.`lngId` is null or `VM_Attributes`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('0763DB5B-024D-4F37-901D-C483BA83712B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `isRoofRackCategory` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `categoryId` from `PR_Categories` where `categoryType` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `fmv_product_specifications` where `fmv_product_specifications`.`productId` = 'B854A978-39B4-4B94-A97C-F2201051B507' and `fmv_product_specifications`.`productId` is not null and `fmv_product_specifications`.`deleted_at` is null and (`fmv_product_specifications`.`lngId` is null or `fmv_product_specifications`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Models` where `VM_Models`.`modelId` = '9ED5F1B6-899A-48DF-8679-F8D407AE8320' and exists (select * from `VM_Manufacturers` where `VM_Models`.`manufacturerId` = `VM_Manufacturers`.`manufacturerId` and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc) and (`VM_Models`.`lngId` is null or `VM_Models`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc limit 1
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `VM_Manufacturers` where `VM_Manufacturers`.`manufacturerId` in ('48A5F29D-7E83-44B5-B093-4AE1AB8FE560') and `VM_Manufacturers`.`deleted_at` is null and (`VM_Manufacturers`.`lngId` is null or `VM_Manufacturers`.`lngId` = '2') and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'C2F0FF0A-0767-468A-B7F1-F6FA03E21A43' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D7D78D3C-56F5-4CF8-A9EE-975C698B7FCB') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D7D78D3C-56F5-4CF8-A9EE-975C698B7FCB', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'C2F0FF0A-0767-468A-B7F1-F6FA03E21A43' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D7D78D3C-56F5-4CF8-A9EE-975C698B7FCB', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D7D78D3C-56F5-4CF8-A9EE-975C698B7FCB', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '7127BA6E-4C71-4E2A-931C-F25D50836AE6' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D7D78D3C-56F5-4CF8-A9EE-975C698B7FCB') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D7D78D3C-56F5-4CF8-A9EE-975C698B7FCB', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '7127BA6E-4C71-4E2A-931C-F25D50836AE6' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D7D78D3C-56F5-4CF8-A9EE-975C698B7FCB', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'D7D78D3C-56F5-4CF8-A9EE-975C698B7FCB', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '0E8B6A70-B530-4B64-B849-7CD810FD8EDC' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('1481CF80-9553-4672-B659-22175F76D729', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '1481CF80-9553-4672-B659-22175F76D729', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '0E8B6A70-B530-4B64-B849-7CD810FD8EDC' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '1481CF80-9553-4672-B659-22175F76D729', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '1481CF80-9553-4672-B659-22175F76D729', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '178529AB-1EA3-4EDF-A491-FD999D51B5AE' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '178529AB-1EA3-4EDF-A491-FD999D51B5AE' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'EFC0301E-7BEF-48C4-AAC4-08A44B5E7CFA' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'EFC0301E-7BEF-48C4-AAC4-08A44B5E7CFA' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '101DA6E2-933C-4767-A273-AD02D34B276B' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '101DA6E2-933C-4767-A273-AD02D34B276B' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '71E527AD-6535-4817-8EC9-6B920EABF053' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '71E527AD-6535-4817-8EC9-6B920EABF053' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '5CB16A43-18E2-4D21-9004-A1A726A54EC0' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '5CB16A43-18E2-4D21-9004-A1A726A54EC0' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('FE02EE2C-3CDC-4AC6-97FE-490ECB0F921B', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '5ED4BD51-EB3C-4953-B5FE-BFBDA60ECBBA' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', 'F4494C65-A162-480E-802A-DF677D82C4F7') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F4494C65-A162-480E-802A-DF677D82C4F7', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '5ED4BD51-EB3C-4953-B5FE-BFBDA60ECBBA' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F4494C65-A162-480E-802A-DF677D82C4F7', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('F4494C65-A162-480E-802A-DF677D82C4F7', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '8FBBC7E5-B0D3-460C-8C82-89E27BD69205' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', 'DFC7031B-350D-4256-BFD8-A01156482C16') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '8FBBC7E5-B0D3-460C-8C82-89E27BD69205' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '6B4D0CB0-AC14-42A6-AB32-AA7FB8A79ADA', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', 'A7CF97A7-D46E-44F9-B157-F805D8C7ECE4', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'B724B8D1-2ED0-440A-8CEE-3275B9167EDC' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CF6EC2A1-917C-44C0-B2B6-0C1640B6D771', 'DFC7031B-350D-4256-BFD8-A01156482C16') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CF6EC2A1-917C-44C0-B2B6-0C1640B6D771', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'B724B8D1-2ED0-440A-8CEE-3275B9167EDC' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CF6EC2A1-917C-44C0-B2B6-0C1640B6D771', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'CF6EC2A1-917C-44C0-B2B6-0C1640B6D771', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '5E6F8D05-7C92-4939-9756-9AF99E99177D' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '5E6F8D05-7C92-4939-9756-9AF99E99177D' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '7C0CAE7D-6586-4ADE-A5C9-47FEB971168C' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '7C0CAE7D-6586-4ADE-A5C9-47FEB971168C' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '4B1201F0-9878-488C-B1A3-C35A71F9D515' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '4B1201F0-9878-488C-B1A3-C35A71F9D515' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = 'B15557EB-1FFE-44AB-B05E-A88DBBA9C553' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '41C0E016-D44F-414F-8DCD-07CBA1565B47', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'DFC7031B-350D-4256-BFD8-A01156482C16') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '41C0E016-D44F-414F-8DCD-07CBA1565B47', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = 'B15557EB-1FFE-44AB-B05E-A88DBBA9C553' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '41C0E016-D44F-414F-8DCD-07CBA1565B47', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', '41C0E016-D44F-414F-8DCD-07CBA1565B47', 'DFC7031B-350D-4256-BFD8-A01156482C16', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '9A142E85-B946-4C16-8862-6B9B0F6C95BE' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'A17D765A-858D-44A2-98B7-D2D4FCE06356', 'F45C2D46-6386-471D-99E5-F2B3CF87320A') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('A17D765A-858D-44A2-98B7-D2D4FCE06356', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'F45C2D46-6386-471D-99E5-F2B3CF87320A', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '9A142E85-B946-4C16-8862-6B9B0F6C95BE' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('A17D765A-858D-44A2-98B7-D2D4FCE06356', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'F45C2D46-6386-471D-99E5-F2B3CF87320A', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('A17D765A-858D-44A2-98B7-D2D4FCE06356', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'F45C2D46-6386-471D-99E5-F2B3CF87320A', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_ProductCategories` where `PR_ProductCategories`.`productId` = '3996D16E-E405-4813-8D78-AF5AF135AD27' and `PR_ProductCategories`.`productId` is not null and exists (select * from `PR_Categories` where `PR_ProductCategories`.`categoryId` = `PR_Categories`.`categoryId` and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc) and `PR_ProductCategories`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_Categories` where `PR_Categories`.`categoryId` in ('08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '5B66CF8E-05DA-42DE-8239-B057ED2BC3B5', '903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'AA01953E-CABA-43AF-B1A3-226E590C3B1B', 'DFC7031B-350D-4256-BFD8-A01156482C16') and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0) order by `lngId` desc, `scope` desc, `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'AA01953E-CABA-43AF-B1A3-226E590C3B1B', 'DFC7031B-350D-4256-BFD8-A01156482C16', '5B66CF8E-05DA-42DE-8239-B057ED2BC3B5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `PR_PackageComponents` where `PR_PackageComponents`.`productId` = '3996D16E-E405-4813-8D78-AF5AF135AD27' and `PR_PackageComponents`.`productId` is not null and exists (select * from `PR_Products` where `PR_PackageComponents`.`componentId` = `PR_Products`.`productId` and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc) and `PR_PackageComponents`.`deleted_at` is null order by `order` asc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'AA01953E-CABA-43AF-B1A3-226E590C3B1B', 'DFC7031B-350D-4256-BFD8-A01156482C16', '5B66CF8E-05DA-42DE-8239-B057ED2BC3B5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `PR_Categories` where `categoryId` in ('903F14E1-03DD-48EA-8E69-B837D70C3C0F', 'AA01953E-CABA-43AF-B1A3-226E590C3B1B', 'DFC7031B-350D-4256-BFD8-A01156482C16', '5B66CF8E-05DA-42DE-8239-B057ED2BC3B5', '3FD96EB4-C315-43C7-92B9-BECDCBB8CD8F', '08FDCA51-149B-4C4B-8C87-D52042CA6273', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5', '2C0FB2F9-F310-435A-BFC0-27BFB884CEE5') and `always_in_stock` = 1 and `PR_Categories`.`deleted_at` is null and (`PR_Categories`.`lngId` is null or `PR_Categories`.`lngId` = 2) and `isActive` = 1 and (`scope` is null or `scope` = 0)
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
select `netSuiteId` from `PR_Products` where 0 = 1 and `PR_Products`.`deleted_at` is null and (`PR_Products`.`lngId` is null or `PR_Products`.`lngId` = 2) and `isActive` = 1 order by `lngId` desc
Metadata | |
---|---|
Bindings |
|
Backtrace |
|
200
[]
[]
0 of 0array:15 [▼ "host" => array:1 [▶ 0 => "rrweb.webexpertsnepal.com" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "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" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] ]
0 of 0array:48 [▼ "REDIRECT_SCRIPT_URL" => "/en-nz/products/roof-racks/cross-bar-roof-racks/pioneer-tradie/pioneer-tradie-1528mm-x-1236mm-_ja9160" "REDIRECT_SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-nz/products/roof-racks/cross-bar-roof-racks/pioneer-tradie/pioneer-tradie-1528mm-x-1236mm-_ja9160" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "REDIRECT_STATUS" => "200" "SCRIPT_URL" => "/en-nz/products/roof-racks/cross-bar-roof-racks/pioneer-tradie/pioneer-tradie-1528mm-x-1236mm-_ja9160" "SCRIPT_URI" => "https://rrweb.webexpertsnepal.com/en-nz/products/roof-racks/cross-bar-roof-racks/pioneer-tradie/pioneer-tradie-1528mm-x-1236mm-_ja9160" "HTTPS" => "on" "SSL_TLS_SNI" => "rrweb.webexpertsnepal.com" "HTTP_HOST" => "rrweb.webexpertsnepal.com" "HTTP_CONNECTION" => "keep-alive" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_ACCEPT" => "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" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin" "SERVER_SIGNATURE" => "<address>Apache/2.4.52 (Ubuntu) Server at rrweb.webexpertsnepal.com Port 443</address>\n" "SERVER_SOFTWARE" => "Apache/2.4.52 (Ubuntu)" "SERVER_NAME" => "rrweb.webexpertsnepal.com" "SERVER_ADDR" => "192.168.2.5" "SERVER_PORT" => "443" "REMOTE_ADDR" => "192.168.2.1" "DOCUMENT_ROOT" => "/var/www/rhinorack/web/public" "REQUEST_SCHEME" => "https" "CONTEXT_PREFIX" => "" "CONTEXT_DOCUMENT_ROOT" => "/var/www/rhinorack/web/public" "SERVER_ADMIN" => "webmaster@" "SCRIPT_FILENAME" => "/var/www/rhinorack/web/public/index.php" "REMOTE_PORT" => "38301" "REDIRECT_URL" => "/en-nz/products/roof-racks/cross-bar-roof-racks/pioneer-tradie/pioneer-tradie-1528mm-x-1236mm-_ja9160" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/en-nz/products/roof-racks/cross-bar-roof-racks/pioneer-tradie/pioneer-tradie-1528mm-x-1236mm-_ja9160" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745804691.4949 "REQUEST_TIME" => 1745804691 ]
[]
0 of 0array:5 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 28 Apr 2025 01:44:51 GMT" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IndSdXVPa0R6YUl0Q1NoV2QvL21RdFE9PSIsInZhbHVlIjoiN3M2MG9ocnBLbGF5d1MyaGIxZUdOTjd2RWF0K3l2U0paamxaWVRsMDZEQXI1TWpEY1o3WmdjMzBjaG1NNDNwVDR1dytKU1owRWp6cjJYaXRoMTlEYzJEQ01ZTzVRdU9xNWFsNGRkUEtkZ0lJQ3ZEV25lckc3dW9ZM3FWMk1UUGQiLCJtYWMiOiIwODIzNmYzYzNkZTgwNGE0NWYwZjVlODBjZTQ0Yjc2ODVmZDRmMGVlOTEyYWFhMWYwMTM0ZDM2ZmFjOWZiODdhIiwidGFnIjoiIn0%3D; expires=Wed, 28 May 2025 11:44:52 GMT; Max-Age=2628000; path=/ ◀XSRF-TOKEN=eyJpdiI6IndSdXVPa0R6YUl0Q1NoV2QvL21RdFE9PSIsInZhbHVlIjoiN3M2MG9ocnBLbGF5d1MyaGIxZUdOTjd2RWF0K3l2U0paamxaWVRsMDZEQXI1TWpEY1o3WmdjMzBjaG1NNDNwVDR1dytKU ▶" 1 => "rhino_rack_session=eyJpdiI6ImJ5a0hPdzZLcWJidDFPV0krcjF4MVE9PSIsInZhbHVlIjoiKzhsRWY3eW1iY1lSdDl0MkxGditSMU41eGtEa29hRWJmR2hrR0wxZWJRY05veS9hbjJTZm0wdDFQSEFhcGV6M3phS0xFTHBiU0FwNytGSUxUbFpJQTM3QU1Ec0pRWDN6TC9acENPWXNyZkpYbGxUMnEzaUVKUDJlN25CZHRJZFYiLCJtYWMiOiI0MjBkY2EyZGQ5ZmRlMzcwZGY1MzRhMzZiYzk4MjdkYTliNmJkYzUxOTcyM2FmNWZkZTI1MzRmZmFhZWMyMzc1IiwidGFnIjoiIn0%3D; expires=Wed, 28 May 2025 11:44:52 GMT; Max-Age=2628000; path=/; httponly ◀rhino_rack_session=eyJpdiI6ImJ5a0hPdzZLcWJidDFPV0krcjF4MVE9PSIsInZhbHVlIjoiKzhsRWY3eW1iY1lSdDl0MkxGditSMU41eGtEa29hRWJmR2hrR0wxZWJRY05veS9hbjJTZm0wdDFQSEFhcGV6M ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IndSdXVPa0R6YUl0Q1NoV2QvL21RdFE9PSIsInZhbHVlIjoiN3M2MG9ocnBLbGF5d1MyaGIxZUdOTjd2RWF0K3l2U0paamxaWVRsMDZEQXI1TWpEY1o3WmdjMzBjaG1NNDNwVDR1dytKU1owRWp6cjJYaXRoMTlEYzJEQ01ZTzVRdU9xNWFsNGRkUEtkZ0lJQ3ZEV25lckc3dW9ZM3FWMk1UUGQiLCJtYWMiOiIwODIzNmYzYzNkZTgwNGE0NWYwZjVlODBjZTQ0Yjc2ODVmZDRmMGVlOTEyYWFhMWYwMTM0ZDM2ZmFjOWZiODdhIiwidGFnIjoiIn0%3D; expires=Wed, 28-May-2025 11:44:52 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IndSdXVPa0R6YUl0Q1NoV2QvL21RdFE9PSIsInZhbHVlIjoiN3M2MG9ocnBLbGF5d1MyaGIxZUdOTjd2RWF0K3l2U0paamxaWVRsMDZEQXI1TWpEY1o3WmdjMzBjaG1NNDNwVDR1dytKU ▶" 1 => "rhino_rack_session=eyJpdiI6ImJ5a0hPdzZLcWJidDFPV0krcjF4MVE9PSIsInZhbHVlIjoiKzhsRWY3eW1iY1lSdDl0MkxGditSMU41eGtEa29hRWJmR2hrR0wxZWJRY05veS9hbjJTZm0wdDFQSEFhcGV6M3phS0xFTHBiU0FwNytGSUxUbFpJQTM3QU1Ec0pRWDN6TC9acENPWXNyZkpYbGxUMnEzaUVKUDJlN25CZHRJZFYiLCJtYWMiOiI0MjBkY2EyZGQ5ZmRlMzcwZGY1MzRhMzZiYzk4MjdkYTliNmJkYzUxOTcyM2FmNWZkZTI1MzRmZmFhZWMyMzc1IiwidGFnIjoiIn0%3D; expires=Wed, 28-May-2025 11:44:52 GMT; path=/; httponly ◀rhino_rack_session=eyJpdiI6ImJ5a0hPdzZLcWJidDFPV0krcjF4MVE9PSIsInZhbHVlIjoiKzhsRWY3eW1iY1lSdDl0MkxGditSMU41eGtEa29hRWJmR2hrR0wxZWJRY05veS9hbjJTZm0wdDFQSEFhcGV6M ▶" ] ]
0 of 0array:9 [▼ "_token" => "CUQpvsBhHBecWNudK1iwB5326NdMijZtBNWjHErv" "country" => "nz" "_flash" => array:2 [▶ "old" => [] "new" => [] ] "lngId" => 2 "session_culture" => "en-nz" "random_number" => 96 "locale" => "en" "_previous" => array:1 [▶ "url" => "https://rrweb.webexpertsnepal.com/en-nz/products/roof-racks/cross-bar-roof-racks/pioneer-tradie/pioneer-tradie-1528mm-x-1236mm-_ja9160" ] "PHPDEBUGBAR_STACK_DATA" => [] ]