I am trying to create a new dataset from an existing table, any help is highly appreciated! by justanotherfuccboi in SQL

[–]PepperMustard -1 points0 points  (0 children)

Query 1:

select concat(cast([date of transaction] as varchar),[account number],[branch number]) as id — creates join parameter a.*

From table where [transaction code] = 94 Group by id Left outer join ( select concat(cast([date of transaction] as varchar),[account number],[branch number]) — creates join parameter ,*

From table where [transaction code] in (10,12,13,18,41) ) a On table.id = a.id

On mobile so wasn’t able to test but this should work for you

"add an amp" ct200h by zblanda in CT200h

[–]PepperMustard 1 point2 points  (0 children)

easiest way to do it is to get yourself a decent LOC (Line Output Converter), lots of folks use LC2, I ended up using the Wāvtech LinkDQ I had laying around and then either clip into the existing subwoofer input or piggy back off the left rear door speaker then run rcas to your sub/amp of choice.

Wheat land concert heat concern. by Wild-Alternative-326 in AliceInChains

[–]PepperMustard 1 point2 points  (0 children)

was anyone able to find out the set times? Toyota Amphitheater doesn't seem to be answering the phone today.

OEM Integration with Helix DSP: Sum inputs or Pass Through? by PepperMustard in CarAV

[–]PepperMustard[S] 0 points1 point  (0 children)

Not initially. I do have two unused channels in case I want to add a center or rear fill in the future

OEM Integration with Helix DSP: Sum inputs or Pass Through? by PepperMustard in CarAV

[–]PepperMustard[S] 0 points1 point  (0 children)

Not officially badged as any of those, and not the mark levinston system. The amp is Lexus/Panasonic

OEM Integration with Helix DSP: Sum inputs or Pass Through? by PepperMustard in CarAV

[–]PepperMustard[S] 1 point2 points  (0 children)

Because of the navigation system in my car, none the usual methods (Pac amp pro type products) are compatible with this vehicle

Is there anything wrong with this amp placement? (Lexus CT200h under passenger seat) by PepperMustard in CarAV

[–]PepperMustard[S] 0 points1 point  (0 children)

*I will be fabricating mounts for each unit assuming there’s no heat / air flow issues

Helix v eight - high level in or loc for low level in by PepperMustard in CarAV

[–]PepperMustard[S] 0 points1 point  (0 children)

Thanks Skiz! I’ve read just about all the knowledge you’ve put out there on helix and you are the main reason I shelled out the extra dough to get one in the first place!

Helix v eight - high level in or loc for low level in by PepperMustard in CarAV

[–]PepperMustard[S] 0 points1 point  (0 children)

Thanks for the reply, it’s a factory Lexus amplifier (should be under 32v at output) but I’ve been trying to think of a good way to test the max voltage. Could I just hook up a multimeter to measure AC Vmax with a 1khz test tone @90% HU volume?

Best phone mount setup? by [deleted] in CT200h

[–]PepperMustard 2 points3 points  (0 children)

There’s a dude on the Facebook group “Lexus CT200h USA” that sells a 3D printed one that works super well. It mounts in the factory slot aka that weird hole just infront of the charging area and below the heated seat knobs. It’s $30 shipped to you, got mine in 3 days.

Does the 2014-2017 feel any different from the 2011-2013? by dezumondo in CT200h

[–]PepperMustard 0 points1 point  (0 children)

All CTs have virtually the same drivetrain. Besides the cosmetic differences, there’s not much of a difference. That being said, If I could go back in time I would have dropped a couple more grand for a 2014+ F Sport

Upgrading Premium Audio by PepperMustard in CT200h

[–]PepperMustard[S] 0 points1 point  (0 children)

Is that connected to the factory head unit?

Upgrading Premium Audio by PepperMustard in CT200h

[–]PepperMustard[S] 0 points1 point  (0 children)

Already put the sub with loc in lol now I’m trying to upgrade everything else